History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gems"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1123 | 2024-04-18 12:00:21 | gems | 2 | 29872 | 348 | 2.216 | 13480.1 |
1122 | 2024-04-18 08:55:21 | gems | 1 | 13983 | 17 | 0.953 | 14672.6 |
1121 | 2024-04-18 08:54:38 | gems | 2 | 29872 | 348 | 0.970 | 30795.9 |
1120 | 2024-04-18 05:14:50 | gems | 2 | 29872 | 348 | 3.346 | 8927.7 |
1119 | 2024-04-18 05:11:10 | gems | 2 | 29872 | 348 | 0.953 | 31345.2 |
1118 | 2024-04-10 10:17:36 | gems | 1 | 13983 | 17 | 0.856 | 16335.3 |
1117 | 2024-04-05 01:06:12 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1116 | 2024-03-31 00:33:44 | gems | 1 | 13983 | 17 | 0.266 | 52567.7 |
1115 | 2024-03-29 03:59:17 | gems | 1 | 13983 | 17 | 0.546 | 25609.9 |
1114 | 2024-03-12 18:01:35 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1113 | 2024-03-05 19:31:12 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1112 | 2024-03-05 00:47:07 | gems | 1 | 13983 | 17 | 0.513 | 27257.3 |
1111 | 2024-03-01 10:42:17 | gems | 1 | 13983 | 17 | 0.800 | 17478.8 |
1110 | 2024-02-29 17:28:55 | gems | 1 | 13983 | 17 | 0.266 | 52567.7 |
1109 | 2024-02-25 22:04:33 | gems | 2 | 29872 | 348 | 1.406 | 21246.1 |
1108 | 2024-02-17 13:46:57 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1107 | 2024-02-03 00:07:29 | gems | 1 | 13983 | 17 | 0.266 | 52567.7 |
1106 | 2024-01-12 18:08:28 | gems | 2 | 29872 | 348 | 0.766 | 38997.4 |
1105 | 2023-12-25 17:57:54 | gems | 1 | 13983 | 17 | 0.263 | 53167.3 |
1104 | 2023-12-14 06:51:06 | gems | 2 | 29872 | 348 | 0.750 | 39829.3 |
1103 | 2023-12-02 20:44:49 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1102 | 2023-11-20 18:51:53 | gems | 2 | 29872 | 348 | 0.766 | 38997.4 |
1101 | 2023-11-19 11:19:46 | gems | 1 | 13983 | 17 | 0.296 | 47239.9 |
1100 | 2023-11-18 19:43:21 | gems | 2 | 29872 | 348 | 0.906 | 32971.3 |
1099 | 2023-11-17 14:09:31 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1098 | 2023-11-09 01:13:12 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1097 | 2023-10-29 01:54:49 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1096 | 2023-10-27 00:54:11 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1095 | 2023-10-20 09:51:09 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1094 | 2023-10-17 08:48:36 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1093 | 2023-10-16 00:33:28 | gems | 1 | 13983 | 17 | 0.266 | 52567.7 |
1092 | 2023-10-04 00:14:44 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1091 | 2023-09-28 18:31:38 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1090 | 2023-09-26 16:20:54 | gems | 1 | 13983 | 17 | 0.423 | 33056.7 |
1089 | 2023-09-16 20:06:06 | gems | 1 | 13983 | 17 | 0.470 | 29751.1 |
1088 | 2023-09-14 15:54:42 | gems | 2 | 29872 | 348 | 0.936 | 31914.5 |
1087 | 2023-07-16 17:10:28 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1086 | 2023-07-05 05:00:37 | gems | 1 | 13983 | 17 | 0.216 | 64736.1 |
1085 | 2023-06-23 06:00:39 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1084 | 2023-06-14 22:31:32 | gems | 2 | 29872 | 348 | 0.843 | 35435.3 |
1083 | 2023-04-10 20:40:55 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1082 | 2023-04-09 00:44:37 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1081 | 2023-03-13 03:29:11 | gems | 2 | 29872 | 348 | 0.876 | 34100.5 |
1080 | 2023-01-30 03:28:50 | gems | 1 | 13983 | 17 | 0.206 | 67878.6 |
1079 | 2022-12-27 08:47:29 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1078 | 2022-12-17 08:03:41 | gems | 2 | 29872 | 348 | 0.796 | 37527.6 |
1077 | 2022-11-29 16:49:24 | gems | 2 | 29872 | 348 | 0.830 | 35990.4 |
1076 | 2022-11-26 20:34:07 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1075 | 2022-11-25 19:16:26 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1074 | 2022-11-25 13:47:04 | gems | 2 | 29872 | 348 | 0.780 | 38297.4 |
1073 | 2022-10-24 23:55:29 | gems | 2 | 29872 | 348 | 0.733 | 40753.1 |
1072 | 2022-10-09 13:48:40 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1071 | 2022-10-06 03:50:07 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1070 | 2022-10-05 10:01:34 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1069 | 2022-10-04 19:55:32 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1068 | 2022-10-03 08:59:13 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1067 | 2022-10-02 03:06:08 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1066 | 2022-10-01 05:52:05 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1065 | 2022-09-30 14:54:26 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1064 | 2022-09-29 08:37:23 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1063 | 2022-09-28 05:42:28 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1062 | 2022-09-27 06:44:27 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1061 | 2022-09-26 14:01:23 | gems | 1 | 13983 | 17 | 0.280 | 49939.3 |
1060 | 2022-09-25 10:06:22 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1059 | 2022-09-24 06:03:38 | gems | 1 | 13983 | 17 | 0.200 | 69915.0 |
1058 | 2022-09-23 06:29:59 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1057 | 2022-09-22 06:09:56 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1056 | 2022-09-21 22:24:44 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1055 | 2022-09-20 06:38:11 | gems | 1 | 13983 | 17 | 0.313 | 44674.1 |
1054 | 2022-09-19 07:47:12 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1053 | 2022-09-18 23:35:55 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1052 | 2022-09-17 03:39:35 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1051 | 2022-09-16 14:36:18 | gems | 1 | 13983 | 17 | 0.216 | 64736.1 |
1050 | 2022-09-02 16:48:21 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1049 | 2022-08-16 00:12:27 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1048 | 2022-08-11 05:06:23 | gems | 2 | 29872 | 348 | 0.736 | 40587.0 |
1047 | 2022-07-21 18:23:34 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1046 | 2022-07-18 14:36:11 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1045 | 2022-07-18 00:46:33 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1044 | 2022-07-10 04:56:10 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1043 | 2022-06-25 09:59:35 | gems | 1 | 13983 | 17 | 0.216 | 64736.1 |
1042 | 2022-06-16 23:36:19 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1041 | 2022-06-01 19:28:46 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1040 | 2022-06-01 15:53:00 | gems | 1 | 13983 | 17 | 0.423 | 33056.7 |
1039 | 2022-05-31 04:31:41 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1038 | 2022-03-14 17:35:31 | gems | 1 | 13983 | 17 | 0.313 | 44674.1 |
1037 | 2022-03-14 05:42:24 | gems | 2 | 29872 | 348 | 0.750 | 39829.3 |
1036 | 2022-02-23 10:14:45 | gems | 1 | 13983 | 17 | 0.310 | 45106.5 |
1035 | 2022-02-19 23:19:31 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1034 | 2022-02-07 10:38:39 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1033 | 2022-02-06 09:32:01 | gems | 1 | 13983 | 17 | 0.203 | 68881.8 |
1032 | 2022-02-05 08:14:35 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1031 | 2022-02-04 08:25:17 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1030 | 2022-02-03 02:49:11 | gems | 1 | 13983 | 17 | 0.250 | 55932.0 |
1029 | 2022-02-02 08:13:14 | gems | 1 | 13983 | 17 | 0.283 | 49409.9 |
1028 | 2022-02-01 06:06:22 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1027 | 2022-01-31 04:03:15 | gems | 1 | 13983 | 17 | 0.233 | 60012.9 |
1026 | 2022-01-30 09:47:37 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |
1025 | 2022-01-29 09:00:50 | gems | 1 | 13983 | 17 | 0.236 | 59250.0 |
1024 | 2021-12-27 02:41:21 | gems | 1 | 13983 | 17 | 0.220 | 63559.1 |