History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sampan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
591 | 2024-04-27 06:47:41 | sampan | 3 | 112716 | 518 | 16.283 | 6922.3 |
590 | 2024-04-20 19:43:36 | sampan | 1 | 48755 | 3 | 1.000 | 48755.0 |
589 | 2024-04-19 11:42:56 | sampan | 1 | 48755 | 3 | 0.970 | 50262.9 |
588 | 2024-04-13 14:56:28 | sampan | 2 | 82551 | 36 | 2.860 | 28864.0 |
587 | 2024-04-13 14:56:04 | sampan | 3 | 112716 | 518 | 8.033 | 14031.6 |
586 | 2024-04-13 04:39:55 | sampan | 2 | 82551 | 36 | 2.843 | 29036.6 |
585 | 2024-04-13 04:38:47 | sampan | 3 | 112716 | 518 | 5.800 | 19433.8 |
584 | 2024-04-11 02:36:29 | sampan | 2 | 82551 | 36 | 2.983 | 27673.8 |
583 | 2024-04-11 02:34:52 | sampan | 3 | 112716 | 518 | 6.640 | 16975.3 |
582 | 2024-04-09 19:47:52 | sampan | 3 | 112716 | 518 | 6.266 | 17988.5 |
581 | 2024-04-08 21:51:46 | sampan | 3 | 112716 | 518 | 14.236 | 7917.7 |
580 | 2024-04-08 21:51:51 | sampan | 1 | 48755 | 3 | 1.203 | 40527.8 |
579 | 2024-04-08 21:51:44 | sampan | 2 | 82551 | 36 | 3.123 | 26433.2 |
578 | 2024-04-08 21:51:35 | sampan | 1 | 48755 | 3 | 1.096 | 44484.5 |
577 | 2024-03-31 18:00:08 | sampan | 1 | 48755 | 3 | 0.936 | 52088.7 |
576 | 2024-03-15 09:46:56 | sampan | 1 | 48755 | 3 | 2.046 | 23829.4 |
575 | 2024-03-14 05:31:32 | sampan | 2 | 82551 | 36 | 3.093 | 26689.6 |
574 | 2024-03-14 05:31:03 | sampan | 3 | 112716 | 518 | 6.830 | 16503.1 |
573 | 2024-03-10 21:33:36 | sampan | 3 | 112716 | 518 | 11.593 | 9722.8 |
572 | 2024-03-10 19:41:36 | sampan | 2 | 82551 | 36 | 6.173 | 13372.9 |
571 | 2024-03-10 19:39:27 | sampan | 3 | 112716 | 518 | 6.983 | 16141.5 |
570 | 2024-03-08 23:11:59 | sampan | 2 | 82551 | 36 | 4.203 | 19641.0 |
569 | 2024-03-08 23:11:27 | sampan | 3 | 112716 | 518 | 6.156 | 18309.9 |
568 | 2024-03-08 17:33:40 | sampan | 1 | 48755 | 3 | 1.373 | 35509.8 |
567 | 2024-03-08 17:33:27 | sampan | 3 | 112716 | 518 | 10.563 | 10670.8 |
566 | 2024-03-08 17:33:27 | sampan | 2 | 82551 | 36 | 5.893 | 14008.3 |
565 | 2024-03-08 17:33:20 | sampan | 1 | 48755 | 3 | 0.986 | 49447.3 |
564 | 2024-02-26 14:23:24 | sampan | 1 | 48755 | 3 | 0.890 | 54780.9 |
563 | 2024-02-07 04:27:53 | sampan | 1 | 48755 | 3 | 0.893 | 54596.9 |
562 | 2024-01-31 11:00:32 | sampan | 2 | 82551 | 36 | 2.796 | 29524.7 |
561 | 2024-01-31 10:59:48 | sampan | 3 | 112716 | 518 | 5.830 | 19333.8 |
560 | 2024-01-31 09:54:51 | sampan | 2 | 82551 | 36 | 2.750 | 30018.5 |
559 | 2024-01-31 03:56:42 | sampan | 2 | 82551 | 36 | 2.593 | 31836.1 |
558 | 2024-01-31 03:53:03 | sampan | 3 | 112716 | 518 | 8.406 | 13409.0 |
557 | 2024-01-30 20:42:19 | sampan | 3 | 112716 | 518 | 6.013 | 18745.4 |
556 | 2024-01-30 13:28:19 | sampan | 2 | 82551 | 36 | 2.736 | 30172.1 |
555 | 2024-01-30 13:27:59 | sampan | 3 | 112716 | 518 | 6.016 | 18736.0 |
554 | 2024-01-30 04:47:44 | sampan | 3 | 112716 | 518 | 5.796 | 19447.2 |
553 | 2024-01-27 10:35:37 | sampan | 1 | 48755 | 3 | 0.903 | 53992.2 |
552 | 2024-01-25 02:45:03 | sampan | 1 | 48755 | 3 | 0.796 | 61250.0 |
551 | 2024-01-13 15:01:09 | sampan | 3 | 112716 | 518 | 5.343 | 21096.0 |
550 | 2024-01-08 03:42:02 | sampan | 1 | 48755 | 3 | 0.856 | 56956.8 |
549 | 2023-12-17 23:19:07 | sampan | 3 | 112716 | 518 | 9.860 | 11431.6 |
548 | 2023-12-09 21:00:04 | sampan | 2 | 82551 | 36 | 2.813 | 29346.2 |
547 | 2023-12-07 18:36:09 | sampan | 1 | 48755 | 3 | 0.873 | 55847.7 |
546 | 2023-12-07 18:36:08 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
545 | 2023-12-03 19:41:34 | sampan | 3 | 112716 | 518 | 4.923 | 22895.8 |
544 | 2023-12-03 19:41:32 | sampan | 2 | 82551 | 36 | 2.266 | 36430.3 |
543 | 2023-11-22 04:04:16 | sampan | 1 | 48755 | 3 | 0.906 | 53813.5 |
542 | 2023-11-20 02:56:06 | sampan | 3 | 112716 | 518 | 6.110 | 18447.8 |
541 | 2023-11-16 00:54:12 | sampan | 2 | 82551 | 36 | 2.733 | 30205.3 |
540 | 2023-11-15 08:30:00 | sampan | 3 | 112716 | 518 | 5.346 | 21084.2 |
539 | 2023-11-11 03:32:10 | sampan | 1 | 48755 | 3 | 0.783 | 62266.9 |
538 | 2023-11-08 18:07:18 | sampan | 1 | 48755 | 3 | 0.780 | 62506.4 |
537 | 2023-11-08 16:14:05 | sampan | 3 | 112716 | 518 | 4.690 | 24033.3 |
536 | 2023-11-02 09:38:28 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
535 | 2023-10-27 23:59:55 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
534 | 2023-10-20 04:12:09 | sampan | 1 | 48755 | 3 | 0.876 | 55656.4 |
533 | 2023-10-18 01:08:00 | sampan | 1 | 48755 | 3 | 0.813 | 59969.2 |
532 | 2023-10-14 04:10:09 | sampan | 1 | 48755 | 3 | 0.906 | 53813.5 |
531 | 2023-10-04 05:49:58 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
530 | 2023-10-04 05:41:49 | sampan | 3 | 112716 | 518 | 6.546 | 17219.1 |
529 | 2023-10-01 17:29:24 | sampan | 3 | 112716 | 518 | 11.483 | 9815.9 |
528 | 2023-09-27 03:18:02 | sampan | 3 | 112716 | 518 | 5.343 | 21096.0 |
527 | 2023-09-25 21:45:21 | sampan | 3 | 112716 | 518 | 4.736 | 23799.8 |
526 | 2023-09-23 12:22:18 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
525 | 2023-09-12 05:44:25 | sampan | 1 | 48755 | 3 | 0.970 | 50262.9 |
524 | 2023-09-12 05:34:26 | sampan | 3 | 112716 | 518 | 13.640 | 8263.6 |
523 | 2023-09-09 02:53:56 | sampan | 1 | 48755 | 3 | 0.780 | 62506.4 |
522 | 2023-09-03 22:37:41 | sampan | 3 | 112716 | 518 | 5.656 | 19928.6 |
521 | 2023-08-19 16:51:54 | sampan | 3 | 112716 | 518 | 4.860 | 23192.6 |
520 | 2023-08-12 16:31:11 | sampan | 3 | 112716 | 518 | 5.266 | 21404.5 |
519 | 2023-07-28 13:27:03 | sampan | 3 | 112716 | 518 | 4.923 | 22895.8 |
518 | 2023-07-10 04:42:08 | sampan | 1 | 48755 | 3 | 0.860 | 56691.9 |
517 | 2023-07-04 23:11:29 | sampan | 3 | 112716 | 518 | 5.593 | 20153.0 |
516 | 2023-07-02 22:48:36 | sampan | 3 | 112716 | 518 | 5.140 | 21929.2 |
515 | 2023-07-01 21:32:52 | sampan | 3 | 112716 | 518 | 5.453 | 20670.5 |
514 | 2023-06-30 23:01:47 | sampan | 3 | 112716 | 518 | 4.843 | 23274.0 |
513 | 2023-06-27 23:07:28 | sampan | 3 | 112716 | 518 | 9.830 | 11466.5 |
512 | 2023-06-24 22:36:05 | sampan | 3 | 112716 | 518 | 4.763 | 23664.9 |
511 | 2023-06-22 22:16:43 | sampan | 3 | 112716 | 518 | 5.140 | 21929.2 |
510 | 2023-06-21 22:27:49 | sampan | 3 | 112716 | 518 | 4.830 | 23336.6 |
509 | 2023-06-20 23:32:32 | sampan | 3 | 112716 | 518 | 6.420 | 17557.0 |
508 | 2023-06-19 23:27:28 | sampan | 3 | 112716 | 518 | 4.813 | 23419.1 |
507 | 2023-06-18 22:34:02 | sampan | 3 | 112716 | 518 | 4.906 | 22975.1 |
506 | 2023-06-17 04:15:38 | sampan | 1 | 48755 | 3 | 0.780 | 62506.4 |
505 | 2023-06-16 23:16:16 | sampan | 3 | 112716 | 518 | 5.516 | 20434.4 |
504 | 2023-06-09 22:56:19 | sampan | 3 | 112716 | 518 | 4.766 | 23650.0 |
503 | 2023-04-24 14:10:23 | sampan | 3 | 112716 | 518 | 4.733 | 23814.9 |
502 | 2023-03-31 16:26:13 | sampan | 1 | 48755 | 3 | 0.840 | 58041.7 |
501 | 2023-03-22 13:43:59 | sampan | 3 | 112716 | 518 | 5.673 | 19868.9 |
500 | 2023-03-19 12:42:46 | sampan | 1 | 48755 | 3 | 1.546 | 31536.2 |
499 | 2023-01-29 04:45:25 | sampan | 3 | 112716 | 518 | 4.686 | 24053.8 |
498 | 2023-01-15 17:12:24 | sampan | 1 | 48755 | 3 | 0.750 | 65006.7 |
497 | 2023-01-11 11:47:32 | sampan | 3 | 112716 | 518 | 4.783 | 23566.0 |
496 | 2022-12-06 21:00:28 | sampan | 3 | 112716 | 518 | 5.703 | 19764.3 |
495 | 2022-12-06 07:41:05 | sampan | 3 | 112716 | 518 | 7.296 | 15449.0 |
494 | 2022-12-05 18:57:44 | sampan | 3 | 112716 | 518 | 4.796 | 23502.1 |
493 | 2022-11-24 20:24:44 | sampan | 1 | 48755 | 3 | 0.780 | 62506.4 |
492 | 2022-11-12 16:55:25 | sampan | 1 | 48755 | 3 | 0.843 | 57835.1 |