History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biotype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 450 | 2026-04-21 17:51:22 | biotype | 1 | 69583 | 3 | 2.093 | 33245.6 |
| 449 | 2026-04-19 01:57:50 | biotype | 3 | 134027 | 70 | 26.970 | 4969.5 |
| 448 | 2026-04-14 21:12:37 | biotype | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 447 | 2026-04-10 20:17:38 | biotype | 1 | 69583 | 3 | 5.876 | 11841.9 |
| 446 | 2026-04-08 21:18:46 | biotype | 2 | 107671 | 14 | 6.936 | 15523.5 |
| 445 | 2026-04-08 15:50:21 | biotype | 3 | 134027 | 70 | 5.890 | 22755.0 |
| 444 | 2026-04-08 08:24:06 | biotype | 2 | 107671 | 14 | 8.236 | 13073.2 |
| 443 | 2026-04-06 00:45:52 | biotype | 3 | 134027 | 70 | 24.860 | 5391.3 |
| 442 | 2026-04-03 10:34:07 | biotype | 3 | 134027 | 70 | 35.033 | 3825.7 |
| 441 | 2026-04-03 10:34:01 | biotype | 3 | 134027 | 70 | 34.563 | 3877.8 |
| 440 | 2026-04-03 10:33:37 | biotype | 3 | 134027 | 70 | 49.750 | 2694.0 |
| 439 | 2026-04-03 10:33:40 | biotype | 3 | 134027 | 70 | 33.033 | 4057.4 |
| 438 | 2026-03-31 14:26:59 | biotype | 1 | 69583 | 3 | 6.236 | 11158.3 |
| 437 | 2026-03-31 11:40:45 | biotype | 1 | 69583 | 3 | 5.733 | 12137.3 |
| 436 | 2026-03-31 11:40:28 | biotype | 1 | 69583 | 3 | 7.686 | 9053.2 |
| 435 | 2026-03-30 08:01:33 | biotype | 1 | 69583 | 3 | 6.733 | 10334.6 |
| 434 | 2026-03-28 07:12:18 | biotype | 1 | 69583 | 3 | 6.860 | 10143.3 |
| 433 | 2026-03-28 07:12:17 | biotype | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 432 | 2026-03-28 07:12:10 | biotype | 1 | 69583 | 3 | 6.173 | 11272.2 |
| 431 | 2026-03-26 03:48:00 | biotype | 2 | 107671 | 14 | 16.766 | 6422.0 |
| 430 | 2026-03-26 03:47:44 | biotype | 2 | 107671 | 14 | 14.503 | 7424.1 |
| 429 | 2026-03-26 03:47:30 | biotype | 2 | 107671 | 14 | 15.593 | 6905.1 |
| 428 | 2026-03-23 06:45:11 | biotype | 3 | 134027 | 70 | 34.360 | 3900.7 |
| 427 | 2026-03-19 07:48:25 | biotype | 3 | 134027 | 70 | 14.080 | 9519.0 |
| 426 | 2026-03-16 11:35:12 | biotype | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 425 | 2026-02-28 08:49:26 | biotype | 4 | 151207 | 756 | 27.063 | 5587.2 |
| 424 | 2026-02-27 13:10:08 | biotype | 4 | 151207 | 756 | 55.000 | 2749.2 |
| 423 | 2026-02-19 13:35:13 | biotype | 2 | 107671 | 14 | 3.453 | 31181.9 |
| 422 | 2026-02-17 18:07:45 | biotype | 1 | 69583 | 3 | 3.576 | 19458.3 |
| 421 | 2026-02-16 22:59:21 | biotype | 1 | 69583 | 3 | 2.110 | 32977.7 |
| 420 | 2026-02-16 14:53:32 | biotype | 3 | 134027 | 70 | 28.126 | 4765.2 |
| 419 | 2026-02-12 15:03:08 | biotype | 2 | 107671 | 14 | 9.626 | 11185.4 |
| 418 | 2026-02-12 15:02:55 | biotype | 2 | 107671 | 14 | 8.213 | 13109.8 |
| 417 | 2026-02-12 15:02:40 | biotype | 2 | 107671 | 14 | 14.203 | 7580.9 |
| 416 | 2026-02-11 14:45:43 | biotype | 3 | 134027 | 70 | 42.566 | 3148.7 |
| 415 | 2026-02-11 14:45:27 | biotype | 3 | 134027 | 70 | 37.050 | 3617.5 |
| 414 | 2026-02-11 14:45:12 | biotype | 3 | 134027 | 70 | 36.630 | 3658.9 |
| 413 | 2026-02-11 13:21:15 | biotype | 4 | 151207 | 756 | 10.686 | 14150.0 |
| 412 | 2026-02-09 11:20:58 | biotype | 1 | 69583 | 3 | 2.580 | 26970.2 |
| 411 | 2026-02-02 20:39:16 | biotype | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 410 | 2026-02-01 23:08:21 | biotype | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 409 | 2026-01-24 09:44:55 | biotype | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 408 | 2026-01-18 22:20:11 | biotype | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 407 | 2026-01-02 10:19:48 | biotype | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 406 | 2025-12-31 21:20:16 | biotype | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 405 | 2025-12-29 05:48:31 | biotype | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 404 | 2025-12-27 21:37:30 | biotype | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 403 | 2025-12-04 10:26:39 | biotype | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 402 | 2025-11-29 23:53:41 | biotype | 3 | 134027 | 70 | 17.233 | 7777.3 |
| 401 | 2025-11-28 02:56:15 | biotype | 3 | 134027 | 70 | 23.390 | 5730.1 |
| 400 | 2025-11-21 06:17:20 | biotype | 1 | 69583 | 3 | 3.873 | 17966.2 |
| 399 | 2025-11-01 07:04:01 | biotype | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 398 | 2025-09-30 19:05:53 | biotype | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 397 | 2025-09-04 21:39:43 | biotype | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 396 | 2025-08-19 11:24:46 | biotype | 1 | 69583 | 3 | 3.220 | 21609.6 |
| 395 | 2025-08-12 18:08:43 | biotype | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 394 | 2025-08-09 16:11:40 | biotype | 1 | 69583 | 3 | 7.283 | 9554.2 |
| 393 | 2025-08-03 22:25:20 | biotype | 1 | 69583 | 3 | 2.470 | 28171.3 |
| 392 | 2025-08-01 20:48:23 | biotype | 3 | 134027 | 70 | 38.736 | 3460.0 |
| 391 | 2025-07-31 21:37:49 | biotype | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 390 | 2025-07-28 03:11:47 | biotype | 3 | 134027 | 70 | 17.596 | 7616.9 |
| 389 | 2025-07-27 07:53:53 | biotype | 3 | 134027 | 70 | 49.423 | 2711.8 |
| 388 | 2025-07-27 07:53:49 | biotype | 3 | 134027 | 70 | 28.283 | 4738.8 |
| 387 | 2025-07-25 10:49:16 | biotype | 3 | 134027 | 70 | 21.063 | 6363.1 |
| 386 | 2025-07-25 06:25:20 | biotype | 1 | 69583 | 3 | 4.313 | 16133.3 |
| 385 | 2025-07-20 08:23:37 | biotype | 3 | 134027 | 70 | 8.656 | 15483.7 |
| 384 | 2025-07-07 18:15:16 | biotype | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 383 | 2025-07-07 07:51:08 | biotype | 1 | 69583 | 3 | 3.373 | 20629.4 |
| 382 | 2025-07-05 15:29:07 | biotype | 1 | 69583 | 3 | 3.003 | 23171.2 |
| 381 | 2025-07-04 21:25:13 | biotype | 1 | 69583 | 3 | 3.030 | 22964.7 |
| 380 | 2025-07-04 09:55:43 | biotype | 1 | 69583 | 3 | 3.843 | 18106.4 |
| 379 | 2025-06-29 05:05:07 | biotype | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 378 | 2025-05-28 20:51:15 | biotype | 1 | 69583 | 3 | 8.500 | 8186.2 |
| 377 | 2025-05-27 06:03:58 | biotype | 3 | 134027 | 70 | 26.360 | 5084.5 |
| 376 | 2025-05-22 15:21:40 | biotype | 1 | 69583 | 3 | 5.873 | 11847.9 |
| 375 | 2025-05-15 16:24:00 | biotype | 1 | 69583 | 3 | 2.486 | 27989.9 |
| 374 | 2025-05-14 03:30:34 | biotype | 3 | 134027 | 70 | 44.530 | 3009.8 |
| 373 | 2025-05-10 05:18:39 | biotype | 3 | 134027 | 70 | 27.923 | 4799.9 |
| 372 | 2025-05-02 07:03:16 | biotype | 1 | 69583 | 3 | 5.640 | 12337.4 |
| 371 | 2025-04-30 22:19:23 | biotype | 3 | 134027 | 70 | 31.573 | 4245.0 |
| 370 | 2025-04-30 17:33:49 | biotype | 3 | 134027 | 70 | 26.610 | 5036.7 |
| 369 | 2025-04-28 11:38:31 | biotype | 3 | 134027 | 70 | 25.440 | 5268.4 |
| 368 | 2025-04-24 00:24:42 | biotype | 3 | 134027 | 70 | 26.440 | 5069.1 |
| 367 | 2025-04-23 21:26:38 | biotype | 3 | 134027 | 70 | 39.290 | 3411.2 |
| 366 | 2025-04-22 14:09:56 | biotype | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 365 | 2025-04-17 20:48:58 | biotype | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 364 | 2025-04-16 11:01:22 | biotype | 1 | 69583 | 3 | 2.920 | 23829.8 |
| 363 | 2025-03-31 09:05:15 | biotype | 1 | 69583 | 3 | 8.953 | 7772.0 |
| 362 | 2025-03-24 02:31:47 | biotype | 3 | 134027 | 70 | 31.316 | 4279.8 |
| 361 | 2025-03-22 04:14:39 | biotype | 3 | 134027 | 70 | 21.656 | 6188.9 |
| 360 | 2025-03-21 04:14:18 | biotype | 3 | 134027 | 70 | 33.456 | 4006.1 |
| 359 | 2025-03-20 16:18:46 | biotype | 1 | 69583 | 3 | 3.673 | 18944.5 |
| 358 | 2025-03-19 12:05:01 | biotype | 3 | 134027 | 70 | 6.013 | 22289.5 |
| 357 | 2025-03-17 05:38:39 | biotype | 1 | 69583 | 3 | 8.610 | 8081.6 |
| 356 | 2025-03-04 19:18:02 | biotype | 2 | 107671 | 14 | 16.203 | 6645.1 |
| 355 | 2025-03-03 14:18:06 | biotype | 2 | 107671 | 14 | 24.360 | 4420.0 |
| 354 | 2025-02-24 19:25:18 | biotype | 2 | 107671 | 14 | 23.186 | 4643.8 |
| 353 | 2025-02-24 17:54:23 | biotype | 1 | 69583 | 3 | 5.580 | 12470.1 |
| 352 | 2025-02-21 03:10:43 | biotype | 3 | 134027 | 70 | 33.770 | 3968.8 |
| 351 | 2025-02-21 03:10:32 | biotype | 2 | 107671 | 14 | 9.940 | 10832.1 |