History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drew"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
630 | 2024-04-23 14:31:40 | drew | 1 | 13983 | 9 | 1.250 | 11186.4 |
629 | 2024-04-05 01:32:20 | drew | 1 | 13983 | 9 | 0.530 | 26383.0 |
628 | 2024-04-04 11:16:10 | drew | 1 | 13983 | 9 | 0.280 | 49939.3 |
627 | 2024-04-03 20:10:54 | drew | 2 | 29872 | 179 | 0.983 | 30388.6 |
626 | 2024-04-03 20:10:50 | drew | 1 | 13983 | 9 | 0.266 | 52567.7 |
625 | 2024-04-03 20:10:41 | drew | 2 | 29872 | 179 | 1.453 | 20558.8 |
624 | 2024-04-03 03:35:59 | drew | 2 | 29872 | 179 | 2.046 | 14600.2 |
623 | 2024-04-03 03:17:44 | drew | 1 | 13983 | 9 | 0.530 | 26383.0 |
622 | 2024-03-31 01:03:26 | drew | 1 | 13983 | 9 | 0.810 | 17263.0 |
621 | 2024-03-27 00:03:23 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
620 | 2024-03-05 20:48:45 | drew | 2 | 29872 | 179 | 2.063 | 14479.9 |
619 | 2024-03-05 20:01:13 | drew | 1 | 13983 | 9 | 0.533 | 26234.5 |
618 | 2024-03-03 20:05:04 | drew | 1 | 13983 | 9 | 0.200 | 69915.0 |
617 | 2024-02-29 21:31:44 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
616 | 2024-02-25 16:29:06 | drew | 1 | 13983 | 9 | 0.263 | 53167.3 |
615 | 2024-02-24 10:54:05 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
614 | 2024-02-06 22:29:05 | drew | 2 | 29872 | 179 | 0.826 | 36164.6 |
613 | 2024-02-06 14:48:39 | drew | 2 | 29872 | 179 | 0.923 | 32364.0 |
612 | 2024-02-02 14:58:15 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
611 | 2023-12-29 22:16:11 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
610 | 2023-12-26 17:10:18 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
609 | 2023-12-25 14:47:22 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
608 | 2023-12-24 02:18:30 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
607 | 2023-12-13 19:11:49 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
606 | 2023-12-12 22:54:07 | drew | 2 | 29872 | 179 | 0.860 | 34734.9 |
605 | 2023-12-06 10:03:19 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
604 | 2023-12-04 08:09:12 | drew | 2 | 29872 | 179 | 0.750 | 39829.3 |
603 | 2023-11-11 12:02:33 | drew | 2 | 29872 | 179 | 0.763 | 39150.7 |
602 | 2023-11-11 04:17:00 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
601 | 2023-11-10 22:45:16 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
600 | 2023-11-03 08:53:31 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
599 | 2023-11-01 19:40:43 | drew | 2 | 29872 | 179 | 0.876 | 34100.5 |
598 | 2023-10-26 01:38:18 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
597 | 2023-10-20 16:59:12 | drew | 1 | 13983 | 9 | 0.470 | 29751.1 |
596 | 2023-10-18 04:00:57 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
595 | 2023-10-11 04:38:34 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
594 | 2023-10-04 09:39:14 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
593 | 2023-09-24 15:22:57 | drew | 2 | 29872 | 179 | 0.750 | 39829.3 |
592 | 2023-09-19 18:39:41 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
591 | 2023-09-19 11:34:29 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
590 | 2023-09-14 06:14:25 | drew | 2 | 29872 | 179 | 0.783 | 38150.7 |
589 | 2023-09-10 14:12:10 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
588 | 2023-09-03 10:53:12 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
587 | 2023-08-14 05:26:47 | drew | 2 | 29872 | 179 | 0.733 | 40753.1 |
586 | 2023-07-15 09:47:34 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
585 | 2023-05-17 17:35:20 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
584 | 2023-05-01 02:31:19 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
583 | 2023-04-23 07:29:09 | drew | 2 | 29872 | 179 | 0.736 | 40587.0 |
582 | 2023-04-20 16:12:05 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
581 | 2023-03-24 13:12:24 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
580 | 2023-02-11 17:43:52 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
579 | 2023-01-29 23:48:37 | drew | 2 | 29872 | 179 | 0.716 | 41720.7 |
578 | 2023-01-28 09:40:02 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
577 | 2023-01-24 18:27:24 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
576 | 2022-12-11 12:04:50 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
575 | 2022-11-11 14:47:57 | drew | 2 | 29872 | 179 | 0.733 | 40753.1 |
574 | 2022-10-10 10:42:26 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
573 | 2022-09-12 00:05:22 | drew | 1 | 13983 | 9 | 0.360 | 38841.7 |
572 | 2022-08-31 18:32:24 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
571 | 2022-08-24 04:09:17 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
570 | 2022-08-15 21:05:10 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
569 | 2022-08-14 06:29:39 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
568 | 2022-07-18 13:15:26 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
567 | 2022-06-27 14:35:49 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
566 | 2022-06-25 08:26:49 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
565 | 2022-06-25 01:42:42 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
564 | 2022-06-17 20:20:12 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
563 | 2022-06-10 02:13:58 | drew | 2 | 29872 | 179 | 0.750 | 39829.3 |
562 | 2022-06-07 20:43:13 | drew | 2 | 29872 | 179 | 0.766 | 38997.4 |
561 | 2022-05-04 00:42:01 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
560 | 2022-04-01 00:49:55 | drew | 1 | 13983 | 9 | 0.310 | 45106.5 |
559 | 2022-03-27 18:34:56 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
558 | 2022-03-11 03:48:17 | drew | 1 | 13983 | 9 | 0.280 | 49939.3 |
557 | 2022-01-29 05:57:12 | drew | 2 | 29872 | 179 | 0.733 | 40753.1 |
556 | 2021-12-29 09:04:35 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
555 | 2021-11-24 03:35:43 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
554 | 2021-11-07 22:21:49 | drew | 2 | 29872 | 179 | 0.983 | 30388.6 |
553 | 2021-11-01 00:24:13 | drew | 1 | 13983 | 9 | 0.326 | 42892.6 |
552 | 2021-09-16 04:55:57 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
551 | 2021-08-29 14:36:13 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
550 | 2021-08-27 09:51:14 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
549 | 2021-08-21 03:03:37 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
548 | 2021-05-20 12:28:10 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
547 | 2021-05-08 13:31:08 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
546 | 2021-02-26 16:39:12 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
545 | 2021-02-17 22:29:30 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
544 | 2020-11-13 17:40:43 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
543 | 2020-11-05 13:33:45 | drew | 1 | 13983 | 9 | 0.250 | 55932.0 |
542 | 2020-10-31 05:16:14 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
541 | 2020-10-18 15:36:22 | drew | 1 | 13983 | 9 | 0.203 | 68881.8 |
540 | 2020-10-16 12:39:23 | drew | 2 | 29872 | 179 | 0.923 | 32364.0 |
539 | 2020-08-21 20:00:01 | drew | 2 | 29872 | 179 | 0.796 | 37527.6 |
538 | 2020-08-21 07:30:47 | drew | 1 | 13983 | 9 | 0.283 | 49409.9 |
537 | 2020-08-14 19:16:54 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
536 | 2020-08-09 15:17:46 | drew | 1 | 13983 | 9 | 0.216 | 64736.1 |
535 | 2020-08-03 22:52:05 | drew | 1 | 13983 | 9 | 0.233 | 60012.9 |
534 | 2020-07-31 08:21:11 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
533 | 2020-07-28 23:30:31 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |
532 | 2020-05-16 09:10:35 | drew | 1 | 13983 | 9 | 0.236 | 59250.0 |
531 | 2020-05-08 10:23:02 | drew | 1 | 13983 | 9 | 0.220 | 63559.1 |