History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
626 | 2024-04-05 23:45:00 | spry | 2 | 29872 | 151 | 1.203 | 24831.3 |
625 | 2024-04-04 19:55:18 | spry | 2 | 29872 | 151 | 1.220 | 24485.2 |
624 | 2024-04-04 19:21:32 | spry | 1 | 13983 | 7 | 0.296 | 47239.9 |
623 | 2024-04-02 18:41:33 | spry | 1 | 13983 | 7 | 0.830 | 16847.0 |
622 | 2024-03-30 19:28:10 | spry | 2 | 29872 | 151 | 3.013 | 9914.4 |
621 | 2024-03-30 19:14:39 | spry | 1 | 13983 | 7 | 0.546 | 25609.9 |
620 | 2024-03-28 17:50:15 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
619 | 2024-03-05 17:31:02 | spry | 1 | 13983 | 7 | 0.796 | 17566.6 |
618 | 2024-02-25 22:35:26 | spry | 1 | 13983 | 7 | 0.390 | 35853.8 |
617 | 2024-02-03 00:30:21 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
616 | 2024-01-26 21:44:45 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
615 | 2023-12-29 17:02:26 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
614 | 2023-12-29 05:21:56 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
613 | 2023-12-21 02:59:44 | spry | 2 | 29872 | 151 | 0.923 | 32364.0 |
612 | 2023-12-15 22:49:47 | spry | 2 | 29872 | 151 | 0.876 | 34100.5 |
611 | 2023-12-09 18:19:01 | spry | 2 | 29872 | 151 | 0.800 | 37340.0 |
610 | 2023-11-19 21:47:16 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
609 | 2023-11-12 02:28:50 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
608 | 2023-11-04 18:10:39 | spry | 2 | 29872 | 151 | 0.860 | 34734.9 |
607 | 2023-11-04 10:38:03 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
606 | 2023-10-28 11:06:24 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
605 | 2023-10-21 04:03:57 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
604 | 2023-10-20 03:35:22 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
603 | 2023-10-18 16:59:51 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
602 | 2023-10-16 13:56:08 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
601 | 2023-10-12 22:01:54 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
600 | 2023-10-12 03:33:48 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
599 | 2023-10-04 12:22:25 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
598 | 2023-09-27 06:02:16 | spry | 2 | 29872 | 151 | 0.906 | 32971.3 |
597 | 2023-09-22 08:15:48 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
596 | 2023-09-19 17:34:32 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
595 | 2023-09-15 08:11:34 | spry | 2 | 29872 | 151 | 0.813 | 36742.9 |
594 | 2023-08-16 07:07:21 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
593 | 2023-06-15 08:43:20 | spry | 2 | 29872 | 151 | 0.736 | 40587.0 |
592 | 2023-06-12 16:37:40 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
591 | 2023-05-18 17:51:17 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
590 | 2023-03-14 08:06:26 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
589 | 2023-03-13 20:17:53 | spry | 2 | 29872 | 151 | 0.796 | 37527.6 |
588 | 2023-02-14 11:06:43 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
587 | 2022-12-18 00:03:05 | spry | 2 | 29872 | 151 | 0.733 | 40753.1 |
586 | 2022-12-07 17:23:53 | spry | 2 | 29872 | 151 | 0.733 | 40753.1 |
585 | 2022-10-30 13:48:00 | spry | 2 | 29872 | 151 | 0.893 | 33451.3 |
584 | 2022-10-09 22:42:28 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
583 | 2022-09-28 17:29:03 | spry | 2 | 29872 | 151 | 0.843 | 35435.3 |
582 | 2022-09-12 22:47:29 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
581 | 2022-08-30 23:59:12 | spry | 2 | 29872 | 151 | 0.736 | 40587.0 |
580 | 2022-08-26 15:11:45 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
579 | 2022-08-17 18:06:49 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
578 | 2022-08-10 14:42:36 | spry | 2 | 29872 | 151 | 0.780 | 38297.4 |
577 | 2022-08-08 05:39:00 | spry | 2 | 29872 | 151 | 0.736 | 40587.0 |
576 | 2022-06-08 13:19:58 | spry | 1 | 13983 | 7 | 0.280 | 49939.3 |
575 | 2022-04-27 10:31:42 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
574 | 2022-03-09 08:25:59 | spry | 2 | 29872 | 151 | 0.846 | 35309.7 |
573 | 2022-02-04 05:28:26 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
572 | 2022-01-18 16:49:02 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
571 | 2021-11-16 11:38:09 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
570 | 2021-10-11 14:23:45 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
569 | 2021-10-04 05:52:59 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
568 | 2021-09-15 02:08:44 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
567 | 2021-07-10 02:22:24 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
566 | 2021-07-03 03:02:02 | spry | 2 | 29872 | 151 | 0.783 | 38150.7 |
565 | 2021-06-25 15:05:48 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
564 | 2021-04-16 06:48:22 | spry | 2 | 29872 | 151 | 0.873 | 34217.6 |
563 | 2021-04-06 19:49:34 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
562 | 2021-04-06 06:07:45 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
561 | 2021-04-02 02:32:11 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
560 | 2021-02-03 13:18:40 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
559 | 2021-01-29 04:58:58 | spry | 2 | 29872 | 151 | 0.860 | 34734.9 |
558 | 2021-01-22 01:11:50 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
557 | 2020-12-24 20:01:37 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
556 | 2020-12-23 03:04:17 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
555 | 2020-11-19 03:44:23 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
554 | 2020-10-20 05:32:23 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
553 | 2020-09-20 23:27:06 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
552 | 2020-08-27 07:10:33 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
551 | 2020-08-06 22:54:28 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
550 | 2020-08-03 16:14:27 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
549 | 2020-07-24 03:50:47 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
548 | 2020-06-16 18:05:18 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
547 | 2020-06-07 11:04:16 | spry | 1 | 13983 | 7 | 0.203 | 68881.8 |
546 | 2020-06-02 21:31:22 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
545 | 2020-05-04 19:15:05 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
544 | 2020-03-30 01:58:28 | spry | 1 | 13983 | 7 | 0.236 | 59250.0 |
543 | 2020-03-25 19:01:58 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
542 | 2020-03-25 01:39:28 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
541 | 2020-03-24 19:00:06 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
540 | 2020-03-22 09:36:03 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
539 | 2020-03-21 16:21:47 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
538 | 2020-03-21 04:30:18 | spry | 1 | 13983 | 7 | 0.220 | 63559.1 |
537 | 2020-03-18 04:43:11 | spry | 1 | 13983 | 7 | 0.216 | 64736.1 |
536 | 2020-03-05 22:31:35 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
535 | 2020-02-28 19:51:31 | spry | 1 | 13983 | 7 | 0.263 | 53167.3 |
534 | 2020-02-25 17:07:58 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
533 | 2020-02-15 04:55:34 | spry | 1 | 13983 | 7 | 0.563 | 24836.6 |
532 | 2020-02-10 09:17:52 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
531 | 2020-02-08 06:32:59 | spry | 1 | 13983 | 7 | 0.856 | 16335.3 |
530 | 2020-01-31 13:44:45 | spry | 1 | 13983 | 7 | 0.250 | 55932.0 |
529 | 2020-01-28 06:38:25 | spry | 1 | 13983 | 7 | 0.233 | 60012.9 |
528 | 2020-01-26 21:22:23 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |
527 | 2020-01-22 04:05:21 | spry | 1 | 13983 | 7 | 0.266 | 52567.7 |