History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chianti"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
371 | 2024-05-01 16:00:18 | chianti | 2 | 107671 | 10 | 3.516 | 30623.2 |
370 | 2024-05-01 16:00:06 | chianti | 3 | 134027 | 116 | 7.220 | 18563.3 |
369 | 2024-04-30 06:34:03 | chianti | 3 | 134027 | 116 | 10.940 | 12251.1 |
368 | 2024-04-27 23:54:04 | chianti | 2 | 107671 | 10 | 3.233 | 33303.7 |
367 | 2024-04-27 15:40:41 | chianti | 3 | 134027 | 116 | 10.236 | 13093.7 |
366 | 2024-04-13 07:04:52 | chianti | 1 | 69583 | 2 | 1.330 | 52318.0 |
365 | 2024-04-07 23:34:12 | chianti | 1 | 69583 | 2 | 3.170 | 21950.5 |
364 | 2024-04-06 05:01:17 | chianti | 2 | 107671 | 10 | 4.830 | 22292.1 |
363 | 2024-04-06 05:01:04 | chianti | 3 | 134027 | 116 | 8.060 | 16628.7 |
362 | 2024-04-06 03:20:08 | chianti | 3 | 134027 | 116 | 21.813 | 6144.4 |
361 | 2024-04-05 22:08:02 | chianti | 3 | 134027 | 116 | 8.780 | 15265.0 |
360 | 2024-04-05 22:07:51 | chianti | 2 | 107671 | 10 | 3.780 | 28484.4 |
359 | 2024-04-04 21:14:53 | chianti | 2 | 107671 | 10 | 3.313 | 32499.5 |
358 | 2024-03-31 05:45:55 | chianti | 1 | 69583 | 2 | 4.140 | 16807.5 |
357 | 2024-03-28 16:54:09 | chianti | 1 | 69583 | 2 | 3.436 | 20251.2 |
356 | 2024-03-28 12:40:28 | chianti | 1 | 69583 | 2 | 1.346 | 51696.1 |
355 | 2024-03-23 12:52:31 | chianti | 3 | 134027 | 116 | 5.750 | 23309.0 |
354 | 2024-03-05 20:56:13 | chianti | 3 | 134027 | 116 | 24.393 | 5494.5 |
353 | 2024-03-05 17:39:00 | chianti | 3 | 134027 | 116 | 22.546 | 5944.6 |
352 | 2024-03-04 04:00:36 | chianti | 3 | 134027 | 116 | 11.186 | 11981.7 |
351 | 2024-03-02 14:22:54 | chianti | 3 | 134027 | 116 | 12.830 | 10446.4 |
350 | 2024-03-02 14:22:57 | chianti | 2 | 107671 | 10 | 8.326 | 12931.9 |
349 | 2024-03-02 14:22:51 | chianti | 1 | 69583 | 2 | 1.546 | 45008.4 |
348 | 2024-02-02 06:30:03 | chianti | 2 | 107671 | 10 | 3.093 | 34811.2 |
347 | 2024-02-02 06:28:27 | chianti | 3 | 134027 | 116 | 6.686 | 20045.9 |
346 | 2024-01-26 13:22:28 | chianti | 3 | 134027 | 116 | 6.670 | 20094.0 |
345 | 2024-01-26 13:06:43 | chianti | 3 | 134027 | 116 | 12.780 | 10487.2 |
344 | 2024-01-26 10:05:09 | chianti | 3 | 134027 | 116 | 6.906 | 19407.3 |
343 | 2024-01-19 00:07:14 | chianti | 3 | 134027 | 116 | 5.783 | 23176.0 |
342 | 2024-01-19 00:07:12 | chianti | 2 | 107671 | 10 | 2.860 | 37647.2 |
341 | 2023-12-30 22:34:34 | chianti | 1 | 69583 | 2 | 1.266 | 54962.9 |
340 | 2023-12-17 01:28:42 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
339 | 2023-12-09 09:03:59 | chianti | 2 | 107671 | 10 | 2.750 | 39153.1 |
338 | 2023-12-04 12:14:31 | chianti | 3 | 134027 | 116 | 6.186 | 21666.2 |
337 | 2023-11-17 19:37:37 | chianti | 1 | 69583 | 2 | 2.530 | 27503.2 |
336 | 2023-10-21 18:27:43 | chianti | 1 | 69583 | 2 | 1.296 | 53690.6 |
335 | 2023-09-24 09:38:43 | chianti | 1 | 69583 | 2 | 1.063 | 65459.1 |
334 | 2023-09-15 06:15:37 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
333 | 2023-09-06 00:36:50 | chianti | 2 | 107671 | 10 | 2.766 | 38926.6 |
332 | 2023-09-01 16:40:13 | chianti | 3 | 134027 | 116 | 5.923 | 22628.2 |
331 | 2023-08-17 10:41:57 | chianti | 1 | 69583 | 2 | 1.093 | 63662.4 |
330 | 2023-07-27 17:40:18 | chianti | 1 | 69583 | 2 | 1.093 | 63662.4 |
329 | 2023-07-02 22:29:51 | chianti | 1 | 69583 | 2 | 1.046 | 66522.9 |
328 | 2023-05-18 22:27:10 | chianti | 3 | 134027 | 116 | 6.640 | 20184.8 |
327 | 2023-05-18 18:40:50 | chianti | 1 | 69583 | 2 | 1.063 | 65459.1 |
326 | 2023-05-16 05:21:08 | chianti | 2 | 107671 | 10 | 2.750 | 39153.1 |
325 | 2023-04-23 04:20:24 | chianti | 1 | 69583 | 2 | 1.250 | 55666.4 |
324 | 2023-03-12 01:44:33 | chianti | 1 | 69583 | 2 | 1.046 | 66522.9 |
323 | 2023-02-24 02:25:53 | chianti | 3 | 134027 | 116 | 5.640 | 23763.7 |
322 | 2023-02-20 06:07:59 | chianti | 2 | 107671 | 10 | 3.156 | 34116.3 |
321 | 2023-01-01 17:57:07 | chianti | 1 | 69583 | 2 | 2.393 | 29077.7 |
320 | 2022-12-30 13:44:26 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
319 | 2022-12-21 13:02:23 | chianti | 1 | 69583 | 2 | 1.063 | 65459.1 |
318 | 2022-12-05 07:43:00 | chianti | 3 | 134027 | 116 | 5.546 | 24166.4 |
317 | 2022-12-01 05:13:30 | chianti | 2 | 107671 | 10 | 2.766 | 38926.6 |
316 | 2022-11-17 13:02:34 | chianti | 1 | 69583 | 2 | 1.186 | 58670.3 |
315 | 2022-11-17 02:51:46 | chianti | 1 | 69583 | 2 | 1.093 | 63662.4 |
314 | 2022-09-21 11:48:25 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
313 | 2022-09-02 04:04:07 | chianti | 1 | 69583 | 2 | 1.080 | 64428.7 |
312 | 2022-07-08 05:58:24 | chianti | 2 | 107671 | 10 | 2.800 | 38453.9 |
311 | 2022-05-03 05:15:08 | chianti | 1 | 69583 | 2 | 1.250 | 55666.4 |
310 | 2022-04-30 19:55:03 | chianti | 1 | 69583 | 2 | 1.060 | 65644.3 |
309 | 2022-04-16 12:07:32 | chianti | 3 | 134027 | 116 | 5.623 | 23835.5 |
308 | 2022-01-24 04:39:56 | chianti | 1 | 69583 | 2 | 1.060 | 65644.3 |
307 | 2022-01-20 18:14:52 | chianti | 1 | 69583 | 2 | 1.093 | 63662.4 |
306 | 2022-01-19 05:31:22 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
305 | 2022-01-15 23:14:28 | chianti | 1 | 69583 | 2 | 1.326 | 52475.9 |
304 | 2021-12-10 19:57:08 | chianti | 1 | 69583 | 2 | 1.236 | 56296.9 |
303 | 2021-12-08 09:36:39 | chianti | 1 | 69583 | 2 | 1.093 | 63662.4 |
302 | 2021-11-10 19:20:58 | chianti | 1 | 69583 | 2 | 1.170 | 59472.6 |
301 | 2021-10-06 09:47:16 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
300 | 2021-09-21 21:02:25 | chianti | 1 | 69583 | 2 | 1.250 | 55666.4 |
299 | 2021-09-21 03:35:13 | chianti | 1 | 69583 | 2 | 1.360 | 51164.0 |
298 | 2021-09-20 15:41:39 | chianti | 1 | 69583 | 2 | 1.080 | 64428.7 |
297 | 2021-09-13 23:21:33 | chianti | 1 | 69583 | 2 | 1.190 | 58473.1 |
296 | 2021-08-04 10:09:32 | chianti | 3 | 134027 | 116 | 5.986 | 22390.1 |
295 | 2021-07-07 15:33:43 | chianti | 1 | 69583 | 2 | 1.076 | 64668.2 |
294 | 2021-06-19 15:21:32 | chianti | 3 | 134027 | 116 | 6.703 | 19995.1 |
293 | 2021-06-18 19:41:45 | chianti | 3 | 134027 | 116 | 13.593 | 9860.0 |
292 | 2021-06-17 19:30:22 | chianti | 3 | 134027 | 116 | 5.576 | 24036.4 |
291 | 2021-06-16 17:27:56 | chianti | 3 | 134027 | 116 | 6.970 | 19229.1 |
290 | 2021-06-15 10:37:17 | chianti | 3 | 134027 | 116 | 6.936 | 19323.4 |
289 | 2021-06-14 15:59:55 | chianti | 3 | 134027 | 116 | 5.923 | 22628.2 |
288 | 2021-06-13 15:34:06 | chianti | 3 | 134027 | 116 | 6.060 | 22116.7 |
287 | 2021-06-12 17:32:53 | chianti | 3 | 134027 | 116 | 8.970 | 14941.7 |
286 | 2021-06-11 19:25:46 | chianti | 3 | 134027 | 116 | 6.410 | 20909.0 |
285 | 2021-06-11 17:35:06 | chianti | 3 | 134027 | 116 | 6.356 | 21086.7 |
284 | 2021-06-10 18:12:46 | chianti | 3 | 134027 | 116 | 6.796 | 19721.5 |
283 | 2021-06-09 19:39:35 | chianti | 3 | 134027 | 116 | 6.686 | 20045.9 |
282 | 2021-06-03 16:51:18 | chianti | 3 | 134027 | 116 | 7.440 | 18014.4 |
281 | 2021-06-02 23:34:40 | chianti | 3 | 134027 | 116 | 5.936 | 22578.7 |
280 | 2021-06-02 06:42:07 | chianti | 3 | 134027 | 116 | 6.156 | 21771.8 |
279 | 2021-06-01 14:54:00 | chianti | 3 | 134027 | 116 | 6.860 | 19537.5 |
278 | 2021-05-31 18:14:29 | chianti | 3 | 134027 | 116 | 6.390 | 20974.5 |
277 | 2021-05-31 01:14:04 | chianti | 3 | 134027 | 116 | 5.686 | 23571.4 |
276 | 2021-05-29 21:38:09 | chianti | 3 | 134027 | 116 | 6.533 | 20515.4 |
275 | 2021-05-29 12:31:01 | chianti | 3 | 134027 | 116 | 6.753 | 19847.0 |
274 | 2021-05-29 07:09:44 | chianti | 3 | 134027 | 116 | 5.796 | 23124.1 |
273 | 2021-05-28 00:27:09 | chianti | 3 | 134027 | 116 | 6.470 | 20715.1 |
272 | 2021-05-27 06:09:15 | chianti | 3 | 134027 | 116 | 7.016 | 19103.1 |