History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gains"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1234 | 2024-04-20 04:48:57 | gains | 1 | 28756 | 17 | 2.296 | 12524.4 |
1233 | 2024-04-18 17:52:46 | gains | 2 | 53800 | 301 | 5.016 | 10725.7 |
1232 | 2024-04-07 10:55:23 | gains | 1 | 28756 | 17 | 1.360 | 21144.1 |
1231 | 2024-04-07 02:24:49 | gains | 1 | 28756 | 17 | 0.780 | 36866.7 |
1230 | 2024-04-03 03:28:21 | gains | 1 | 28756 | 17 | 1.126 | 25538.2 |
1229 | 2024-03-31 02:53:27 | gains | 1 | 28756 | 17 | 0.546 | 52666.7 |
1228 | 2024-03-27 02:49:50 | gains | 1 | 28756 | 17 | 1.690 | 17015.4 |
1227 | 2024-03-25 17:57:27 | gains | 1 | 28756 | 17 | 1.110 | 25906.3 |
1226 | 2024-03-19 09:06:29 | gains | 1 | 28756 | 17 | 1.140 | 25224.6 |
1225 | 2024-03-08 06:51:19 | gains | 1 | 28756 | 17 | 1.783 | 16127.9 |
1224 | 2024-03-08 06:50:46 | gains | 2 | 53800 | 301 | 1.953 | 27547.4 |
1223 | 2024-03-08 06:50:13 | gains | 1 | 28756 | 17 | 0.766 | 37540.5 |
1222 | 2024-03-04 14:53:32 | gains | 2 | 53800 | 301 | 5.670 | 9488.5 |
1221 | 2024-03-03 23:39:17 | gains | 2 | 53800 | 301 | 1.906 | 28226.7 |
1220 | 2024-03-03 22:10:05 | gains | 1 | 28756 | 17 | 0.953 | 30174.2 |
1219 | 2024-03-01 10:43:08 | gains | 1 | 28756 | 17 | 2.076 | 13851.6 |
1218 | 2024-02-27 05:42:29 | gains | 1 | 28756 | 17 | 1.000 | 28756.0 |
1217 | 2024-02-25 17:24:45 | gains | 1 | 28756 | 17 | 0.596 | 48248.3 |
1216 | 2024-02-21 03:01:02 | gains | 1 | 28756 | 17 | 0.533 | 53951.2 |
1215 | 2024-02-06 22:08:25 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1214 | 2024-02-06 09:45:18 | gains | 2 | 53800 | 301 | 1.626 | 33087.3 |
1213 | 2024-02-02 21:44:15 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1212 | 2024-01-15 22:15:28 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1211 | 2024-01-07 19:35:47 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1210 | 2024-01-06 23:22:53 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1209 | 2023-12-29 10:30:02 | gains | 2 | 53800 | 301 | 1.860 | 28924.7 |
1208 | 2023-12-23 10:49:29 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1207 | 2023-12-21 09:35:43 | gains | 2 | 53800 | 301 | 1.390 | 38705.0 |
1206 | 2023-12-16 06:10:18 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1205 | 2023-12-15 21:04:38 | gains | 2 | 53800 | 301 | 1.826 | 29463.3 |
1204 | 2023-12-12 04:16:32 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1203 | 2023-12-10 18:44:37 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1202 | 2023-12-05 14:10:42 | gains | 2 | 53800 | 301 | 1.610 | 33416.1 |
1201 | 2023-11-16 05:38:29 | gains | 1 | 28756 | 17 | 0.470 | 61183.0 |
1200 | 2023-11-15 11:35:26 | gains | 1 | 28756 | 17 | 0.450 | 63902.2 |
1199 | 2023-11-13 09:08:07 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1198 | 2023-11-13 05:17:18 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1197 | 2023-11-12 09:31:15 | gains | 1 | 28756 | 17 | 0.440 | 65354.5 |
1196 | 2023-11-12 04:41:29 | gains | 2 | 53800 | 301 | 1.453 | 37026.8 |
1195 | 2023-10-26 17:12:44 | gains | 1 | 28756 | 17 | 0.546 | 52666.7 |
1194 | 2023-10-19 21:59:43 | gains | 1 | 28756 | 17 | 0.470 | 61183.0 |
1193 | 2023-10-19 00:03:22 | gains | 1 | 28756 | 17 | 0.466 | 61708.2 |
1192 | 2023-10-12 02:14:04 | gains | 1 | 28756 | 17 | 0.513 | 56054.6 |
1191 | 2023-10-04 23:27:59 | gains | 1 | 28756 | 17 | 0.533 | 53951.2 |
1190 | 2023-10-03 22:31:09 | gains | 2 | 53800 | 301 | 1.560 | 34487.2 |
1189 | 2023-10-02 09:24:17 | gains | 2 | 53800 | 301 | 1.420 | 37887.3 |
1188 | 2023-09-27 14:33:36 | gains | 2 | 53800 | 301 | 1.656 | 32487.9 |
1187 | 2023-09-22 23:55:38 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1186 | 2023-09-15 07:07:32 | gains | 2 | 53800 | 301 | 1.673 | 32157.8 |
1185 | 2023-09-11 01:02:02 | gains | 1 | 28756 | 17 | 1.033 | 27837.4 |
1184 | 2023-08-31 16:37:37 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1183 | 2023-08-31 16:18:46 | gains | 1 | 28756 | 17 | 0.483 | 59536.2 |
1182 | 2023-07-13 05:25:24 | gains | 2 | 53800 | 301 | 1.673 | 32157.8 |
1181 | 2023-07-11 21:22:30 | gains | 1 | 28756 | 17 | 0.500 | 57512.0 |
1180 | 2023-07-04 21:25:48 | gains | 2 | 53800 | 301 | 1.640 | 32804.9 |
1179 | 2023-07-02 21:01:55 | gains | 2 | 53800 | 301 | 1.440 | 37361.1 |
1178 | 2023-07-01 19:46:22 | gains | 2 | 53800 | 301 | 3.593 | 14973.6 |
1177 | 2023-06-30 21:16:03 | gains | 2 | 53800 | 301 | 1.643 | 32745.0 |
1176 | 2023-06-27 21:21:51 | gains | 2 | 53800 | 301 | 1.640 | 32804.9 |
1175 | 2023-06-24 20:50:10 | gains | 2 | 53800 | 301 | 1.593 | 33772.8 |
1174 | 2023-06-22 20:44:41 | gains | 2 | 53800 | 301 | 1.580 | 34050.6 |
1173 | 2023-06-21 20:41:31 | gains | 2 | 53800 | 301 | 1.393 | 38621.7 |
1172 | 2023-06-20 21:35:39 | gains | 2 | 53800 | 301 | 1.390 | 38705.0 |
1171 | 2023-06-19 21:25:54 | gains | 2 | 53800 | 301 | 1.406 | 38264.6 |
1170 | 2023-06-18 20:46:52 | gains | 2 | 53800 | 301 | 1.593 | 33772.8 |
1169 | 2023-06-18 13:29:25 | gains | 2 | 53800 | 301 | 1.500 | 35866.7 |
1168 | 2023-06-16 21:30:42 | gains | 2 | 53800 | 301 | 2.813 | 19125.5 |
1167 | 2023-06-15 19:29:00 | gains | 2 | 53800 | 301 | 1.656 | 32487.9 |
1166 | 2023-06-14 22:36:11 | gains | 2 | 53800 | 301 | 1.686 | 31909.8 |
1165 | 2023-06-13 18:33:38 | gains | 2 | 53800 | 301 | 1.563 | 34421.0 |
1164 | 2023-06-11 22:43:44 | gains | 2 | 53800 | 301 | 1.656 | 32487.9 |
1163 | 2023-06-06 02:02:34 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1162 | 2023-05-31 10:35:39 | gains | 1 | 28756 | 17 | 0.420 | 68466.7 |
1161 | 2023-03-31 23:38:16 | gains | 2 | 53800 | 301 | 1.406 | 38264.6 |
1160 | 2023-03-31 14:53:50 | gains | 1 | 28756 | 17 | 0.483 | 59536.2 |
1159 | 2023-03-27 23:16:57 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1158 | 2023-03-10 07:07:07 | gains | 1 | 28756 | 17 | 0.440 | 65354.5 |
1157 | 2023-02-25 13:47:34 | gains | 1 | 28756 | 17 | 0.486 | 59168.7 |
1156 | 2023-02-17 06:47:10 | gains | 2 | 53800 | 301 | 1.546 | 34799.5 |
1155 | 2023-01-21 04:41:09 | gains | 2 | 53800 | 301 | 1.500 | 35866.7 |
1154 | 2023-01-11 09:24:34 | gains | 1 | 28756 | 17 | 0.876 | 32826.5 |
1153 | 2023-01-04 20:59:18 | gains | 2 | 53800 | 301 | 1.360 | 39558.8 |
1152 | 2022-12-28 02:09:08 | gains | 2 | 53800 | 301 | 2.093 | 25704.7 |
1151 | 2022-12-11 09:26:07 | gains | 2 | 53800 | 301 | 1.453 | 37026.8 |
1150 | 2022-11-26 08:02:37 | gains | 1 | 28756 | 17 | 0.466 | 61708.2 |
1149 | 2022-11-22 23:20:09 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1148 | 2022-11-09 17:43:38 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1147 | 2022-11-07 14:39:02 | gains | 1 | 28756 | 17 | 0.486 | 59168.7 |
1146 | 2022-10-30 01:26:22 | gains | 1 | 28756 | 17 | 0.483 | 59536.2 |
1145 | 2022-10-20 07:45:15 | gains | 1 | 28756 | 17 | 0.440 | 65354.5 |
1144 | 2022-09-12 03:59:11 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1143 | 2022-08-29 19:22:26 | gains | 2 | 53800 | 301 | 1.596 | 33709.3 |
1142 | 2022-08-22 14:20:46 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1141 | 2022-08-17 14:06:01 | gains | 1 | 28756 | 17 | 0.440 | 65354.5 |
1140 | 2022-08-14 23:41:05 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1139 | 2022-08-06 21:21:00 | gains | 1 | 28756 | 17 | 0.453 | 63479.0 |
1138 | 2022-07-29 07:50:34 | gains | 1 | 28756 | 17 | 0.423 | 67981.1 |
1137 | 2022-07-11 07:03:22 | gains | 2 | 53800 | 301 | 1.406 | 38264.6 |
1136 | 2022-07-03 08:18:28 | gains | 1 | 28756 | 17 | 0.436 | 65954.1 |
1135 | 2022-06-25 19:44:44 | gains | 1 | 28756 | 17 | 0.440 | 65354.5 |