History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trenches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
328 | 2024-04-28 21:00:26 | trenches | 1 | 82945 | 9 | 2.983 | 27805.9 |
327 | 2024-03-31 19:40:07 | trenches | 3 | 146162 | 285 | 9.686 | 15090.0 |
326 | 2024-03-31 19:39:55 | trenches | 2 | 121059 | 49 | 6.390 | 18945.1 |
325 | 2024-03-30 00:54:30 | trenches | 1 | 82945 | 9 | 4.796 | 17294.6 |
324 | 2024-03-30 00:15:05 | trenches | 2 | 121059 | 49 | 4.063 | 29795.5 |
323 | 2024-03-29 20:09:20 | trenches | 1 | 82945 | 9 | 4.156 | 19957.9 |
322 | 2024-03-29 03:42:23 | trenches | 3 | 146162 | 285 | 17.173 | 8511.2 |
321 | 2024-03-29 03:29:21 | trenches | 1 | 82945 | 9 | 1.593 | 52068.4 |
320 | 2024-03-29 03:29:03 | trenches | 3 | 146162 | 285 | 17.906 | 8162.7 |
319 | 2024-03-29 03:29:03 | trenches | 2 | 121059 | 49 | 8.800 | 13756.7 |
318 | 2024-03-29 03:28:55 | trenches | 1 | 82945 | 9 | 2.406 | 34474.2 |
317 | 2024-02-28 06:15:30 | trenches | 1 | 82945 | 9 | 2.906 | 28542.7 |
316 | 2024-02-27 21:15:23 | trenches | 1 | 82945 | 9 | 1.373 | 60411.5 |
315 | 2024-02-21 19:27:08 | trenches | 2 | 121059 | 49 | 4.063 | 29795.5 |
314 | 2024-02-21 04:32:14 | trenches | 1 | 82945 | 9 | 3.466 | 23931.0 |
313 | 2024-02-10 17:09:56 | trenches | 2 | 121059 | 49 | 12.500 | 9684.7 |
312 | 2024-02-06 01:36:03 | trenches | 3 | 146162 | 285 | 34.910 | 4186.8 |
311 | 2024-02-04 02:41:11 | trenches | 2 | 121059 | 49 | 3.826 | 31641.1 |
310 | 2024-02-01 06:29:35 | trenches | 1 | 82945 | 9 | 1.453 | 57085.3 |
309 | 2024-02-01 05:29:28 | trenches | 2 | 121059 | 49 | 3.623 | 33414.0 |
308 | 2024-02-01 05:25:36 | trenches | 3 | 146162 | 285 | 8.190 | 17846.4 |
307 | 2024-01-31 23:26:48 | trenches | 2 | 121059 | 49 | 3.686 | 32842.9 |
306 | 2024-01-31 18:02:40 | trenches | 3 | 146162 | 285 | 10.923 | 13381.1 |
305 | 2024-01-31 06:32:55 | trenches | 3 | 146162 | 285 | 7.436 | 19656.0 |
304 | 2024-01-31 06:32:51 | trenches | 2 | 121059 | 49 | 3.893 | 31096.6 |
303 | 2024-01-02 03:59:57 | trenches | 2 | 121059 | 49 | 3.703 | 32692.1 |
302 | 2023-12-29 06:57:42 | trenches | 2 | 121059 | 49 | 3.203 | 37795.5 |
301 | 2023-12-29 03:45:26 | trenches | 1 | 82945 | 9 | 1.393 | 59544.1 |
300 | 2023-12-16 22:01:15 | trenches | 1 | 82945 | 9 | 1.626 | 51011.7 |
299 | 2023-11-26 16:16:43 | trenches | 1 | 82945 | 9 | 1.453 | 57085.3 |
298 | 2023-11-19 23:39:21 | trenches | 1 | 82945 | 9 | 1.330 | 62364.7 |
297 | 2023-11-09 19:14:34 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
296 | 2023-10-31 00:23:21 | trenches | 3 | 146162 | 285 | 7.546 | 19369.5 |
295 | 2023-10-25 15:30:28 | trenches | 2 | 121059 | 49 | 3.610 | 33534.3 |
294 | 2023-10-25 15:30:19 | trenches | 3 | 146162 | 285 | 7.970 | 18339.0 |
293 | 2023-10-19 19:04:52 | trenches | 1 | 82945 | 9 | 1.236 | 67107.6 |
292 | 2023-10-01 14:33:28 | trenches | 2 | 121059 | 49 | 3.233 | 37444.8 |
291 | 2023-09-14 04:01:45 | trenches | 1 | 82945 | 9 | 1.236 | 67107.6 |
290 | 2023-09-12 05:28:13 | trenches | 1 | 82945 | 9 | 1.500 | 55296.7 |
289 | 2023-07-15 03:18:58 | trenches | 1 | 82945 | 9 | 1.486 | 55817.6 |
288 | 2023-07-13 12:30:07 | trenches | 2 | 121059 | 49 | 3.626 | 33386.4 |
287 | 2023-06-21 17:48:06 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
286 | 2023-04-04 11:13:34 | trenches | 1 | 82945 | 9 | 1.390 | 59672.7 |
285 | 2023-03-30 04:06:53 | trenches | 2 | 121059 | 49 | 3.843 | 31501.2 |
284 | 2023-03-20 12:01:54 | trenches | 1 | 82945 | 9 | 1.250 | 66356.0 |
283 | 2023-01-16 14:50:34 | trenches | 1 | 82945 | 9 | 1.283 | 64649.3 |
282 | 2022-12-26 00:33:44 | trenches | 2 | 121059 | 49 | 3.140 | 38553.8 |
281 | 2022-11-18 21:04:31 | trenches | 1 | 82945 | 9 | 1.376 | 60279.8 |
280 | 2022-11-07 23:12:08 | trenches | 1 | 82945 | 9 | 1.250 | 66356.0 |
279 | 2022-08-25 05:21:00 | trenches | 2 | 121059 | 49 | 3.216 | 37642.7 |
278 | 2022-07-22 10:56:44 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
277 | 2022-06-29 09:16:48 | trenches | 1 | 82945 | 9 | 1.393 | 59544.1 |
276 | 2022-06-27 04:10:40 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
275 | 2022-05-15 23:35:23 | trenches | 3 | 146162 | 285 | 7.283 | 20068.9 |
274 | 2022-03-31 15:15:38 | trenches | 1 | 82945 | 9 | 1.543 | 53755.7 |
273 | 2022-03-16 03:18:03 | trenches | 2 | 121059 | 49 | 4.373 | 27683.3 |
272 | 2022-03-06 11:23:44 | trenches | 1 | 82945 | 9 | 1.326 | 62552.8 |
271 | 2021-12-21 03:22:44 | trenches | 1 | 82945 | 9 | 1.390 | 59672.7 |
270 | 2021-12-10 17:00:37 | trenches | 1 | 82945 | 9 | 1.376 | 60279.8 |
269 | 2021-11-18 03:06:10 | trenches | 1 | 82945 | 9 | 1.280 | 64800.8 |
268 | 2021-11-01 05:38:55 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
267 | 2021-09-22 19:41:56 | trenches | 1 | 82945 | 9 | 1.503 | 55186.3 |
266 | 2021-09-20 16:23:39 | trenches | 1 | 82945 | 9 | 1.440 | 57600.7 |
265 | 2021-09-18 12:50:00 | trenches | 1 | 82945 | 9 | 1.453 | 57085.3 |
264 | 2021-09-01 00:52:26 | trenches | 1 | 82945 | 9 | 1.263 | 65673.0 |
263 | 2021-08-27 18:21:01 | trenches | 1 | 82945 | 9 | 1.453 | 57085.3 |
262 | 2021-05-25 16:24:20 | trenches | 1 | 82945 | 9 | 1.483 | 55930.5 |
261 | 2021-05-23 16:32:20 | trenches | 1 | 82945 | 9 | 1.513 | 54821.5 |
260 | 2021-04-29 09:35:01 | trenches | 1 | 82945 | 9 | 1.470 | 56425.2 |
259 | 2021-03-30 22:02:10 | trenches | 1 | 82945 | 9 | 2.890 | 28700.7 |
258 | 2021-03-28 23:43:09 | trenches | 1 | 82945 | 9 | 1.250 | 66356.0 |
257 | 2021-02-21 16:07:56 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
256 | 2021-01-12 18:22:54 | trenches | 1 | 82945 | 9 | 1.406 | 58993.6 |
255 | 2020-11-18 12:16:54 | trenches | 1 | 82945 | 9 | 1.593 | 52068.4 |
254 | 2020-11-05 14:31:46 | trenches | 1 | 82945 | 9 | 1.610 | 51518.6 |
253 | 2020-10-26 19:42:53 | trenches | 1 | 82945 | 9 | 1.436 | 57761.1 |
252 | 2020-10-25 04:10:26 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
251 | 2020-10-18 20:11:58 | trenches | 1 | 82945 | 9 | 1.313 | 63172.1 |
250 | 2020-10-16 13:36:05 | trenches | 1 | 82945 | 9 | 1.326 | 62552.8 |
249 | 2020-08-06 13:21:30 | trenches | 1 | 82945 | 9 | 1.296 | 64000.8 |
248 | 2020-06-19 17:56:27 | trenches | 1 | 82945 | 9 | 1.873 | 44284.6 |
247 | 2020-06-15 10:36:15 | trenches | 1 | 82945 | 9 | 1.330 | 62364.7 |
246 | 2020-05-05 02:58:43 | trenches | 1 | 82945 | 9 | 1.436 | 57761.1 |
245 | 2020-03-30 03:10:51 | trenches | 1 | 82945 | 9 | 1.250 | 66356.0 |
244 | 2020-03-29 21:19:55 | trenches | 1 | 82945 | 9 | 1.876 | 44213.8 |
243 | 2020-03-28 23:42:14 | trenches | 1 | 82945 | 9 | 1.330 | 62364.7 |
242 | 2020-03-21 04:49:44 | trenches | 1 | 82945 | 9 | 1.406 | 58993.6 |
241 | 2020-03-18 08:03:31 | trenches | 1 | 82945 | 9 | 1.530 | 54212.4 |
240 | 2020-02-28 15:51:53 | trenches | 3 | 146162 | 285 | 18.830 | 7762.2 |
239 | 2020-02-28 14:02:46 | trenches | 3 | 146162 | 285 | 8.483 | 17230.0 |
238 | 2020-02-28 11:37:17 | trenches | 3 | 146162 | 285 | 16.280 | 8978.0 |
237 | 2020-02-28 07:37:28 | trenches | 3 | 146162 | 285 | 8.343 | 17519.1 |
236 | 2020-02-28 02:34:06 | trenches | 3 | 146162 | 285 | 8.266 | 17682.3 |
235 | 2020-02-27 21:19:31 | trenches | 3 | 146162 | 285 | 18.656 | 7834.6 |
234 | 2020-02-26 03:33:25 | trenches | 1 | 82945 | 9 | 1.593 | 52068.4 |
233 | 2020-02-13 22:41:44 | trenches | 2 | 121059 | 49 | 4.533 | 26706.2 |
232 | 2020-02-13 14:46:04 | trenches | 1 | 82945 | 9 | 1.563 | 53067.8 |
231 | 2020-02-10 02:52:44 | trenches | 1 | 82945 | 9 | 2.250 | 36864.4 |
230 | 2020-02-06 11:40:21 | trenches | 1 | 82945 | 9 | 2.300 | 36063.0 |
229 | 2020-02-04 14:35:00 | trenches | 1 | 82945 | 9 | 3.986 | 20809.1 |