History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"franks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
539 | 2024-03-06 23:10:42 | franks | 3 | 112716 | 924 | 18.670 | 6037.3 |
538 | 2024-03-05 21:30:42 | franks | 2 | 82551 | 92 | 2.846 | 29006.0 |
537 | 2024-03-04 23:26:05 | franks | 2 | 82551 | 92 | 2.703 | 30540.5 |
536 | 2024-03-04 23:25:53 | franks | 2 | 82551 | 92 | 3.953 | 20883.1 |
535 | 2024-03-04 23:25:49 | franks | 1 | 48755 | 9 | 0.920 | 52994.6 |
534 | 2024-03-04 23:25:26 | franks | 3 | 112716 | 924 | 7.436 | 15158.1 |
533 | 2024-03-04 07:46:35 | franks | 3 | 112716 | 924 | 12.093 | 9320.8 |
532 | 2024-03-04 02:30:26 | franks | 3 | 112716 | 924 | 5.893 | 19127.1 |
531 | 2024-03-04 02:30:25 | franks | 2 | 82551 | 92 | 2.780 | 29694.6 |
530 | 2024-03-04 02:30:24 | franks | 1 | 48755 | 9 | 0.940 | 51867.0 |
529 | 2024-02-28 10:31:33 | franks | 1 | 48755 | 9 | 4.610 | 10575.9 |
528 | 2024-02-28 05:37:38 | franks | 1 | 48755 | 9 | 1.860 | 26212.4 |
527 | 2024-02-25 08:13:20 | franks | 1 | 48755 | 9 | 0.876 | 55656.4 |
526 | 2024-01-17 06:01:53 | franks | 2 | 82551 | 92 | 2.203 | 37472.1 |
525 | 2024-01-12 11:59:10 | franks | 3 | 112716 | 924 | 4.953 | 22757.1 |
524 | 2024-01-12 11:59:01 | franks | 2 | 82551 | 92 | 2.500 | 33020.4 |
523 | 2024-01-06 11:33:09 | franks | 3 | 112716 | 924 | 4.720 | 23880.5 |
522 | 2024-01-04 08:17:41 | franks | 1 | 48755 | 9 | 0.810 | 60191.4 |
521 | 2023-12-08 13:39:05 | franks | 1 | 48755 | 9 | 0.736 | 66243.2 |
520 | 2023-12-08 13:39:04 | franks | 1 | 48755 | 9 | 0.733 | 66514.3 |
519 | 2023-12-08 13:06:11 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
518 | 2023-12-07 10:22:45 | franks | 1 | 48755 | 9 | 0.890 | 54780.9 |
517 | 2023-12-06 21:05:56 | franks | 2 | 82551 | 92 | 2.470 | 33421.5 |
516 | 2023-12-06 20:56:58 | franks | 3 | 112716 | 924 | 10.830 | 10407.8 |
515 | 2023-12-03 15:17:18 | franks | 3 | 112716 | 924 | 5.110 | 22057.9 |
514 | 2023-12-03 15:17:13 | franks | 2 | 82551 | 92 | 2.393 | 34496.9 |
513 | 2023-11-20 21:46:49 | franks | 1 | 48755 | 9 | 0.780 | 62506.4 |
512 | 2023-11-17 18:41:06 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
511 | 2023-11-01 05:01:52 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
510 | 2023-10-28 02:37:04 | franks | 3 | 112716 | 924 | 5.640 | 19985.1 |
509 | 2023-10-28 02:37:08 | franks | 2 | 82551 | 92 | 2.563 | 32208.7 |
508 | 2023-10-27 19:09:39 | franks | 2 | 82551 | 92 | 2.310 | 35736.4 |
507 | 2023-10-22 07:25:27 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
506 | 2023-10-18 17:06:51 | franks | 1 | 48755 | 9 | 0.733 | 66514.3 |
505 | 2023-10-13 18:19:27 | franks | 1 | 48755 | 9 | 0.846 | 57630.0 |
504 | 2023-10-12 13:50:37 | franks | 3 | 112716 | 924 | 4.720 | 23880.5 |
503 | 2023-10-03 16:14:39 | franks | 1 | 48755 | 9 | 0.736 | 66243.2 |
502 | 2023-09-23 22:07:18 | franks | 1 | 48755 | 9 | 0.720 | 67715.3 |
501 | 2023-09-22 06:15:35 | franks | 1 | 48755 | 9 | 0.763 | 63899.1 |
500 | 2023-09-22 01:42:39 | franks | 1 | 48755 | 9 | 0.716 | 68093.6 |
499 | 2023-09-15 14:15:47 | franks | 1 | 48755 | 9 | 1.733 | 28133.3 |
498 | 2023-08-06 03:14:01 | franks | 2 | 82551 | 92 | 2.106 | 39198.0 |
497 | 2023-07-22 12:23:10 | franks | 3 | 112716 | 924 | 5.673 | 19868.9 |
496 | 2023-07-18 17:40:03 | franks | 1 | 48755 | 9 | 0.733 | 66514.3 |
495 | 2023-06-05 01:10:40 | franks | 1 | 48755 | 9 | 0.796 | 61250.0 |
494 | 2023-04-21 12:36:02 | franks | 1 | 48755 | 9 | 0.766 | 63648.8 |
493 | 2023-04-19 00:27:50 | franks | 2 | 82551 | 92 | 2.060 | 40073.3 |
492 | 2023-04-03 19:46:17 | franks | 3 | 112716 | 924 | 4.563 | 24702.2 |
491 | 2023-02-23 13:11:16 | franks | 1 | 48755 | 9 | 0.720 | 67715.3 |
490 | 2023-02-12 00:46:07 | franks | 1 | 48755 | 9 | 0.736 | 66243.2 |
489 | 2023-01-20 03:01:52 | franks | 2 | 82551 | 92 | 2.126 | 38829.3 |
488 | 2022-12-30 16:16:15 | franks | 3 | 112716 | 924 | 4.546 | 24794.5 |
487 | 2022-12-09 03:58:28 | franks | 1 | 48755 | 9 | 0.796 | 61250.0 |
486 | 2022-12-06 04:18:09 | franks | 3 | 112716 | 924 | 5.923 | 19030.2 |
485 | 2022-11-06 16:24:47 | franks | 1 | 48755 | 9 | 0.716 | 68093.6 |
484 | 2022-11-01 12:30:13 | franks | 2 | 82551 | 92 | 2.390 | 34540.2 |
483 | 2022-10-27 19:37:12 | franks | 3 | 112716 | 924 | 5.453 | 20670.5 |
482 | 2022-10-24 00:00:38 | franks | 3 | 112716 | 924 | 4.626 | 24365.8 |
481 | 2022-10-20 05:34:20 | franks | 3 | 112716 | 924 | 4.733 | 23814.9 |
480 | 2022-09-25 00:38:07 | franks | 3 | 112716 | 924 | 4.703 | 23966.8 |
479 | 2022-09-10 21:13:11 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
478 | 2022-09-01 17:41:40 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
477 | 2022-09-01 07:16:01 | franks | 1 | 48755 | 9 | 0.796 | 61250.0 |
476 | 2022-08-31 20:27:48 | franks | 3 | 112716 | 924 | 5.283 | 21335.6 |
475 | 2022-08-24 06:19:56 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
474 | 2022-08-16 04:41:24 | franks | 1 | 48755 | 9 | 1.280 | 38089.8 |
473 | 2022-08-11 06:47:32 | franks | 1 | 48755 | 9 | 0.720 | 67715.3 |
472 | 2022-08-08 23:20:57 | franks | 1 | 48755 | 9 | 0.936 | 52088.7 |
471 | 2022-07-20 20:40:28 | franks | 1 | 48755 | 9 | 0.733 | 66514.3 |
470 | 2022-07-18 17:28:00 | franks | 1 | 48755 | 9 | 0.736 | 66243.2 |
469 | 2022-07-18 10:28:18 | franks | 1 | 48755 | 9 | 0.733 | 66514.3 |
468 | 2022-07-17 03:26:24 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
467 | 2022-07-10 13:08:11 | franks | 1 | 48755 | 9 | 0.766 | 63648.8 |
466 | 2022-06-25 18:17:37 | franks | 1 | 48755 | 9 | 0.796 | 61250.0 |
465 | 2022-06-08 21:06:10 | franks | 1 | 48755 | 9 | 0.796 | 61250.0 |
464 | 2022-06-02 18:45:21 | franks | 2 | 82551 | 92 | 2.250 | 36689.3 |
463 | 2022-05-25 20:29:38 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
462 | 2022-03-29 07:57:38 | franks | 1 | 48755 | 9 | 0.936 | 52088.7 |
461 | 2022-03-27 04:14:31 | franks | 1 | 48755 | 9 | 0.716 | 68093.6 |
460 | 2022-03-19 20:31:07 | franks | 1 | 48755 | 9 | 0.716 | 68093.6 |
459 | 2021-12-26 16:37:34 | franks | 1 | 48755 | 9 | 0.763 | 63899.1 |
458 | 2021-12-24 13:59:59 | franks | 1 | 48755 | 9 | 0.890 | 54780.9 |
457 | 2021-12-06 00:31:33 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
456 | 2021-10-27 08:43:18 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
455 | 2021-09-15 14:17:25 | franks | 1 | 48755 | 9 | 0.736 | 66243.2 |
454 | 2021-09-13 10:47:34 | franks | 1 | 48755 | 9 | 0.720 | 67715.3 |
453 | 2021-08-29 15:02:16 | franks | 1 | 48755 | 9 | 0.720 | 67715.3 |
452 | 2021-08-24 15:36:42 | franks | 1 | 48755 | 9 | 0.783 | 62266.9 |
451 | 2021-07-28 03:00:21 | franks | 2 | 82551 | 92 | 2.390 | 34540.2 |
450 | 2021-06-09 23:27:14 | franks | 1 | 48755 | 9 | 0.843 | 57835.1 |
449 | 2021-06-02 17:56:12 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
448 | 2021-05-28 22:55:24 | franks | 1 | 48755 | 9 | 0.810 | 60191.4 |
447 | 2021-05-27 22:07:25 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
446 | 2021-05-27 14:09:20 | franks | 1 | 48755 | 9 | 0.810 | 60191.4 |
445 | 2021-05-27 06:55:27 | franks | 1 | 48755 | 9 | 0.826 | 59025.4 |
444 | 2021-05-26 21:28:23 | franks | 1 | 48755 | 9 | 0.750 | 65006.7 |
443 | 2021-05-26 12:09:29 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
442 | 2021-05-25 22:37:33 | franks | 1 | 48755 | 9 | 0.766 | 63648.8 |
441 | 2021-05-25 15:26:02 | franks | 1 | 48755 | 9 | 0.830 | 58741.0 |
440 | 2021-05-25 00:48:00 | franks | 1 | 48755 | 9 | 0.843 | 57835.1 |