History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reason"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
523 | 2024-04-03 11:11:08 | reason | 1 | 48755 | 5 | 0.966 | 50471.0 |
522 | 2024-03-28 18:46:46 | reason | 1 | 48755 | 5 | 2.096 | 23261.0 |
521 | 2024-03-26 22:52:22 | reason | 1 | 48755 | 5 | 0.783 | 62266.9 |
520 | 2024-03-06 16:21:20 | reason | 3 | 112716 | 596 | 19.423 | 5803.2 |
519 | 2024-03-06 09:31:57 | reason | 2 | 82551 | 42 | 9.296 | 8880.3 |
518 | 2024-03-05 18:09:06 | reason | 3 | 112716 | 596 | 13.970 | 8068.4 |
517 | 2024-03-05 03:38:21 | reason | 3 | 112716 | 596 | 14.143 | 7969.7 |
516 | 2024-03-05 00:03:50 | reason | 3 | 112716 | 596 | 5.626 | 20034.8 |
515 | 2024-03-05 00:03:51 | reason | 2 | 82551 | 42 | 2.626 | 31436.0 |
514 | 2024-03-05 00:03:45 | reason | 1 | 48755 | 5 | 1.186 | 41108.8 |
513 | 2024-03-05 00:03:40 | reason | 3 | 112716 | 596 | 6.126 | 18399.6 |
512 | 2024-03-05 00:03:37 | reason | 2 | 82551 | 42 | 2.673 | 30883.3 |
511 | 2024-03-04 01:12:37 | reason | 3 | 112716 | 596 | 15.470 | 7286.1 |
510 | 2024-03-04 01:12:38 | reason | 2 | 82551 | 42 | 3.423 | 24116.6 |
509 | 2024-03-04 01:12:20 | reason | 1 | 48755 | 5 | 2.970 | 16415.8 |
508 | 2024-01-12 16:06:19 | reason | 1 | 48755 | 5 | 0.783 | 62266.9 |
507 | 2023-12-21 01:40:36 | reason | 2 | 82551 | 42 | 2.486 | 33206.4 |
506 | 2023-12-20 01:54:21 | reason | 1 | 48755 | 5 | 0.763 | 63899.1 |
505 | 2023-12-17 12:22:34 | reason | 3 | 112716 | 596 | 5.826 | 19347.1 |
504 | 2023-12-11 06:13:28 | reason | 2 | 82551 | 42 | 2.516 | 32810.4 |
503 | 2023-12-11 06:13:23 | reason | 3 | 112716 | 596 | 5.736 | 19650.6 |
502 | 2023-11-29 14:58:34 | reason | 2 | 82551 | 42 | 2.593 | 31836.1 |
501 | 2023-11-12 09:10:18 | reason | 1 | 48755 | 5 | 0.763 | 63899.1 |
500 | 2023-11-10 23:05:44 | reason | 1 | 48755 | 5 | 0.813 | 59969.2 |
499 | 2023-11-03 17:42:17 | reason | 3 | 112716 | 596 | 6.060 | 18600.0 |
498 | 2023-11-03 17:42:07 | reason | 3 | 112716 | 596 | 11.516 | 9787.8 |
497 | 2023-11-02 01:45:45 | reason | 1 | 48755 | 5 | 1.780 | 27390.4 |
496 | 2023-11-01 17:00:59 | reason | 3 | 112716 | 596 | 5.533 | 20371.6 |
495 | 2023-11-01 17:00:56 | reason | 2 | 82551 | 42 | 2.500 | 33020.4 |
494 | 2023-10-28 21:34:47 | reason | 3 | 112716 | 596 | 12.643 | 8915.3 |
493 | 2023-10-27 16:11:18 | reason | 1 | 48755 | 5 | 0.860 | 56691.9 |
492 | 2023-10-23 14:10:01 | reason | 3 | 112716 | 596 | 6.156 | 18309.9 |
491 | 2023-10-20 17:59:13 | reason | 1 | 48755 | 5 | 0.890 | 54780.9 |
490 | 2023-10-18 00:25:28 | reason | 3 | 112716 | 596 | 11.266 | 10005.0 |
489 | 2023-10-17 23:48:17 | reason | 1 | 48755 | 5 | 0.750 | 65006.7 |
488 | 2023-10-15 21:54:32 | reason | 3 | 112716 | 596 | 5.233 | 21539.5 |
487 | 2023-10-15 21:54:31 | reason | 2 | 82551 | 42 | 2.393 | 34496.9 |
486 | 2023-10-10 23:15:52 | reason | 1 | 48755 | 5 | 0.763 | 63899.1 |
485 | 2023-10-07 06:03:42 | reason | 1 | 48755 | 5 | 1.596 | 30548.2 |
484 | 2023-10-04 12:44:15 | reason | 1 | 48755 | 5 | 0.733 | 66514.3 |
483 | 2023-09-23 10:30:24 | reason | 1 | 48755 | 5 | 0.796 | 61250.0 |
482 | 2023-09-19 16:35:27 | reason | 1 | 48755 | 5 | 0.843 | 57835.1 |
481 | 2023-09-14 22:48:57 | reason | 3 | 112716 | 596 | 4.983 | 22620.1 |
480 | 2023-09-14 22:48:54 | reason | 2 | 82551 | 42 | 2.360 | 34979.2 |
479 | 2023-09-10 14:50:31 | reason | 1 | 48755 | 5 | 0.826 | 59025.4 |
478 | 2023-08-03 12:51:26 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
477 | 2023-05-26 23:29:50 | reason | 1 | 48755 | 5 | 0.843 | 57835.1 |
476 | 2023-04-29 02:14:43 | reason | 1 | 48755 | 5 | 0.860 | 56691.9 |
475 | 2023-02-18 00:07:30 | reason | 1 | 48755 | 5 | 0.780 | 62506.4 |
474 | 2023-02-03 12:02:56 | reason | 1 | 48755 | 5 | 0.750 | 65006.7 |
473 | 2023-01-31 02:09:45 | reason | 1 | 48755 | 5 | 0.876 | 55656.4 |
472 | 2022-12-16 11:30:42 | reason | 1 | 48755 | 5 | 0.763 | 63899.1 |
471 | 2022-10-09 13:31:34 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
470 | 2022-08-24 11:17:45 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
469 | 2022-06-22 23:04:59 | reason | 1 | 48755 | 5 | 0.873 | 55847.7 |
468 | 2022-04-13 20:50:04 | reason | 1 | 48755 | 5 | 1.170 | 41670.9 |
467 | 2022-03-10 09:03:40 | reason | 1 | 48755 | 5 | 1.156 | 42175.6 |
466 | 2022-03-07 00:26:17 | reason | 1 | 48755 | 5 | 0.763 | 63899.1 |
465 | 2022-01-16 02:20:27 | reason | 1 | 48755 | 5 | 0.906 | 53813.5 |
464 | 2021-11-23 09:23:50 | reason | 1 | 48755 | 5 | 0.906 | 53813.5 |
463 | 2021-11-16 00:25:29 | reason | 1 | 48755 | 5 | 0.783 | 62266.9 |
462 | 2021-11-13 23:02:34 | reason | 1 | 48755 | 5 | 0.986 | 49447.3 |
461 | 2021-11-11 22:13:34 | reason | 1 | 48755 | 5 | 0.890 | 54780.9 |
460 | 2021-10-10 01:26:00 | reason | 1 | 48755 | 5 | 0.873 | 55847.7 |
459 | 2021-08-17 01:34:43 | reason | 1 | 48755 | 5 | 0.813 | 59969.2 |
458 | 2021-05-21 13:41:28 | reason | 1 | 48755 | 5 | 0.906 | 53813.5 |
457 | 2021-05-16 09:15:44 | reason | 1 | 48755 | 5 | 0.890 | 54780.9 |
456 | 2021-05-13 00:29:29 | reason | 1 | 48755 | 5 | 0.873 | 55847.7 |
455 | 2021-04-22 04:43:33 | reason | 1 | 48755 | 5 | 0.873 | 55847.7 |
454 | 2021-03-24 14:01:22 | reason | 1 | 48755 | 5 | 0.856 | 56956.8 |
453 | 2021-02-25 23:19:54 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
452 | 2021-02-09 05:40:15 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
451 | 2021-02-02 22:19:00 | reason | 1 | 48755 | 5 | 0.796 | 61250.0 |
450 | 2021-01-07 05:43:46 | reason | 1 | 48755 | 5 | 0.920 | 52994.6 |
449 | 2020-12-09 08:35:42 | reason | 1 | 48755 | 5 | 0.826 | 59025.4 |
448 | 2020-11-13 07:17:59 | reason | 1 | 48755 | 5 | 0.826 | 59025.4 |
447 | 2020-11-07 12:00:03 | reason | 1 | 48755 | 5 | 0.796 | 61250.0 |
446 | 2020-10-25 14:35:05 | reason | 1 | 48755 | 5 | 0.796 | 61250.0 |
445 | 2020-10-24 08:54:36 | reason | 1 | 48755 | 5 | 1.516 | 32160.3 |
444 | 2020-10-21 00:17:33 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
443 | 2020-09-12 22:58:34 | reason | 1 | 48755 | 5 | 0.780 | 62506.4 |
442 | 2020-09-05 13:23:17 | reason | 1 | 48755 | 5 | 0.750 | 65006.7 |
441 | 2020-08-02 18:51:47 | reason | 1 | 48755 | 5 | 0.780 | 62506.4 |
440 | 2020-07-27 09:34:24 | reason | 1 | 48755 | 5 | 0.796 | 61250.0 |
439 | 2020-07-21 19:31:34 | reason | 1 | 48755 | 5 | 0.893 | 54596.9 |
438 | 2020-05-01 07:22:52 | reason | 1 | 48755 | 5 | 0.983 | 49598.2 |
437 | 2020-03-27 16:18:16 | reason | 1 | 48755 | 5 | 0.766 | 63648.8 |
436 | 2020-03-26 14:23:10 | reason | 1 | 48755 | 5 | 0.843 | 57835.1 |
435 | 2020-03-24 14:56:45 | reason | 1 | 48755 | 5 | 0.846 | 57630.0 |
434 | 2020-03-23 07:37:10 | reason | 1 | 48755 | 5 | 0.876 | 55656.4 |
433 | 2020-03-22 05:43:50 | reason | 1 | 48755 | 5 | 0.876 | 55656.4 |
432 | 2020-03-19 21:04:34 | reason | 1 | 48755 | 5 | 0.920 | 52994.6 |
431 | 2020-03-18 22:16:40 | reason | 1 | 48755 | 5 | 0.906 | 53813.5 |
430 | 2020-02-24 23:05:22 | reason | 1 | 48755 | 5 | 0.940 | 51867.0 |
429 | 2020-02-22 20:15:22 | reason | 1 | 48755 | 5 | 0.920 | 52994.6 |
428 | 2020-02-15 12:43:29 | reason | 1 | 48755 | 5 | 1.876 | 25988.8 |
427 | 2020-02-11 12:54:07 | reason | 1 | 48755 | 5 | 1.983 | 24586.5 |
426 | 2020-02-02 04:40:34 | reason | 1 | 48755 | 5 | 1.300 | 37503.8 |
425 | 2020-02-01 04:30:25 | reason | 1 | 48755 | 5 | 0.920 | 52994.6 |
424 | 2020-02-01 02:53:47 | reason | 1 | 48755 | 5 | 1.953 | 24964.2 |