History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"billies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
623 | 2025-04-19 23:25:37 | billies | 1 | 69583 | 13 | 2.453 | 28366.5 |
622 | 2025-04-19 08:15:50 | billies | 1 | 69583 | 13 | 1.076 | 64668.2 |
621 | 2025-04-16 00:23:30 | billies | 3 | 134027 | 740 | 17.626 | 7603.9 |
620 | 2025-04-15 11:30:17 | billies | 1 | 69583 | 13 | 1.236 | 56296.9 |
619 | 2025-04-14 14:14:37 | billies | 1 | 69583 | 13 | 8.013 | 8683.8 |
618 | 2025-04-03 18:06:22 | billies | 1 | 69583 | 13 | 1.140 | 61037.7 |
617 | 2025-03-28 11:20:24 | billies | 1 | 69583 | 13 | 8.720 | 7979.7 |
616 | 2025-03-26 00:36:32 | billies | 3 | 134027 | 740 | 19.453 | 6889.8 |
615 | 2025-03-25 07:09:05 | billies | 3 | 134027 | 740 | 49.660 | 2698.9 |
614 | 2025-03-23 06:21:49 | billies | 3 | 134027 | 740 | 25.546 | 5246.5 |
613 | 2025-03-23 01:56:35 | billies | 1 | 69583 | 13 | 3.890 | 17887.7 |
612 | 2025-03-20 23:23:02 | billies | 2 | 107671 | 100 | 16.466 | 6539.0 |
611 | 2025-03-20 22:20:45 | billies | 3 | 134027 | 740 | 34.470 | 3888.2 |
610 | 2025-03-19 00:55:55 | billies | 1 | 69583 | 13 | 1.110 | 62687.4 |
609 | 2025-03-15 07:37:30 | billies | 1 | 69583 | 13 | 5.953 | 11688.7 |
608 | 2025-03-05 20:51:22 | billies | 1 | 69583 | 13 | 3.516 | 19790.4 |
607 | 2025-03-03 04:32:43 | billies | 1 | 69583 | 13 | 7.070 | 9842.0 |
606 | 2025-02-28 13:40:48 | billies | 1 | 69583 | 13 | 4.280 | 16257.7 |
605 | 2025-02-20 21:01:54 | billies | 1 | 69583 | 13 | 4.563 | 15249.4 |
604 | 2025-02-14 07:37:16 | billies | 1 | 69583 | 13 | 2.046 | 34009.3 |
603 | 2025-02-10 10:37:00 | billies | 1 | 69583 | 13 | 2.453 | 28366.5 |
602 | 2025-02-06 16:30:28 | billies | 1 | 69583 | 13 | 6.390 | 10889.4 |
601 | 2025-01-29 21:57:00 | billies | 2 | 107671 | 100 | 10.390 | 10362.9 |
600 | 2025-01-29 12:55:13 | billies | 1 | 69583 | 13 | 4.096 | 16988.0 |
599 | 2025-01-28 17:30:59 | billies | 2 | 107671 | 100 | 15.830 | 6801.7 |
598 | 2025-01-28 08:55:46 | billies | 3 | 134027 | 740 | 22.500 | 5956.8 |
597 | 2025-01-28 05:40:31 | billies | 3 | 134027 | 740 | 15.533 | 8628.5 |
596 | 2025-01-27 17:48:48 | billies | 3 | 134027 | 740 | 20.186 | 6639.6 |
595 | 2025-01-27 16:35:08 | billies | 3 | 134027 | 740 | 24.313 | 5512.6 |
594 | 2025-01-27 16:35:04 | billies | 2 | 107671 | 100 | 19.046 | 5653.2 |
593 | 2025-01-20 23:03:27 | billies | 1 | 69583 | 13 | 5.610 | 12403.4 |
592 | 2025-01-09 10:38:14 | billies | 1 | 69583 | 13 | 8.046 | 8648.1 |
591 | 2024-12-31 04:03:10 | billies | 1 | 69583 | 13 | 8.686 | 8010.9 |
590 | 2024-12-30 07:23:24 | billies | 1 | 69583 | 13 | 3.766 | 18476.6 |
589 | 2024-12-18 11:44:46 | billies | 1 | 69583 | 13 | 5.673 | 12265.6 |
588 | 2024-12-10 04:38:22 | billies | 1 | 69583 | 13 | 3.656 | 19032.5 |
587 | 2024-11-14 21:21:33 | billies | 1 | 69583 | 13 | 3.156 | 22047.8 |
586 | 2024-11-13 16:39:07 | billies | 1 | 69583 | 13 | 5.030 | 13833.6 |
585 | 2024-11-08 03:09:44 | billies | 1 | 69583 | 13 | 2.686 | 25905.8 |
584 | 2024-10-26 09:25:12 | billies | 1 | 69583 | 13 | 3.000 | 23194.3 |
583 | 2024-10-14 07:18:05 | billies | 1 | 69583 | 13 | 8.563 | 8126.0 |
582 | 2024-09-11 16:52:31 | billies | 1 | 69583 | 13 | 7.440 | 9352.6 |
581 | 2024-09-07 13:30:13 | billies | 1 | 69583 | 13 | 13.176 | 5281.0 |
580 | 2024-09-05 05:20:53 | billies | 1 | 69583 | 13 | 9.736 | 7147.0 |
579 | 2024-08-29 03:07:24 | billies | 1 | 69583 | 13 | 5.766 | 12067.8 |
578 | 2024-08-17 08:43:00 | billies | 1 | 69583 | 13 | 13.236 | 5257.1 |
577 | 2024-08-15 05:28:48 | billies | 1 | 69583 | 13 | 12.843 | 5418.0 |
576 | 2024-08-15 05:28:08 | billies | 1 | 69583 | 13 | 9.906 | 7024.3 |
575 | 2024-08-08 04:26:20 | billies | 1 | 69583 | 13 | 5.110 | 13617.0 |
574 | 2024-08-05 18:27:05 | billies | 1 | 69583 | 13 | 4.046 | 17198.0 |
573 | 2024-08-02 03:35:04 | billies | 1 | 69583 | 13 | 5.220 | 13330.1 |
572 | 2024-07-29 18:12:50 | billies | 3 | 134027 | 740 | 22.030 | 6083.8 |
571 | 2024-07-29 15:43:03 | billies | 2 | 107671 | 100 | 13.266 | 8116.3 |
570 | 2024-07-29 15:09:04 | billies | 3 | 134027 | 740 | 7.500 | 17870.3 |
569 | 2024-07-29 14:30:35 | billies | 3 | 134027 | 740 | 18.703 | 7166.1 |
568 | 2024-07-29 14:30:34 | billies | 2 | 107671 | 100 | 17.613 | 6113.2 |
567 | 2024-07-29 14:15:26 | billies | 1 | 69583 | 13 | 4.283 | 16246.3 |
566 | 2024-07-11 02:59:17 | billies | 1 | 69583 | 13 | 4.530 | 15360.5 |
565 | 2024-07-07 13:30:21 | billies | 1 | 69583 | 13 | 4.796 | 14508.5 |
564 | 2024-07-07 13:29:11 | billies | 1 | 69583 | 13 | 2.140 | 32515.4 |
563 | 2024-07-02 04:09:33 | billies | 1 | 69583 | 13 | 6.513 | 10683.7 |
562 | 2024-06-28 20:55:02 | billies | 1 | 69583 | 13 | 4.576 | 15206.1 |
561 | 2024-06-28 19:01:00 | billies | 1 | 69583 | 13 | 4.560 | 15259.4 |
560 | 2024-06-27 22:17:32 | billies | 1 | 69583 | 13 | 2.516 | 27656.2 |
559 | 2024-06-14 10:03:38 | billies | 1 | 69583 | 13 | 3.936 | 17678.6 |
558 | 2024-06-11 10:18:42 | billies | 1 | 69583 | 13 | 3.330 | 20895.8 |
557 | 2024-05-28 05:31:52 | billies | 1 | 69583 | 13 | 5.456 | 12753.5 |
556 | 2024-03-28 11:03:39 | billies | 1 | 69583 | 13 | 1.063 | 65459.1 |
555 | 2024-01-09 06:51:18 | billies | 3 | 134027 | 740 | 6.233 | 21502.8 |
554 | 2024-01-09 06:51:17 | billies | 2 | 107671 | 100 | 3.313 | 32499.5 |
553 | 2023-12-27 19:18:40 | billies | 3 | 134027 | 740 | 6.580 | 20368.8 |
552 | 2023-12-27 19:18:37 | billies | 2 | 107671 | 100 | 3.143 | 34257.4 |
551 | 2023-12-21 13:15:09 | billies | 1 | 69583 | 13 | 1.110 | 62687.4 |
550 | 2023-12-15 13:29:49 | billies | 1 | 69583 | 13 | 2.436 | 28564.4 |
549 | 2023-12-14 22:41:42 | billies | 1 | 69583 | 13 | 1.126 | 61796.6 |
548 | 2023-12-12 04:31:35 | billies | 1 | 69583 | 13 | 1.190 | 58473.1 |
547 | 2023-12-07 13:24:41 | billies | 2 | 107671 | 100 | 3.046 | 35348.3 |
546 | 2023-12-07 13:24:37 | billies | 3 | 134027 | 740 | 5.910 | 22678.0 |
545 | 2023-12-07 08:42:10 | billies | 3 | 134027 | 740 | 6.063 | 22105.7 |
544 | 2023-12-03 15:21:42 | billies | 3 | 134027 | 740 | 6.326 | 21186.7 |
543 | 2023-12-03 15:21:35 | billies | 3 | 134027 | 740 | 5.876 | 22809.2 |
542 | 2023-12-03 15:16:50 | billies | 3 | 134027 | 740 | 6.376 | 21020.5 |
541 | 2023-12-03 00:14:43 | billies | 3 | 134027 | 740 | 5.686 | 23571.4 |
540 | 2023-12-03 00:14:40 | billies | 2 | 107671 | 100 | 3.030 | 35535.0 |
539 | 2023-11-26 05:09:28 | billies | 1 | 69583 | 13 | 1.263 | 55093.4 |
538 | 2023-11-15 03:30:35 | billies | 1 | 69583 | 13 | 1.170 | 59472.6 |
537 | 2023-11-14 21:43:01 | billies | 1 | 69583 | 13 | 1.156 | 60192.9 |
536 | 2023-11-11 02:44:50 | billies | 1 | 69583 | 13 | 1.093 | 63662.4 |
535 | 2023-10-30 08:20:23 | billies | 1 | 69583 | 13 | 1.220 | 57035.2 |
534 | 2023-10-22 06:32:01 | billies | 1 | 69583 | 13 | 1.203 | 57841.2 |
533 | 2023-10-19 01:17:54 | billies | 1 | 69583 | 13 | 1.063 | 65459.1 |
532 | 2023-10-13 23:07:01 | billies | 1 | 69583 | 13 | 1.063 | 65459.1 |
531 | 2023-10-08 22:36:41 | billies | 1 | 69583 | 13 | 1.376 | 50569.0 |
530 | 2023-10-07 01:16:32 | billies | 3 | 134027 | 740 | 9.250 | 14489.4 |
529 | 2023-10-01 05:48:39 | billies | 2 | 107671 | 100 | 5.076 | 21211.8 |
528 | 2023-10-01 05:48:33 | billies | 3 | 134027 | 740 | 9.436 | 14203.8 |
527 | 2023-09-28 03:07:34 | billies | 3 | 134027 | 740 | 8.986 | 14915.1 |
526 | 2023-09-28 03:07:35 | billies | 2 | 107671 | 100 | 3.296 | 32667.2 |
525 | 2023-09-25 16:11:45 | billies | 1 | 69583 | 13 | 1.076 | 64668.2 |
524 | 2023-09-25 09:14:20 | billies | 1 | 69583 | 13 | 1.050 | 66269.5 |