History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spotty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
434 | 2024-04-20 19:21:47 | spotty | 3 | 112716 | 453 | 22.363 | 5040.3 |
433 | 2024-04-20 18:41:35 | spotty | 3 | 112716 | 453 | 9.516 | 11844.9 |
432 | 2024-04-20 18:41:30 | spotty | 1 | 48755 | 4 | 1.296 | 37619.6 |
431 | 2024-04-03 01:08:21 | spotty | 1 | 48755 | 4 | 2.376 | 20519.8 |
430 | 2024-03-31 07:04:21 | spotty | 1 | 48755 | 4 | 1.436 | 33951.9 |
429 | 2024-03-31 03:33:07 | spotty | 2 | 82551 | 44 | 4.173 | 19782.2 |
428 | 2024-03-31 03:32:45 | spotty | 3 | 112716 | 453 | 6.156 | 18309.9 |
427 | 2024-03-30 07:55:39 | spotty | 3 | 112716 | 453 | 6.203 | 18171.2 |
426 | 2024-03-29 09:07:25 | spotty | 2 | 82551 | 44 | 2.813 | 29346.2 |
425 | 2024-03-25 07:46:25 | spotty | 2 | 82551 | 44 | 2.220 | 37185.1 |
424 | 2024-03-22 05:07:33 | spotty | 2 | 82551 | 44 | 4.906 | 16826.5 |
423 | 2024-03-22 05:07:11 | spotty | 3 | 112716 | 453 | 6.623 | 17018.9 |
422 | 2024-03-20 18:18:02 | spotty | 3 | 112716 | 453 | 5.860 | 19234.8 |
421 | 2024-03-20 02:22:40 | spotty | 3 | 112716 | 453 | 9.796 | 11506.3 |
420 | 2024-03-20 02:22:33 | spotty | 1 | 48755 | 4 | 0.940 | 51867.0 |
419 | 2024-03-07 05:50:27 | spotty | 1 | 48755 | 4 | 1.936 | 25183.4 |
418 | 2024-02-28 01:24:15 | spotty | 2 | 82551 | 44 | 2.826 | 29211.3 |
417 | 2024-02-18 18:52:00 | spotty | 1 | 48755 | 4 | 1.203 | 40527.8 |
416 | 2024-02-07 04:02:10 | spotty | 2 | 82551 | 44 | 3.610 | 22867.3 |
415 | 2024-02-07 04:01:46 | spotty | 3 | 112716 | 453 | 5.576 | 20214.5 |
414 | 2024-02-05 14:21:10 | spotty | 3 | 112716 | 453 | 11.750 | 9592.9 |
413 | 2024-02-05 04:54:09 | spotty | 1 | 48755 | 4 | 1.033 | 47197.5 |
412 | 2024-02-05 04:53:21 | spotty | 3 | 112716 | 453 | 10.656 | 10577.7 |
411 | 2024-02-05 04:53:17 | spotty | 2 | 82551 | 44 | 3.453 | 23907.0 |
410 | 2024-01-21 09:45:57 | spotty | 2 | 82551 | 44 | 2.186 | 37763.5 |
409 | 2024-01-19 06:15:18 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
408 | 2024-01-15 08:31:29 | spotty | 3 | 112716 | 453 | 5.156 | 21861.1 |
407 | 2024-01-15 08:31:28 | spotty | 2 | 82551 | 44 | 2.423 | 34069.7 |
406 | 2024-01-03 16:54:20 | spotty | 1 | 48755 | 4 | 0.826 | 59025.4 |
405 | 2023-12-21 15:50:46 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
404 | 2023-12-01 23:38:34 | spotty | 2 | 82551 | 44 | 2.236 | 36919.1 |
403 | 2023-11-18 14:29:14 | spotty | 1 | 48755 | 4 | 0.860 | 56691.9 |
402 | 2023-11-16 07:04:04 | spotty | 1 | 48755 | 4 | 0.846 | 57630.0 |
401 | 2023-11-03 02:55:31 | spotty | 1 | 48755 | 4 | 0.813 | 59969.2 |
400 | 2023-10-25 21:53:48 | spotty | 1 | 48755 | 4 | 0.766 | 63648.8 |
399 | 2023-10-13 15:41:41 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
398 | 2023-10-09 23:46:01 | spotty | 1 | 48755 | 4 | 0.890 | 54780.9 |
397 | 2023-10-09 07:57:29 | spotty | 1 | 48755 | 4 | 0.800 | 60943.8 |
396 | 2023-10-06 16:50:44 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
395 | 2023-09-27 05:01:19 | spotty | 1 | 48755 | 4 | 0.876 | 55656.4 |
394 | 2023-09-13 12:50:39 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
393 | 2023-08-31 04:15:26 | spotty | 2 | 82551 | 44 | 2.093 | 39441.5 |
392 | 2023-08-05 09:24:12 | spotty | 1 | 48755 | 4 | 0.826 | 59025.4 |
391 | 2023-05-24 13:20:51 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
390 | 2023-05-18 22:35:20 | spotty | 2 | 82551 | 44 | 2.093 | 39441.5 |
389 | 2023-05-06 13:15:22 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
388 | 2023-02-28 05:36:01 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
387 | 2023-02-24 03:01:58 | spotty | 2 | 82551 | 44 | 2.110 | 39123.7 |
386 | 2023-01-17 11:16:18 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
385 | 2023-01-13 18:07:17 | spotty | 1 | 48755 | 4 | 0.733 | 66514.3 |
384 | 2022-12-25 00:00:09 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
383 | 2022-12-06 21:15:22 | spotty | 2 | 82551 | 44 | 2.110 | 39123.7 |
382 | 2022-09-12 03:07:58 | spotty | 1 | 48755 | 4 | 0.733 | 66514.3 |
381 | 2022-09-04 17:43:36 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
380 | 2022-09-01 21:57:03 | spotty | 1 | 48755 | 4 | 0.860 | 56691.9 |
379 | 2022-04-21 14:57:49 | spotty | 1 | 48755 | 4 | 1.080 | 45143.5 |
378 | 2022-04-21 05:52:55 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
377 | 2022-04-06 08:45:48 | spotty | 2 | 82551 | 44 | 2.953 | 27955.0 |
376 | 2022-01-16 23:19:43 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
375 | 2021-12-17 08:18:50 | spotty | 1 | 48755 | 4 | 0.903 | 53992.2 |
374 | 2021-11-08 15:32:12 | spotty | 1 | 48755 | 4 | 0.733 | 66514.3 |
373 | 2021-09-28 07:28:31 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
372 | 2021-09-26 04:35:31 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
371 | 2021-09-24 00:37:49 | spotty | 1 | 48755 | 4 | 0.736 | 66243.2 |
370 | 2021-09-06 19:59:17 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
369 | 2021-08-14 15:22:23 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
368 | 2021-06-22 05:24:21 | spotty | 1 | 48755 | 4 | 0.890 | 54780.9 |
367 | 2021-06-08 08:24:30 | spotty | 2 | 82551 | 44 | 2.110 | 39123.7 |
366 | 2021-04-26 12:00:36 | spotty | 1 | 48755 | 4 | 0.890 | 54780.9 |
365 | 2021-03-17 06:53:21 | spotty | 2 | 82551 | 44 | 2.110 | 39123.7 |
364 | 2021-02-20 05:15:33 | spotty | 2 | 82551 | 44 | 2.406 | 34310.5 |
363 | 2021-02-11 07:48:05 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
362 | 2021-01-09 22:57:37 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
361 | 2021-01-05 12:57:48 | spotty | 1 | 48755 | 4 | 0.830 | 58741.0 |
360 | 2020-11-23 10:22:33 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
359 | 2020-11-07 17:39:28 | spotty | 2 | 82551 | 44 | 2.340 | 35278.2 |
358 | 2020-10-18 04:32:21 | spotty | 1 | 48755 | 4 | 0.873 | 55847.7 |
357 | 2020-10-15 09:48:34 | spotty | 1 | 48755 | 4 | 0.936 | 52088.7 |
356 | 2020-09-29 18:16:32 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
355 | 2020-09-20 03:27:06 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
354 | 2020-09-12 11:23:32 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
353 | 2020-08-31 01:36:18 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
352 | 2020-08-10 22:42:59 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
351 | 2020-08-07 15:52:10 | spotty | 1 | 48755 | 4 | 0.766 | 63648.8 |
350 | 2020-07-17 12:43:44 | spotty | 1 | 48755 | 4 | 0.936 | 52088.7 |
349 | 2020-06-14 06:13:24 | spotty | 1 | 48755 | 4 | 0.766 | 63648.8 |
348 | 2020-06-13 05:31:18 | spotty | 1 | 48755 | 4 | 0.813 | 59969.2 |
347 | 2020-06-10 01:27:13 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
346 | 2020-06-09 01:09:36 | spotty | 1 | 48755 | 4 | 0.780 | 62506.4 |
345 | 2020-06-08 01:25:24 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
344 | 2020-06-07 23:10:54 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
343 | 2020-06-02 07:30:57 | spotty | 1 | 48755 | 4 | 0.796 | 61250.0 |
342 | 2020-06-01 08:07:56 | spotty | 1 | 48755 | 4 | 0.830 | 58741.0 |
341 | 2020-05-01 03:43:23 | spotty | 1 | 48755 | 4 | 0.860 | 56691.9 |
340 | 2020-04-22 04:06:51 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
339 | 2020-04-18 11:27:10 | spotty | 1 | 48755 | 4 | 0.763 | 63899.1 |
338 | 2020-04-17 12:14:54 | spotty | 1 | 48755 | 4 | 0.923 | 52822.3 |
337 | 2020-04-16 12:14:01 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |
336 | 2020-03-27 21:32:34 | spotty | 1 | 48755 | 4 | 0.783 | 62266.9 |
335 | 2020-03-26 05:10:09 | spotty | 1 | 48755 | 4 | 0.750 | 65006.7 |