History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"certifier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1070 | 2025-08-25 11:11:41 | certifier | 1 | 81242 | 4 | 6.203 | 13097.2 |
| 1069 | 2025-08-12 10:37:22 | certifier | 1 | 81242 | 4 | 3.280 | 24768.9 |
| 1068 | 2025-08-03 01:45:23 | certifier | 4 | 165329 | 453 | 100.343 | 1647.6 |
| 1067 | 2025-07-31 21:29:31 | certifier | 3 | 148641 | 85 | 19.546 | 7604.7 |
| 1066 | 2025-07-30 12:16:59 | certifier | 4 | 165329 | 453 | 36.470 | 4533.3 |
| 1065 | 2025-07-29 10:13:13 | certifier | 4 | 165329 | 453 | 38.316 | 4314.9 |
| 1064 | 2025-07-28 00:11:23 | certifier | 4 | 165329 | 453 | 32.953 | 5017.1 |
| 1063 | 2025-07-27 19:13:11 | certifier | 3 | 148641 | 85 | 19.796 | 7508.6 |
| 1062 | 2025-07-27 15:47:15 | certifier | 3 | 148641 | 85 | 18.500 | 8034.6 |
| 1061 | 2025-07-27 05:30:37 | certifier | 4 | 165329 | 453 | 33.440 | 4944.0 |
| 1060 | 2025-07-26 06:42:11 | certifier | 1 | 81242 | 4 | 3.560 | 22820.8 |
| 1059 | 2025-07-25 16:31:08 | certifier | 4 | 165329 | 453 | 37.143 | 4451.1 |
| 1058 | 2025-07-25 01:15:32 | certifier | 3 | 148641 | 85 | 21.923 | 6780.1 |
| 1057 | 2025-07-24 19:33:46 | certifier | 1 | 81242 | 4 | 3.393 | 23944.0 |
| 1056 | 2025-07-24 03:56:17 | certifier | 3 | 148641 | 85 | 29.033 | 5119.7 |
| 1055 | 2025-07-24 01:56:48 | certifier | 3 | 148641 | 85 | 32.343 | 4595.8 |
| 1054 | 2025-07-23 12:04:14 | certifier | 3 | 148641 | 85 | 37.893 | 3922.7 |
| 1053 | 2025-07-22 11:11:34 | certifier | 1 | 81242 | 4 | 4.433 | 18326.6 |
| 1052 | 2025-07-19 00:06:32 | certifier | 3 | 148641 | 85 | 7.313 | 20325.6 |
| 1051 | 2025-07-18 04:56:28 | certifier | 1 | 81242 | 4 | 3.640 | 22319.2 |
| 1050 | 2025-07-10 23:46:32 | certifier | 1 | 81242 | 4 | 7.076 | 11481.3 |
| 1049 | 2025-07-02 07:56:56 | certifier | 1 | 81242 | 4 | 6.876 | 11815.3 |
| 1048 | 2025-06-18 07:59:51 | certifier | 1 | 81242 | 4 | 3.890 | 20884.8 |
| 1047 | 2025-06-12 14:12:43 | certifier | 1 | 81242 | 4 | 4.920 | 16512.6 |
| 1046 | 2025-05-16 08:31:53 | certifier | 1 | 81242 | 4 | 4.110 | 19766.9 |
| 1045 | 2025-05-06 13:49:00 | certifier | 1 | 81242 | 4 | 8.003 | 10151.4 |
| 1044 | 2025-05-02 00:52:19 | certifier | 1 | 81242 | 4 | 6.033 | 13466.3 |
| 1043 | 2025-04-26 03:12:44 | certifier | 1 | 81242 | 4 | 5.453 | 14898.6 |
| 1042 | 2025-04-21 06:54:51 | certifier | 1 | 81242 | 4 | 7.390 | 10993.5 |
| 1041 | 2025-04-17 22:33:05 | certifier | 3 | 148641 | 85 | 32.970 | 4508.4 |
| 1040 | 2025-04-15 00:02:54 | certifier | 3 | 148641 | 85 | 39.766 | 3737.9 |
| 1039 | 2025-04-14 08:26:38 | certifier | 3 | 148641 | 85 | 36.346 | 4089.6 |
| 1038 | 2025-04-14 04:04:38 | certifier | 3 | 148641 | 85 | 35.470 | 4190.6 |
| 1037 | 2025-04-12 14:34:42 | certifier | 3 | 148641 | 85 | 23.753 | 6257.8 |
| 1036 | 2025-04-08 16:58:09 | certifier | 3 | 148641 | 85 | 8.500 | 17487.2 |
| 1035 | 2025-04-06 07:21:44 | certifier | 1 | 81242 | 4 | 7.296 | 11135.1 |
| 1034 | 2025-03-31 01:34:48 | certifier | 1 | 81242 | 4 | 6.803 | 11942.1 |
| 1033 | 2025-03-16 12:55:44 | certifier | 1 | 81242 | 4 | 8.000 | 10155.3 |
| 1032 | 2025-03-04 06:15:22 | certifier | 1 | 81242 | 4 | 5.233 | 15524.9 |
| 1031 | 2025-02-24 17:38:13 | certifier | 1 | 81242 | 4 | 1.813 | 44810.8 |
| 1030 | 2025-02-12 15:07:39 | certifier | 2 | 121436 | 13 | 9.580 | 12676.0 |
| 1029 | 2025-02-12 14:13:05 | certifier | 1 | 81242 | 4 | 3.890 | 20884.8 |
| 1028 | 2025-02-08 10:22:26 | certifier | 1 | 81242 | 4 | 3.016 | 26937.0 |
| 1027 | 2025-02-07 04:48:10 | certifier | 3 | 148641 | 85 | 30.523 | 4869.8 |
| 1026 | 2025-02-05 08:51:34 | certifier | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 1025 | 2025-02-03 19:00:57 | certifier | 3 | 148641 | 85 | 47.533 | 3127.1 |
| 1024 | 2025-02-03 16:21:43 | certifier | 3 | 148641 | 85 | 42.816 | 3471.6 |
| 1023 | 2025-02-03 07:22:58 | certifier | 3 | 148641 | 85 | 55.720 | 2667.6 |
| 1022 | 2025-01-31 21:28:37 | certifier | 3 | 148641 | 85 | 60.400 | 2460.9 |
| 1021 | 2025-01-31 10:09:09 | certifier | 3 | 148641 | 85 | 32.423 | 4584.4 |
| 1020 | 2025-01-30 18:14:24 | certifier | 3 | 148641 | 85 | 36.846 | 4034.1 |
| 1019 | 2025-01-30 16:57:30 | certifier | 3 | 148641 | 85 | 27.030 | 5499.1 |
| 1018 | 2025-01-24 20:41:52 | certifier | 2 | 121436 | 13 | 3.763 | 32271.1 |
| 1017 | 2025-01-23 07:01:46 | certifier | 1 | 81242 | 4 | 7.186 | 11305.6 |
| 1016 | 2025-01-21 19:33:20 | certifier | 1 | 81242 | 4 | 9.906 | 8201.3 |
| 1015 | 2025-01-14 12:09:39 | certifier | 1 | 81242 | 4 | 4.953 | 16402.6 |
| 1014 | 2025-01-09 20:27:53 | certifier | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 1013 | 2024-12-30 15:37:41 | certifier | 3 | 148641 | 85 | 52.126 | 2851.6 |
| 1012 | 2024-12-29 21:37:33 | certifier | 3 | 148641 | 85 | 36.393 | 4084.3 |
| 1011 | 2024-12-27 16:13:38 | certifier | 3 | 148641 | 85 | 54.690 | 2717.9 |
| 1010 | 2024-12-27 16:13:40 | certifier | 2 | 121436 | 13 | 9.750 | 12455.0 |
| 1009 | 2024-12-21 01:49:53 | certifier | 4 | 165329 | 453 | 75.553 | 2188.3 |
| 1008 | 2024-12-20 14:42:05 | certifier | 4 | 165329 | 453 | 76.643 | 2157.1 |
| 1007 | 2024-12-20 07:44:52 | certifier | 1 | 81242 | 4 | 6.936 | 11713.1 |
| 1006 | 2024-12-20 05:53:39 | certifier | 4 | 165329 | 453 | 64.456 | 2565.0 |
| 1005 | 2024-12-19 22:33:37 | certifier | 1 | 81242 | 4 | 6.686 | 12151.1 |
| 1004 | 2024-12-18 13:16:33 | certifier | 4 | 165329 | 453 | 44.956 | 3677.6 |
| 1003 | 2024-12-18 05:15:50 | certifier | 4 | 165329 | 453 | 67.173 | 2461.2 |
| 1002 | 2024-12-17 10:05:42 | certifier | 4 | 165329 | 453 | 62.550 | 2643.1 |
| 1001 | 2024-12-16 18:47:02 | certifier | 4 | 165329 | 453 | 73.223 | 2257.9 |
| 1000 | 2024-12-15 23:33:20 | certifier | 4 | 165329 | 453 | 58.253 | 2838.1 |
| 999 | 2024-12-15 04:11:27 | certifier | 4 | 165329 | 453 | 61.380 | 2693.5 |
| 998 | 2024-12-14 08:29:10 | certifier | 4 | 165329 | 453 | 41.033 | 4029.2 |
| 997 | 2024-12-13 14:52:50 | certifier | 4 | 165329 | 453 | 60.223 | 2745.3 |
| 996 | 2024-12-12 05:21:58 | certifier | 4 | 165329 | 453 | 66.266 | 2494.9 |
| 995 | 2024-12-11 06:53:15 | certifier | 4 | 165329 | 453 | 72.820 | 2270.4 |
| 994 | 2024-12-10 14:01:21 | certifier | 4 | 165329 | 453 | 16.000 | 10333.1 |
| 993 | 2024-12-09 05:32:26 | certifier | 4 | 165329 | 453 | 65.066 | 2540.9 |
| 992 | 2024-12-08 12:47:50 | certifier | 4 | 165329 | 453 | 32.970 | 5014.5 |
| 991 | 2024-12-07 19:01:13 | certifier | 4 | 165329 | 453 | 47.220 | 3501.2 |
| 990 | 2024-12-06 08:39:41 | certifier | 4 | 165329 | 453 | 69.363 | 2383.5 |
| 989 | 2024-12-05 11:54:55 | certifier | 4 | 165329 | 453 | 23.690 | 6978.9 |
| 988 | 2024-12-04 21:27:30 | certifier | 4 | 165329 | 453 | 91.386 | 1809.1 |
| 987 | 2024-12-04 03:11:46 | certifier | 1 | 81242 | 4 | 7.546 | 10766.2 |
| 986 | 2024-12-03 19:36:36 | certifier | 4 | 165329 | 453 | 59.036 | 2800.5 |
| 985 | 2024-12-03 03:41:39 | certifier | 4 | 165329 | 453 | 87.143 | 1897.2 |
| 984 | 2024-11-26 18:36:16 | certifier | 1 | 81242 | 4 | 1.326 | 61268.5 |
| 983 | 2024-11-24 17:08:59 | certifier | 4 | 165329 | 453 | 42.836 | 3859.6 |
| 982 | 2024-11-20 13:47:32 | certifier | 4 | 165329 | 453 | 63.643 | 2597.8 |
| 981 | 2024-11-19 23:15:28 | certifier | 4 | 165329 | 453 | 70.520 | 2344.4 |
| 980 | 2024-11-19 17:32:05 | certifier | 4 | 165329 | 453 | 75.270 | 2196.5 |
| 979 | 2024-11-19 15:02:50 | certifier | 4 | 165329 | 453 | 52.563 | 3145.3 |
| 978 | 2024-11-18 03:08:02 | certifier | 1 | 81242 | 4 | 3.640 | 22319.2 |
| 977 | 2024-11-14 18:09:33 | certifier | 3 | 148641 | 85 | 14.953 | 9940.5 |
| 976 | 2024-11-12 19:30:33 | certifier | 3 | 148641 | 85 | 36.206 | 4105.4 |
| 975 | 2024-11-11 20:24:14 | certifier | 3 | 148641 | 85 | 39.126 | 3799.0 |
| 974 | 2024-11-03 14:54:41 | certifier | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 973 | 2024-10-25 09:50:26 | certifier | 3 | 148641 | 85 | 35.173 | 4226.0 |
| 972 | 2024-10-25 03:52:06 | certifier | 1 | 81242 | 4 | 6.216 | 13069.8 |
| 971 | 2024-10-20 09:37:11 | certifier | 3 | 148641 | 85 | 31.156 | 4770.9 |