History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sewers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
443 | 2024-04-13 07:09:56 | sewers | 1 | 48755 | 13 | 1.856 | 26268.9 |
442 | 2024-03-31 05:06:43 | sewers | 1 | 48755 | 13 | 2.970 | 16415.8 |
441 | 2024-03-29 03:11:02 | sewers | 1 | 48755 | 13 | 1.656 | 29441.4 |
440 | 2024-03-29 03:10:48 | sewers | 2 | 82551 | 140 | 5.923 | 13937.4 |
439 | 2024-03-29 03:10:47 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
438 | 2024-02-28 04:58:35 | sewers | 2 | 82551 | 140 | 3.610 | 22867.3 |
437 | 2024-02-28 02:52:17 | sewers | 2 | 82551 | 140 | 2.516 | 32810.4 |
436 | 2024-02-28 02:03:28 | sewers | 2 | 82551 | 140 | 5.733 | 14399.3 |
435 | 2024-02-28 02:03:22 | sewers | 1 | 48755 | 13 | 2.156 | 22613.6 |
434 | 2024-02-24 00:12:47 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
433 | 2024-01-20 11:56:09 | sewers | 2 | 82551 | 140 | 2.483 | 33246.5 |
432 | 2024-01-07 13:08:53 | sewers | 1 | 48755 | 13 | 0.783 | 62266.9 |
431 | 2023-12-31 15:36:07 | sewers | 2 | 82551 | 140 | 2.203 | 37472.1 |
430 | 2023-12-07 11:59:06 | sewers | 2 | 82551 | 140 | 2.436 | 33887.9 |
429 | 2023-12-05 07:46:47 | sewers | 1 | 48755 | 13 | 0.873 | 55847.7 |
428 | 2023-11-27 06:27:40 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
427 | 2023-11-18 15:37:45 | sewers | 1 | 48755 | 13 | 0.813 | 59969.2 |
426 | 2023-11-10 16:18:17 | sewers | 1 | 48755 | 13 | 0.813 | 59969.2 |
425 | 2023-10-30 19:39:12 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
424 | 2023-10-23 18:43:17 | sewers | 2 | 82551 | 140 | 2.766 | 29844.9 |
423 | 2023-10-22 14:54:32 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
422 | 2023-10-19 17:53:48 | sewers | 1 | 48755 | 13 | 1.313 | 37132.5 |
421 | 2023-10-17 01:54:37 | sewers | 1 | 48755 | 13 | 0.983 | 49598.2 |
420 | 2023-10-13 12:32:52 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
419 | 2023-10-08 05:47:11 | sewers | 1 | 48755 | 13 | 0.766 | 63648.8 |
418 | 2023-09-26 21:10:45 | sewers | 1 | 48755 | 13 | 0.783 | 62266.9 |
417 | 2023-09-18 02:37:18 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
416 | 2023-09-14 09:00:33 | sewers | 1 | 48755 | 13 | 0.920 | 52994.6 |
415 | 2023-09-04 19:23:25 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
414 | 2023-07-07 22:39:44 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
413 | 2023-05-15 15:05:27 | sewers | 1 | 48755 | 13 | 0.783 | 62266.9 |
412 | 2023-05-02 19:54:32 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
411 | 2023-04-11 16:29:43 | sewers | 1 | 48755 | 13 | 0.766 | 63648.8 |
410 | 2023-04-08 10:59:12 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
409 | 2023-02-05 02:18:11 | sewers | 2 | 82551 | 140 | 2.623 | 31472.0 |
408 | 2023-01-29 19:27:30 | sewers | 1 | 48755 | 13 | 0.843 | 57835.1 |
407 | 2023-01-28 18:21:46 | sewers | 1 | 48755 | 13 | 0.780 | 62506.4 |
406 | 2022-12-28 13:47:00 | sewers | 2 | 82551 | 140 | 2.160 | 38218.1 |
405 | 2022-11-27 02:02:18 | sewers | 1 | 48755 | 13 | 0.766 | 63648.8 |
404 | 2022-10-04 16:28:20 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
403 | 2022-07-22 10:43:05 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
402 | 2022-07-19 20:16:34 | sewers | 2 | 82551 | 140 | 2.143 | 38521.2 |
401 | 2022-05-28 01:01:01 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
400 | 2022-03-15 09:06:01 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
399 | 2022-03-06 19:19:45 | sewers | 1 | 48755 | 13 | 0.906 | 53813.5 |
398 | 2022-03-06 15:11:10 | sewers | 1 | 48755 | 13 | 0.843 | 57835.1 |
397 | 2022-02-05 04:05:14 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
396 | 2022-01-30 02:52:57 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
395 | 2022-01-26 16:03:32 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
394 | 2022-01-20 22:59:24 | sewers | 1 | 48755 | 13 | 0.813 | 59969.2 |
393 | 2022-01-17 19:22:45 | sewers | 1 | 48755 | 13 | 0.873 | 55847.7 |
392 | 2022-01-17 04:33:34 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
391 | 2022-01-16 14:05:43 | sewers | 1 | 48755 | 13 | 0.906 | 53813.5 |
390 | 2022-01-16 04:27:49 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
389 | 2022-01-15 20:23:52 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
388 | 2022-01-15 12:34:38 | sewers | 1 | 48755 | 13 | 0.830 | 58741.0 |
387 | 2022-01-14 21:21:25 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
386 | 2022-01-14 13:51:03 | sewers | 1 | 48755 | 13 | 0.906 | 53813.5 |
385 | 2022-01-13 22:40:45 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
384 | 2022-01-08 08:53:25 | sewers | 1 | 48755 | 13 | 0.813 | 59969.2 |
383 | 2022-01-07 19:03:14 | sewers | 1 | 48755 | 13 | 0.893 | 54596.9 |
382 | 2022-01-07 11:14:39 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
381 | 2022-01-06 20:42:05 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
380 | 2021-12-21 09:35:13 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
379 | 2021-11-26 20:37:37 | sewers | 1 | 48755 | 13 | 0.936 | 52088.7 |
378 | 2021-11-25 13:12:06 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
377 | 2021-10-26 08:04:10 | sewers | 1 | 48755 | 13 | 0.923 | 52822.3 |
376 | 2021-10-10 02:06:04 | sewers | 1 | 48755 | 13 | 0.766 | 63648.8 |
375 | 2021-09-21 00:41:02 | sewers | 1 | 48755 | 13 | 1.763 | 27654.6 |
374 | 2021-09-20 07:29:26 | sewers | 1 | 48755 | 13 | 1.186 | 41108.8 |
373 | 2021-09-19 13:04:16 | sewers | 1 | 48755 | 13 | 0.843 | 57835.1 |
372 | 2021-09-16 15:58:39 | sewers | 1 | 48755 | 13 | 0.843 | 57835.1 |
371 | 2021-09-13 06:02:59 | sewers | 1 | 48755 | 13 | 0.766 | 63648.8 |
370 | 2021-08-27 21:28:19 | sewers | 1 | 48755 | 13 | 0.783 | 62266.9 |
369 | 2021-07-08 05:22:49 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
368 | 2021-05-31 07:04:54 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
367 | 2021-04-08 10:03:29 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
366 | 2021-04-04 06:11:10 | sewers | 1 | 48755 | 13 | 0.763 | 63899.1 |
365 | 2021-04-04 05:37:12 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
364 | 2021-02-10 20:07:24 | sewers | 2 | 82551 | 140 | 2.250 | 36689.3 |
363 | 2021-01-19 14:50:18 | sewers | 1 | 48755 | 13 | 0.983 | 49598.2 |
362 | 2020-12-30 05:48:37 | sewers | 1 | 48755 | 13 | 0.860 | 56691.9 |
361 | 2020-11-02 05:06:37 | sewers | 1 | 48755 | 13 | 0.843 | 57835.1 |
360 | 2020-10-15 13:29:22 | sewers | 1 | 48755 | 13 | 1.563 | 31193.2 |
359 | 2020-10-04 23:29:21 | sewers | 1 | 48755 | 13 | 0.750 | 65006.7 |
358 | 2020-09-26 22:35:06 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
357 | 2020-09-07 19:34:47 | sewers | 1 | 48755 | 13 | 0.906 | 53813.5 |
356 | 2020-08-26 21:42:19 | sewers | 1 | 48755 | 13 | 0.876 | 55656.4 |
355 | 2020-06-11 23:59:21 | sewers | 1 | 48755 | 13 | 0.873 | 55847.7 |
354 | 2020-06-09 00:21:57 | sewers | 1 | 48755 | 13 | 0.800 | 60943.8 |
353 | 2020-04-10 15:07:49 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
352 | 2020-03-27 16:14:12 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
351 | 2020-03-24 13:08:34 | sewers | 1 | 48755 | 13 | 0.893 | 54596.9 |
350 | 2020-03-24 08:13:47 | sewers | 1 | 48755 | 13 | 0.796 | 61250.0 |
349 | 2020-03-23 14:01:15 | sewers | 1 | 48755 | 13 | 1.393 | 35000.0 |
348 | 2020-03-22 03:20:41 | sewers | 1 | 48755 | 13 | 0.890 | 54780.9 |
347 | 2020-03-19 20:33:59 | sewers | 1 | 48755 | 13 | 0.923 | 52822.3 |
346 | 2020-03-18 22:04:12 | sewers | 1 | 48755 | 13 | 0.953 | 51159.5 |
345 | 2020-03-04 14:03:21 | sewers | 1 | 48755 | 13 | 1.890 | 25796.3 |
344 | 2020-03-01 16:40:39 | sewers | 1 | 48755 | 13 | 1.563 | 31193.2 |