History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
629 | 2024-04-05 00:45:59 | sock | 1 | 13983 | 24 | 0.263 | 53167.3 |
628 | 2024-04-03 02:56:44 | sock | 2 | 29872 | 255 | 3.283 | 9099.0 |
627 | 2024-04-03 02:48:00 | sock | 1 | 13983 | 24 | 0.280 | 49939.3 |
626 | 2024-03-31 01:26:46 | sock | 2 | 29872 | 255 | 2.156 | 13855.3 |
625 | 2024-03-31 01:06:15 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
624 | 2024-03-28 17:59:07 | sock | 1 | 13983 | 24 | 0.296 | 47239.9 |
623 | 2024-03-05 19:47:30 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
622 | 2024-03-03 19:37:42 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
621 | 2024-02-29 21:51:49 | sock | 1 | 13983 | 24 | 0.530 | 26383.0 |
620 | 2024-02-26 19:21:39 | sock | 1 | 13983 | 24 | 0.280 | 49939.3 |
619 | 2024-02-25 04:52:56 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
618 | 2024-02-02 17:20:43 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
617 | 2024-01-28 17:02:47 | sock | 1 | 13983 | 24 | 0.263 | 53167.3 |
616 | 2024-01-28 16:26:25 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
615 | 2024-01-25 10:21:02 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
614 | 2024-01-05 00:17:26 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
613 | 2023-12-22 11:52:49 | sock | 2 | 29872 | 255 | 0.940 | 31778.7 |
612 | 2023-12-18 21:08:26 | sock | 1 | 13983 | 24 | 0.266 | 52567.7 |
611 | 2023-12-17 08:16:25 | sock | 2 | 29872 | 255 | 0.766 | 38997.4 |
610 | 2023-12-14 14:34:52 | sock | 2 | 29872 | 255 | 0.766 | 38997.4 |
609 | 2023-12-11 01:42:23 | sock | 1 | 13983 | 24 | 0.280 | 49939.3 |
608 | 2023-11-20 10:22:07 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
607 | 2023-11-12 03:06:23 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
606 | 2023-11-11 18:23:22 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
605 | 2023-11-11 08:53:27 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
604 | 2023-11-03 07:26:13 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
603 | 2023-10-29 05:34:33 | sock | 2 | 29872 | 255 | 0.750 | 39829.3 |
602 | 2023-10-19 21:16:23 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
601 | 2023-10-18 12:34:06 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
600 | 2023-10-14 07:24:38 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
599 | 2023-10-07 10:19:42 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
598 | 2023-09-27 00:45:46 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
597 | 2023-09-06 09:05:05 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
596 | 2023-08-15 00:23:33 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
595 | 2023-06-10 12:19:12 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
594 | 2023-06-09 11:37:09 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
593 | 2023-04-26 17:50:57 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
592 | 2023-03-27 23:28:41 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
591 | 2023-01-11 17:03:28 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
590 | 2023-01-06 23:18:53 | sock | 1 | 13983 | 24 | 0.266 | 52567.7 |
589 | 2022-11-11 05:02:15 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
588 | 2022-10-19 14:10:53 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
587 | 2022-09-16 00:50:27 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
586 | 2022-07-29 06:03:25 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
585 | 2022-07-18 19:00:29 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
584 | 2022-06-17 02:50:03 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
583 | 2022-06-09 18:26:34 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
582 | 2022-06-08 18:15:23 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
581 | 2022-06-01 20:36:29 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
580 | 2022-06-01 14:29:34 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
579 | 2022-05-25 18:10:23 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
578 | 2022-05-17 05:49:58 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
577 | 2022-05-13 16:46:35 | sock | 1 | 13983 | 24 | 0.313 | 44674.1 |
576 | 2022-05-11 19:51:54 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
575 | 2022-05-11 08:08:47 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
574 | 2022-05-10 21:33:47 | sock | 1 | 13983 | 24 | 0.313 | 44674.1 |
573 | 2022-05-10 02:11:49 | sock | 1 | 13983 | 24 | 0.390 | 35853.8 |
572 | 2022-05-08 15:01:51 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
571 | 2022-05-08 02:15:08 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
570 | 2022-05-07 16:15:41 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
569 | 2022-02-23 09:05:43 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
568 | 2022-02-17 09:55:36 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
567 | 2022-02-11 18:14:44 | sock | 1 | 13983 | 24 | 0.266 | 52567.7 |
566 | 2022-02-07 10:38:57 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
565 | 2022-02-06 09:32:36 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
564 | 2022-02-05 08:15:10 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
563 | 2022-02-04 08:25:23 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
562 | 2022-02-03 02:50:13 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
561 | 2022-02-02 08:13:50 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
560 | 2022-02-01 06:06:58 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
559 | 2022-01-31 04:03:35 | sock | 1 | 13983 | 24 | 0.266 | 52567.7 |
558 | 2022-01-30 09:48:10 | sock | 1 | 13983 | 24 | 0.263 | 53167.3 |
557 | 2022-01-29 09:01:56 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
556 | 2022-01-22 11:09:27 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
555 | 2021-12-06 16:03:27 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
554 | 2021-12-04 13:25:16 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
553 | 2021-10-11 23:55:38 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
552 | 2021-10-06 07:27:18 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
551 | 2021-09-05 19:07:24 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
550 | 2021-09-03 11:52:12 | sock | 1 | 13983 | 24 | 0.296 | 47239.9 |
549 | 2021-08-14 19:03:22 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
548 | 2021-07-07 12:32:59 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
547 | 2021-06-20 16:21:14 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
546 | 2021-05-29 10:40:16 | sock | 1 | 13983 | 24 | 0.283 | 49409.9 |
545 | 2021-04-07 17:00:57 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
544 | 2021-04-03 13:23:14 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
543 | 2021-04-01 02:03:39 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
542 | 2021-03-23 19:15:42 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
541 | 2021-02-09 19:26:51 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
540 | 2021-01-16 01:42:53 | sock | 1 | 13983 | 24 | 0.216 | 64736.1 |
539 | 2020-12-13 06:43:58 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
538 | 2020-12-11 09:26:45 | sock | 1 | 13983 | 24 | 0.220 | 63559.1 |
537 | 2020-11-13 19:41:44 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
536 | 2020-11-10 08:30:49 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
535 | 2020-10-20 08:48:26 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
534 | 2020-10-02 13:39:57 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
533 | 2020-09-04 15:41:12 | sock | 1 | 13983 | 24 | 0.236 | 59250.0 |
532 | 2020-08-07 20:31:33 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |
531 | 2020-07-30 11:44:02 | sock | 1 | 13983 | 24 | 0.233 | 60012.9 |
530 | 2020-07-17 17:42:39 | sock | 1 | 13983 | 24 | 0.250 | 55932.0 |