History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coffee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 527 | 2025-02-04 22:40:34 | coffee | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 526 | 2025-01-26 20:17:19 | coffee | 3 | 112716 | 443 | 25.673 | 4390.4 |
| 525 | 2025-01-23 21:31:08 | coffee | 3 | 112716 | 443 | 32.936 | 3422.3 |
| 524 | 2025-01-09 22:15:40 | coffee | 2 | 82551 | 34 | 13.220 | 6244.4 |
| 523 | 2025-01-09 22:15:34 | coffee | 1 | 48755 | 5 | 2.126 | 22932.7 |
| 522 | 2025-01-09 15:19:01 | coffee | 1 | 48755 | 5 | 6.016 | 8104.2 |
| 521 | 2025-01-03 21:40:10 | coffee | 3 | 112716 | 443 | 25.360 | 4444.6 |
| 520 | 2025-01-03 08:37:36 | coffee | 1 | 48755 | 5 | 3.953 | 12333.7 |
| 519 | 2025-01-01 16:08:27 | coffee | 3 | 112716 | 443 | 14.033 | 8032.2 |
| 518 | 2025-01-01 13:01:04 | coffee | 3 | 112716 | 443 | 15.283 | 7375.3 |
| 517 | 2025-01-01 05:55:30 | coffee | 1 | 48755 | 5 | 3.966 | 12293.2 |
| 516 | 2024-12-29 01:47:53 | coffee | 1 | 48755 | 5 | 2.906 | 16777.4 |
| 515 | 2024-12-27 13:50:46 | coffee | 3 | 112716 | 443 | 15.736 | 7162.9 |
| 514 | 2024-12-10 02:03:33 | coffee | 1 | 48755 | 5 | 5.483 | 8892.0 |
| 513 | 2024-12-08 22:08:37 | coffee | 1 | 48755 | 5 | 2.046 | 23829.4 |
| 512 | 2024-12-02 17:52:50 | coffee | 2 | 82551 | 34 | 2.580 | 31996.5 |
| 511 | 2024-12-02 17:52:49 | coffee | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 510 | 2024-12-02 01:08:52 | coffee | 3 | 112716 | 443 | 20.936 | 5383.8 |
| 509 | 2024-11-30 10:09:40 | coffee | 3 | 112716 | 443 | 25.343 | 4447.6 |
| 508 | 2024-11-30 10:08:49 | coffee | 2 | 82551 | 34 | 14.780 | 5585.3 |
| 507 | 2024-11-30 10:08:42 | coffee | 1 | 48755 | 5 | 1.983 | 24586.5 |
| 506 | 2024-11-09 02:29:09 | coffee | 1 | 48755 | 5 | 2.046 | 23829.4 |
| 505 | 2024-11-08 20:58:52 | coffee | 1 | 48755 | 5 | 4.220 | 11553.3 |
| 504 | 2024-11-03 13:08:13 | coffee | 3 | 112716 | 443 | 40.670 | 2771.5 |
| 503 | 2024-11-02 10:31:49 | coffee | 1 | 48755 | 5 | 6.296 | 7743.8 |
| 502 | 2024-11-01 22:38:13 | coffee | 3 | 112716 | 443 | 39.593 | 2846.9 |
| 501 | 2024-10-30 09:55:49 | coffee | 2 | 82551 | 34 | 7.186 | 11487.8 |
| 500 | 2024-10-30 07:25:30 | coffee | 3 | 112716 | 443 | 28.266 | 3987.7 |
| 499 | 2024-10-30 05:16:04 | coffee | 3 | 112716 | 443 | 28.313 | 3981.1 |
| 498 | 2024-10-30 05:16:03 | coffee | 2 | 82551 | 34 | 9.953 | 8294.1 |
| 497 | 2024-10-30 05:15:59 | coffee | 1 | 48755 | 5 | 3.283 | 14850.7 |
| 496 | 2024-10-20 16:10:50 | coffee | 1 | 48755 | 5 | 4.406 | 11065.6 |
| 495 | 2024-10-09 11:34:34 | coffee | 1 | 48755 | 5 | 4.420 | 11030.5 |
| 494 | 2024-10-08 05:26:11 | coffee | 1 | 48755 | 5 | 4.610 | 10575.9 |
| 493 | 2024-10-02 16:12:05 | coffee | 1 | 48755 | 5 | 6.123 | 7962.6 |
| 492 | 2024-09-30 01:07:29 | coffee | 1 | 48755 | 5 | 6.173 | 7898.1 |
| 491 | 2024-09-08 16:45:51 | coffee | 1 | 48755 | 5 | 8.203 | 5943.6 |
| 490 | 2024-09-05 00:50:06 | coffee | 1 | 48755 | 5 | 4.860 | 10031.9 |
| 489 | 2024-08-21 17:55:00 | coffee | 1 | 48755 | 5 | 3.420 | 14255.8 |
| 488 | 2024-08-14 21:35:37 | coffee | 1 | 48755 | 5 | 7.656 | 6368.2 |
| 487 | 2024-08-14 16:18:09 | coffee | 1 | 48755 | 5 | 3.126 | 15596.6 |
| 486 | 2024-08-08 14:35:57 | coffee | 1 | 48755 | 5 | 3.640 | 13394.2 |
| 485 | 2024-08-04 00:43:28 | coffee | 1 | 48755 | 5 | 2.906 | 16777.4 |
| 484 | 2024-08-01 00:50:16 | coffee | 3 | 112716 | 443 | 27.253 | 4135.9 |
| 483 | 2024-08-01 00:48:20 | coffee | 2 | 82551 | 34 | 8.826 | 9353.2 |
| 482 | 2024-07-31 22:05:50 | coffee | 3 | 112716 | 443 | 14.173 | 7952.9 |
| 481 | 2024-07-31 14:18:05 | coffee | 3 | 112716 | 443 | 17.610 | 6400.7 |
| 480 | 2024-07-31 11:17:26 | coffee | 3 | 112716 | 443 | 14.093 | 7998.0 |
| 479 | 2024-07-31 11:17:26 | coffee | 2 | 82551 | 34 | 10.970 | 7525.2 |
| 478 | 2024-07-31 11:16:32 | coffee | 1 | 48755 | 5 | 1.220 | 39963.1 |
| 477 | 2024-07-31 01:12:40 | coffee | 1 | 48755 | 5 | 2.343 | 20808.8 |
| 476 | 2024-07-17 18:52:39 | coffee | 1 | 48755 | 5 | 1.343 | 36303.1 |
| 475 | 2024-07-08 01:01:07 | coffee | 1 | 48755 | 5 | 1.813 | 26891.9 |
| 474 | 2024-07-02 21:24:28 | coffee | 1 | 48755 | 5 | 4.173 | 11683.4 |
| 473 | 2024-07-01 06:12:29 | coffee | 1 | 48755 | 5 | 4.063 | 11999.8 |
| 472 | 2024-06-30 04:25:12 | coffee | 1 | 48755 | 5 | 4.766 | 10229.8 |
| 471 | 2024-06-26 11:18:52 | coffee | 3 | 112716 | 443 | 15.360 | 7338.3 |
| 470 | 2024-06-23 05:55:53 | coffee | 3 | 112716 | 443 | 29.750 | 3788.8 |
| 469 | 2024-06-21 22:08:55 | coffee | 2 | 82551 | 34 | 3.173 | 26016.7 |
| 468 | 2024-06-21 22:08:32 | coffee | 3 | 112716 | 443 | 5.686 | 19823.4 |
| 467 | 2024-06-18 20:55:30 | coffee | 1 | 48755 | 5 | 4.046 | 12050.2 |
| 466 | 2024-06-05 05:21:08 | coffee | 3 | 112716 | 443 | 16.360 | 6889.7 |
| 465 | 2024-06-04 20:19:16 | coffee | 2 | 82551 | 34 | 13.750 | 6003.7 |
| 464 | 2024-06-04 20:19:23 | coffee | 1 | 48755 | 5 | 1.266 | 38511.1 |
| 463 | 2024-06-04 16:02:26 | coffee | 3 | 112716 | 443 | 28.943 | 3894.4 |
| 462 | 2024-06-04 14:53:29 | coffee | 3 | 112716 | 443 | 6.106 | 18459.9 |
| 461 | 2024-05-28 21:24:40 | coffee | 1 | 48755 | 5 | 3.033 | 16074.8 |
| 460 | 2024-05-17 12:34:13 | coffee | 2 | 82551 | 34 | 4.000 | 20637.8 |
| 459 | 2024-05-17 12:34:09 | coffee | 2 | 82551 | 34 | 6.016 | 13721.9 |
| 458 | 2024-05-17 12:34:06 | coffee | 1 | 48755 | 5 | 2.216 | 22001.4 |
| 457 | 2024-05-17 12:33:36 | coffee | 3 | 112716 | 443 | 8.360 | 13482.8 |
| 456 | 2024-05-14 04:10:37 | coffee | 2 | 82551 | 34 | 2.486 | 33206.4 |
| 455 | 2024-05-09 18:54:56 | coffee | 2 | 82551 | 34 | 6.126 | 13475.5 |
| 454 | 2024-05-09 16:07:36 | coffee | 3 | 112716 | 443 | 17.470 | 6452.0 |
| 453 | 2024-05-09 11:29:48 | coffee | 3 | 112716 | 443 | 19.096 | 5902.6 |
| 452 | 2024-05-06 04:00:28 | coffee | 3 | 112716 | 443 | 16.250 | 6936.4 |
| 451 | 2024-05-04 12:31:40 | coffee | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 450 | 2024-05-04 07:14:43 | coffee | 3 | 112716 | 443 | 10.890 | 10350.4 |
| 449 | 2024-05-04 03:21:59 | coffee | 2 | 82551 | 34 | 5.876 | 14048.8 |
| 448 | 2024-05-04 03:21:29 | coffee | 3 | 112716 | 443 | 6.156 | 18309.9 |
| 447 | 2024-04-30 09:05:00 | coffee | 1 | 48755 | 5 | 2.486 | 19611.8 |
| 446 | 2024-04-28 10:28:21 | coffee | 1 | 48755 | 5 | 1.123 | 43415.0 |
| 445 | 2024-04-21 01:10:55 | coffee | 1 | 48755 | 5 | 2.656 | 18356.6 |
| 444 | 2024-04-13 00:52:52 | coffee | 2 | 82551 | 34 | 2.343 | 35233.0 |
| 443 | 2024-04-13 00:51:43 | coffee | 3 | 112716 | 443 | 4.966 | 22697.5 |
| 442 | 2024-04-09 03:17:07 | coffee | 2 | 82551 | 34 | 2.873 | 28733.4 |
| 441 | 2024-04-09 03:17:06 | coffee | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 440 | 2024-04-09 03:16:47 | coffee | 3 | 112716 | 443 | 5.250 | 21469.7 |
| 439 | 2024-04-06 01:27:34 | coffee | 2 | 82551 | 34 | 8.140 | 10141.4 |
| 438 | 2024-04-06 01:27:05 | coffee | 1 | 48755 | 5 | 1.563 | 31193.2 |
| 437 | 2024-03-31 22:01:01 | coffee | 3 | 112716 | 443 | 9.690 | 11632.2 |
| 436 | 2024-03-31 08:07:03 | coffee | 3 | 112716 | 443 | 17.453 | 6458.3 |
| 435 | 2024-03-30 11:05:15 | coffee | 1 | 48755 | 5 | 0.936 | 52088.7 |
| 434 | 2024-03-30 01:52:30 | coffee | 1 | 48755 | 5 | 2.313 | 21078.7 |
| 433 | 2024-03-08 21:23:13 | coffee | 2 | 82551 | 34 | 2.810 | 29377.6 |
| 432 | 2024-03-08 21:23:06 | coffee | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 431 | 2024-03-08 21:22:36 | coffee | 3 | 112716 | 443 | 9.203 | 12247.7 |
| 430 | 2024-03-08 21:22:38 | coffee | 3 | 112716 | 443 | 6.440 | 17502.5 |
| 429 | 2024-03-06 22:07:00 | coffee | 1 | 48755 | 5 | 2.970 | 16415.8 |
| 428 | 2024-03-01 15:58:20 | coffee | 3 | 112716 | 443 | 5.580 | 20200.0 |