History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"comps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1031 | 2025-02-04 20:46:02 | comps | 1 | 28756 | 19 | 0.953 | 30174.2 |
1030 | 2025-01-26 18:17:13 | comps | 2 | 53800 | 245 | 8.216 | 6548.2 |
1029 | 2025-01-26 12:22:22 | comps | 2 | 53800 | 245 | 8.030 | 6699.9 |
1028 | 2025-01-26 11:34:55 | comps | 1 | 28756 | 19 | 0.500 | 57512.0 |
1027 | 2025-01-26 00:30:35 | comps | 1 | 28756 | 19 | 0.513 | 56054.6 |
1026 | 2025-01-25 00:44:39 | comps | 2 | 53800 | 245 | 1.436 | 37465.2 |
1025 | 2025-01-23 19:19:36 | comps | 1 | 28756 | 19 | 2.983 | 9640.0 |
1024 | 2025-01-22 02:18:36 | comps | 1 | 28756 | 19 | 2.220 | 12953.2 |
1023 | 2025-01-06 12:17:12 | comps | 1 | 28756 | 19 | 1.906 | 15087.1 |
1022 | 2024-12-28 20:47:31 | comps | 2 | 53800 | 245 | 2.406 | 22360.8 |
1021 | 2024-12-28 04:49:50 | comps | 2 | 53800 | 245 | 7.986 | 6736.8 |
1020 | 2024-12-27 12:06:16 | comps | 2 | 53800 | 245 | 7.890 | 6818.8 |
1019 | 2024-12-27 09:50:53 | comps | 2 | 53800 | 245 | 11.453 | 4697.5 |
1018 | 2024-12-27 09:26:35 | comps | 1 | 28756 | 19 | 0.483 | 59536.2 |
1017 | 2024-12-26 20:01:15 | comps | 1 | 28756 | 19 | 0.546 | 52666.7 |
1016 | 2024-12-24 17:13:09 | comps | 1 | 28756 | 19 | 1.406 | 20452.3 |
1015 | 2024-11-27 09:00:05 | comps | 2 | 53800 | 245 | 7.530 | 7144.8 |
1014 | 2024-11-27 06:28:52 | comps | 2 | 53800 | 245 | 6.513 | 8260.4 |
1013 | 2024-11-27 03:54:23 | comps | 2 | 53800 | 245 | 3.810 | 14120.7 |
1012 | 2024-11-27 03:32:07 | comps | 1 | 28756 | 19 | 2.266 | 12690.2 |
1011 | 2024-11-26 19:15:29 | comps | 1 | 28756 | 19 | 0.546 | 52666.7 |
1010 | 2024-11-24 17:03:42 | comps | 1 | 28756 | 19 | 2.703 | 10638.5 |
1009 | 2024-11-07 02:44:32 | comps | 1 | 28756 | 19 | 0.983 | 29253.3 |
1008 | 2024-10-29 22:10:11 | comps | 2 | 53800 | 245 | 3.736 | 14400.4 |
1007 | 2024-10-28 05:34:54 | comps | 2 | 53800 | 245 | 7.576 | 7101.4 |
1006 | 2024-10-28 03:18:41 | comps | 2 | 53800 | 245 | 8.016 | 6711.6 |
1005 | 2024-10-28 02:25:05 | comps | 1 | 28756 | 19 | 0.516 | 55728.7 |
1004 | 2024-10-27 18:04:07 | comps | 1 | 28756 | 19 | 2.470 | 11642.1 |
1003 | 2024-10-25 15:49:44 | comps | 1 | 28756 | 19 | 1.186 | 24246.2 |
1002 | 2024-10-10 14:00:09 | comps | 1 | 28756 | 19 | 2.376 | 12102.7 |
1001 | 2024-10-10 05:20:28 | comps | 1 | 28756 | 19 | 0.983 | 29253.3 |
1000 | 2024-09-28 13:42:56 | comps | 2 | 53800 | 245 | 6.970 | 7718.8 |
999 | 2024-09-27 22:15:41 | comps | 2 | 53800 | 245 | 18.486 | 2910.3 |
998 | 2024-09-27 20:56:01 | comps | 2 | 53800 | 245 | 13.500 | 3985.2 |
997 | 2024-09-27 20:55:52 | comps | 1 | 28756 | 19 | 2.876 | 9998.6 |
996 | 2024-09-27 16:35:18 | comps | 1 | 28756 | 19 | 3.500 | 8216.0 |
995 | 2024-09-07 12:52:39 | comps | 1 | 28756 | 19 | 3.920 | 7335.7 |
994 | 2024-08-30 11:32:18 | comps | 1 | 28756 | 19 | 2.593 | 11089.9 |
993 | 2024-08-28 18:22:01 | comps | 1 | 28756 | 19 | 5.860 | 4907.2 |
992 | 2024-08-28 08:06:36 | comps | 1 | 28756 | 19 | 2.126 | 13525.9 |
991 | 2024-08-17 03:59:58 | comps | 1 | 28756 | 19 | 4.003 | 7183.6 |
990 | 2024-08-17 03:59:24 | comps | 1 | 28756 | 19 | 1.453 | 19790.8 |
989 | 2024-08-15 06:44:16 | comps | 1 | 28756 | 19 | 1.796 | 16011.1 |
988 | 2024-08-12 23:19:41 | comps | 1 | 28756 | 19 | 3.640 | 7900.0 |
987 | 2024-08-09 13:24:18 | comps | 1 | 28756 | 19 | 0.876 | 32826.5 |
986 | 2024-08-08 02:30:01 | comps | 1 | 28756 | 19 | 1.046 | 27491.4 |
985 | 2024-08-03 19:54:34 | comps | 2 | 53800 | 245 | 6.720 | 8006.0 |
984 | 2024-08-03 09:34:27 | comps | 2 | 53800 | 245 | 5.716 | 9412.2 |
983 | 2024-07-29 16:13:36 | comps | 1 | 28756 | 19 | 1.233 | 23322.0 |
982 | 2024-07-29 04:07:02 | comps | 1 | 28756 | 19 | 2.600 | 11060.0 |
981 | 2024-07-28 23:02:38 | comps | 2 | 53800 | 245 | 9.390 | 5729.5 |
980 | 2024-07-28 21:01:42 | comps | 2 | 53800 | 245 | 4.673 | 11512.9 |
979 | 2024-07-28 18:32:06 | comps | 2 | 53800 | 245 | 5.690 | 9455.2 |
978 | 2024-07-28 15:42:03 | comps | 2 | 53800 | 245 | 6.690 | 8041.9 |
977 | 2024-07-28 15:41:57 | comps | 1 | 28756 | 19 | 1.220 | 23570.5 |
976 | 2024-07-27 00:01:38 | comps | 1 | 28756 | 19 | 2.483 | 11581.2 |
975 | 2024-07-25 08:53:14 | comps | 1 | 28756 | 19 | 1.140 | 25224.6 |
974 | 2024-07-17 00:47:06 | comps | 1 | 28756 | 19 | 0.986 | 29164.3 |
973 | 2024-07-15 08:55:46 | comps | 1 | 28756 | 19 | 1.423 | 20208.0 |
972 | 2024-07-09 20:11:45 | comps | 1 | 28756 | 19 | 1.560 | 18433.3 |
971 | 2024-07-08 05:03:59 | comps | 1 | 28756 | 19 | 2.906 | 9895.4 |
970 | 2024-07-07 09:46:25 | comps | 1 | 28756 | 19 | 0.610 | 47141.0 |
969 | 2024-07-06 19:44:42 | comps | 1 | 28756 | 19 | 1.893 | 15190.7 |
968 | 2024-07-05 21:12:51 | comps | 1 | 28756 | 19 | 0.593 | 48492.4 |
967 | 2024-06-29 14:08:04 | comps | 1 | 28756 | 19 | 2.123 | 13545.0 |
966 | 2024-06-28 22:31:47 | comps | 1 | 28756 | 19 | 2.893 | 9939.9 |
965 | 2024-06-28 12:07:54 | comps | 1 | 28756 | 19 | 1.076 | 26724.9 |
964 | 2024-06-23 01:41:28 | comps | 1 | 28756 | 19 | 1.233 | 23322.0 |
963 | 2024-06-14 18:24:15 | comps | 2 | 53800 | 245 | 3.470 | 15504.3 |
962 | 2024-06-11 19:47:10 | comps | 1 | 28756 | 19 | 2.266 | 12690.2 |
961 | 2024-06-07 12:36:01 | comps | 1 | 28756 | 19 | 0.876 | 32826.5 |
960 | 2024-06-05 14:59:48 | comps | 1 | 28756 | 19 | 0.513 | 56054.6 |
959 | 2024-06-04 21:16:30 | comps | 1 | 28756 | 19 | 0.596 | 48248.3 |
958 | 2024-06-01 07:55:01 | comps | 1 | 28756 | 19 | 1.626 | 17685.1 |
957 | 2024-06-01 07:54:12 | comps | 2 | 53800 | 245 | 5.360 | 10037.3 |
956 | 2024-05-30 12:45:40 | comps | 1 | 28756 | 19 | 2.593 | 11089.9 |
955 | 2024-05-29 15:15:57 | comps | 1 | 28756 | 19 | 1.513 | 19005.9 |
954 | 2024-05-08 17:23:00 | comps | 1 | 28756 | 19 | 1.093 | 26309.2 |
953 | 2024-05-02 00:00:59 | comps | 1 | 28756 | 19 | 1.173 | 24514.9 |
952 | 2024-05-01 23:05:54 | comps | 2 | 53800 | 245 | 1.830 | 29398.9 |
951 | 2024-05-01 23:05:50 | comps | 1 | 28756 | 19 | 0.530 | 54256.6 |
950 | 2024-05-01 23:05:48 | comps | 1 | 28756 | 19 | 0.530 | 54256.6 |
949 | 2024-05-01 23:05:44 | comps | 2 | 53800 | 245 | 1.736 | 30990.8 |
948 | 2024-05-01 14:43:08 | comps | 1 | 28756 | 19 | 1.920 | 14977.1 |
947 | 2024-04-25 12:28:43 | comps | 1 | 28756 | 19 | 1.940 | 14822.7 |
946 | 2024-04-08 16:32:34 | comps | 1 | 28756 | 19 | 0.610 | 47141.0 |
945 | 2024-04-04 23:38:43 | comps | 1 | 28756 | 19 | 0.546 | 52666.7 |
944 | 2024-04-03 04:08:29 | comps | 1 | 28756 | 19 | 0.563 | 51076.4 |
943 | 2024-04-01 17:38:30 | comps | 1 | 28756 | 19 | 1.423 | 20208.0 |
942 | 2024-03-31 02:52:07 | comps | 1 | 28756 | 19 | 0.530 | 54256.6 |
941 | 2024-03-26 22:37:22 | comps | 1 | 28756 | 19 | 0.640 | 44931.3 |
940 | 2024-03-09 04:17:45 | comps | 1 | 28756 | 19 | 0.563 | 51076.4 |
939 | 2024-03-09 04:15:58 | comps | 2 | 53800 | 245 | 1.673 | 32157.8 |
938 | 2024-03-09 04:14:22 | comps | 1 | 28756 | 19 | 0.516 | 55728.7 |
937 | 2024-03-02 14:22:13 | comps | 1 | 28756 | 19 | 0.640 | 44931.3 |
936 | 2024-03-01 00:56:16 | comps | 1 | 28756 | 19 | 1.126 | 25538.2 |
935 | 2024-02-25 22:50:02 | comps | 2 | 53800 | 245 | 1.826 | 29463.3 |
934 | 2024-02-25 17:56:00 | comps | 1 | 28756 | 19 | 1.720 | 16718.6 |
933 | 2024-02-08 03:45:53 | comps | 1 | 28756 | 19 | 0.546 | 52666.7 |
932 | 2024-01-28 19:59:51 | comps | 1 | 28756 | 19 | 1.030 | 27918.4 |