History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affirmation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
578 | 2024-04-25 12:22:23 | affirmation | 4 | 148819 | 86 | 33.206 | 4481.7 |
577 | 2024-04-24 07:55:15 | affirmation | 1 | 49908 | 2 | 0.796 | 62698.5 |
576 | 2024-04-24 05:34:31 | affirmation | 2 | 86808 | 6 | 2.656 | 32683.7 |
575 | 2024-04-24 05:33:45 | affirmation | 3 | 121633 | 22 | 22.766 | 5342.7 |
574 | 2024-04-24 00:33:10 | affirmation | 5 | 164607 | 560 | 42.940 | 3833.4 |
573 | 2024-04-24 00:32:59 | affirmation | 4 | 148819 | 86 | 31.813 | 4677.9 |
572 | 2024-04-23 23:27:48 | affirmation | 5 | 164607 | 560 | 36.376 | 4525.2 |
571 | 2024-04-23 10:36:02 | affirmation | 3 | 121633 | 22 | 10.376 | 11722.5 |
570 | 2024-04-23 10:36:00 | affirmation | 2 | 86808 | 6 | 3.736 | 23235.5 |
569 | 2024-04-23 10:28:00 | affirmation | 1 | 49908 | 2 | 1.840 | 27123.9 |
568 | 2024-04-23 10:15:09 | affirmation | 5 | 164607 | 560 | 23.863 | 6898.0 |
567 | 2024-04-23 10:14:47 | affirmation | 4 | 148819 | 86 | 14.483 | 10275.4 |
566 | 2024-04-22 11:17:32 | affirmation | 3 | 121633 | 22 | 13.313 | 9136.4 |
565 | 2024-04-22 11:17:26 | affirmation | 2 | 86808 | 6 | 2.830 | 30674.2 |
564 | 2024-04-22 07:03:39 | affirmation | 4 | 148819 | 86 | 11.250 | 13228.4 |
563 | 2024-04-22 01:31:45 | affirmation | 5 | 164607 | 560 | 23.330 | 7055.6 |
562 | 2024-04-22 01:10:47 | affirmation | 4 | 148819 | 86 | 22.453 | 6628.0 |
561 | 2024-04-22 01:09:51 | affirmation | 4 | 148819 | 86 | 31.910 | 4663.7 |
560 | 2024-04-21 23:02:52 | affirmation | 5 | 164607 | 560 | 36.296 | 4535.1 |
559 | 2024-04-21 23:02:43 | affirmation | 4 | 148819 | 86 | 27.626 | 5386.9 |
558 | 2024-04-21 23:02:58 | affirmation | 1 | 49908 | 2 | 3.623 | 13775.3 |
557 | 2024-04-21 23:02:53 | affirmation | 2 | 86808 | 6 | 5.953 | 14582.2 |
556 | 2024-04-21 23:02:42 | affirmation | 3 | 121633 | 22 | 11.186 | 10873.7 |
555 | 2024-04-21 23:02:27 | affirmation | 1 | 49908 | 2 | 0.953 | 52369.4 |
554 | 2024-04-21 04:08:16 | affirmation | 1 | 49908 | 2 | 1.923 | 25953.2 |
553 | 2024-04-05 11:21:41 | affirmation | 1 | 49908 | 2 | 0.766 | 65154.0 |
552 | 2024-04-05 11:03:35 | affirmation | 2 | 86808 | 6 | 5.046 | 17203.3 |
551 | 2024-04-01 10:38:53 | affirmation | 5 | 164607 | 560 | 26.736 | 6156.8 |
550 | 2024-03-28 06:13:09 | affirmation | 1 | 49908 | 2 | 0.783 | 63739.5 |
549 | 2024-03-22 14:46:39 | affirmation | 3 | 121633 | 22 | 13.966 | 8709.2 |
548 | 2024-03-22 07:30:56 | affirmation | 2 | 86808 | 6 | 6.656 | 13042.1 |
547 | 2024-03-22 07:24:41 | affirmation | 1 | 49908 | 2 | 0.890 | 56076.4 |
546 | 2024-03-21 16:35:56 | affirmation | 3 | 121633 | 22 | 16.560 | 7345.0 |
545 | 2024-03-19 04:58:54 | affirmation | 4 | 148819 | 86 | 16.110 | 9237.7 |
544 | 2024-03-19 04:57:19 | affirmation | 3 | 121633 | 22 | 6.500 | 18712.8 |
543 | 2024-03-18 14:04:47 | affirmation | 4 | 148819 | 86 | 28.410 | 5238.3 |
542 | 2024-03-16 17:44:16 | affirmation | 3 | 121633 | 22 | 16.003 | 7600.6 |
541 | 2024-03-16 17:44:18 | affirmation | 2 | 86808 | 6 | 8.123 | 10686.7 |
540 | 2024-03-16 17:44:10 | affirmation | 4 | 148819 | 86 | 14.453 | 10296.8 |
539 | 2024-03-16 17:43:16 | affirmation | 1 | 49908 | 2 | 1.763 | 28308.6 |
538 | 2024-03-16 06:04:14 | affirmation | 4 | 148819 | 86 | 27.970 | 5320.7 |
537 | 2024-03-16 06:04:13 | affirmation | 3 | 121633 | 22 | 10.970 | 11087.8 |
536 | 2024-03-16 06:04:07 | affirmation | 2 | 86808 | 6 | 5.346 | 16237.9 |
535 | 2024-03-16 06:03:35 | affirmation | 1 | 49908 | 2 | 1.893 | 26364.5 |
534 | 2024-03-14 21:17:59 | affirmation | 5 | 164607 | 560 | 49.770 | 3307.4 |
533 | 2024-03-13 20:32:28 | affirmation | 5 | 164607 | 560 | 41.656 | 3951.6 |
532 | 2024-03-13 13:02:17 | affirmation | 5 | 164607 | 560 | 42.096 | 3910.3 |
531 | 2024-03-13 10:50:43 | affirmation | 5 | 164607 | 560 | 50.376 | 3267.6 |
530 | 2024-03-13 10:49:17 | affirmation | 4 | 148819 | 86 | 16.140 | 9220.5 |
529 | 2024-03-13 10:26:55 | affirmation | 1 | 49908 | 2 | 0.796 | 62698.5 |
528 | 2024-03-13 10:26:35 | affirmation | 5 | 164607 | 560 | 16.846 | 9771.3 |
527 | 2024-03-13 10:26:34 | affirmation | 4 | 148819 | 86 | 10.096 | 14740.4 |
526 | 2024-03-13 10:26:37 | affirmation | 3 | 121633 | 22 | 6.420 | 18946.0 |
525 | 2024-03-13 10:26:37 | affirmation | 2 | 86808 | 6 | 2.516 | 34502.4 |
524 | 2024-03-13 09:33:01 | affirmation | 1 | 49908 | 2 | 0.903 | 55269.1 |
523 | 2024-02-19 01:45:00 | affirmation | 3 | 121633 | 22 | 6.580 | 18485.3 |
522 | 2024-02-16 04:08:18 | affirmation | 2 | 86808 | 6 | 2.593 | 33477.8 |
521 | 2024-02-16 03:28:29 | affirmation | 1 | 49908 | 2 | 1.296 | 38509.3 |
520 | 2024-02-13 12:07:25 | affirmation | 2 | 86808 | 6 | 3.466 | 25045.6 |
519 | 2024-02-13 11:39:10 | affirmation | 1 | 49908 | 2 | 1.830 | 27272.1 |
518 | 2024-02-12 15:45:18 | affirmation | 1 | 49908 | 2 | 2.283 | 21860.7 |
517 | 2024-02-12 11:54:52 | affirmation | 2 | 86808 | 6 | 5.093 | 17044.6 |
516 | 2024-02-12 09:58:30 | affirmation | 3 | 121633 | 22 | 6.940 | 17526.4 |
515 | 2024-02-11 15:00:54 | affirmation | 5 | 164607 | 560 | 17.796 | 9249.7 |
514 | 2024-02-10 17:39:55 | affirmation | 1 | 49908 | 2 | 0.783 | 63739.5 |
513 | 2024-02-10 01:46:18 | affirmation | 5 | 164607 | 560 | 41.536 | 3963.0 |
512 | 2024-02-09 23:30:06 | affirmation | 5 | 164607 | 560 | 46.800 | 3517.2 |
511 | 2024-02-09 23:30:05 | affirmation | 2 | 86808 | 6 | 7.356 | 11801.0 |
510 | 2024-02-09 23:29:53 | affirmation | 3 | 121633 | 22 | 15.126 | 8041.3 |
509 | 2024-02-04 13:56:52 | affirmation | 2 | 86808 | 6 | 6.486 | 13383.9 |
508 | 2024-02-04 13:54:10 | affirmation | 4 | 148819 | 86 | 23.893 | 6228.6 |
507 | 2024-02-04 13:54:05 | affirmation | 3 | 121633 | 22 | 11.596 | 10489.2 |
506 | 2024-02-04 10:21:50 | affirmation | 1 | 49908 | 2 | 0.873 | 57168.4 |
505 | 2024-02-04 10:17:07 | affirmation | 1 | 49908 | 2 | 2.610 | 19121.8 |
504 | 2024-02-02 04:04:45 | affirmation | 1 | 49908 | 2 | 0.843 | 59202.8 |
503 | 2024-01-28 16:39:50 | affirmation | 1 | 49908 | 2 | 0.810 | 61614.8 |
502 | 2024-01-06 05:01:07 | affirmation | 2 | 86808 | 6 | 2.280 | 38073.7 |
501 | 2024-01-04 03:38:39 | affirmation | 5 | 164607 | 560 | 19.203 | 8571.9 |
500 | 2023-12-11 11:04:38 | affirmation | 2 | 86808 | 6 | 2.390 | 36321.3 |
499 | 2023-12-11 06:54:49 | affirmation | 1 | 49908 | 2 | 0.720 | 69316.7 |
498 | 2023-12-06 23:57:24 | affirmation | 1 | 49908 | 2 | 0.720 | 69316.7 |
497 | 2023-12-05 14:34:46 | affirmation | 5 | 164607 | 560 | 13.516 | 12178.7 |
496 | 2023-12-02 06:26:44 | affirmation | 1 | 49908 | 2 | 0.720 | 69316.7 |
495 | 2023-11-26 03:28:35 | affirmation | 1 | 49908 | 2 | 0.733 | 68087.3 |
494 | 2023-11-23 16:51:03 | affirmation | 5 | 164607 | 560 | 20.066 | 8203.3 |
493 | 2023-11-23 12:16:35 | affirmation | 5 | 164607 | 560 | 32.780 | 5021.6 |
492 | 2023-11-20 03:38:51 | affirmation | 5 | 164607 | 560 | 12.703 | 12958.1 |
491 | 2023-11-11 09:44:24 | affirmation | 1 | 49908 | 2 | 0.890 | 56076.4 |
490 | 2023-11-02 23:00:28 | affirmation | 5 | 164607 | 560 | 15.326 | 10740.4 |
489 | 2023-10-28 13:46:26 | affirmation | 5 | 164607 | 560 | 18.283 | 9003.3 |
488 | 2023-10-21 06:08:15 | affirmation | 5 | 164607 | 560 | 50.613 | 3252.3 |
487 | 2023-10-15 20:38:21 | affirmation | 1 | 49908 | 2 | 0.846 | 58992.9 |
486 | 2023-10-13 01:36:53 | affirmation | 5 | 164607 | 560 | 16.533 | 9956.3 |
485 | 2023-10-12 00:56:42 | affirmation | 2 | 86808 | 6 | 2.360 | 36783.1 |
484 | 2023-10-06 15:01:51 | affirmation | 5 | 164607 | 560 | 28.063 | 5865.6 |
483 | 2023-09-23 21:18:28 | affirmation | 1 | 49908 | 2 | 0.860 | 58032.6 |
482 | 2023-09-12 17:27:43 | affirmation | 1 | 49908 | 2 | 0.736 | 67809.8 |
481 | 2023-09-11 23:49:14 | affirmation | 1 | 49908 | 2 | 0.920 | 54247.8 |
480 | 2023-09-11 13:48:02 | affirmation | 5 | 164607 | 560 | 18.970 | 8677.2 |
479 | 2023-09-02 11:45:31 | affirmation | 5 | 164607 | 560 | 12.623 | 13040.2 |