History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"greats"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
505 | 2024-05-06 22:02:35 | greats | 2 | 82551 | 130 | 3.826 | 21576.3 |
504 | 2024-05-06 21:41:23 | greats | 1 | 48755 | 5 | 0.893 | 54596.9 |
503 | 2024-05-06 21:41:16 | greats | 2 | 82551 | 130 | 5.313 | 15537.5 |
502 | 2024-05-06 18:43:22 | greats | 2 | 82551 | 130 | 4.216 | 19580.4 |
501 | 2024-04-27 19:42:14 | greats | 1 | 48755 | 5 | 0.810 | 60191.4 |
500 | 2024-04-06 06:14:32 | greats | 2 | 82551 | 130 | 6.156 | 13409.8 |
499 | 2024-04-06 06:14:22 | greats | 1 | 48755 | 5 | 3.470 | 14050.4 |
498 | 2024-03-07 16:24:37 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
497 | 2024-02-29 12:21:14 | greats | 1 | 48755 | 5 | 0.843 | 57835.1 |
496 | 2024-02-28 05:30:38 | greats | 2 | 82551 | 130 | 4.800 | 17198.1 |
495 | 2024-02-28 05:29:36 | greats | 1 | 48755 | 5 | 1.846 | 26411.2 |
494 | 2023-12-31 04:29:16 | greats | 2 | 82551 | 130 | 2.126 | 38829.3 |
493 | 2023-12-14 12:09:03 | greats | 1 | 48755 | 5 | 0.750 | 65006.7 |
492 | 2023-12-12 06:37:30 | greats | 2 | 82551 | 130 | 4.983 | 16566.5 |
491 | 2023-11-23 15:49:03 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
490 | 2023-11-22 08:49:45 | greats | 1 | 48755 | 5 | 0.873 | 55847.7 |
489 | 2023-11-04 12:15:55 | greats | 1 | 48755 | 5 | 0.796 | 61250.0 |
488 | 2023-10-31 09:38:34 | greats | 1 | 48755 | 5 | 0.813 | 59969.2 |
487 | 2023-10-28 20:41:40 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
486 | 2023-10-28 14:40:59 | greats | 1 | 48755 | 5 | 0.813 | 59969.2 |
485 | 2023-10-19 22:54:41 | greats | 1 | 48755 | 5 | 0.720 | 67715.3 |
484 | 2023-10-11 05:39:16 | greats | 1 | 48755 | 5 | 0.800 | 60943.8 |
483 | 2023-10-07 19:12:10 | greats | 1 | 48755 | 5 | 0.736 | 66243.2 |
482 | 2023-10-07 05:39:39 | greats | 2 | 82551 | 130 | 2.250 | 36689.3 |
481 | 2023-09-30 17:58:50 | greats | 1 | 48755 | 5 | 0.716 | 68093.6 |
480 | 2023-09-26 01:45:38 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
479 | 2023-09-14 15:48:34 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
478 | 2023-07-28 06:17:32 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
477 | 2023-07-18 05:58:57 | greats | 2 | 82551 | 130 | 3.156 | 26156.8 |
476 | 2023-07-16 10:55:37 | greats | 1 | 48755 | 5 | 0.813 | 59969.2 |
475 | 2023-04-26 20:48:11 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
474 | 2023-04-06 10:33:19 | greats | 2 | 82551 | 130 | 2.330 | 35429.6 |
473 | 2023-04-05 00:26:04 | greats | 1 | 48755 | 5 | 0.796 | 61250.0 |
472 | 2023-02-16 17:36:46 | greats | 1 | 48755 | 5 | 0.716 | 68093.6 |
471 | 2023-01-04 12:23:14 | greats | 2 | 82551 | 130 | 2.106 | 39198.0 |
470 | 2022-12-27 02:17:19 | greats | 1 | 48755 | 5 | 0.796 | 61250.0 |
469 | 2022-12-14 05:49:17 | greats | 1 | 48755 | 5 | 0.780 | 62506.4 |
468 | 2022-09-12 18:19:53 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
467 | 2022-09-08 13:00:06 | greats | 2 | 82551 | 130 | 2.096 | 39385.0 |
466 | 2022-08-19 20:40:48 | greats | 1 | 48755 | 5 | 0.766 | 63648.8 |
465 | 2022-08-17 10:38:48 | greats | 1 | 48755 | 5 | 0.846 | 57630.0 |
464 | 2022-08-07 11:52:12 | greats | 1 | 48755 | 5 | 0.716 | 68093.6 |
463 | 2022-05-27 18:00:09 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
462 | 2022-04-06 01:44:23 | greats | 1 | 48755 | 5 | 1.140 | 42767.5 |
461 | 2022-04-03 21:58:40 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
460 | 2022-02-16 09:45:07 | greats | 1 | 48755 | 5 | 0.750 | 65006.7 |
459 | 2022-01-05 12:00:26 | greats | 1 | 48755 | 5 | 0.763 | 63899.1 |
458 | 2022-01-03 09:23:49 | greats | 1 | 48755 | 5 | 0.796 | 61250.0 |
457 | 2021-11-15 01:28:50 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
456 | 2021-11-03 19:14:55 | greats | 1 | 48755 | 5 | 0.750 | 65006.7 |
455 | 2021-11-01 16:41:09 | greats | 1 | 48755 | 5 | 0.716 | 68093.6 |
454 | 2021-09-21 04:17:10 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
453 | 2021-08-19 10:51:02 | greats | 1 | 48755 | 5 | 0.813 | 59969.2 |
452 | 2021-08-17 05:58:01 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
451 | 2021-08-15 12:50:11 | greats | 1 | 48755 | 5 | 0.810 | 60191.4 |
450 | 2021-06-15 12:20:16 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
449 | 2021-05-14 21:21:26 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
448 | 2021-02-16 18:06:44 | greats | 1 | 48755 | 5 | 0.860 | 56691.9 |
447 | 2021-02-12 00:11:37 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
446 | 2021-01-09 07:13:33 | greats | 1 | 48755 | 5 | 0.736 | 66243.2 |
445 | 2020-11-10 07:31:15 | greats | 1 | 48755 | 5 | 0.856 | 56956.8 |
444 | 2020-10-31 00:21:23 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
443 | 2020-10-22 20:39:48 | greats | 1 | 48755 | 5 | 0.750 | 65006.7 |
442 | 2020-10-17 10:45:05 | greats | 1 | 48755 | 5 | 0.736 | 66243.2 |
441 | 2020-10-16 11:03:29 | greats | 1 | 48755 | 5 | 0.860 | 56691.9 |
440 | 2020-09-17 12:19:46 | greats | 1 | 48755 | 5 | 0.766 | 63648.8 |
439 | 2020-09-06 15:19:38 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
438 | 2020-08-27 23:59:11 | greats | 1 | 48755 | 5 | 0.840 | 58041.7 |
437 | 2020-08-10 13:06:18 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
436 | 2020-08-03 04:53:20 | greats | 1 | 48755 | 5 | 0.720 | 67715.3 |
435 | 2020-08-03 01:16:33 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
434 | 2020-07-12 00:20:25 | greats | 1 | 48755 | 5 | 0.780 | 62506.4 |
433 | 2020-05-18 22:26:45 | greats | 1 | 48755 | 5 | 0.846 | 57630.0 |
432 | 2020-05-09 07:51:45 | greats | 1 | 48755 | 5 | 0.800 | 60943.8 |
431 | 2020-03-26 09:40:08 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
430 | 2020-03-25 02:13:44 | greats | 1 | 48755 | 5 | 1.796 | 27146.4 |
429 | 2020-03-24 01:18:44 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
428 | 2020-03-23 03:57:49 | greats | 1 | 48755 | 5 | 0.873 | 55847.7 |
427 | 2020-03-21 09:25:18 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
426 | 2020-03-18 16:28:47 | greats | 1 | 48755 | 5 | 0.826 | 59025.4 |
425 | 2020-03-11 03:08:06 | greats | 1 | 48755 | 5 | 0.733 | 66514.3 |
424 | 2020-02-26 01:40:59 | greats | 1 | 48755 | 5 | 0.843 | 57835.1 |
423 | 2020-02-24 08:02:05 | greats | 1 | 48755 | 5 | 0.890 | 54780.9 |
422 | 2020-02-21 07:00:28 | greats | 1 | 48755 | 5 | 0.906 | 53813.5 |
421 | 2020-02-13 23:06:36 | greats | 1 | 48755 | 5 | 0.923 | 52822.3 |
420 | 2020-02-10 03:09:06 | greats | 1 | 48755 | 5 | 2.343 | 20808.8 |
419 | 2020-02-06 18:44:28 | greats | 1 | 48755 | 5 | 0.846 | 57630.0 |
418 | 2020-01-31 14:59:36 | greats | 1 | 48755 | 5 | 1.093 | 44606.6 |
417 | 2020-01-30 21:23:56 | greats | 1 | 48755 | 5 | 1.860 | 26212.4 |
416 | 2020-01-30 21:17:27 | greats | 1 | 48755 | 5 | 1.796 | 27146.4 |
415 | 2020-01-26 12:49:22 | greats | 1 | 48755 | 5 | 0.890 | 54780.9 |
414 | 2020-01-24 22:40:12 | greats | 1 | 48755 | 5 | 1.970 | 24748.7 |
413 | 2020-01-22 00:37:36 | greats | 1 | 48755 | 5 | 0.923 | 52822.3 |
412 | 2020-01-15 21:17:49 | greats | 1 | 48755 | 5 | 0.813 | 59969.2 |
411 | 2020-01-13 02:58:08 | greats | 1 | 48755 | 5 | 1.030 | 47335.0 |
410 | 2020-01-11 13:56:38 | greats | 1 | 48755 | 5 | 0.876 | 55656.4 |
409 | 2020-01-10 20:24:34 | greats | 1 | 48755 | 5 | 0.923 | 52822.3 |
408 | 2020-01-04 19:02:53 | greats | 1 | 48755 | 5 | 0.843 | 57835.1 |
407 | 2019-12-26 12:41:54 | greats | 1 | 48755 | 5 | 0.906 | 53813.5 |
406 | 2019-12-26 11:35:00 | greats | 1 | 48755 | 5 | 1.033 | 47197.5 |