History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smiley"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
497 | 2024-04-27 10:06:05 | smiley | 1 | 48755 | 6 | 1.203 | 40527.8 |
496 | 2024-04-27 08:21:06 | smiley | 1 | 48755 | 6 | 0.906 | 53813.5 |
495 | 2024-04-11 05:01:28 | smiley | 1 | 48755 | 6 | 1.030 | 47335.0 |
494 | 2024-04-03 11:41:04 | smiley | 1 | 48755 | 6 | 3.233 | 15080.4 |
493 | 2024-03-30 01:06:49 | smiley | 1 | 48755 | 6 | 1.970 | 24748.7 |
492 | 2024-03-12 18:29:00 | smiley | 1 | 48755 | 6 | 0.873 | 55847.7 |
491 | 2024-03-04 14:53:44 | smiley | 3 | 112716 | 788 | 15.483 | 7280.0 |
490 | 2024-03-04 07:53:32 | smiley | 3 | 112716 | 788 | 5.606 | 20106.3 |
489 | 2024-03-04 07:53:31 | smiley | 2 | 82551 | 44 | 3.076 | 26837.1 |
488 | 2024-03-04 07:53:28 | smiley | 1 | 48755 | 6 | 0.940 | 51867.0 |
487 | 2024-02-27 13:48:45 | smiley | 3 | 112716 | 788 | 11.156 | 10103.6 |
486 | 2024-02-27 13:48:42 | smiley | 2 | 82551 | 44 | 2.673 | 30883.3 |
485 | 2024-01-15 07:56:56 | smiley | 3 | 112716 | 788 | 4.923 | 22895.8 |
484 | 2024-01-14 21:53:11 | smiley | 3 | 112716 | 788 | 5.673 | 19868.9 |
483 | 2024-01-14 21:53:07 | smiley | 2 | 82551 | 44 | 2.390 | 34540.2 |
482 | 2024-01-07 13:34:48 | smiley | 3 | 112716 | 788 | 5.330 | 21147.5 |
481 | 2024-01-07 13:34:47 | smiley | 2 | 82551 | 44 | 2.296 | 35954.3 |
480 | 2023-12-28 06:44:12 | smiley | 1 | 48755 | 6 | 0.936 | 52088.7 |
479 | 2023-12-26 17:13:11 | smiley | 2 | 82551 | 44 | 2.186 | 37763.5 |
478 | 2023-12-08 19:16:53 | smiley | 3 | 112716 | 788 | 5.626 | 20034.8 |
477 | 2023-11-28 18:26:15 | smiley | 3 | 112716 | 788 | 4.780 | 23580.8 |
476 | 2023-11-28 18:26:11 | smiley | 2 | 82551 | 44 | 2.123 | 38884.1 |
475 | 2023-11-25 22:39:09 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
474 | 2023-11-17 05:56:07 | smiley | 1 | 48755 | 6 | 0.796 | 61250.0 |
473 | 2023-11-14 11:37:45 | smiley | 1 | 48755 | 6 | 0.920 | 52994.6 |
472 | 2023-11-06 23:53:14 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
471 | 2023-10-28 08:23:33 | smiley | 3 | 112716 | 788 | 5.876 | 19182.4 |
470 | 2023-10-22 04:49:37 | smiley | 1 | 48755 | 6 | 0.830 | 58741.0 |
469 | 2023-10-18 23:22:59 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
468 | 2023-10-18 10:08:19 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
467 | 2023-10-13 17:58:13 | smiley | 1 | 48755 | 6 | 0.893 | 54596.9 |
466 | 2023-10-04 13:27:15 | smiley | 1 | 48755 | 6 | 0.813 | 59969.2 |
465 | 2023-10-01 18:55:25 | smiley | 2 | 82551 | 44 | 2.720 | 30349.6 |
464 | 2023-09-28 13:07:55 | smiley | 2 | 82551 | 44 | 2.423 | 34069.7 |
463 | 2023-09-26 01:35:18 | smiley | 1 | 48755 | 6 | 1.063 | 45865.5 |
462 | 2023-09-12 21:00:46 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
461 | 2023-08-14 09:05:51 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
460 | 2023-08-05 05:00:46 | smiley | 3 | 112716 | 788 | 5.453 | 20670.5 |
459 | 2023-07-14 08:40:42 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
458 | 2023-07-10 03:20:00 | smiley | 2 | 82551 | 44 | 2.173 | 37989.4 |
457 | 2023-05-15 00:00:16 | smiley | 1 | 48755 | 6 | 0.733 | 66514.3 |
456 | 2023-04-19 07:20:08 | smiley | 3 | 112716 | 788 | 4.593 | 24540.8 |
455 | 2023-04-17 05:15:55 | smiley | 1 | 48755 | 6 | 0.860 | 56691.9 |
454 | 2023-03-28 01:01:53 | smiley | 2 | 82551 | 44 | 2.060 | 40073.3 |
453 | 2023-03-18 19:24:14 | smiley | 1 | 48755 | 6 | 0.846 | 57630.0 |
452 | 2023-03-09 22:27:18 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
451 | 2023-01-23 18:36:52 | smiley | 3 | 112716 | 788 | 4.563 | 24702.2 |
450 | 2022-12-29 01:11:56 | smiley | 1 | 48755 | 6 | 0.843 | 57835.1 |
449 | 2022-12-24 03:08:01 | smiley | 2 | 82551 | 44 | 2.093 | 39441.5 |
448 | 2022-11-04 15:33:53 | smiley | 3 | 112716 | 788 | 4.953 | 22757.1 |
447 | 2022-10-27 19:00:51 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
446 | 2022-10-24 05:25:55 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
445 | 2022-09-18 11:07:57 | smiley | 1 | 48755 | 6 | 0.810 | 60191.4 |
444 | 2022-09-04 22:05:53 | smiley | 2 | 82551 | 44 | 2.220 | 37185.1 |
443 | 2022-08-24 16:56:55 | smiley | 2 | 82551 | 44 | 2.186 | 37763.5 |
442 | 2022-08-10 17:28:03 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
441 | 2022-08-03 15:06:21 | smiley | 2 | 82551 | 44 | 2.343 | 35233.0 |
440 | 2022-08-03 01:12:50 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
439 | 2022-07-29 08:32:14 | smiley | 1 | 48755 | 6 | 1.500 | 32503.3 |
438 | 2022-07-25 07:37:31 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
437 | 2022-07-19 13:26:15 | smiley | 3 | 112716 | 788 | 4.673 | 24120.7 |
436 | 2022-07-18 20:02:53 | smiley | 1 | 48755 | 6 | 0.783 | 62266.9 |
435 | 2022-07-18 00:12:37 | smiley | 1 | 48755 | 6 | 0.733 | 66514.3 |
434 | 2022-07-16 23:29:52 | smiley | 2 | 82551 | 44 | 2.143 | 38521.2 |
433 | 2022-07-15 23:48:34 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
432 | 2022-07-04 04:15:47 | smiley | 2 | 82551 | 44 | 2.190 | 37694.5 |
431 | 2022-07-03 04:25:07 | smiley | 1 | 48755 | 6 | 0.843 | 57835.1 |
430 | 2022-06-26 17:42:24 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
429 | 2022-06-17 05:20:25 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
428 | 2022-06-08 23:51:14 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
427 | 2022-06-06 15:59:11 | smiley | 3 | 112716 | 788 | 4.560 | 24718.4 |
426 | 2022-06-04 04:53:12 | smiley | 1 | 48755 | 6 | 0.830 | 58741.0 |
425 | 2022-04-29 23:43:00 | smiley | 1 | 48755 | 6 | 0.763 | 63899.1 |
424 | 2022-04-27 18:19:05 | smiley | 1 | 48755 | 6 | 0.813 | 59969.2 |
423 | 2022-03-15 15:50:29 | smiley | 2 | 82551 | 44 | 2.766 | 29844.9 |
422 | 2022-02-24 18:07:18 | smiley | 1 | 48755 | 6 | 1.000 | 48755.0 |
421 | 2022-02-01 10:37:23 | smiley | 3 | 112716 | 788 | 5.846 | 19280.9 |
420 | 2022-01-23 08:59:36 | smiley | 1 | 48755 | 6 | 0.843 | 57835.1 |
419 | 2021-11-24 19:05:07 | smiley | 1 | 48755 | 6 | 0.813 | 59969.2 |
418 | 2021-11-15 01:56:13 | smiley | 3 | 112716 | 788 | 4.800 | 23482.5 |
417 | 2021-11-14 17:58:52 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
416 | 2021-10-30 20:22:53 | smiley | 1 | 48755 | 6 | 0.876 | 55656.4 |
415 | 2021-10-27 10:21:56 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
414 | 2021-10-02 12:46:00 | smiley | 1 | 48755 | 6 | 0.783 | 62266.9 |
413 | 2021-09-13 06:18:01 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
412 | 2021-07-13 11:42:16 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
411 | 2021-04-10 02:43:18 | smiley | 1 | 48755 | 6 | 0.856 | 56956.8 |
410 | 2021-03-23 12:53:04 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
409 | 2021-02-02 18:50:25 | smiley | 1 | 48755 | 6 | 0.843 | 57835.1 |
408 | 2021-01-31 03:42:45 | smiley | 1 | 48755 | 6 | 0.763 | 63899.1 |
407 | 2021-01-07 01:48:58 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
406 | 2021-01-05 15:45:14 | smiley | 1 | 48755 | 6 | 0.843 | 57835.1 |
405 | 2021-01-04 11:30:17 | smiley | 1 | 48755 | 6 | 0.783 | 62266.9 |
404 | 2020-11-11 15:24:31 | smiley | 1 | 48755 | 6 | 0.750 | 65006.7 |
403 | 2020-11-01 21:34:15 | smiley | 2 | 82551 | 44 | 4.640 | 17791.2 |
402 | 2020-10-02 23:49:59 | smiley | 1 | 48755 | 6 | 0.830 | 58741.0 |
401 | 2020-09-23 13:04:35 | smiley | 1 | 48755 | 6 | 0.830 | 58741.0 |
400 | 2020-09-13 02:34:11 | smiley | 1 | 48755 | 6 | 0.826 | 59025.4 |
399 | 2020-08-07 09:57:43 | smiley | 1 | 48755 | 6 | 0.766 | 63648.8 |
398 | 2020-07-31 22:13:47 | smiley | 1 | 48755 | 6 | 0.906 | 53813.5 |