History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spouts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
397 | 2024-05-04 09:52:45 | spouts | 1 | 48755 | 10 | 0.953 | 51159.5 |
396 | 2024-04-27 08:39:27 | spouts | 1 | 48755 | 10 | 2.813 | 17332.0 |
395 | 2024-04-08 16:30:31 | spouts | 1 | 48755 | 10 | 3.046 | 16006.2 |
394 | 2024-04-03 09:31:42 | spouts | 2 | 82551 | 117 | 6.800 | 12139.9 |
393 | 2024-04-03 09:31:38 | spouts | 1 | 48755 | 10 | 0.876 | 55656.4 |
392 | 2024-04-03 09:31:29 | spouts | 2 | 82551 | 117 | 2.936 | 28116.8 |
391 | 2024-04-03 08:30:38 | spouts | 2 | 82551 | 117 | 3.503 | 23565.8 |
390 | 2024-04-03 06:32:34 | spouts | 1 | 48755 | 10 | 0.970 | 50262.9 |
389 | 2024-03-31 17:27:39 | spouts | 1 | 48755 | 10 | 0.983 | 49598.2 |
388 | 2024-03-04 04:13:02 | spouts | 2 | 82551 | 117 | 5.796 | 14242.8 |
387 | 2024-03-04 04:12:57 | spouts | 1 | 48755 | 10 | 1.983 | 24586.5 |
386 | 2024-02-25 22:37:10 | spouts | 2 | 82551 | 117 | 6.233 | 13244.2 |
385 | 2024-02-25 22:36:10 | spouts | 1 | 48755 | 10 | 1.173 | 41564.4 |
384 | 2024-02-05 20:47:58 | spouts | 1 | 48755 | 10 | 0.890 | 54780.9 |
383 | 2024-01-23 02:53:26 | spouts | 1 | 48755 | 10 | 0.906 | 53813.5 |
382 | 2024-01-20 01:13:53 | spouts | 1 | 48755 | 10 | 0.906 | 53813.5 |
381 | 2024-01-08 15:50:53 | spouts | 2 | 82551 | 117 | 5.063 | 16304.8 |
380 | 2024-01-06 20:44:46 | spouts | 1 | 48755 | 10 | 0.780 | 62506.4 |
379 | 2023-12-08 13:33:24 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
378 | 2023-12-07 05:37:22 | spouts | 2 | 82551 | 117 | 2.203 | 37472.1 |
377 | 2023-11-18 05:48:22 | spouts | 1 | 48755 | 10 | 0.906 | 53813.5 |
376 | 2023-11-17 17:47:29 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
375 | 2023-11-16 20:55:45 | spouts | 2 | 82551 | 117 | 4.500 | 18344.7 |
374 | 2023-11-10 16:34:19 | spouts | 1 | 48755 | 10 | 0.813 | 59969.2 |
373 | 2023-11-06 15:54:17 | spouts | 2 | 82551 | 117 | 2.326 | 35490.5 |
372 | 2023-11-01 00:32:43 | spouts | 1 | 48755 | 10 | 0.813 | 59969.2 |
371 | 2023-10-31 22:46:39 | spouts | 1 | 48755 | 10 | 0.783 | 62266.9 |
370 | 2023-10-21 18:00:44 | spouts | 1 | 48755 | 10 | 0.796 | 61250.0 |
369 | 2023-10-14 06:30:41 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
368 | 2023-10-07 07:14:09 | spouts | 1 | 48755 | 10 | 0.890 | 54780.9 |
367 | 2023-09-26 05:31:22 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
366 | 2023-09-14 02:06:13 | spouts | 1 | 48755 | 10 | 0.780 | 62506.4 |
365 | 2023-09-12 07:35:05 | spouts | 1 | 48755 | 10 | 0.846 | 57630.0 |
364 | 2023-09-11 10:16:35 | spouts | 2 | 82551 | 117 | 2.530 | 32628.9 |
363 | 2023-09-05 13:41:42 | spouts | 2 | 82551 | 117 | 2.123 | 38884.1 |
362 | 2023-09-04 05:23:18 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
361 | 2023-05-24 12:42:52 | spouts | 2 | 82551 | 117 | 2.440 | 33832.4 |
360 | 2023-05-09 02:28:28 | spouts | 1 | 48755 | 10 | 0.736 | 66243.2 |
359 | 2023-03-04 01:37:28 | spouts | 2 | 82551 | 117 | 2.406 | 34310.5 |
358 | 2023-03-01 00:23:41 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
357 | 2023-01-08 05:45:29 | spouts | 1 | 48755 | 10 | 0.736 | 66243.2 |
356 | 2022-12-25 04:33:17 | spouts | 1 | 48755 | 10 | 0.830 | 58741.0 |
355 | 2022-12-10 08:38:27 | spouts | 2 | 82551 | 117 | 2.173 | 37989.4 |
354 | 2022-09-13 00:41:05 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
353 | 2022-09-01 07:35:53 | spouts | 2 | 82551 | 117 | 2.250 | 36689.3 |
352 | 2022-08-24 04:04:34 | spouts | 1 | 48755 | 10 | 0.763 | 63899.1 |
351 | 2022-07-27 07:41:05 | spouts | 2 | 82551 | 117 | 2.126 | 38829.3 |
350 | 2022-07-25 01:19:06 | spouts | 2 | 82551 | 117 | 2.220 | 37185.1 |
349 | 2022-07-13 12:59:52 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
348 | 2022-04-06 03:36:39 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
347 | 2022-03-13 17:45:27 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
346 | 2022-02-26 08:57:23 | spouts | 2 | 82551 | 117 | 2.513 | 32849.6 |
345 | 2021-12-26 03:59:03 | spouts | 1 | 48755 | 10 | 0.796 | 61250.0 |
344 | 2021-12-24 01:40:17 | spouts | 1 | 48755 | 10 | 0.876 | 55656.4 |
343 | 2021-12-09 17:54:08 | spouts | 1 | 48755 | 10 | 1.700 | 28679.4 |
342 | 2021-11-29 08:35:21 | spouts | 1 | 48755 | 10 | 0.876 | 55656.4 |
341 | 2021-11-26 13:04:46 | spouts | 2 | 82551 | 117 | 2.186 | 37763.5 |
340 | 2021-10-28 21:18:39 | spouts | 1 | 48755 | 10 | 0.873 | 55847.7 |
339 | 2021-09-15 00:42:07 | spouts | 1 | 48755 | 10 | 1.673 | 29142.3 |
338 | 2021-08-28 10:24:26 | spouts | 1 | 48755 | 10 | 0.796 | 61250.0 |
337 | 2021-08-09 16:37:19 | spouts | 1 | 48755 | 10 | 0.780 | 62506.4 |
336 | 2021-05-24 07:23:53 | spouts | 1 | 48755 | 10 | 0.910 | 53576.9 |
335 | 2021-05-06 07:55:33 | spouts | 1 | 48755 | 10 | 0.890 | 54780.9 |
334 | 2021-04-27 10:33:15 | spouts | 1 | 48755 | 10 | 1.016 | 47987.2 |
333 | 2021-04-24 17:31:27 | spouts | 1 | 48755 | 10 | 0.780 | 62506.4 |
332 | 2021-01-10 21:14:16 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
331 | 2021-01-03 17:58:38 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
330 | 2020-10-31 00:09:01 | spouts | 1 | 48755 | 10 | 0.830 | 58741.0 |
329 | 2020-10-30 21:45:43 | spouts | 1 | 48755 | 10 | 0.906 | 53813.5 |
328 | 2020-10-23 04:23:09 | spouts | 1 | 48755 | 10 | 0.873 | 55847.7 |
327 | 2020-10-22 19:46:28 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
326 | 2020-10-21 14:56:24 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
325 | 2020-09-19 17:49:32 | spouts | 1 | 48755 | 10 | 0.733 | 66514.3 |
324 | 2020-06-15 06:26:21 | spouts | 1 | 48755 | 10 | 0.826 | 59025.4 |
323 | 2020-05-28 10:46:17 | spouts | 1 | 48755 | 10 | 0.750 | 65006.7 |
322 | 2020-03-27 22:03:33 | spouts | 1 | 48755 | 10 | 0.876 | 55656.4 |
321 | 2020-03-25 04:56:40 | spouts | 1 | 48755 | 10 | 0.893 | 54596.9 |
320 | 2020-03-23 22:15:50 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
319 | 2020-03-21 16:59:28 | spouts | 1 | 48755 | 10 | 0.766 | 63648.8 |
318 | 2020-03-19 21:17:59 | spouts | 1 | 48755 | 10 | 0.906 | 53813.5 |
317 | 2020-03-18 22:04:23 | spouts | 1 | 48755 | 10 | 0.796 | 61250.0 |
316 | 2020-03-12 01:38:59 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
315 | 2020-03-06 03:10:56 | spouts | 1 | 48755 | 10 | 0.876 | 55656.4 |
314 | 2020-02-24 20:13:05 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
313 | 2020-02-23 05:45:23 | spouts | 1 | 48755 | 10 | 1.016 | 47987.2 |
312 | 2020-02-19 10:30:56 | spouts | 1 | 48755 | 10 | 0.903 | 53992.2 |
311 | 2020-02-19 06:51:05 | spouts | 1 | 48755 | 10 | 2.906 | 16777.4 |
310 | 2020-02-18 16:25:42 | spouts | 1 | 48755 | 10 | 0.843 | 57835.1 |
309 | 2020-02-01 05:40:01 | spouts | 1 | 48755 | 10 | 0.890 | 54780.9 |
308 | 2020-02-01 05:17:11 | spouts | 1 | 48755 | 10 | 1.000 | 48755.0 |
307 | 2020-01-31 17:01:31 | spouts | 1 | 48755 | 10 | 2.873 | 16970.1 |
306 | 2020-01-26 13:02:06 | spouts | 1 | 48755 | 10 | 1.923 | 25353.6 |
305 | 2020-01-25 09:16:28 | spouts | 1 | 48755 | 10 | 1.983 | 24586.5 |
304 | 2020-01-22 16:39:52 | spouts | 1 | 48755 | 10 | 0.893 | 54596.9 |
303 | 2020-01-13 05:56:49 | spouts | 1 | 48755 | 10 | 0.936 | 52088.7 |
302 | 2020-01-13 02:39:35 | spouts | 1 | 48755 | 10 | 0.890 | 54780.9 |
301 | 2020-01-08 22:03:27 | spouts | 1 | 48755 | 10 | 2.970 | 16415.8 |
300 | 2020-01-05 15:09:30 | spouts | 1 | 48755 | 10 | 0.826 | 59025.4 |
299 | 2020-01-04 18:23:28 | spouts | 1 | 48755 | 10 | 0.780 | 62506.4 |
298 | 2019-12-27 13:33:12 | spouts | 1 | 48755 | 10 | 0.893 | 54596.9 |