History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whodunit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1208 | 2025-10-01 22:55:19 | whodunit | 5 | 170374 | 1636 | 23.783 | 7163.7 |
1207 | 2025-09-27 04:11:17 | whodunit | 5 | 170374 | 1636 | 16.173 | 10534.5 |
1206 | 2025-09-26 04:07:35 | whodunit | 5 | 170374 | 1636 | 15.330 | 11113.8 |
1205 | 2025-09-06 13:01:34 | whodunit | 4 | 161609 | 97 | 11.046 | 14630.5 |
1204 | 2025-08-21 08:22:46 | whodunit | 1 | 82945 | 3 | 4.686 | 17700.6 |
1203 | 2025-08-19 16:45:01 | whodunit | 1 | 82945 | 3 | 3.263 | 25419.9 |
1202 | 2025-07-25 22:28:04 | whodunit | 1 | 82945 | 3 | 9.860 | 8412.3 |
1201 | 2025-07-25 04:45:44 | whodunit | 1 | 82945 | 3 | 4.030 | 20581.9 |
1200 | 2025-07-13 14:10:56 | whodunit | 1 | 82945 | 3 | 1.310 | 63316.8 |
1199 | 2025-06-25 03:13:01 | whodunit | 1 | 82945 | 3 | 4.596 | 18047.2 |
1198 | 2025-06-20 03:48:25 | whodunit | 1 | 82945 | 3 | 8.453 | 9812.5 |
1197 | 2025-05-06 18:06:21 | whodunit | 4 | 161609 | 97 | 46.173 | 3500.1 |
1196 | 2025-05-06 12:11:24 | whodunit | 4 | 161609 | 97 | 65.466 | 2468.6 |
1195 | 2025-05-04 18:29:31 | whodunit | 4 | 161609 | 97 | 42.563 | 3796.9 |
1194 | 2025-05-04 18:22:55 | whodunit | 4 | 161609 | 97 | 68.956 | 2343.7 |
1193 | 2025-05-02 16:48:05 | whodunit | 1 | 82945 | 3 | 3.516 | 23590.7 |
1192 | 2025-04-18 05:07:50 | whodunit | 3 | 146162 | 5 | 20.313 | 7195.5 |
1191 | 2025-04-02 06:24:34 | whodunit | 1 | 82945 | 3 | 3.483 | 23814.2 |
1190 | 2025-04-02 05:06:31 | whodunit | 1 | 82945 | 3 | 6.190 | 13399.8 |
1189 | 2025-04-01 01:11:29 | whodunit | 3 | 146162 | 5 | 34.080 | 4288.8 |
1188 | 2025-03-31 23:21:21 | whodunit | 2 | 121059 | 4 | 17.236 | 7023.6 |
1187 | 2025-03-31 23:14:48 | whodunit | 3 | 146162 | 5 | 47.923 | 3049.9 |
1186 | 2025-03-30 00:14:06 | whodunit | 1 | 82945 | 3 | 2.923 | 28376.7 |
1185 | 2025-03-23 20:23:46 | whodunit | 4 | 161609 | 97 | 50.673 | 3189.3 |
1184 | 2025-03-20 03:30:50 | whodunit | 1 | 82945 | 3 | 4.266 | 19443.3 |
1183 | 2025-03-18 10:00:26 | whodunit | 4 | 161609 | 97 | 59.630 | 2710.2 |
1182 | 2025-03-09 16:32:50 | whodunit | 1 | 82945 | 3 | 4.953 | 16746.4 |
1181 | 2025-03-02 18:19:01 | whodunit | 3 | 146162 | 5 | 23.143 | 6315.6 |
1180 | 2025-03-02 18:18:59 | whodunit | 2 | 121059 | 4 | 13.706 | 8832.6 |
1179 | 2025-03-02 18:18:22 | whodunit | 1 | 82945 | 3 | 3.406 | 24352.6 |
1178 | 2025-03-01 21:46:58 | whodunit | 1 | 82945 | 3 | 9.930 | 8353.0 |
1177 | 2025-02-24 07:15:54 | whodunit | 4 | 161609 | 97 | 61.910 | 2610.4 |
1176 | 2025-02-23 20:49:16 | whodunit | 4 | 161609 | 97 | 49.643 | 3255.4 |
1175 | 2025-02-07 19:43:57 | whodunit | 4 | 161609 | 97 | 46.800 | 3453.2 |
1174 | 2025-02-02 11:40:53 | whodunit | 1 | 82945 | 3 | 6.696 | 12387.2 |
1173 | 2025-01-31 02:41:11 | whodunit | 4 | 161609 | 97 | 56.800 | 2845.2 |
1172 | 2025-01-29 20:14:07 | whodunit | 4 | 161609 | 97 | 68.130 | 2372.1 |
1171 | 2025-01-29 11:14:49 | whodunit | 5 | 170374 | 1636 | 77.330 | 2203.2 |
1170 | 2025-01-29 11:13:06 | whodunit | 5 | 170374 | 1636 | 74.096 | 2299.4 |
1169 | 2025-01-29 05:01:05 | whodunit | 2 | 121059 | 4 | 22.140 | 5467.9 |
1168 | 2025-01-29 05:00:09 | whodunit | 1 | 82945 | 3 | 3.220 | 25759.3 |
1167 | 2025-01-29 03:58:19 | whodunit | 5 | 170374 | 1636 | 68.176 | 2499.0 |
1166 | 2025-01-29 03:28:31 | whodunit | 5 | 170374 | 1636 | 85.473 | 1993.3 |
1165 | 2025-01-28 23:07:22 | whodunit | 4 | 161609 | 97 | 12.033 | 13430.5 |
1164 | 2025-01-26 21:08:42 | whodunit | 4 | 161609 | 97 | 39.533 | 4088.0 |
1163 | 2025-01-15 21:08:20 | whodunit | 1 | 82945 | 3 | 9.783 | 8478.5 |
1162 | 2025-01-08 06:19:27 | whodunit | 2 | 121059 | 4 | 15.890 | 7618.6 |
1161 | 2025-01-08 06:19:30 | whodunit | 1 | 82945 | 3 | 5.843 | 14195.6 |
1160 | 2025-01-05 09:57:25 | whodunit | 3 | 146162 | 5 | 14.250 | 10257.0 |
1159 | 2025-01-04 12:24:12 | whodunit | 3 | 146162 | 5 | 18.266 | 8001.9 |
1158 | 2025-01-04 12:20:06 | whodunit | 4 | 161609 | 97 | 34.363 | 4703.0 |
1157 | 2025-01-02 18:04:43 | whodunit | 3 | 146162 | 5 | 26.126 | 5594.5 |
1156 | 2025-01-02 00:05:20 | whodunit | 1 | 82945 | 3 | 4.953 | 16746.4 |
1155 | 2025-01-02 00:04:25 | whodunit | 3 | 146162 | 5 | 53.673 | 2723.2 |
1154 | 2025-01-02 00:04:18 | whodunit | 2 | 121059 | 4 | 17.580 | 6886.2 |
1153 | 2024-12-29 09:29:11 | whodunit | 4 | 161609 | 97 | 58.893 | 2744.1 |
1152 | 2024-12-29 07:07:32 | whodunit | 4 | 161609 | 97 | 53.283 | 3033.0 |
1151 | 2024-12-29 06:08:34 | whodunit | 4 | 161609 | 97 | 49.126 | 3289.7 |
1150 | 2024-12-28 17:00:05 | whodunit | 5 | 170374 | 1636 | 96.193 | 1771.2 |
1149 | 2024-12-28 16:30:42 | whodunit | 5 | 170374 | 1636 | 103.413 | 1647.5 |
1148 | 2024-12-28 16:15:42 | whodunit | 5 | 170374 | 1636 | 64.426 | 2644.5 |
1147 | 2024-12-27 20:47:33 | whodunit | 4 | 161609 | 97 | 19.283 | 8380.9 |
1146 | 2024-12-25 13:18:07 | whodunit | 4 | 161609 | 97 | 57.176 | 2826.5 |
1145 | 2024-12-06 02:35:17 | whodunit | 3 | 146162 | 5 | 8.033 | 18195.2 |
1144 | 2024-12-06 02:35:16 | whodunit | 2 | 121059 | 4 | 3.733 | 32429.4 |
1143 | 2024-12-04 07:18:52 | whodunit | 1 | 82945 | 3 | 3.173 | 26140.9 |
1142 | 2024-12-03 19:37:13 | whodunit | 1 | 82945 | 3 | 6.703 | 12374.3 |
1141 | 2024-12-02 12:12:09 | whodunit | 3 | 146162 | 5 | 34.990 | 4177.3 |
1140 | 2024-12-01 13:53:22 | whodunit | 3 | 146162 | 5 | 47.706 | 3063.8 |
1139 | 2024-12-01 13:53:22 | whodunit | 2 | 121059 | 4 | 23.720 | 5103.7 |
1138 | 2024-12-01 13:52:46 | whodunit | 1 | 82945 | 3 | 5.173 | 16034.2 |
1137 | 2024-11-29 02:17:05 | whodunit | 4 | 161609 | 97 | 70.753 | 2284.1 |
1136 | 2024-11-28 17:53:05 | whodunit | 4 | 161609 | 97 | 45.813 | 3527.6 |
1135 | 2024-11-28 17:53:08 | whodunit | 3 | 146162 | 5 | 28.250 | 5173.9 |
1134 | 2024-11-28 17:53:09 | whodunit | 2 | 121059 | 4 | 16.453 | 7357.9 |
1133 | 2024-11-28 17:52:49 | whodunit | 1 | 82945 | 3 | 3.093 | 26817.0 |
1132 | 2024-11-28 11:42:58 | whodunit | 5 | 170374 | 1636 | 17.003 | 10020.2 |
1131 | 2024-11-24 04:54:29 | whodunit | 5 | 170374 | 1636 | 84.566 | 2014.7 |
1130 | 2024-11-23 21:21:11 | whodunit | 5 | 170374 | 1636 | 88.956 | 1915.3 |
1129 | 2024-11-23 16:06:02 | whodunit | 5 | 170374 | 1636 | 93.163 | 1828.8 |
1128 | 2024-10-30 14:21:15 | whodunit | 2 | 121059 | 4 | 3.530 | 34294.3 |
1127 | 2024-10-30 14:21:15 | whodunit | 1 | 82945 | 3 | 1.390 | 59672.7 |
1126 | 2024-10-30 14:20:55 | whodunit | 3 | 146162 | 5 | 6.203 | 23563.1 |
1125 | 2024-10-23 03:17:21 | whodunit | 5 | 170374 | 1636 | 97.350 | 1750.1 |
1124 | 2024-10-22 19:10:37 | whodunit | 5 | 170374 | 1636 | 110.943 | 1535.7 |
1123 | 2024-10-22 15:04:52 | whodunit | 5 | 170374 | 1636 | 90.286 | 1887.0 |
1122 | 2024-10-22 11:52:13 | whodunit | 5 | 170374 | 1636 | 107.133 | 1590.3 |
1121 | 2024-10-22 11:52:13 | whodunit | 3 | 146162 | 5 | 32.380 | 4514.0 |
1120 | 2024-10-22 11:52:15 | whodunit | 2 | 121059 | 4 | 17.483 | 6924.4 |
1119 | 2024-10-21 18:30:44 | whodunit | 4 | 161609 | 97 | 11.610 | 13919.8 |
1118 | 2024-10-21 11:59:11 | whodunit | 4 | 161609 | 97 | 80.083 | 2018.0 |
1117 | 2024-10-21 03:49:03 | whodunit | 4 | 161609 | 97 | 48.236 | 3350.4 |
1116 | 2024-10-21 03:49:09 | whodunit | 2 | 121059 | 4 | 17.550 | 6897.9 |
1115 | 2024-10-21 03:49:09 | whodunit | 1 | 82945 | 3 | 6.733 | 12319.2 |
1114 | 2024-10-17 17:13:27 | whodunit | 3 | 146162 | 5 | 21.143 | 6913.0 |
1113 | 2024-10-15 04:41:09 | whodunit | 3 | 146162 | 5 | 34.736 | 4207.8 |
1112 | 2024-10-15 04:41:08 | whodunit | 2 | 121059 | 4 | 14.250 | 8495.4 |
1111 | 2024-10-13 01:50:39 | whodunit | 1 | 82945 | 3 | 6.640 | 12491.7 |
1110 | 2024-09-25 10:53:16 | whodunit | 1 | 82945 | 3 | 6.940 | 11951.7 |
1109 | 2024-09-20 03:15:51 | whodunit | 3 | 146162 | 5 | 78.643 | 1858.6 |