History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"existing"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
267 | 2024-04-24 22:51:06 | existing | 2 | 121059 | 38 | 4.466 | 27106.8 |
266 | 2024-04-24 22:50:57 | existing | 1 | 82945 | 2 | 1.280 | 64800.8 |
265 | 2024-04-13 18:02:43 | existing | 2 | 121059 | 38 | 13.503 | 8965.3 |
264 | 2024-04-13 03:50:13 | existing | 3 | 146162 | 331 | 18.030 | 8106.6 |
263 | 2024-04-13 02:11:05 | existing | 3 | 146162 | 331 | 7.516 | 19446.8 |
262 | 2024-04-11 03:53:20 | existing | 2 | 121059 | 38 | 3.423 | 35366.3 |
261 | 2024-04-10 19:41:01 | existing | 3 | 146162 | 331 | 18.406 | 7941.0 |
260 | 2024-04-09 19:42:57 | existing | 2 | 121059 | 38 | 4.720 | 25648.1 |
259 | 2024-04-09 05:26:30 | existing | 3 | 146162 | 331 | 32.250 | 4532.2 |
258 | 2024-04-09 00:07:19 | existing | 1 | 82945 | 2 | 3.156 | 26281.7 |
257 | 2024-04-09 00:07:03 | existing | 3 | 146162 | 331 | 17.470 | 8366.5 |
256 | 2024-04-09 00:07:03 | existing | 2 | 121059 | 38 | 5.093 | 23769.7 |
255 | 2024-04-09 00:07:00 | existing | 1 | 82945 | 2 | 3.610 | 22976.5 |
254 | 2024-04-05 01:47:52 | existing | 1 | 82945 | 2 | 2.780 | 29836.3 |
253 | 2024-03-16 11:40:50 | existing | 2 | 121059 | 38 | 7.016 | 17254.7 |
252 | 2024-03-16 11:35:29 | existing | 1 | 82945 | 2 | 1.923 | 43133.1 |
251 | 2024-03-10 06:58:00 | existing | 3 | 146162 | 331 | 9.440 | 15483.3 |
250 | 2024-03-09 20:25:39 | existing | 3 | 146162 | 331 | 8.470 | 17256.4 |
249 | 2024-03-09 20:25:28 | existing | 2 | 121059 | 38 | 4.203 | 28803.0 |
248 | 2024-03-08 23:11:18 | existing | 1 | 82945 | 2 | 1.500 | 55296.7 |
247 | 2024-03-08 23:11:03 | existing | 2 | 121059 | 38 | 4.313 | 28068.4 |
246 | 2024-03-08 23:10:50 | existing | 1 | 82945 | 2 | 1.576 | 52630.1 |
245 | 2024-02-29 17:45:44 | existing | 3 | 146162 | 331 | 8.936 | 16356.5 |
244 | 2024-02-22 09:25:14 | existing | 3 | 146162 | 331 | 7.796 | 18748.3 |
243 | 2024-02-20 11:04:01 | existing | 3 | 146162 | 331 | 7.393 | 19770.3 |
242 | 2024-02-13 04:19:16 | existing | 1 | 82945 | 2 | 1.330 | 62364.7 |
241 | 2024-02-05 05:16:55 | existing | 3 | 146162 | 331 | 7.686 | 19016.7 |
240 | 2024-02-04 06:37:30 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
239 | 2024-02-04 04:03:35 | existing | 3 | 146162 | 331 | 6.953 | 21021.4 |
238 | 2024-02-03 11:23:49 | existing | 1 | 82945 | 2 | 1.313 | 63172.1 |
237 | 2024-01-30 17:57:43 | existing | 2 | 121059 | 38 | 3.483 | 34757.1 |
236 | 2024-01-30 12:00:15 | existing | 2 | 121059 | 38 | 3.580 | 33815.4 |
235 | 2024-01-30 11:59:47 | existing | 2 | 121059 | 38 | 3.580 | 33815.4 |
234 | 2024-01-30 11:58:55 | existing | 3 | 146162 | 331 | 7.190 | 20328.5 |
233 | 2024-01-30 07:55:30 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
232 | 2024-01-18 11:12:37 | existing | 3 | 146162 | 331 | 8.500 | 17195.5 |
231 | 2024-01-14 15:05:00 | existing | 3 | 146162 | 331 | 7.796 | 18748.3 |
230 | 2024-01-05 05:25:01 | existing | 1 | 82945 | 2 | 1.326 | 62552.8 |
229 | 2023-12-11 02:42:00 | existing | 1 | 82945 | 2 | 1.500 | 55296.7 |
228 | 2023-12-01 13:26:15 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
227 | 2023-11-25 23:27:37 | existing | 1 | 82945 | 2 | 1.360 | 60989.0 |
226 | 2023-11-17 02:37:45 | existing | 3 | 146162 | 331 | 6.360 | 22981.4 |
225 | 2023-11-12 17:16:41 | existing | 1 | 82945 | 2 | 1.220 | 67987.7 |
224 | 2023-10-30 22:35:23 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
223 | 2023-10-07 02:46:44 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
222 | 2023-10-01 18:59:12 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
221 | 2023-09-30 00:07:37 | existing | 1 | 82945 | 2 | 1.410 | 58826.2 |
220 | 2023-09-16 17:12:14 | existing | 1 | 82945 | 2 | 1.220 | 67987.7 |
219 | 2023-08-19 05:53:27 | existing | 3 | 146162 | 331 | 6.923 | 21112.5 |
218 | 2023-07-10 12:17:54 | existing | 1 | 82945 | 2 | 1.216 | 68211.3 |
217 | 2023-06-11 11:59:05 | existing | 1 | 82945 | 2 | 1.236 | 67107.6 |
216 | 2023-05-04 02:06:42 | existing | 3 | 146162 | 331 | 5.983 | 24429.6 |
215 | 2023-04-17 17:10:52 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
214 | 2023-03-02 10:04:12 | existing | 1 | 82945 | 2 | 1.373 | 60411.5 |
213 | 2023-02-26 19:40:56 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
212 | 2023-02-11 11:33:32 | existing | 1 | 82945 | 2 | 1.236 | 67107.6 |
211 | 2023-02-09 06:34:02 | existing | 3 | 146162 | 331 | 6.280 | 23274.2 |
210 | 2022-12-09 07:05:57 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
209 | 2022-11-20 11:20:26 | existing | 3 | 146162 | 331 | 6.533 | 22372.9 |
208 | 2022-11-09 23:40:00 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
207 | 2022-09-27 17:13:35 | existing | 3 | 146162 | 331 | 6.140 | 23804.9 |
206 | 2022-09-06 08:22:01 | existing | 3 | 146162 | 331 | 6.046 | 24175.0 |
205 | 2022-08-12 17:39:48 | existing | 1 | 82945 | 2 | 1.296 | 64000.8 |
204 | 2022-07-20 17:49:06 | existing | 1 | 82945 | 2 | 1.360 | 60989.0 |
203 | 2022-07-19 01:52:11 | existing | 1 | 82945 | 2 | 1.406 | 58993.6 |
202 | 2022-07-17 00:39:20 | existing | 1 | 82945 | 2 | 1.360 | 60989.0 |
201 | 2022-06-23 22:51:06 | existing | 3 | 146162 | 331 | 6.016 | 24295.5 |
200 | 2022-06-21 18:51:54 | existing | 3 | 146162 | 331 | 6.390 | 22873.6 |
199 | 2022-04-01 18:02:59 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
198 | 2022-03-09 11:46:48 | existing | 1 | 82945 | 2 | 2.533 | 32745.8 |
197 | 2022-02-03 04:36:05 | existing | 3 | 146162 | 331 | 6.560 | 22280.8 |
196 | 2022-01-05 12:47:05 | existing | 1 | 82945 | 2 | 1.500 | 55296.7 |
195 | 2021-11-22 10:00:39 | existing | 1 | 82945 | 2 | 1.470 | 56425.2 |
194 | 2021-11-05 21:40:40 | existing | 1 | 82945 | 2 | 1.953 | 42470.6 |
193 | 2021-10-30 15:24:40 | existing | 1 | 82945 | 2 | 1.453 | 57085.3 |
192 | 2021-10-30 07:46:15 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
191 | 2021-10-29 18:20:10 | existing | 1 | 82945 | 2 | 1.393 | 59544.1 |
190 | 2021-10-29 02:30:34 | existing | 1 | 82945 | 2 | 1.436 | 57761.1 |
189 | 2021-10-28 20:34:49 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
188 | 2021-10-27 22:45:33 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
187 | 2021-10-27 02:33:32 | existing | 1 | 82945 | 2 | 1.436 | 57761.1 |
186 | 2021-09-26 15:00:58 | existing | 1 | 82945 | 2 | 1.236 | 67107.6 |
185 | 2021-09-21 20:39:55 | existing | 1 | 82945 | 2 | 2.110 | 39310.4 |
184 | 2021-09-21 03:51:14 | existing | 1 | 82945 | 2 | 1.266 | 65517.4 |
183 | 2021-08-19 10:03:32 | existing | 1 | 82945 | 2 | 1.406 | 58993.6 |
182 | 2021-08-17 05:50:34 | existing | 1 | 82945 | 2 | 1.440 | 57600.7 |
181 | 2021-08-12 21:12:05 | existing | 1 | 82945 | 2 | 1.220 | 67987.7 |
180 | 2021-06-20 17:23:00 | existing | 1 | 82945 | 2 | 1.453 | 57085.3 |
179 | 2021-05-12 04:05:52 | existing | 1 | 82945 | 2 | 1.436 | 57761.1 |
178 | 2021-04-29 18:52:18 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
177 | 2021-04-01 02:12:28 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
176 | 2021-03-14 22:11:04 | existing | 1 | 82945 | 2 | 1.390 | 59672.7 |
175 | 2021-02-09 19:34:48 | existing | 1 | 82945 | 2 | 1.233 | 67270.9 |
174 | 2021-02-07 20:45:02 | existing | 1 | 82945 | 2 | 1.280 | 64800.8 |
173 | 2021-01-16 01:31:02 | existing | 1 | 82945 | 2 | 1.626 | 51011.7 |
172 | 2020-12-25 08:30:47 | existing | 1 | 82945 | 2 | 1.250 | 66356.0 |
171 | 2020-11-06 02:34:45 | existing | 1 | 82945 | 2 | 1.346 | 61623.3 |
170 | 2020-10-31 11:19:48 | existing | 1 | 82945 | 2 | 1.466 | 56579.1 |
169 | 2020-10-31 01:06:01 | existing | 1 | 82945 | 2 | 1.500 | 55296.7 |
168 | 2020-10-27 15:05:00 | existing | 1 | 82945 | 2 | 1.296 | 64000.8 |