History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gamps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
940 | 2024-04-18 15:20:16 | gamps | 1 | 28756 | 19 | 1.703 | 16885.5 |
939 | 2024-04-17 11:20:47 | gamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
938 | 2024-04-09 17:55:12 | gamps | 2 | 53800 | 215 | 1.923 | 27977.1 |
937 | 2024-04-03 04:13:50 | gamps | 1 | 28756 | 19 | 1.140 | 25224.6 |
936 | 2024-03-30 22:14:39 | gamps | 2 | 53800 | 215 | 1.720 | 31279.1 |
935 | 2024-03-30 22:14:34 | gamps | 1 | 28756 | 19 | 1.076 | 26724.9 |
934 | 2024-03-30 22:14:27 | gamps | 2 | 53800 | 215 | 3.673 | 14647.4 |
933 | 2024-03-30 22:14:24 | gamps | 1 | 28756 | 19 | 1.126 | 25538.2 |
932 | 2024-03-27 02:41:24 | gamps | 1 | 28756 | 19 | 1.156 | 24875.4 |
931 | 2024-03-23 09:51:30 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
930 | 2024-03-03 22:52:41 | gamps | 1 | 28756 | 19 | 1.110 | 25906.3 |
929 | 2024-03-01 10:43:02 | gamps | 1 | 28756 | 19 | 1.200 | 23963.3 |
928 | 2024-02-29 04:56:43 | gamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
927 | 2024-02-25 22:50:51 | gamps | 2 | 53800 | 215 | 1.843 | 29191.5 |
926 | 2024-02-25 17:34:00 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
925 | 2024-02-11 01:15:05 | gamps | 1 | 28756 | 19 | 0.576 | 49923.6 |
924 | 2024-01-24 19:49:39 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
923 | 2024-01-22 04:50:01 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
922 | 2023-12-22 12:45:10 | gamps | 2 | 53800 | 215 | 1.656 | 32487.9 |
921 | 2023-12-21 13:23:22 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
920 | 2023-12-11 16:14:48 | gamps | 2 | 53800 | 215 | 1.470 | 36598.6 |
919 | 2023-11-30 16:33:25 | gamps | 2 | 53800 | 215 | 1.720 | 31279.1 |
918 | 2023-11-28 13:07:33 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
917 | 2023-11-20 21:48:53 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
916 | 2023-11-18 23:04:38 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
915 | 2023-11-12 08:33:53 | gamps | 1 | 28756 | 19 | 0.466 | 61708.2 |
914 | 2023-10-28 06:36:35 | gamps | 2 | 53800 | 215 | 1.656 | 32487.9 |
913 | 2023-10-25 20:59:10 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
912 | 2023-10-22 05:02:33 | gamps | 1 | 28756 | 19 | 0.580 | 49579.3 |
911 | 2023-10-19 00:03:28 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
910 | 2023-10-17 14:37:21 | gamps | 2 | 53800 | 215 | 1.720 | 31279.1 |
909 | 2023-10-16 04:30:59 | gamps | 2 | 53800 | 215 | 1.563 | 34421.0 |
908 | 2023-10-11 02:23:55 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
907 | 2023-10-10 23:45:08 | gamps | 1 | 28756 | 19 | 0.530 | 54256.6 |
906 | 2023-10-05 02:32:31 | gamps | 1 | 28756 | 19 | 0.513 | 56054.6 |
905 | 2023-09-27 18:49:05 | gamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
904 | 2023-09-13 12:43:24 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
903 | 2023-09-12 09:24:42 | gamps | 2 | 53800 | 215 | 1.500 | 35866.7 |
902 | 2023-09-09 23:35:22 | gamps | 2 | 53800 | 215 | 1.376 | 39098.8 |
901 | 2023-09-07 09:17:05 | gamps | 1 | 28756 | 19 | 0.450 | 63902.2 |
900 | 2023-08-12 04:39:43 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
899 | 2023-08-10 00:37:37 | gamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
898 | 2023-08-09 01:28:46 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
897 | 2023-08-04 15:23:20 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
896 | 2023-07-05 03:16:10 | gamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
895 | 2023-07-02 16:12:33 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
894 | 2023-06-17 00:21:56 | gamps | 1 | 28756 | 19 | 0.513 | 56054.6 |
893 | 2023-06-11 16:22:35 | gamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
892 | 2023-06-02 14:02:49 | gamps | 2 | 53800 | 215 | 1.343 | 40059.6 |
891 | 2023-05-11 01:09:24 | gamps | 1 | 28756 | 19 | 0.533 | 53951.2 |
890 | 2023-05-10 07:26:35 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
889 | 2023-05-09 08:06:52 | gamps | 2 | 53800 | 215 | 1.373 | 39184.3 |
888 | 2023-04-28 18:41:55 | gamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
887 | 2023-04-02 16:45:54 | gamps | 2 | 53800 | 215 | 1.343 | 40059.6 |
886 | 2023-04-01 08:05:03 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
885 | 2023-03-31 13:54:01 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
884 | 2023-03-31 06:18:12 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
883 | 2023-03-21 06:03:59 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
882 | 2023-03-20 12:15:47 | gamps | 1 | 28756 | 19 | 0.466 | 61708.2 |
881 | 2023-03-10 08:29:38 | gamps | 2 | 53800 | 215 | 1.623 | 33148.5 |
880 | 2023-03-10 07:40:47 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
879 | 2023-03-07 00:34:24 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
878 | 2023-02-20 15:13:17 | gamps | 2 | 53800 | 215 | 1.423 | 37807.4 |
877 | 2023-01-25 16:48:06 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
876 | 2023-01-25 01:51:16 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
875 | 2023-01-14 13:39:48 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
874 | 2023-01-13 16:15:28 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
873 | 2023-01-01 21:30:44 | gamps | 2 | 53800 | 215 | 1.610 | 33416.1 |
872 | 2022-12-31 16:05:21 | gamps | 2 | 53800 | 215 | 1.343 | 40059.6 |
871 | 2022-12-27 20:04:25 | gamps | 2 | 53800 | 215 | 1.530 | 35163.4 |
870 | 2022-12-27 04:29:27 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
869 | 2022-12-22 02:13:27 | gamps | 2 | 53800 | 215 | 1.360 | 39558.8 |
868 | 2022-12-15 14:57:45 | gamps | 2 | 53800 | 215 | 1.390 | 38705.0 |
867 | 2022-12-11 12:20:44 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
866 | 2022-11-30 13:21:21 | gamps | 1 | 28756 | 19 | 0.486 | 59168.7 |
865 | 2022-11-24 20:19:16 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
864 | 2022-11-17 19:52:10 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
863 | 2022-11-16 04:01:39 | gamps | 2 | 53800 | 215 | 1.373 | 39184.3 |
862 | 2022-11-15 23:00:16 | gamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
861 | 2022-11-11 06:04:10 | gamps | 2 | 53800 | 215 | 1.733 | 31044.4 |
860 | 2022-11-05 03:03:10 | gamps | 2 | 53800 | 215 | 1.376 | 39098.8 |
859 | 2022-10-31 11:51:07 | gamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
858 | 2022-10-25 03:31:01 | gamps | 2 | 53800 | 215 | 1.546 | 34799.5 |
857 | 2022-10-24 14:17:47 | gamps | 1 | 28756 | 19 | 0.546 | 52666.7 |
856 | 2022-10-14 08:22:51 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
855 | 2022-10-13 05:01:02 | gamps | 2 | 53800 | 215 | 1.656 | 32487.9 |
854 | 2022-10-02 09:59:11 | gamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
853 | 2022-10-01 02:02:05 | gamps | 2 | 53800 | 215 | 1.390 | 38705.0 |
852 | 2022-09-18 13:40:30 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
851 | 2022-09-12 20:10:06 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
850 | 2022-09-11 00:09:43 | gamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
849 | 2022-09-06 10:04:51 | gamps | 2 | 53800 | 215 | 1.483 | 36277.8 |
848 | 2022-09-01 10:59:40 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
847 | 2022-08-31 19:50:51 | gamps | 2 | 53800 | 215 | 1.360 | 39558.8 |
846 | 2022-08-28 15:20:42 | gamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
845 | 2022-08-19 10:10:48 | gamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
844 | 2022-08-07 01:47:42 | gamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
843 | 2022-08-06 15:43:01 | gamps | 2 | 53800 | 215 | 1.466 | 36698.5 |
842 | 2022-07-23 14:59:05 | gamps | 1 | 28756 | 19 | 0.486 | 59168.7 |
841 | 2022-07-12 12:09:00 | gamps | 1 | 28756 | 19 | 0.500 | 57512.0 |