History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"treaties"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
356 | 2024-05-08 00:29:50 | treaties | 2 | 121059 | 28 | 9.050 | 13376.7 |
355 | 2024-05-06 15:48:52 | treaties | 2 | 121059 | 28 | 6.686 | 18106.3 |
354 | 2024-04-25 21:45:41 | treaties | 2 | 121059 | 28 | 8.673 | 13958.1 |
353 | 2024-04-25 20:10:00 | treaties | 3 | 146162 | 359 | 16.406 | 8909.1 |
352 | 2024-04-25 18:36:45 | treaties | 3 | 146162 | 359 | 9.110 | 16044.1 |
351 | 2024-04-22 05:55:21 | treaties | 1 | 82945 | 3 | 1.690 | 49079.9 |
350 | 2024-04-22 05:55:08 | treaties | 3 | 146162 | 359 | 9.673 | 15110.3 |
349 | 2024-04-22 05:55:10 | treaties | 2 | 121059 | 28 | 5.170 | 23415.7 |
348 | 2024-04-22 05:55:02 | treaties | 1 | 82945 | 3 | 1.550 | 53512.9 |
347 | 2024-04-21 13:37:08 | treaties | 2 | 121059 | 28 | 14.766 | 8198.5 |
346 | 2024-04-20 23:02:17 | treaties | 3 | 146162 | 359 | 25.546 | 5721.5 |
345 | 2024-04-20 14:02:40 | treaties | 3 | 146162 | 359 | 11.500 | 12709.7 |
344 | 2024-04-19 00:12:38 | treaties | 3 | 146162 | 359 | 19.970 | 7319.1 |
343 | 2024-04-19 00:12:38 | treaties | 2 | 121059 | 28 | 9.890 | 12240.5 |
342 | 2024-04-18 20:47:17 | treaties | 1 | 82945 | 3 | 1.623 | 51106.0 |
341 | 2024-04-06 11:33:41 | treaties | 1 | 82945 | 3 | 4.343 | 19098.5 |
340 | 2024-03-30 02:11:17 | treaties | 1 | 82945 | 3 | 3.456 | 24000.3 |
339 | 2024-03-25 19:53:04 | treaties | 2 | 121059 | 28 | 4.156 | 29128.7 |
338 | 2024-03-25 19:29:36 | treaties | 3 | 146162 | 359 | 8.156 | 17920.8 |
337 | 2024-03-25 07:25:25 | treaties | 2 | 121059 | 28 | 3.266 | 37066.4 |
336 | 2024-03-25 07:19:26 | treaties | 3 | 146162 | 359 | 7.516 | 19446.8 |
335 | 2024-03-23 02:15:21 | treaties | 3 | 146162 | 359 | 8.733 | 16736.7 |
334 | 2024-03-23 02:15:23 | treaties | 2 | 121059 | 28 | 4.110 | 29454.7 |
333 | 2024-03-23 02:15:21 | treaties | 1 | 82945 | 3 | 1.580 | 52496.8 |
332 | 2024-03-19 17:25:36 | treaties | 2 | 121059 | 28 | 6.766 | 17892.3 |
331 | 2024-03-19 17:17:13 | treaties | 1 | 82945 | 3 | 1.406 | 58993.6 |
330 | 2024-03-18 21:38:34 | treaties | 2 | 121059 | 28 | 4.936 | 24525.7 |
329 | 2024-03-18 20:18:27 | treaties | 3 | 146162 | 359 | 17.173 | 8511.2 |
328 | 2024-03-18 19:39:15 | treaties | 3 | 146162 | 359 | 25.860 | 5652.0 |
327 | 2024-03-18 04:59:18 | treaties | 3 | 146162 | 359 | 8.393 | 17414.8 |
326 | 2024-03-18 04:59:21 | treaties | 2 | 121059 | 28 | 3.983 | 30393.9 |
325 | 2024-02-21 23:23:47 | treaties | 1 | 82945 | 3 | 1.593 | 52068.4 |
324 | 2024-02-07 03:56:45 | treaties | 1 | 82945 | 3 | 1.436 | 57761.1 |
323 | 2024-01-30 16:10:31 | treaties | 2 | 121059 | 28 | 4.110 | 29454.7 |
322 | 2024-01-29 09:07:36 | treaties | 3 | 146162 | 359 | 9.593 | 15236.3 |
321 | 2024-01-27 19:07:35 | treaties | 3 | 146162 | 359 | 7.190 | 20328.5 |
320 | 2024-01-27 19:07:25 | treaties | 2 | 121059 | 28 | 3.343 | 36212.7 |
319 | 2024-01-26 15:48:03 | treaties | 2 | 121059 | 28 | 4.483 | 27004.0 |
318 | 2024-01-25 21:50:14 | treaties | 1 | 82945 | 3 | 1.513 | 54821.5 |
317 | 2024-01-14 08:18:06 | treaties | 1 | 82945 | 3 | 1.453 | 57085.3 |
316 | 2023-12-26 06:05:29 | treaties | 1 | 82945 | 3 | 1.310 | 63316.8 |
315 | 2023-11-28 21:39:48 | treaties | 1 | 82945 | 3 | 1.453 | 57085.3 |
314 | 2023-11-23 15:24:39 | treaties | 2 | 121059 | 28 | 3.266 | 37066.4 |
313 | 2023-11-17 10:33:05 | treaties | 1 | 82945 | 3 | 1.390 | 59672.7 |
312 | 2023-11-07 18:33:59 | treaties | 2 | 121059 | 28 | 3.686 | 32842.9 |
311 | 2023-11-01 18:25:56 | treaties | 1 | 82945 | 3 | 1.263 | 65673.0 |
310 | 2023-10-07 00:35:52 | treaties | 1 | 82945 | 3 | 1.313 | 63172.1 |
309 | 2023-09-25 02:32:38 | treaties | 1 | 82945 | 3 | 1.360 | 60989.0 |
308 | 2023-09-15 01:30:25 | treaties | 1 | 82945 | 3 | 1.250 | 66356.0 |
307 | 2023-09-04 04:49:02 | treaties | 1 | 82945 | 3 | 1.423 | 58288.8 |
306 | 2023-08-31 23:09:07 | treaties | 1 | 82945 | 3 | 1.360 | 60989.0 |
305 | 2023-08-11 23:52:33 | treaties | 2 | 121059 | 28 | 5.343 | 22657.5 |
304 | 2023-06-19 07:38:25 | treaties | 1 | 82945 | 3 | 1.486 | 55817.6 |
303 | 2023-05-04 04:32:24 | treaties | 1 | 82945 | 3 | 1.436 | 57761.1 |
302 | 2023-04-27 09:32:40 | treaties | 2 | 121059 | 28 | 3.156 | 38358.4 |
301 | 2023-04-21 17:05:22 | treaties | 1 | 82945 | 3 | 1.436 | 57761.1 |
300 | 2023-04-02 21:16:18 | treaties | 1 | 82945 | 3 | 1.420 | 58412.0 |
299 | 2023-03-20 00:09:50 | treaties | 1 | 82945 | 3 | 1.360 | 60989.0 |
298 | 2023-02-03 22:37:55 | treaties | 2 | 121059 | 28 | 3.220 | 37596.0 |
297 | 2023-01-17 01:48:31 | treaties | 1 | 82945 | 3 | 1.403 | 59119.7 |
296 | 2023-01-14 10:33:12 | treaties | 1 | 82945 | 3 | 1.233 | 67270.9 |
295 | 2022-11-14 13:57:14 | treaties | 2 | 121059 | 28 | 3.330 | 36354.1 |
294 | 2022-11-10 23:00:48 | treaties | 1 | 82945 | 3 | 1.420 | 58412.0 |
293 | 2022-10-03 18:36:09 | treaties | 2 | 121059 | 28 | 3.186 | 37997.2 |
292 | 2022-09-16 01:41:07 | treaties | 1 | 82945 | 3 | 1.296 | 64000.8 |
291 | 2022-08-23 13:05:55 | treaties | 2 | 121059 | 28 | 3.263 | 37100.5 |
290 | 2022-06-16 20:43:20 | treaties | 2 | 121059 | 28 | 3.313 | 36540.6 |
289 | 2022-05-15 15:27:35 | treaties | 1 | 82945 | 3 | 1.280 | 64800.8 |
288 | 2022-05-03 03:36:34 | treaties | 1 | 82945 | 3 | 1.626 | 51011.7 |
287 | 2022-01-06 04:41:37 | treaties | 1 | 82945 | 3 | 1.390 | 59672.7 |
286 | 2022-01-06 01:50:25 | treaties | 1 | 82945 | 3 | 1.546 | 53651.4 |
285 | 2022-01-05 15:11:13 | treaties | 1 | 82945 | 3 | 1.483 | 55930.5 |
284 | 2022-01-05 06:54:00 | treaties | 1 | 82945 | 3 | 1.593 | 52068.4 |
283 | 2022-01-04 16:30:09 | treaties | 1 | 82945 | 3 | 1.623 | 51106.0 |
282 | 2022-01-02 20:21:13 | treaties | 1 | 82945 | 3 | 1.453 | 57085.3 |
281 | 2021-12-16 15:52:38 | treaties | 1 | 82945 | 3 | 1.280 | 64800.8 |
280 | 2021-11-18 17:14:49 | treaties | 1 | 82945 | 3 | 1.326 | 62552.8 |
279 | 2021-10-30 16:37:00 | treaties | 1 | 82945 | 3 | 1.500 | 55296.7 |
278 | 2021-10-29 13:29:44 | treaties | 1 | 82945 | 3 | 1.313 | 63172.1 |
277 | 2021-10-28 19:00:47 | treaties | 1 | 82945 | 3 | 1.516 | 54713.1 |
276 | 2021-10-27 20:58:47 | treaties | 1 | 82945 | 3 | 1.483 | 55930.5 |
275 | 2021-09-22 02:28:09 | treaties | 1 | 82945 | 3 | 1.360 | 60989.0 |
274 | 2021-09-20 09:36:08 | treaties | 1 | 82945 | 3 | 2.846 | 29144.4 |
273 | 2021-07-28 12:05:14 | treaties | 1 | 82945 | 3 | 1.470 | 56425.2 |
272 | 2021-06-17 05:57:00 | treaties | 1 | 82945 | 3 | 1.516 | 54713.1 |
271 | 2021-06-13 18:49:49 | treaties | 1 | 82945 | 3 | 1.283 | 64649.3 |
270 | 2021-05-25 23:50:32 | treaties | 1 | 82945 | 3 | 1.296 | 64000.8 |
269 | 2021-04-29 21:05:06 | treaties | 1 | 82945 | 3 | 1.330 | 62364.7 |
268 | 2021-03-29 08:19:52 | treaties | 1 | 82945 | 3 | 1.266 | 65517.4 |
267 | 2021-03-10 21:56:36 | treaties | 1 | 82945 | 3 | 1.280 | 64800.8 |
266 | 2021-03-03 08:57:16 | treaties | 1 | 82945 | 3 | 1.250 | 66356.0 |
265 | 2021-02-01 00:09:16 | treaties | 1 | 82945 | 3 | 1.283 | 64649.3 |
264 | 2021-01-04 08:41:54 | treaties | 1 | 82945 | 3 | 1.310 | 63316.8 |
263 | 2020-12-14 11:30:42 | treaties | 1 | 82945 | 3 | 1.436 | 57761.1 |
262 | 2020-12-03 12:46:07 | treaties | 1 | 82945 | 3 | 1.406 | 58993.6 |
261 | 2020-11-02 04:48:00 | treaties | 1 | 82945 | 3 | 1.513 | 54821.5 |
260 | 2020-11-01 10:42:46 | treaties | 1 | 82945 | 3 | 1.313 | 63172.1 |
259 | 2020-10-26 19:27:35 | treaties | 1 | 82945 | 3 | 1.343 | 61761.0 |
258 | 2020-10-23 02:17:48 | treaties | 2 | 121059 | 28 | 3.250 | 37248.9 |
257 | 2020-10-15 21:38:29 | treaties | 1 | 82945 | 3 | 1.936 | 42843.5 |