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 |
| 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 |
| 427 | 2024-01-29 11:37:30 | coffee | 2 | 82551 | 34 | 2.500 | 33020.4 |
| 426 | 2024-01-29 11:37:07 | coffee | 3 | 112716 | 443 | 5.563 | 20261.7 |
| 425 | 2024-01-29 11:36:14 | coffee | 3 | 112716 | 443 | 6.203 | 18171.2 |
| 424 | 2024-01-28 23:42:04 | coffee | 2 | 82551 | 34 | 2.436 | 33887.9 |
| 423 | 2024-01-21 10:04:24 | coffee | 2 | 82551 | 34 | 2.356 | 35038.6 |
| 422 | 2024-01-20 06:01:18 | coffee | 3 | 112716 | 443 | 5.220 | 21593.1 |
| 421 | 2024-01-15 12:10:38 | coffee | 3 | 112716 | 443 | 5.970 | 18880.4 |
| 420 | 2024-01-09 22:48:05 | coffee | 3 | 112716 | 443 | 4.766 | 23650.0 |
| 419 | 2024-01-06 03:48:22 | coffee | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 418 | 2024-01-06 01:33:05 | coffee | 3 | 112716 | 443 | 5.330 | 21147.5 |
| 417 | 2023-12-22 18:05:26 | coffee | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 416 | 2023-11-22 19:22:01 | coffee | 2 | 82551 | 34 | 2.420 | 34112.0 |
| 415 | 2023-11-19 16:17:15 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 414 | 2023-11-18 07:34:03 | coffee | 2 | 82551 | 34 | 2.623 | 31472.0 |
| 413 | 2023-11-15 12:00:39 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 412 | 2023-11-11 08:14:07 | coffee | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 411 | 2023-11-07 19:34:50 | coffee | 2 | 82551 | 34 | 2.373 | 34787.6 |
| 410 | 2023-10-30 03:31:09 | coffee | 3 | 112716 | 443 | 4.733 | 23814.9 |
| 409 | 2023-10-22 18:58:56 | coffee | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 408 | 2023-10-18 22:46:24 | coffee | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 407 | 2023-10-13 13:23:49 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 406 | 2023-10-11 04:29:07 | coffee | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 405 | 2023-10-08 01:52:59 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 404 | 2023-09-24 21:10:26 | coffee | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 403 | 2023-09-14 08:25:41 | coffee | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 402 | 2023-09-10 12:03:13 | coffee | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 401 | 2023-09-07 01:58:30 | coffee | 1 | 48755 | 5 | 1.686 | 28917.6 |
| 400 | 2023-08-11 20:30:54 | coffee | 2 | 82551 | 34 | 2.156 | 38289.0 |
| 399 | 2023-08-07 12:33:14 | coffee | 3 | 112716 | 443 | 4.690 | 24033.3 |
| 398 | 2023-08-06 23:53:42 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 397 | 2023-05-21 04:52:08 | coffee | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 396 | 2023-05-08 06:10:24 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 395 | 2023-04-23 07:32:37 | coffee | 2 | 82551 | 34 | 4.640 | 17791.2 |
| 394 | 2023-04-13 22:17:05 | coffee | 3 | 112716 | 443 | 5.313 | 21215.1 |
| 393 | 2023-03-25 16:32:37 | coffee | 3 | 112716 | 443 | 4.923 | 22895.8 |
| 392 | 2023-03-04 23:21:10 | coffee | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 391 | 2023-01-31 23:51:28 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 390 | 2023-01-28 05:57:35 | coffee | 2 | 82551 | 34 | 2.406 | 34310.5 |
| 389 | 2023-01-20 05:54:51 | coffee | 3 | 112716 | 443 | 4.640 | 24292.2 |
| 388 | 2022-12-28 12:55:43 | coffee | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 387 | 2022-11-11 15:27:25 | coffee | 2 | 82551 | 34 | 2.250 | 36689.3 |
| 386 | 2022-10-30 21:20:24 | coffee | 3 | 112716 | 443 | 4.576 | 24632.0 |
| 385 | 2022-10-10 13:36:21 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 384 | 2022-09-16 06:01:16 | coffee | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 383 | 2022-09-04 19:42:55 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 382 | 2022-09-01 07:17:59 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 381 | 2022-07-02 10:36:42 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 380 | 2022-06-30 06:00:29 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 379 | 2022-06-23 22:15:23 | coffee | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 378 | 2022-06-13 07:16:44 | coffee | 2 | 82551 | 34 | 2.140 | 38575.2 |
| 377 | 2022-06-11 04:25:49 | coffee | 2 | 82551 | 34 | 2.406 | 34310.5 |
| 376 | 2022-05-21 17:23:18 | coffee | 3 | 112716 | 443 | 8.046 | 14008.9 |
| 375 | 2022-05-18 07:36:18 | coffee | 3 | 112716 | 443 | 5.263 | 21416.7 |
| 374 | 2022-05-12 16:10:35 | coffee | 3 | 112716 | 443 | 6.593 | 17096.3 |
| 373 | 2022-03-04 11:33:54 | coffee | 1 | 48755 | 5 | 1.140 | 42767.5 |
| 372 | 2022-02-28 21:34:13 | coffee | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 371 | 2022-01-28 02:57:16 | coffee | 2 | 82551 | 34 | 2.593 | 31836.1 |
| 370 | 2021-12-15 15:29:51 | coffee | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 369 | 2021-12-13 13:43:53 | coffee | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 368 | 2021-11-24 05:54:46 | coffee | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 367 | 2021-11-17 03:52:32 | coffee | 2 | 82551 | 34 | 2.266 | 36430.3 |
| 366 | 2021-10-20 19:31:13 | coffee | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 365 | 2021-09-08 14:49:06 | coffee | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 364 | 2021-08-21 05:38:09 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 363 | 2021-08-19 19:16:25 | coffee | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 362 | 2021-08-09 13:19:10 | coffee | 3 | 112716 | 443 | 5.170 | 21801.9 |
| 361 | 2021-07-27 23:21:52 | coffee | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 360 | 2021-07-09 06:08:26 | coffee | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 359 | 2021-07-08 12:11:28 | coffee | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 358 | 2021-07-07 17:58:49 | coffee | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 357 | 2021-06-15 13:35:20 | coffee | 2 | 82551 | 34 | 2.576 | 32046.2 |
| 356 | 2021-05-20 14:53:43 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 355 | 2021-05-19 02:05:49 | coffee | 1 | 48755 | 5 | 0.840 | 58041.7 |
| 354 | 2021-05-16 19:51:52 | coffee | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 353 | 2021-04-19 01:40:25 | coffee | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 352 | 2021-04-14 07:03:57 | coffee | 3 | 112716 | 443 | 5.420 | 20796.3 |
| 351 | 2021-03-26 01:27:52 | coffee | 2 | 82551 | 34 | 2.156 | 38289.0 |
| 350 | 2021-03-19 16:41:27 | coffee | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 349 | 2021-02-25 00:04:40 | coffee | 2 | 82551 | 34 | 2.420 | 34112.0 |
| 348 | 2021-02-24 13:39:46 | coffee | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 347 | 2021-02-19 23:56:23 | coffee | 3 | 112716 | 443 | 4.970 | 22679.3 |
| 346 | 2021-02-18 01:34:21 | coffee | 1 | 48755 | 5 | 0.783 | 62266.9 |