History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"retailers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 509 | 2024-05-15 16:29:05 | retailers | 3 | 148641 | 206 | 14.203 | 10465.5 |
| 508 | 2024-05-12 15:18:08 | retailers | 3 | 148641 | 206 | 13.890 | 10701.3 |
| 507 | 2024-05-09 14:07:22 | retailers | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 506 | 2024-05-06 20:37:43 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 505 | 2024-04-29 00:10:27 | retailers | 1 | 81242 | 5 | 1.516 | 53589.7 |
| 504 | 2024-04-28 05:17:33 | retailers | 3 | 148641 | 206 | 11.220 | 13247.9 |
| 503 | 2024-04-20 23:45:34 | retailers | 3 | 148641 | 206 | 24.893 | 5971.2 |
| 502 | 2024-04-20 23:45:32 | retailers | 2 | 121436 | 27 | 6.186 | 19630.8 |
| 501 | 2024-04-08 13:18:01 | retailers | 3 | 148641 | 206 | 22.186 | 6699.8 |
| 500 | 2024-04-08 13:17:56 | retailers | 2 | 121436 | 27 | 9.830 | 12353.6 |
| 499 | 2024-04-08 13:12:32 | retailers | 1 | 81242 | 5 | 1.766 | 46003.4 |
| 498 | 2024-04-05 03:03:39 | retailers | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 497 | 2024-03-28 13:47:47 | retailers | 1 | 81242 | 5 | 1.403 | 57905.9 |
| 496 | 2024-03-23 19:11:15 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 495 | 2024-03-22 12:50:32 | retailers | 3 | 148641 | 206 | 9.660 | 15387.3 |
| 494 | 2024-03-21 23:14:47 | retailers | 3 | 148641 | 206 | 28.296 | 5253.1 |
| 493 | 2024-03-21 19:58:21 | retailers | 3 | 148641 | 206 | 23.626 | 6291.4 |
| 492 | 2024-03-21 19:58:18 | retailers | 2 | 121436 | 27 | 13.550 | 8962.1 |
| 491 | 2024-03-04 20:30:12 | retailers | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 490 | 2024-02-27 12:43:30 | retailers | 1 | 81242 | 5 | 1.670 | 48647.9 |
| 489 | 2024-01-29 07:08:21 | retailers | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 488 | 2024-01-29 04:48:10 | retailers | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 487 | 2024-01-28 07:28:39 | retailers | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 486 | 2024-01-21 11:31:34 | retailers | 3 | 148641 | 206 | 7.156 | 20771.5 |
| 485 | 2024-01-21 11:31:35 | retailers | 2 | 121436 | 27 | 3.656 | 33215.5 |
| 484 | 2023-12-18 23:50:24 | retailers | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 483 | 2023-12-12 15:18:06 | retailers | 1 | 81242 | 5 | 1.456 | 55798.1 |
| 482 | 2023-12-03 06:04:57 | retailers | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 481 | 2023-11-21 23:14:54 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 480 | 2023-11-18 00:42:13 | retailers | 1 | 81242 | 5 | 1.470 | 55266.7 |
| 479 | 2023-11-05 20:58:58 | retailers | 1 | 81242 | 5 | 2.326 | 34927.8 |
| 478 | 2023-10-20 23:59:54 | retailers | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 477 | 2023-10-11 03:50:28 | retailers | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 476 | 2023-10-06 07:59:26 | retailers | 1 | 81242 | 5 | 1.330 | 61084.2 |
| 475 | 2023-08-02 04:49:48 | retailers | 1 | 81242 | 5 | 1.280 | 63470.3 |
| 474 | 2023-06-23 01:52:47 | retailers | 1 | 81242 | 5 | 1.486 | 54671.6 |
| 473 | 2023-04-30 11:23:30 | retailers | 1 | 81242 | 5 | 1.470 | 55266.7 |
| 472 | 2023-02-25 07:41:42 | retailers | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 471 | 2023-02-23 08:12:41 | retailers | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 470 | 2022-12-21 22:39:02 | retailers | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 469 | 2022-10-30 05:29:53 | retailers | 2 | 121436 | 27 | 3.156 | 38477.8 |
| 468 | 2022-10-25 06:02:59 | retailers | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 467 | 2022-09-05 01:48:22 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 466 | 2022-06-27 20:10:14 | retailers | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 465 | 2022-05-31 18:24:25 | retailers | 2 | 121436 | 27 | 3.750 | 32382.9 |
| 464 | 2022-04-14 00:15:09 | retailers | 1 | 81242 | 5 | 1.953 | 41598.6 |
| 463 | 2022-04-11 18:58:21 | retailers | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 462 | 2022-02-18 21:33:09 | retailers | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 461 | 2022-01-11 21:31:55 | retailers | 1 | 81242 | 5 | 1.673 | 48560.7 |
| 460 | 2021-11-07 22:36:48 | retailers | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 459 | 2021-10-25 04:00:44 | retailers | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 458 | 2021-09-25 09:26:56 | retailers | 1 | 81242 | 5 | 1.466 | 55417.5 |
| 457 | 2021-09-25 02:20:49 | retailers | 3 | 148641 | 206 | 6.406 | 23203.4 |
| 456 | 2021-09-22 03:07:58 | retailers | 1 | 81242 | 5 | 1.346 | 60358.1 |
| 455 | 2021-09-21 10:46:48 | retailers | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 454 | 2021-09-15 06:22:15 | retailers | 1 | 81242 | 5 | 1.393 | 58321.6 |
| 453 | 2021-09-06 00:15:21 | retailers | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 452 | 2021-07-14 13:54:18 | retailers | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 451 | 2021-06-28 07:55:33 | retailers | 1 | 81242 | 5 | 1.906 | 42624.3 |
| 450 | 2021-04-11 10:49:47 | retailers | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 449 | 2021-03-09 00:30:27 | retailers | 3 | 148641 | 206 | 6.546 | 22707.1 |
| 448 | 2021-02-26 20:55:41 | retailers | 3 | 148641 | 206 | 13.626 | 10908.6 |
| 447 | 2021-01-24 15:14:29 | retailers | 1 | 81242 | 5 | 1.356 | 59913.0 |
| 446 | 2021-01-01 17:28:46 | retailers | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 445 | 2020-11-23 14:16:44 | retailers | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 444 | 2020-11-12 14:36:28 | retailers | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 443 | 2020-10-23 21:47:11 | retailers | 1 | 81242 | 5 | 2.546 | 31909.7 |
| 442 | 2020-10-16 02:12:52 | retailers | 1 | 81242 | 5 | 1.283 | 63321.9 |
| 441 | 2020-09-25 19:35:12 | retailers | 1 | 81242 | 5 | 1.233 | 65889.7 |
| 440 | 2020-09-25 15:49:35 | retailers | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 439 | 2020-09-18 16:01:06 | retailers | 1 | 81242 | 5 | 1.376 | 59042.2 |
| 438 | 2020-09-14 00:49:18 | retailers | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 437 | 2020-08-22 16:40:09 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 436 | 2020-08-01 21:13:12 | retailers | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 435 | 2020-07-29 09:19:46 | retailers | 1 | 81242 | 5 | 1.466 | 55417.5 |
| 434 | 2020-07-23 19:34:24 | retailers | 1 | 81242 | 5 | 1.313 | 61875.1 |
| 433 | 2020-06-20 20:37:32 | retailers | 1 | 81242 | 5 | 1.750 | 46424.0 |
| 432 | 2020-06-08 00:10:02 | retailers | 1 | 81242 | 5 | 1.296 | 62686.7 |
| 431 | 2020-05-13 13:28:38 | retailers | 3 | 148641 | 206 | 6.763 | 21978.6 |
| 430 | 2020-03-29 02:14:27 | retailers | 1 | 81242 | 5 | 1.453 | 55913.3 |
| 429 | 2020-03-28 17:57:48 | retailers | 1 | 81242 | 5 | 1.513 | 53696.0 |
| 428 | 2020-03-25 20:25:10 | retailers | 1 | 81242 | 5 | 1.263 | 64324.6 |
| 427 | 2020-03-20 21:47:53 | retailers | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 426 | 2020-03-06 11:37:51 | retailers | 1 | 81242 | 5 | 1.326 | 61268.5 |
| 425 | 2020-02-29 19:17:01 | retailers | 3 | 148641 | 206 | 13.000 | 11433.9 |
| 424 | 2020-02-29 17:06:39 | retailers | 3 | 148641 | 206 | 7.906 | 18801.0 |
| 423 | 2020-02-29 14:11:49 | retailers | 3 | 148641 | 206 | 9.640 | 15419.2 |
| 422 | 2020-02-29 13:38:16 | retailers | 3 | 148641 | 206 | 8.656 | 17172.0 |
| 421 | 2020-02-29 07:45:52 | retailers | 3 | 148641 | 206 | 9.800 | 15167.4 |
| 420 | 2020-02-29 03:20:25 | retailers | 3 | 148641 | 206 | 13.673 | 10871.1 |
| 419 | 2020-02-28 21:01:50 | retailers | 3 | 148641 | 206 | 15.280 | 9727.8 |
| 418 | 2020-02-28 16:09:58 | retailers | 1 | 81242 | 5 | 1.516 | 53589.7 |
| 417 | 2020-02-26 06:48:29 | retailers | 1 | 81242 | 5 | 3.173 | 25604.2 |
| 416 | 2020-02-22 11:31:31 | retailers | 1 | 81242 | 5 | 2.203 | 36877.9 |
| 415 | 2020-02-19 19:57:13 | retailers | 1 | 81242 | 5 | 1.530 | 53099.3 |
| 414 | 2020-02-12 13:32:35 | retailers | 1 | 81242 | 5 | 1.610 | 50460.9 |
| 413 | 2020-02-08 15:46:17 | retailers | 1 | 81242 | 5 | 1.483 | 54782.2 |
| 412 | 2020-02-02 20:24:39 | retailers | 1 | 81242 | 5 | 4.313 | 18836.5 |
| 411 | 2020-01-29 06:01:48 | retailers | 1 | 81242 | 5 | 2.750 | 29542.5 |
| 410 | 2020-01-21 23:01:43 | retailers | 1 | 81242 | 5 | 1.656 | 49059.2 |