History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jobber"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
623 | 2024-04-15 05:00:46 | jobber | 1 | 48755 | 14 | 1.906 | 25579.7 |
622 | 2024-04-06 00:41:51 | jobber | 3 | 112716 | 718 | 12.750 | 8840.5 |
621 | 2024-04-05 04:22:01 | jobber | 3 | 112716 | 718 | 11.970 | 9416.5 |
620 | 2024-04-05 04:22:04 | jobber | 2 | 82551 | 78 | 8.126 | 10158.9 |
619 | 2024-04-05 04:21:49 | jobber | 1 | 48755 | 14 | 0.906 | 53813.5 |
618 | 2024-04-05 04:21:30 | jobber | 3 | 112716 | 718 | 6.796 | 16585.6 |
617 | 2024-04-05 04:21:29 | jobber | 2 | 82551 | 78 | 5.860 | 14087.2 |
616 | 2024-04-05 04:21:24 | jobber | 1 | 48755 | 14 | 1.170 | 41670.9 |
615 | 2024-03-31 19:11:40 | jobber | 1 | 48755 | 14 | 0.890 | 54780.9 |
614 | 2024-03-31 06:02:43 | jobber | 1 | 48755 | 14 | 0.953 | 51159.5 |
613 | 2024-03-02 02:25:53 | jobber | 1 | 48755 | 14 | 0.940 | 51867.0 |
612 | 2024-02-28 05:18:40 | jobber | 1 | 48755 | 14 | 1.530 | 31866.0 |
611 | 2024-02-28 05:11:03 | jobber | 1 | 48755 | 14 | 2.736 | 17819.8 |
610 | 2024-02-26 21:28:11 | jobber | 3 | 112716 | 718 | 6.953 | 16211.1 |
609 | 2024-02-25 19:41:25 | jobber | 3 | 112716 | 718 | 5.750 | 19602.8 |
608 | 2024-02-25 19:41:18 | jobber | 2 | 82551 | 78 | 2.406 | 34310.5 |
607 | 2024-02-22 06:42:14 | jobber | 2 | 82551 | 78 | 5.000 | 16510.2 |
606 | 2024-02-21 15:24:05 | jobber | 2 | 82551 | 78 | 6.810 | 12122.0 |
605 | 2024-02-18 03:29:38 | jobber | 2 | 82551 | 78 | 2.343 | 35233.0 |
604 | 2024-01-30 19:36:24 | jobber | 2 | 82551 | 78 | 2.546 | 32423.8 |
603 | 2024-01-30 19:35:08 | jobber | 3 | 112716 | 718 | 7.826 | 14402.8 |
602 | 2024-01-30 13:31:43 | jobber | 3 | 112716 | 718 | 5.030 | 22408.7 |
601 | 2024-01-30 09:43:43 | jobber | 2 | 82551 | 78 | 2.516 | 32810.4 |
600 | 2024-01-30 09:43:15 | jobber | 3 | 112716 | 718 | 5.250 | 21469.7 |
599 | 2024-01-23 03:44:21 | jobber | 3 | 112716 | 718 | 6.410 | 17584.4 |
598 | 2024-01-20 22:48:35 | jobber | 3 | 112716 | 718 | 5.250 | 21469.7 |
597 | 2024-01-10 16:28:40 | jobber | 2 | 82551 | 78 | 2.030 | 40665.5 |
596 | 2024-01-04 20:24:39 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
595 | 2023-12-17 01:41:58 | jobber | 3 | 112716 | 718 | 5.063 | 22262.7 |
594 | 2023-12-17 01:41:55 | jobber | 2 | 82551 | 78 | 2.343 | 35233.0 |
593 | 2023-12-04 09:42:06 | jobber | 1 | 48755 | 14 | 0.796 | 61250.0 |
592 | 2023-12-04 09:42:05 | jobber | 1 | 48755 | 14 | 0.813 | 59969.2 |
591 | 2023-11-28 16:43:29 | jobber | 3 | 112716 | 718 | 4.906 | 22975.1 |
590 | 2023-11-22 02:17:28 | jobber | 3 | 112716 | 718 | 5.500 | 20493.8 |
589 | 2023-11-20 22:05:01 | jobber | 1 | 48755 | 14 | 0.830 | 58741.0 |
588 | 2023-11-16 16:56:34 | jobber | 2 | 82551 | 78 | 2.030 | 40665.5 |
587 | 2023-11-11 13:45:28 | jobber | 1 | 48755 | 14 | 0.796 | 61250.0 |
586 | 2023-11-05 20:35:41 | jobber | 1 | 48755 | 14 | 0.843 | 57835.1 |
585 | 2023-10-27 15:27:30 | jobber | 1 | 48755 | 14 | 0.890 | 54780.9 |
584 | 2023-10-26 06:16:41 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
583 | 2023-10-19 23:35:25 | jobber | 1 | 48755 | 14 | 0.843 | 57835.1 |
582 | 2023-10-19 23:11:50 | jobber | 1 | 48755 | 14 | 0.796 | 61250.0 |
581 | 2023-10-11 13:20:12 | jobber | 1 | 48755 | 14 | 0.830 | 58741.0 |
580 | 2023-10-04 01:09:53 | jobber | 3 | 112716 | 718 | 6.266 | 17988.5 |
579 | 2023-09-30 21:33:59 | jobber | 3 | 112716 | 718 | 5.826 | 19347.1 |
578 | 2023-09-26 23:09:11 | jobber | 3 | 112716 | 718 | 5.030 | 22408.7 |
577 | 2023-09-24 23:24:10 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
576 | 2023-09-12 03:26:07 | jobber | 3 | 112716 | 718 | 5.030 | 22408.7 |
575 | 2023-09-11 11:54:36 | jobber | 1 | 48755 | 14 | 0.736 | 66243.2 |
574 | 2023-08-22 00:38:29 | jobber | 3 | 112716 | 718 | 5.280 | 21347.7 |
573 | 2023-08-21 10:37:51 | jobber | 1 | 48755 | 14 | 0.796 | 61250.0 |
572 | 2023-08-19 13:38:46 | jobber | 2 | 82551 | 78 | 2.046 | 40347.5 |
571 | 2023-08-16 20:59:30 | jobber | 3 | 112716 | 718 | 5.953 | 18934.3 |
570 | 2023-06-29 07:36:34 | jobber | 1 | 48755 | 14 | 0.750 | 65006.7 |
569 | 2023-05-24 01:33:19 | jobber | 1 | 48755 | 14 | 0.720 | 67715.3 |
568 | 2023-05-16 09:38:12 | jobber | 3 | 112716 | 718 | 4.406 | 25582.4 |
567 | 2023-05-12 19:56:28 | jobber | 3 | 112716 | 718 | 4.406 | 25582.4 |
566 | 2023-05-06 23:17:12 | jobber | 3 | 112716 | 718 | 8.793 | 12818.8 |
565 | 2023-04-29 15:52:41 | jobber | 2 | 82551 | 78 | 2.030 | 40665.5 |
564 | 2023-03-19 12:00:18 | jobber | 1 | 48755 | 14 | 0.716 | 68093.6 |
563 | 2023-03-18 21:11:37 | jobber | 1 | 48755 | 14 | 0.716 | 68093.6 |
562 | 2023-03-09 23:23:53 | jobber | 1 | 48755 | 14 | 0.783 | 62266.9 |
561 | 2023-02-18 04:06:53 | jobber | 1 | 48755 | 14 | 0.796 | 61250.0 |
560 | 2023-02-14 04:18:57 | jobber | 3 | 112716 | 718 | 4.580 | 24610.5 |
559 | 2023-02-12 14:58:56 | jobber | 3 | 112716 | 718 | 4.406 | 25582.4 |
558 | 2023-02-01 21:58:12 | jobber | 2 | 82551 | 78 | 2.406 | 34310.5 |
557 | 2023-01-06 02:42:43 | jobber | 1 | 48755 | 14 | 0.800 | 60943.8 |
556 | 2022-12-29 12:31:25 | jobber | 1 | 48755 | 14 | 0.813 | 59969.2 |
555 | 2022-12-26 07:42:08 | jobber | 3 | 112716 | 718 | 5.046 | 22337.7 |
554 | 2022-12-26 00:01:12 | jobber | 3 | 112716 | 718 | 4.983 | 22620.1 |
553 | 2022-11-24 03:39:09 | jobber | 3 | 112716 | 718 | 4.516 | 24959.3 |
552 | 2022-11-16 02:34:02 | jobber | 1 | 48755 | 14 | 0.813 | 59969.2 |
551 | 2022-11-14 15:26:52 | jobber | 1 | 48755 | 14 | 0.986 | 49447.3 |
550 | 2022-11-13 23:59:15 | jobber | 2 | 82551 | 78 | 2.030 | 40665.5 |
549 | 2022-11-10 22:44:23 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
548 | 2022-11-09 13:37:29 | jobber | 3 | 112716 | 718 | 4.780 | 23580.8 |
547 | 2022-11-01 02:27:12 | jobber | 3 | 112716 | 718 | 4.986 | 22606.5 |
546 | 2022-10-27 12:42:20 | jobber | 3 | 112716 | 718 | 4.513 | 24975.8 |
545 | 2022-10-05 11:53:48 | jobber | 3 | 112716 | 718 | 5.143 | 21916.4 |
544 | 2022-10-01 03:39:02 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
543 | 2022-09-22 22:15:05 | jobber | 3 | 112716 | 718 | 4.906 | 22975.1 |
542 | 2022-09-18 17:14:58 | jobber | 1 | 48755 | 14 | 0.716 | 68093.6 |
541 | 2022-09-17 04:25:07 | jobber | 3 | 112716 | 718 | 4.546 | 24794.5 |
540 | 2022-08-23 21:09:02 | jobber | 1 | 48755 | 14 | 0.736 | 66243.2 |
539 | 2022-08-07 10:04:00 | jobber | 1 | 48755 | 14 | 0.736 | 66243.2 |
538 | 2022-07-21 18:39:04 | jobber | 1 | 48755 | 14 | 0.750 | 65006.7 |
537 | 2022-07-13 11:27:20 | jobber | 3 | 112716 | 718 | 4.470 | 25216.1 |
536 | 2022-05-27 05:07:56 | jobber | 3 | 112716 | 718 | 4.420 | 25501.4 |
535 | 2022-05-15 19:04:59 | jobber | 1 | 48755 | 14 | 0.826 | 59025.4 |
534 | 2022-05-13 14:15:55 | jobber | 1 | 48755 | 14 | 0.876 | 55656.4 |
533 | 2022-05-08 07:01:28 | jobber | 3 | 112716 | 718 | 4.830 | 23336.6 |
532 | 2022-05-06 02:57:31 | jobber | 2 | 82551 | 78 | 2.096 | 39385.0 |
531 | 2022-05-03 15:28:13 | jobber | 3 | 112716 | 718 | 5.750 | 19602.8 |
530 | 2022-05-01 11:54:44 | jobber | 3 | 112716 | 718 | 4.436 | 25409.4 |
529 | 2022-04-29 05:49:50 | jobber | 3 | 112716 | 718 | 4.940 | 22817.0 |
528 | 2022-03-30 23:32:53 | jobber | 1 | 48755 | 14 | 0.890 | 54780.9 |
527 | 2022-03-04 05:48:12 | jobber | 3 | 112716 | 718 | 4.593 | 24540.8 |
526 | 2022-03-04 02:48:06 | jobber | 3 | 112716 | 718 | 4.936 | 22835.5 |
525 | 2022-01-28 06:36:17 | jobber | 1 | 48755 | 14 | 0.733 | 66514.3 |
524 | 2021-12-27 23:07:04 | jobber | 3 | 112716 | 718 | 5.046 | 22337.7 |