History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bobbies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
633 | 2024-04-27 08:42:29 | bobbies | 1 | 69583 | 8 | 1.343 | 51811.6 |
632 | 2024-04-23 00:04:51 | bobbies | 1 | 69583 | 8 | 1.173 | 59320.5 |
631 | 2024-04-22 13:27:07 | bobbies | 1 | 69583 | 8 | 4.546 | 15306.4 |
630 | 2024-03-28 07:48:05 | bobbies | 1 | 69583 | 8 | 2.263 | 30748.1 |
629 | 2024-03-21 22:07:41 | bobbies | 3 | 134027 | 545 | 10.720 | 12502.5 |
628 | 2024-03-15 20:36:21 | bobbies | 2 | 107671 | 68 | 3.563 | 30219.2 |
627 | 2024-03-15 20:33:42 | bobbies | 3 | 134027 | 545 | 7.453 | 17983.0 |
626 | 2024-03-15 10:19:42 | bobbies | 3 | 134027 | 545 | 10.593 | 12652.4 |
625 | 2024-03-14 15:42:11 | bobbies | 3 | 134027 | 545 | 22.546 | 5944.6 |
624 | 2024-03-13 17:50:46 | bobbies | 1 | 69583 | 8 | 4.296 | 16197.2 |
623 | 2024-03-13 17:50:19 | bobbies | 3 | 134027 | 545 | 22.066 | 6073.9 |
622 | 2024-03-13 17:50:27 | bobbies | 2 | 107671 | 68 | 4.893 | 22005.1 |
621 | 2024-02-12 12:47:04 | bobbies | 2 | 107671 | 68 | 5.720 | 18823.6 |
620 | 2024-01-24 06:45:59 | bobbies | 3 | 134027 | 545 | 5.876 | 22809.2 |
619 | 2024-01-13 09:55:50 | bobbies | 1 | 69583 | 8 | 1.140 | 61037.7 |
618 | 2023-12-31 16:38:07 | bobbies | 1 | 69583 | 8 | 1.110 | 62687.4 |
617 | 2023-12-21 20:10:31 | bobbies | 1 | 69583 | 8 | 1.140 | 61037.7 |
616 | 2023-11-23 04:11:58 | bobbies | 1 | 69583 | 8 | 1.266 | 54962.9 |
615 | 2023-11-05 21:07:36 | bobbies | 1 | 69583 | 8 | 1.080 | 64428.7 |
614 | 2023-11-03 10:40:07 | bobbies | 3 | 134027 | 545 | 5.673 | 23625.4 |
613 | 2023-10-29 05:04:22 | bobbies | 1 | 69583 | 8 | 1.953 | 35628.8 |
612 | 2023-10-25 15:35:38 | bobbies | 1 | 69583 | 8 | 1.080 | 64428.7 |
611 | 2023-10-22 15:33:42 | bobbies | 1 | 69583 | 8 | 1.233 | 56433.9 |
610 | 2023-09-30 02:24:33 | bobbies | 1 | 69583 | 8 | 1.076 | 64668.2 |
609 | 2023-09-24 23:21:07 | bobbies | 1 | 69583 | 8 | 1.140 | 61037.7 |
608 | 2023-09-21 22:22:40 | bobbies | 1 | 69583 | 8 | 1.220 | 57035.2 |
607 | 2023-08-18 00:38:38 | bobbies | 1 | 69583 | 8 | 1.156 | 60192.9 |
606 | 2023-08-10 17:47:54 | bobbies | 3 | 134027 | 545 | 5.626 | 23822.8 |
605 | 2023-06-26 08:11:30 | bobbies | 1 | 69583 | 8 | 1.080 | 64428.7 |
604 | 2023-05-20 12:10:06 | bobbies | 1 | 69583 | 8 | 1.076 | 64668.2 |
603 | 2023-04-22 02:50:13 | bobbies | 3 | 134027 | 545 | 5.530 | 24236.3 |
602 | 2023-04-13 20:10:14 | bobbies | 3 | 134027 | 545 | 5.546 | 24166.4 |
601 | 2023-03-20 12:23:42 | bobbies | 1 | 69583 | 8 | 1.186 | 58670.3 |
600 | 2023-03-18 18:37:40 | bobbies | 3 | 134027 | 545 | 5.983 | 22401.3 |
599 | 2023-02-15 15:41:52 | bobbies | 1 | 69583 | 8 | 1.203 | 57841.2 |
598 | 2023-01-27 08:42:34 | bobbies | 3 | 134027 | 545 | 10.330 | 12974.5 |
597 | 2023-01-25 14:59:05 | bobbies | 3 | 134027 | 545 | 9.216 | 14542.9 |
596 | 2023-01-23 14:59:01 | bobbies | 3 | 134027 | 545 | 5.470 | 24502.2 |
595 | 2023-01-04 12:30:00 | bobbies | 1 | 69583 | 8 | 1.046 | 66522.9 |
594 | 2023-01-03 14:37:56 | bobbies | 3 | 134027 | 545 | 5.563 | 24092.6 |
593 | 2022-12-13 06:48:46 | bobbies | 3 | 134027 | 545 | 6.860 | 19537.5 |
592 | 2022-12-11 10:12:11 | bobbies | 3 | 134027 | 545 | 6.046 | 22167.9 |
591 | 2022-12-08 23:19:22 | bobbies | 1 | 69583 | 8 | 1.173 | 59320.5 |
590 | 2022-11-24 14:23:50 | bobbies | 2 | 107671 | 68 | 2.800 | 38453.9 |
589 | 2022-11-08 06:04:58 | bobbies | 3 | 134027 | 545 | 6.376 | 21020.5 |
588 | 2022-10-04 17:33:45 | bobbies | 2 | 107671 | 68 | 2.763 | 38968.9 |
587 | 2022-09-26 09:25:25 | bobbies | 1 | 69583 | 8 | 1.110 | 62687.4 |
586 | 2022-09-11 16:54:17 | bobbies | 1 | 69583 | 8 | 1.060 | 65644.3 |
585 | 2022-09-01 17:15:46 | bobbies | 1 | 69583 | 8 | 2.390 | 29114.2 |
584 | 2022-08-29 06:34:01 | bobbies | 2 | 107671 | 68 | 3.266 | 32967.2 |
583 | 2022-08-29 00:22:37 | bobbies | 1 | 69583 | 8 | 1.063 | 65459.1 |
582 | 2022-08-28 08:07:18 | bobbies | 2 | 107671 | 68 | 2.953 | 36461.6 |
581 | 2022-08-15 16:13:14 | bobbies | 1 | 69583 | 8 | 1.080 | 64428.7 |
580 | 2022-07-30 08:06:36 | bobbies | 1 | 69583 | 8 | 1.170 | 59472.6 |
579 | 2022-07-18 10:02:37 | bobbies | 1 | 69583 | 8 | 1.110 | 62687.4 |
578 | 2022-07-15 13:52:42 | bobbies | 2 | 107671 | 68 | 2.750 | 39153.1 |
577 | 2022-06-16 20:08:24 | bobbies | 1 | 69583 | 8 | 1.093 | 63662.4 |
576 | 2022-06-07 10:06:09 | bobbies | 2 | 107671 | 68 | 2.780 | 38730.6 |
575 | 2022-06-01 18:06:27 | bobbies | 1 | 69583 | 8 | 1.063 | 65459.1 |
574 | 2022-05-25 19:34:32 | bobbies | 1 | 69583 | 8 | 1.063 | 65459.1 |
573 | 2022-05-16 09:09:28 | bobbies | 1 | 69583 | 8 | 2.263 | 30748.1 |
572 | 2022-05-06 21:55:41 | bobbies | 1 | 69583 | 8 | 1.090 | 63837.6 |
571 | 2022-05-06 07:48:51 | bobbies | 3 | 134027 | 545 | 5.563 | 24092.6 |
570 | 2022-05-04 18:33:08 | bobbies | 1 | 69583 | 8 | 1.220 | 57035.2 |
569 | 2022-04-27 00:07:16 | bobbies | 2 | 107671 | 68 | 3.110 | 34620.9 |
568 | 2022-04-26 04:25:33 | bobbies | 2 | 107671 | 68 | 3.110 | 34620.9 |
567 | 2022-02-21 19:59:32 | bobbies | 2 | 107671 | 68 | 3.390 | 31761.4 |
566 | 2022-02-08 04:55:35 | bobbies | 1 | 69583 | 8 | 1.220 | 57035.2 |
565 | 2022-01-25 21:37:23 | bobbies | 1 | 69583 | 8 | 1.076 | 64668.2 |
564 | 2022-01-23 17:24:42 | bobbies | 1 | 69583 | 8 | 1.046 | 66522.9 |
563 | 2021-11-19 06:07:39 | bobbies | 1 | 69583 | 8 | 1.440 | 48321.5 |
562 | 2021-11-15 23:59:03 | bobbies | 2 | 107671 | 68 | 3.283 | 32796.5 |
561 | 2021-11-07 06:43:49 | bobbies | 1 | 69583 | 8 | 1.186 | 58670.3 |
560 | 2021-10-09 02:43:06 | bobbies | 1 | 69583 | 8 | 1.076 | 64668.2 |
559 | 2021-09-20 02:17:23 | bobbies | 1 | 69583 | 8 | 1.063 | 65459.1 |
558 | 2021-08-04 04:45:06 | bobbies | 1 | 69583 | 8 | 1.063 | 65459.1 |
557 | 2021-05-26 00:31:21 | bobbies | 1 | 69583 | 8 | 2.500 | 27833.2 |
556 | 2021-05-03 11:44:48 | bobbies | 1 | 69583 | 8 | 1.233 | 56433.9 |
555 | 2021-04-29 19:59:18 | bobbies | 1 | 69583 | 8 | 1.203 | 57841.2 |
554 | 2021-01-25 09:18:26 | bobbies | 1 | 69583 | 8 | 1.153 | 60349.5 |
553 | 2021-01-12 14:44:31 | bobbies | 1 | 69583 | 8 | 1.080 | 64428.7 |
552 | 2020-10-24 04:44:44 | bobbies | 1 | 69583 | 8 | 1.143 | 60877.5 |
551 | 2020-10-04 07:30:42 | bobbies | 1 | 69583 | 8 | 1.110 | 62687.4 |
550 | 2020-09-29 23:21:50 | bobbies | 1 | 69583 | 8 | 1.183 | 58819.1 |
549 | 2020-09-17 18:50:25 | bobbies | 1 | 69583 | 8 | 1.093 | 63662.4 |
548 | 2020-08-08 00:18:48 | bobbies | 1 | 69583 | 8 | 1.126 | 61796.6 |
547 | 2020-08-04 19:15:52 | bobbies | 1 | 69583 | 8 | 1.110 | 62687.4 |
546 | 2020-07-24 16:02:34 | bobbies | 1 | 69583 | 8 | 1.093 | 63662.4 |
545 | 2020-07-20 20:10:26 | bobbies | 1 | 69583 | 8 | 1.156 | 60192.9 |
544 | 2020-06-16 18:00:28 | bobbies | 1 | 69583 | 8 | 1.093 | 63662.4 |
543 | 2020-05-07 12:16:11 | bobbies | 1 | 69583 | 8 | 1.330 | 52318.0 |
542 | 2020-04-22 11:26:53 | bobbies | 1 | 69583 | 8 | 1.140 | 61037.7 |
541 | 2020-03-28 15:02:31 | bobbies | 1 | 69583 | 8 | 1.283 | 54234.6 |
540 | 2020-03-26 18:53:32 | bobbies | 1 | 69583 | 8 | 1.313 | 52995.4 |
539 | 2020-03-25 16:01:30 | bobbies | 1 | 69583 | 8 | 1.203 | 57841.2 |
538 | 2020-03-20 02:51:58 | bobbies | 1 | 69583 | 8 | 1.173 | 59320.5 |
537 | 2020-02-27 23:26:43 | bobbies | 3 | 134027 | 545 | 7.766 | 17258.2 |
536 | 2020-02-27 22:59:58 | bobbies | 1 | 69583 | 8 | 1.500 | 46388.7 |
535 | 2020-02-27 15:35:06 | bobbies | 3 | 134027 | 545 | 21.220 | 6316.1 |
534 | 2020-02-27 14:12:43 | bobbies | 3 | 134027 | 545 | 9.516 | 14084.4 |