History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"midlist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
299 | 2024-04-29 04:12:17 | midlist | 1 | 69583 | 2 | 5.296 | 13138.8 |
298 | 2024-04-09 04:59:31 | midlist | 1 | 69583 | 2 | 4.033 | 17253.4 |
297 | 2024-04-05 03:27:57 | midlist | 2 | 107671 | 18 | 3.703 | 29076.7 |
296 | 2024-04-04 05:29:26 | midlist | 3 | 134027 | 210 | 21.186 | 6326.2 |
295 | 2024-04-04 05:29:27 | midlist | 2 | 107671 | 18 | 11.750 | 9163.5 |
294 | 2024-04-04 05:29:06 | midlist | 3 | 134027 | 210 | 17.783 | 7536.8 |
293 | 2024-04-04 05:29:19 | midlist | 1 | 69583 | 2 | 3.033 | 22942.0 |
292 | 2024-04-04 05:29:06 | midlist | 2 | 107671 | 18 | 6.953 | 15485.5 |
291 | 2024-04-04 05:29:04 | midlist | 1 | 69583 | 2 | 2.673 | 26031.8 |
290 | 2024-03-12 01:08:12 | midlist | 3 | 134027 | 210 | 16.533 | 8106.6 |
289 | 2024-03-07 21:26:44 | midlist | 3 | 134027 | 210 | 10.843 | 12360.7 |
288 | 2024-03-04 22:58:58 | midlist | 1 | 69583 | 2 | 1.393 | 49951.9 |
287 | 2024-03-04 21:15:43 | midlist | 2 | 107671 | 18 | 11.360 | 9478.1 |
286 | 2024-03-04 12:59:03 | midlist | 3 | 134027 | 210 | 25.596 | 5236.2 |
285 | 2024-03-04 01:35:08 | midlist | 2 | 107671 | 18 | 3.330 | 32333.6 |
284 | 2024-03-04 01:34:37 | midlist | 3 | 134027 | 210 | 6.970 | 19229.1 |
283 | 2024-03-03 21:28:15 | midlist | 3 | 134027 | 210 | 6.546 | 20474.6 |
282 | 2024-03-03 21:28:13 | midlist | 2 | 107671 | 18 | 3.170 | 33965.6 |
281 | 2024-03-03 21:28:11 | midlist | 1 | 69583 | 2 | 1.263 | 55093.4 |
280 | 2024-02-03 04:56:48 | midlist | 1 | 69583 | 2 | 4.030 | 17266.3 |
279 | 2024-01-18 01:50:49 | midlist | 1 | 69583 | 2 | 1.220 | 57035.2 |
278 | 2024-01-03 08:44:58 | midlist | 1 | 69583 | 2 | 1.126 | 61796.6 |
277 | 2024-01-02 10:22:41 | midlist | 3 | 134027 | 210 | 5.843 | 22938.0 |
276 | 2023-12-27 20:00:01 | midlist | 3 | 134027 | 210 | 6.033 | 22215.6 |
275 | 2023-12-27 20:00:03 | midlist | 2 | 107671 | 18 | 3.186 | 33795.0 |
274 | 2023-12-11 07:55:41 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
273 | 2023-12-01 00:03:10 | midlist | 3 | 134027 | 210 | 5.966 | 22465.1 |
272 | 2023-12-01 00:03:05 | midlist | 2 | 107671 | 18 | 4.033 | 26697.5 |
271 | 2023-11-18 17:20:18 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
270 | 2023-11-18 05:11:00 | midlist | 1 | 69583 | 2 | 1.153 | 60349.5 |
269 | 2023-10-30 08:22:49 | midlist | 1 | 69583 | 2 | 1.063 | 65459.1 |
268 | 2023-10-22 06:04:44 | midlist | 1 | 69583 | 2 | 1.170 | 59472.6 |
267 | 2023-10-14 07:03:23 | midlist | 1 | 69583 | 2 | 1.126 | 61796.6 |
266 | 2023-10-14 06:00:16 | midlist | 1 | 69583 | 2 | 1.233 | 56433.9 |
265 | 2023-10-07 22:48:35 | midlist | 3 | 134027 | 210 | 5.750 | 23309.0 |
264 | 2023-09-25 09:08:28 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
263 | 2023-07-18 08:59:54 | midlist | 3 | 134027 | 210 | 5.660 | 23679.7 |
262 | 2023-07-16 11:30:27 | midlist | 1 | 69583 | 2 | 1.110 | 62687.4 |
261 | 2023-06-27 07:07:16 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
260 | 2023-04-16 18:58:49 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
259 | 2023-04-01 23:42:15 | midlist | 3 | 134027 | 210 | 5.720 | 23431.3 |
258 | 2023-03-11 11:48:12 | midlist | 1 | 69583 | 2 | 1.050 | 66269.5 |
257 | 2023-02-06 21:02:11 | midlist | 1 | 69583 | 2 | 1.030 | 67556.3 |
256 | 2023-01-27 21:39:44 | midlist | 1 | 69583 | 2 | 1.030 | 67556.3 |
255 | 2023-01-17 12:23:22 | midlist | 3 | 134027 | 210 | 5.623 | 23835.5 |
254 | 2022-12-27 21:31:21 | midlist | 3 | 134027 | 210 | 6.780 | 19768.0 |
253 | 2022-12-13 04:07:21 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
252 | 2022-12-11 06:01:35 | midlist | 3 | 134027 | 210 | 5.906 | 22693.4 |
251 | 2022-12-05 09:30:33 | midlist | 1 | 69583 | 2 | 1.140 | 61037.7 |
250 | 2022-12-03 15:46:17 | midlist | 3 | 134027 | 210 | 5.673 | 23625.4 |
249 | 2022-11-26 05:51:06 | midlist | 1 | 69583 | 2 | 1.030 | 67556.3 |
248 | 2022-11-23 08:14:51 | midlist | 1 | 69583 | 2 | 1.236 | 56296.9 |
247 | 2022-11-19 20:31:55 | midlist | 1 | 69583 | 2 | 1.203 | 57841.2 |
246 | 2022-11-13 19:14:15 | midlist | 3 | 134027 | 210 | 6.203 | 21606.8 |
245 | 2022-11-12 18:44:35 | midlist | 1 | 69583 | 2 | 1.173 | 59320.5 |
244 | 2022-10-30 07:19:41 | midlist | 3 | 134027 | 210 | 6.360 | 21073.4 |
243 | 2022-08-28 18:39:48 | midlist | 3 | 134027 | 210 | 5.640 | 23763.7 |
242 | 2022-07-31 12:25:02 | midlist | 1 | 69583 | 2 | 1.343 | 51811.6 |
241 | 2022-07-30 13:11:15 | midlist | 1 | 69583 | 2 | 1.126 | 61796.6 |
240 | 2022-06-06 16:22:27 | midlist | 1 | 69583 | 2 | 1.216 | 57222.9 |
239 | 2022-05-18 13:31:44 | midlist | 1 | 69583 | 2 | 1.063 | 65459.1 |
238 | 2022-05-05 06:07:50 | midlist | 1 | 69583 | 2 | 1.063 | 65459.1 |
237 | 2022-04-01 13:15:11 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
236 | 2022-03-25 22:02:44 | midlist | 1 | 69583 | 2 | 1.080 | 64428.7 |
235 | 2022-03-23 17:49:53 | midlist | 1 | 69583 | 2 | 1.483 | 46920.4 |
234 | 2022-01-13 14:30:52 | midlist | 1 | 69583 | 2 | 1.050 | 66269.5 |
233 | 2021-12-14 18:28:31 | midlist | 1 | 69583 | 2 | 1.063 | 65459.1 |
232 | 2021-09-26 18:31:12 | midlist | 1 | 69583 | 2 | 1.216 | 57222.9 |
231 | 2021-09-22 06:21:29 | midlist | 1 | 69583 | 2 | 1.063 | 65459.1 |
230 | 2021-09-07 12:00:00 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
229 | 2021-06-06 14:15:08 | midlist | 1 | 69583 | 2 | 1.220 | 57035.2 |
228 | 2021-05-23 02:57:14 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
227 | 2021-05-13 17:54:19 | midlist | 1 | 69583 | 2 | 1.220 | 57035.2 |
226 | 2021-04-24 08:01:56 | midlist | 1 | 69583 | 2 | 1.220 | 57035.2 |
225 | 2021-03-26 06:44:35 | midlist | 1 | 69583 | 2 | 1.140 | 61037.7 |
224 | 2021-03-04 11:16:31 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
223 | 2021-03-04 10:54:29 | midlist | 1 | 69583 | 2 | 1.170 | 59472.6 |
222 | 2021-02-28 10:39:04 | midlist | 1 | 69583 | 2 | 1.060 | 65644.3 |
221 | 2021-02-18 21:41:09 | midlist | 1 | 69583 | 2 | 1.830 | 38023.5 |
220 | 2021-01-09 13:13:52 | midlist | 1 | 69583 | 2 | 1.046 | 66522.9 |
219 | 2020-12-03 13:38:48 | midlist | 1 | 69583 | 2 | 1.143 | 60877.5 |
218 | 2020-11-06 15:40:15 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
217 | 2020-10-21 22:53:17 | midlist | 1 | 69583 | 2 | 1.076 | 64668.2 |
216 | 2020-10-03 09:05:57 | midlist | 1 | 69583 | 2 | 1.076 | 64668.2 |
215 | 2020-08-29 19:02:52 | midlist | 1 | 69583 | 2 | 1.060 | 65644.3 |
214 | 2020-08-29 01:27:13 | midlist | 1 | 69583 | 2 | 1.050 | 66269.5 |
213 | 2020-08-25 20:47:07 | midlist | 1 | 69583 | 2 | 1.093 | 63662.4 |
212 | 2020-08-24 08:53:35 | midlist | 1 | 69583 | 2 | 1.080 | 64428.7 |
211 | 2020-07-20 07:42:36 | midlist | 1 | 69583 | 2 | 1.280 | 54361.7 |
210 | 2020-07-19 05:42:36 | midlist | 1 | 69583 | 2 | 1.123 | 61961.7 |
209 | 2020-07-11 17:26:33 | midlist | 1 | 69583 | 2 | 1.263 | 55093.4 |
208 | 2020-05-24 11:19:35 | midlist | 1 | 69583 | 2 | 1.173 | 59320.5 |
207 | 2020-03-29 19:48:54 | midlist | 1 | 69583 | 2 | 1.186 | 58670.3 |
206 | 2020-03-26 06:47:24 | midlist | 1 | 69583 | 2 | 1.283 | 54234.6 |
205 | 2020-03-26 01:50:51 | midlist | 1 | 69583 | 2 | 1.250 | 55666.4 |
204 | 2020-03-20 23:39:27 | midlist | 1 | 69583 | 2 | 1.220 | 57035.2 |
203 | 2020-03-01 10:07:25 | midlist | 1 | 69583 | 2 | 3.313 | 21003.0 |
202 | 2020-02-24 17:18:19 | midlist | 1 | 69583 | 2 | 1.203 | 57841.2 |
201 | 2020-02-21 07:16:12 | midlist | 1 | 69583 | 2 | 3.610 | 19275.1 |
200 | 2020-02-21 05:42:22 | midlist | 1 | 69583 | 2 | 1.890 | 36816.4 |