History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
377 | 2024-05-01 16:42:22 | affair | 3 | 112716 | 129 | 16.406 | 6870.4 |
376 | 2024-04-29 00:56:46 | affair | 3 | 112716 | 129 | 6.503 | 17332.9 |
375 | 2024-04-28 20:51:14 | affair | 2 | 82551 | 14 | 2.686 | 30733.8 |
374 | 2024-04-28 20:50:35 | affair | 2 | 82551 | 14 | 2.356 | 35038.6 |
373 | 2024-04-28 20:50:30 | affair | 3 | 112716 | 129 | 5.186 | 21734.7 |
372 | 2024-04-28 20:50:27 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
371 | 2024-04-28 20:50:13 | affair | 3 | 112716 | 129 | 5.533 | 20371.6 |
370 | 2024-04-28 11:15:46 | affair | 3 | 112716 | 129 | 7.360 | 15314.7 |
369 | 2024-04-27 23:45:38 | affair | 1 | 48755 | 3 | 3.173 | 15365.6 |
368 | 2024-04-06 13:28:26 | affair | 1 | 48755 | 3 | 2.203 | 22131.2 |
367 | 2024-04-05 21:48:32 | affair | 1 | 48755 | 3 | 1.826 | 26700.4 |
366 | 2024-04-01 09:49:39 | affair | 3 | 112716 | 129 | 9.313 | 12103.1 |
365 | 2024-03-30 19:35:05 | affair | 2 | 82551 | 14 | 3.080 | 26802.3 |
364 | 2024-03-30 06:35:32 | affair | 2 | 82551 | 14 | 8.576 | 9625.8 |
363 | 2024-03-30 00:57:05 | affair | 1 | 48755 | 3 | 2.313 | 21078.7 |
362 | 2024-03-29 19:35:11 | affair | 3 | 112716 | 129 | 19.000 | 5932.4 |
361 | 2024-03-29 05:49:27 | affair | 3 | 112716 | 129 | 19.143 | 5888.1 |
360 | 2024-03-29 05:49:33 | affair | 1 | 48755 | 3 | 1.966 | 24799.1 |
359 | 2024-03-29 05:49:26 | affair | 2 | 82551 | 14 | 4.283 | 19274.1 |
358 | 2024-03-29 05:49:20 | affair | 1 | 48755 | 3 | 2.703 | 18037.4 |
357 | 2024-03-25 03:45:06 | affair | 1 | 48755 | 3 | 0.766 | 63648.8 |
356 | 2024-03-07 09:06:18 | affair | 1 | 48755 | 3 | 1.940 | 25131.4 |
355 | 2024-03-06 16:07:07 | affair | 1 | 48755 | 3 | 0.860 | 56691.9 |
354 | 2024-02-28 09:08:37 | affair | 1 | 48755 | 3 | 1.393 | 35000.0 |
353 | 2024-02-28 01:35:51 | affair | 1 | 48755 | 3 | 1.860 | 26212.4 |
352 | 2024-02-12 15:09:52 | affair | 3 | 112716 | 129 | 12.066 | 9341.6 |
351 | 2024-02-09 16:48:12 | affair | 3 | 112716 | 129 | 5.920 | 19039.9 |
350 | 2024-02-09 16:48:11 | affair | 2 | 82551 | 14 | 2.453 | 33653.1 |
349 | 2024-02-06 04:16:17 | affair | 2 | 82551 | 14 | 2.750 | 30018.5 |
348 | 2024-02-06 04:15:49 | affair | 3 | 112716 | 129 | 5.716 | 19719.4 |
347 | 2024-02-06 03:49:26 | affair | 2 | 82551 | 14 | 2.360 | 34979.2 |
346 | 2024-02-06 03:49:18 | affair | 3 | 112716 | 129 | 5.423 | 20784.8 |
345 | 2024-02-05 09:40:42 | affair | 3 | 112716 | 129 | 6.843 | 16471.7 |
344 | 2024-02-05 09:40:46 | affair | 1 | 48755 | 3 | 1.783 | 27344.4 |
343 | 2024-02-05 09:40:38 | affair | 2 | 82551 | 14 | 5.483 | 15055.8 |
342 | 2023-12-19 19:42:11 | affair | 1 | 48755 | 3 | 0.813 | 59969.2 |
341 | 2023-12-15 21:54:43 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
340 | 2023-11-30 07:30:34 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
339 | 2023-11-26 09:53:45 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
338 | 2023-11-12 04:21:44 | affair | 1 | 48755 | 3 | 0.733 | 66514.3 |
337 | 2023-10-20 07:59:32 | affair | 1 | 48755 | 3 | 0.753 | 64747.7 |
336 | 2023-10-14 23:49:07 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
335 | 2023-10-01 15:01:10 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
334 | 2023-09-26 07:47:54 | affair | 1 | 48755 | 3 | 0.860 | 56691.9 |
333 | 2023-09-15 17:09:41 | affair | 1 | 48755 | 3 | 1.686 | 28917.6 |
332 | 2023-07-29 10:36:31 | affair | 1 | 48755 | 3 | 0.813 | 59969.2 |
331 | 2023-07-27 04:21:20 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
330 | 2023-04-24 20:07:18 | affair | 1 | 48755 | 3 | 0.766 | 63648.8 |
329 | 2023-03-31 12:49:02 | affair | 1 | 48755 | 3 | 0.953 | 51159.5 |
328 | 2023-02-13 02:00:14 | affair | 1 | 48755 | 3 | 0.720 | 67715.3 |
327 | 2022-12-10 05:04:38 | affair | 1 | 48755 | 3 | 0.830 | 58741.0 |
326 | 2022-12-09 09:42:49 | affair | 1 | 48755 | 3 | 0.733 | 66514.3 |
325 | 2022-08-12 23:18:40 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
324 | 2022-08-10 13:50:18 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
323 | 2022-08-05 22:48:30 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
322 | 2022-04-01 23:54:34 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
321 | 2022-03-28 15:41:53 | affair | 1 | 48755 | 3 | 1.016 | 47987.2 |
320 | 2022-01-05 18:02:42 | affair | 1 | 48755 | 3 | 0.893 | 54596.9 |
319 | 2021-12-07 21:54:36 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
318 | 2021-11-07 05:04:32 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
317 | 2021-11-04 00:13:27 | affair | 1 | 48755 | 3 | 0.856 | 56956.8 |
316 | 2021-11-01 21:56:59 | affair | 1 | 48755 | 3 | 0.876 | 55656.4 |
315 | 2021-10-04 03:21:31 | affair | 1 | 48755 | 3 | 0.873 | 55847.7 |
314 | 2021-08-24 22:22:35 | affair | 1 | 48755 | 3 | 0.783 | 62266.9 |
313 | 2021-07-25 00:00:11 | affair | 1 | 48755 | 3 | 0.826 | 59025.4 |
312 | 2021-05-20 21:21:16 | affair | 1 | 48755 | 3 | 1.080 | 45143.5 |
311 | 2021-05-15 04:33:30 | affair | 1 | 48755 | 3 | 0.766 | 63648.8 |
310 | 2021-05-06 05:07:31 | affair | 1 | 48755 | 3 | 0.830 | 58741.0 |
309 | 2021-04-14 07:18:37 | affair | 1 | 48755 | 3 | 0.783 | 62266.9 |
308 | 2021-03-17 14:44:42 | affair | 2 | 82551 | 14 | 2.110 | 39123.7 |
307 | 2021-02-20 20:49:35 | affair | 1 | 48755 | 3 | 0.750 | 65006.7 |
306 | 2021-02-18 09:14:47 | affair | 1 | 48755 | 3 | 0.766 | 63648.8 |
305 | 2021-02-14 03:03:25 | affair | 3 | 112716 | 129 | 4.750 | 23729.7 |
304 | 2020-12-30 03:34:21 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
303 | 2020-12-29 19:09:34 | affair | 2 | 82551 | 14 | 2.186 | 37763.5 |
302 | 2020-12-29 08:02:16 | affair | 1 | 48755 | 3 | 0.826 | 59025.4 |
301 | 2020-12-20 05:03:27 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
300 | 2020-12-02 11:49:15 | affair | 1 | 48755 | 3 | 0.783 | 62266.9 |
299 | 2020-11-14 07:36:34 | affair | 1 | 48755 | 3 | 0.763 | 63899.1 |
298 | 2020-11-01 09:20:43 | affair | 3 | 112716 | 129 | 5.423 | 20784.8 |
297 | 2020-10-31 20:16:11 | affair | 3 | 112716 | 129 | 5.143 | 21916.4 |
296 | 2020-10-27 23:59:56 | affair | 3 | 112716 | 129 | 5.267 | 21400.4 |
295 | 2020-10-26 16:17:40 | affair | 2 | 82551 | 14 | 2.546 | 32423.8 |
294 | 2020-10-18 17:45:34 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
293 | 2020-10-16 18:40:28 | affair | 1 | 48755 | 3 | 1.796 | 27146.4 |
292 | 2020-10-13 12:53:55 | affair | 2 | 82551 | 14 | 2.530 | 32628.9 |
291 | 2020-09-20 11:00:19 | affair | 1 | 48755 | 3 | 0.736 | 66243.2 |
290 | 2020-09-16 09:43:36 | affair | 3 | 112716 | 129 | 4.640 | 24292.2 |
289 | 2020-09-10 18:28:22 | affair | 1 | 48755 | 3 | 1.516 | 32160.3 |
288 | 2020-09-05 18:46:07 | affair | 1 | 48755 | 3 | 0.860 | 56691.9 |
287 | 2020-08-31 18:24:40 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
286 | 2020-08-22 13:37:41 | affair | 2 | 82551 | 14 | 2.453 | 33653.1 |
285 | 2020-08-16 06:59:12 | affair | 3 | 112716 | 129 | 4.673 | 24120.7 |
284 | 2020-08-12 20:53:17 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
283 | 2020-08-10 06:33:25 | affair | 1 | 48755 | 3 | 0.763 | 63899.1 |
282 | 2020-08-10 01:14:56 | affair | 1 | 48755 | 3 | 0.766 | 63648.8 |
281 | 2020-07-31 12:28:21 | affair | 3 | 112716 | 129 | 5.563 | 20261.7 |
280 | 2020-07-28 20:18:01 | affair | 3 | 112716 | 129 | 4.800 | 23482.5 |
279 | 2020-07-27 06:09:21 | affair | 1 | 48755 | 3 | 0.830 | 58741.0 |
278 | 2020-07-18 13:05:32 | affair | 1 | 48755 | 3 | 0.813 | 59969.2 |