History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whiskeys"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
550 | 2024-04-13 07:11:32 | whiskeys | 1 | 82945 | 3 | 1.436 | 57761.1 |
549 | 2024-04-05 05:15:19 | whiskeys | 1 | 82945 | 3 | 5.140 | 16137.2 |
548 | 2024-03-29 11:59:39 | whiskeys | 1 | 82945 | 3 | 3.736 | 22201.6 |
547 | 2024-03-29 11:39:47 | whiskeys | 1 | 82945 | 3 | 2.970 | 27927.6 |
546 | 2024-03-08 21:56:46 | whiskeys | 1 | 82945 | 3 | 2.920 | 28405.8 |
545 | 2024-03-07 05:55:18 | whiskeys | 1 | 82945 | 3 | 1.546 | 53651.4 |
544 | 2024-03-07 02:53:09 | whiskeys | 4 | 161609 | 816 | 28.376 | 5695.3 |
543 | 2024-03-06 05:05:47 | whiskeys | 2 | 121059 | 15 | 12.500 | 9684.7 |
542 | 2024-03-06 05:05:49 | whiskeys | 1 | 82945 | 3 | 1.563 | 53067.8 |
541 | 2024-03-06 03:26:20 | whiskeys | 3 | 146162 | 99 | 8.000 | 18270.3 |
540 | 2024-03-06 00:25:42 | whiskeys | 4 | 161609 | 816 | 27.800 | 5813.3 |
539 | 2024-03-02 04:34:58 | whiskeys | 2 | 121059 | 15 | 4.280 | 28284.8 |
538 | 2024-03-02 04:34:35 | whiskeys | 3 | 146162 | 99 | 7.330 | 19940.2 |
537 | 2024-03-01 14:19:56 | whiskeys | 4 | 161609 | 816 | 14.626 | 11049.4 |
536 | 2024-02-28 07:07:59 | whiskeys | 4 | 161609 | 816 | 37.610 | 4297.0 |
535 | 2024-02-28 07:07:57 | whiskeys | 3 | 146162 | 99 | 15.296 | 9555.6 |
534 | 2024-02-28 07:07:58 | whiskeys | 2 | 121059 | 15 | 8.266 | 14645.4 |
533 | 2024-02-28 07:02:22 | whiskeys | 4 | 161609 | 816 | 24.580 | 6574.8 |
532 | 2024-02-28 07:02:25 | whiskeys | 2 | 121059 | 15 | 10.326 | 11723.7 |
531 | 2024-02-28 07:02:23 | whiskeys | 3 | 146162 | 99 | 8.423 | 17352.7 |
530 | 2024-02-28 07:02:16 | whiskeys | 1 | 82945 | 3 | 1.703 | 48705.2 |
529 | 2024-02-28 06:51:18 | whiskeys | 1 | 82945 | 3 | 1.500 | 55296.7 |
528 | 2024-02-05 09:08:12 | whiskeys | 1 | 82945 | 3 | 1.513 | 54821.5 |
527 | 2024-02-01 01:43:44 | whiskeys | 4 | 161609 | 816 | 11.000 | 14691.7 |
526 | 2024-01-30 19:18:28 | whiskeys | 1 | 82945 | 3 | 1.343 | 61761.0 |
525 | 2024-01-27 17:24:07 | whiskeys | 3 | 146162 | 99 | 13.203 | 11070.4 |
524 | 2024-01-27 16:26:11 | whiskeys | 4 | 161609 | 816 | 11.826 | 13665.6 |
523 | 2024-01-27 16:25:37 | whiskeys | 3 | 146162 | 99 | 10.830 | 13496.0 |
522 | 2024-01-27 16:25:33 | whiskeys | 4 | 161609 | 816 | 12.453 | 12977.5 |
521 | 2024-01-27 14:41:11 | whiskeys | 4 | 161609 | 816 | 15.736 | 10270.0 |
520 | 2024-01-27 14:41:07 | whiskeys | 3 | 146162 | 99 | 6.580 | 22213.1 |
519 | 2024-01-27 14:40:59 | whiskeys | 2 | 121059 | 15 | 3.876 | 31233.0 |
518 | 2024-01-18 21:32:02 | whiskeys | 1 | 82945 | 3 | 1.360 | 60989.0 |
517 | 2024-01-14 03:13:40 | whiskeys | 2 | 121059 | 15 | 2.986 | 40542.2 |
516 | 2024-01-12 04:05:31 | whiskeys | 4 | 161609 | 816 | 10.330 | 15644.6 |
515 | 2023-11-30 20:11:41 | whiskeys | 1 | 82945 | 3 | 1.250 | 66356.0 |
514 | 2023-11-28 19:52:25 | whiskeys | 1 | 82945 | 3 | 1.326 | 62552.8 |
513 | 2023-11-28 13:17:02 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
512 | 2023-11-21 17:48:24 | whiskeys | 4 | 161609 | 816 | 11.236 | 14383.1 |
511 | 2023-11-19 19:23:29 | whiskeys | 1 | 82945 | 3 | 1.326 | 62552.8 |
510 | 2023-11-18 07:48:17 | whiskeys | 1 | 82945 | 3 | 1.360 | 60989.0 |
509 | 2023-11-10 01:53:27 | whiskeys | 4 | 161609 | 816 | 10.330 | 15644.6 |
508 | 2023-11-10 01:48:38 | whiskeys | 4 | 161609 | 816 | 12.190 | 13257.5 |
507 | 2023-11-06 18:10:17 | whiskeys | 4 | 161609 | 816 | 11.673 | 13844.7 |
506 | 2023-10-24 00:23:52 | whiskeys | 2 | 121059 | 15 | 3.546 | 34139.6 |
505 | 2023-10-21 05:44:56 | whiskeys | 4 | 161609 | 816 | 10.186 | 15865.8 |
504 | 2023-09-30 04:37:39 | whiskeys | 1 | 82945 | 3 | 2.670 | 31065.5 |
503 | 2023-09-28 12:50:11 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
502 | 2023-09-14 04:55:04 | whiskeys | 1 | 82945 | 3 | 1.356 | 61168.9 |
501 | 2023-08-08 22:19:10 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
500 | 2023-08-02 14:45:04 | whiskeys | 2 | 121059 | 15 | 3.406 | 35542.9 |
499 | 2023-08-01 02:36:04 | whiskeys | 4 | 161609 | 816 | 10.046 | 16086.9 |
498 | 2023-07-07 12:40:23 | whiskeys | 4 | 161609 | 816 | 10.876 | 14859.2 |
497 | 2023-07-04 11:18:57 | whiskeys | 1 | 82945 | 3 | 1.343 | 61761.0 |
496 | 2023-05-17 01:44:17 | whiskeys | 4 | 161609 | 816 | 10.983 | 14714.5 |
495 | 2023-04-11 11:35:31 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
494 | 2023-04-10 04:04:10 | whiskeys | 2 | 121059 | 15 | 2.953 | 40995.3 |
493 | 2023-04-08 10:45:52 | whiskeys | 4 | 161609 | 816 | 11.250 | 14365.2 |
492 | 2023-03-27 08:07:58 | whiskeys | 4 | 161609 | 816 | 10.673 | 15141.9 |
491 | 2023-03-25 11:30:24 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
490 | 2023-02-18 04:58:42 | whiskeys | 4 | 161609 | 816 | 9.970 | 16209.5 |
489 | 2023-02-02 19:24:07 | whiskeys | 1 | 82945 | 3 | 1.203 | 68948.5 |
488 | 2023-02-01 07:55:24 | whiskeys | 4 | 161609 | 816 | 13.906 | 11621.5 |
487 | 2023-01-26 16:10:24 | whiskeys | 3 | 146162 | 99 | 5.813 | 25144.0 |
486 | 2023-01-15 15:44:42 | whiskeys | 2 | 121059 | 15 | 3.080 | 39304.9 |
485 | 2023-01-09 17:51:12 | whiskeys | 4 | 161609 | 816 | 9.846 | 16413.7 |
484 | 2023-01-04 09:24:43 | whiskeys | 4 | 161609 | 816 | 10.283 | 15716.1 |
483 | 2022-12-29 13:50:11 | whiskeys | 4 | 161609 | 816 | 10.093 | 16012.0 |
482 | 2022-12-28 06:48:53 | whiskeys | 4 | 161609 | 816 | 11.593 | 13940.2 |
481 | 2022-12-16 14:35:40 | whiskeys | 4 | 161609 | 816 | 10.016 | 16135.1 |
480 | 2022-12-12 11:55:15 | whiskeys | 3 | 146162 | 99 | 7.283 | 20068.9 |
479 | 2022-12-10 03:17:21 | whiskeys | 3 | 146162 | 99 | 5.843 | 25014.9 |
478 | 2022-12-01 17:33:53 | whiskeys | 1 | 82945 | 3 | 1.186 | 69936.8 |
477 | 2022-11-19 00:51:26 | whiskeys | 4 | 161609 | 816 | 11.800 | 13695.7 |
476 | 2022-11-13 08:19:11 | whiskeys | 3 | 146162 | 99 | 6.656 | 21959.4 |
475 | 2022-11-11 08:12:20 | whiskeys | 3 | 146162 | 99 | 8.080 | 18089.4 |
474 | 2022-11-09 23:11:54 | whiskeys | 3 | 146162 | 99 | 7.596 | 19242.0 |
473 | 2022-11-02 23:06:50 | whiskeys | 1 | 82945 | 3 | 1.360 | 60989.0 |
472 | 2022-10-28 17:22:57 | whiskeys | 3 | 146162 | 99 | 6.920 | 21121.7 |
471 | 2022-10-19 21:14:21 | whiskeys | 2 | 121059 | 15 | 3.373 | 35890.6 |
470 | 2022-09-06 02:08:29 | whiskeys | 4 | 161609 | 816 | 11.313 | 14285.2 |
469 | 2022-08-26 05:20:42 | whiskeys | 3 | 146162 | 99 | 6.046 | 24175.0 |
468 | 2022-07-27 12:05:06 | whiskeys | 1 | 82945 | 3 | 1.236 | 67107.6 |
467 | 2022-05-31 11:26:32 | whiskeys | 1 | 82945 | 3 | 1.216 | 68211.3 |
466 | 2022-05-21 09:53:13 | whiskeys | 2 | 121059 | 15 | 3.030 | 39953.5 |
465 | 2022-04-15 21:40:15 | whiskeys | 3 | 146162 | 99 | 5.893 | 24802.6 |
464 | 2022-04-14 22:24:49 | whiskeys | 3 | 146162 | 99 | 7.110 | 20557.2 |
463 | 2022-04-09 02:25:30 | whiskeys | 3 | 146162 | 99 | 5.873 | 24887.1 |
462 | 2022-03-31 22:25:00 | whiskeys | 3 | 146162 | 99 | 7.143 | 20462.3 |
461 | 2022-03-31 09:17:05 | whiskeys | 3 | 146162 | 99 | 14.203 | 10290.9 |
460 | 2022-03-31 03:20:51 | whiskeys | 3 | 146162 | 99 | 8.406 | 17387.8 |
459 | 2022-03-31 02:02:24 | whiskeys | 3 | 146162 | 99 | 7.643 | 19123.6 |
458 | 2022-03-30 13:44:02 | whiskeys | 3 | 146162 | 99 | 6.643 | 22002.4 |
457 | 2022-03-30 09:07:36 | whiskeys | 3 | 146162 | 99 | 6.610 | 22112.3 |
456 | 2022-03-30 07:51:28 | whiskeys | 3 | 146162 | 99 | 6.843 | 21359.3 |
455 | 2022-03-29 16:36:54 | whiskeys | 3 | 146162 | 99 | 7.923 | 18447.8 |
454 | 2022-03-29 12:28:30 | whiskeys | 3 | 146162 | 99 | 8.610 | 16975.8 |
453 | 2022-03-29 11:10:22 | whiskeys | 3 | 146162 | 99 | 8.670 | 16858.4 |
452 | 2022-03-28 23:17:33 | whiskeys | 3 | 146162 | 99 | 6.643 | 22002.4 |
451 | 2022-03-28 22:36:20 | whiskeys | 3 | 146162 | 99 | 7.360 | 19859.0 |