History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deacon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
420 | 2024-03-30 00:08:56 | deacon | 2 | 82551 | 30 | 5.736 | 14391.7 |
419 | 2024-03-30 00:08:34 | deacon | 3 | 112716 | 387 | 6.186 | 18221.1 |
418 | 2024-03-29 05:33:26 | deacon | 3 | 112716 | 387 | 12.486 | 9027.4 |
417 | 2024-03-29 05:31:38 | deacon | 1 | 48755 | 3 | 1.923 | 25353.6 |
416 | 2024-03-29 05:31:26 | deacon | 3 | 112716 | 387 | 12.156 | 9272.5 |
415 | 2024-03-29 05:31:28 | deacon | 2 | 82551 | 30 | 4.533 | 18211.1 |
414 | 2024-03-29 05:31:20 | deacon | 1 | 48755 | 3 | 1.076 | 45311.3 |
413 | 2024-02-29 21:47:44 | deacon | 1 | 48755 | 3 | 0.876 | 55656.4 |
412 | 2024-02-28 11:52:10 | deacon | 2 | 82551 | 30 | 5.266 | 15676.2 |
411 | 2024-02-28 11:51:48 | deacon | 3 | 112716 | 387 | 6.300 | 17891.4 |
410 | 2024-02-28 02:41:24 | deacon | 2 | 82551 | 30 | 5.796 | 14242.8 |
409 | 2024-02-28 00:55:11 | deacon | 3 | 112716 | 387 | 6.063 | 18590.8 |
408 | 2024-02-28 00:55:09 | deacon | 2 | 82551 | 30 | 3.190 | 25878.1 |
407 | 2024-02-28 00:55:09 | deacon | 1 | 48755 | 3 | 1.780 | 27390.4 |
406 | 2024-02-25 22:35:43 | deacon | 1 | 48755 | 3 | 2.813 | 17332.0 |
405 | 2024-01-30 07:06:37 | deacon | 1 | 48755 | 3 | 0.860 | 56691.9 |
404 | 2023-12-19 21:30:04 | deacon | 3 | 112716 | 387 | 5.343 | 21096.0 |
403 | 2023-12-19 21:30:03 | deacon | 2 | 82551 | 30 | 2.643 | 31233.8 |
402 | 2023-12-13 22:02:51 | deacon | 3 | 112716 | 387 | 5.546 | 20323.8 |
401 | 2023-12-13 22:02:47 | deacon | 2 | 82551 | 30 | 2.403 | 34353.3 |
400 | 2023-11-26 00:55:26 | deacon | 3 | 112716 | 387 | 5.220 | 21593.1 |
399 | 2023-11-26 00:55:27 | deacon | 2 | 82551 | 30 | 2.436 | 33887.9 |
398 | 2023-11-25 12:35:21 | deacon | 1 | 48755 | 3 | 0.783 | 62266.9 |
397 | 2023-11-24 20:05:57 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
396 | 2023-11-17 23:07:09 | deacon | 1 | 48755 | 3 | 0.873 | 55847.7 |
395 | 2023-11-12 01:58:09 | deacon | 1 | 48755 | 3 | 0.800 | 60943.8 |
394 | 2023-10-28 19:32:12 | deacon | 1 | 48755 | 3 | 0.780 | 62506.4 |
393 | 2023-10-21 22:18:06 | deacon | 1 | 48755 | 3 | 0.813 | 59969.2 |
392 | 2023-10-18 17:47:02 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
391 | 2023-10-11 06:42:15 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
390 | 2023-10-08 14:07:58 | deacon | 1 | 48755 | 3 | 0.796 | 61250.0 |
389 | 2023-09-24 23:39:45 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
388 | 2023-09-14 10:59:19 | deacon | 1 | 48755 | 3 | 0.890 | 54780.9 |
387 | 2023-09-10 21:13:43 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
386 | 2023-08-05 00:14:52 | deacon | 1 | 48755 | 3 | 0.766 | 63648.8 |
385 | 2023-06-21 17:02:35 | deacon | 1 | 48755 | 3 | 0.736 | 66243.2 |
384 | 2023-04-27 12:36:19 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
383 | 2023-04-22 12:14:26 | deacon | 1 | 48755 | 3 | 0.736 | 66243.2 |
382 | 2023-04-05 06:57:53 | deacon | 1 | 48755 | 3 | 0.733 | 66514.3 |
381 | 2023-03-21 21:47:33 | deacon | 1 | 48755 | 3 | 0.733 | 66514.3 |
380 | 2023-01-22 06:27:50 | deacon | 1 | 48755 | 3 | 0.813 | 59969.2 |
379 | 2023-01-18 21:37:31 | deacon | 1 | 48755 | 3 | 0.813 | 59969.2 |
378 | 2022-11-17 20:10:11 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
377 | 2022-10-01 04:56:07 | deacon | 1 | 48755 | 3 | 0.736 | 66243.2 |
376 | 2022-08-25 19:12:45 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
375 | 2022-07-10 12:38:27 | deacon | 1 | 48755 | 3 | 0.766 | 63648.8 |
374 | 2022-06-06 23:00:04 | deacon | 1 | 48755 | 3 | 0.736 | 66243.2 |
373 | 2022-03-08 17:23:04 | deacon | 1 | 48755 | 3 | 1.000 | 48755.0 |
372 | 2022-02-20 03:24:08 | deacon | 1 | 48755 | 3 | 0.860 | 56691.9 |
371 | 2022-02-16 19:08:21 | deacon | 1 | 48755 | 3 | 0.783 | 62266.9 |
370 | 2021-12-21 06:26:12 | deacon | 1 | 48755 | 3 | 0.780 | 62506.4 |
369 | 2021-12-18 04:26:20 | deacon | 1 | 48755 | 3 | 0.893 | 54596.9 |
368 | 2021-11-08 19:53:54 | deacon | 1 | 48755 | 3 | 0.830 | 58741.0 |
367 | 2021-10-30 07:40:48 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
366 | 2021-09-25 01:30:21 | deacon | 1 | 48755 | 3 | 0.903 | 53992.2 |
365 | 2021-09-07 20:21:37 | deacon | 1 | 48755 | 3 | 1.690 | 28849.1 |
364 | 2021-08-09 05:02:56 | deacon | 1 | 48755 | 3 | 0.846 | 57630.0 |
363 | 2021-07-30 08:50:18 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
362 | 2021-07-12 15:42:01 | deacon | 1 | 48755 | 3 | 0.733 | 66514.3 |
361 | 2021-05-05 01:19:10 | deacon | 1 | 48755 | 3 | 0.876 | 55656.4 |
360 | 2021-05-01 08:12:44 | deacon | 1 | 48755 | 3 | 1.063 | 45865.5 |
359 | 2021-03-30 15:40:10 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
358 | 2021-02-27 01:21:27 | deacon | 1 | 48755 | 3 | 0.846 | 57630.0 |
357 | 2021-02-26 08:19:26 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
356 | 2021-02-02 23:14:39 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
355 | 2021-02-02 12:09:20 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
354 | 2021-01-14 06:18:42 | deacon | 1 | 48755 | 3 | 0.766 | 63648.8 |
353 | 2020-10-31 21:19:24 | deacon | 1 | 48755 | 3 | 0.860 | 56691.9 |
352 | 2020-10-31 14:53:48 | deacon | 1 | 48755 | 3 | 0.876 | 55656.4 |
351 | 2020-10-29 12:06:08 | deacon | 1 | 48755 | 3 | 0.783 | 62266.9 |
350 | 2020-10-20 03:52:05 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
349 | 2020-09-26 21:02:38 | deacon | 1 | 48755 | 3 | 0.733 | 66514.3 |
348 | 2020-09-10 02:38:23 | deacon | 1 | 48755 | 3 | 0.733 | 66514.3 |
347 | 2020-09-05 04:32:47 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
346 | 2020-09-05 00:32:10 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
345 | 2020-08-05 14:23:52 | deacon | 1 | 48755 | 3 | 0.873 | 55847.7 |
344 | 2020-08-01 15:54:58 | deacon | 1 | 48755 | 3 | 1.033 | 47197.5 |
343 | 2020-07-29 14:41:41 | deacon | 1 | 48755 | 3 | 0.766 | 63648.8 |
342 | 2020-06-06 18:28:44 | deacon | 1 | 48755 | 3 | 0.763 | 63899.1 |
341 | 2020-04-30 04:32:28 | deacon | 1 | 48755 | 3 | 0.750 | 65006.7 |
340 | 2020-03-27 18:25:54 | deacon | 1 | 48755 | 3 | 0.890 | 54780.9 |
339 | 2020-03-25 09:00:10 | deacon | 1 | 48755 | 3 | 0.783 | 62266.9 |
338 | 2020-03-24 20:24:26 | deacon | 1 | 48755 | 3 | 0.903 | 53992.2 |
337 | 2020-03-23 13:34:43 | deacon | 1 | 48755 | 3 | 1.000 | 48755.0 |
336 | 2020-03-22 01:45:50 | deacon | 1 | 48755 | 3 | 0.843 | 57835.1 |
335 | 2020-03-19 21:26:20 | deacon | 1 | 48755 | 3 | 0.890 | 54780.9 |
334 | 2020-03-19 00:16:11 | deacon | 1 | 48755 | 3 | 0.780 | 62506.4 |
333 | 2020-03-18 21:21:59 | deacon | 1 | 48755 | 3 | 0.856 | 56956.8 |
332 | 2020-02-25 16:05:33 | deacon | 1 | 48755 | 3 | 0.923 | 52822.3 |
331 | 2020-02-20 09:57:11 | deacon | 1 | 48755 | 3 | 0.906 | 53813.5 |
330 | 2020-02-12 19:28:21 | deacon | 1 | 48755 | 3 | 0.936 | 52088.7 |
329 | 2020-02-04 20:02:06 | deacon | 1 | 48755 | 3 | 1.046 | 46610.9 |
328 | 2020-02-04 15:57:25 | deacon | 1 | 48755 | 3 | 1.936 | 25183.4 |
327 | 2020-02-02 11:16:46 | deacon | 1 | 48755 | 3 | 0.966 | 50471.0 |
326 | 2020-02-01 03:08:41 | deacon | 1 | 48755 | 3 | 2.796 | 17437.4 |
325 | 2020-01-29 05:59:43 | deacon | 1 | 48755 | 3 | 1.936 | 25183.4 |
324 | 2020-01-26 21:59:29 | deacon | 1 | 48755 | 3 | 0.936 | 52088.7 |
323 | 2020-01-26 07:11:50 | deacon | 1 | 48755 | 3 | 0.780 | 62506.4 |
322 | 2020-01-22 01:47:26 | deacon | 1 | 48755 | 3 | 0.923 | 52822.3 |
321 | 2020-01-14 20:27:17 | deacon | 1 | 48755 | 3 | 0.830 | 58741.0 |