History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ditch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
523 | 2024-04-28 07:07:01 | ditch | 2 | 53800 | 93 | 1.796 | 29955.5 |
522 | 2024-04-28 01:09:25 | ditch | 3 | 83667 | 674 | 11.470 | 7294.4 |
521 | 2024-04-27 23:00:02 | ditch | 1 | 28756 | 9 | 1.110 | 25906.3 |
520 | 2024-04-27 05:01:47 | ditch | 3 | 83667 | 674 | 9.296 | 9000.3 |
519 | 2024-04-21 01:10:50 | ditch | 1 | 28756 | 9 | 1.563 | 18398.0 |
518 | 2024-04-03 03:24:42 | ditch | 1 | 28756 | 9 | 0.856 | 33593.5 |
517 | 2024-03-31 07:48:33 | ditch | 1 | 28756 | 9 | 0.483 | 59536.2 |
516 | 2024-03-29 19:18:25 | ditch | 2 | 53800 | 93 | 3.266 | 16472.7 |
515 | 2024-03-29 19:17:57 | ditch | 3 | 83667 | 674 | 9.003 | 9293.2 |
514 | 2024-03-29 07:11:43 | ditch | 1 | 28756 | 9 | 1.670 | 17219.2 |
513 | 2024-03-29 02:57:52 | ditch | 2 | 53800 | 93 | 1.783 | 30173.9 |
512 | 2024-03-29 02:57:50 | ditch | 1 | 28756 | 9 | 0.546 | 52666.7 |
511 | 2024-03-29 02:57:32 | ditch | 3 | 83667 | 674 | 4.313 | 19398.8 |
510 | 2024-03-29 02:18:32 | ditch | 3 | 83667 | 674 | 10.706 | 7815.0 |
509 | 2024-03-29 02:18:34 | ditch | 2 | 53800 | 93 | 5.453 | 9866.1 |
508 | 2024-03-29 02:13:50 | ditch | 1 | 28756 | 9 | 0.533 | 53951.2 |
507 | 2024-03-03 21:33:12 | ditch | 1 | 28756 | 9 | 0.513 | 56054.6 |
506 | 2024-03-01 04:12:32 | ditch | 1 | 28756 | 9 | 0.533 | 53951.2 |
505 | 2024-02-27 20:32:43 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
504 | 2024-01-28 22:27:53 | ditch | 1 | 28756 | 9 | 0.470 | 61183.0 |
503 | 2024-01-18 11:52:33 | ditch | 1 | 28756 | 9 | 0.516 | 55728.7 |
502 | 2024-01-16 04:00:03 | ditch | 3 | 83667 | 674 | 3.766 | 22216.4 |
501 | 2024-01-02 23:25:10 | ditch | 2 | 53800 | 93 | 3.296 | 16322.8 |
500 | 2023-12-20 07:25:57 | ditch | 3 | 83667 | 674 | 5.346 | 15650.4 |
499 | 2023-12-19 16:51:29 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
498 | 2023-12-17 21:06:14 | ditch | 3 | 83667 | 674 | 3.923 | 21327.3 |
497 | 2023-12-17 21:06:13 | ditch | 2 | 53800 | 93 | 1.623 | 33148.5 |
496 | 2023-11-17 04:40:24 | ditch | 1 | 28756 | 9 | 0.440 | 65354.5 |
495 | 2023-11-14 15:22:05 | ditch | 2 | 53800 | 93 | 1.673 | 32157.8 |
494 | 2023-11-13 19:58:31 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
493 | 2023-11-12 04:56:03 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
492 | 2023-11-11 19:16:21 | ditch | 1 | 28756 | 9 | 0.470 | 61183.0 |
491 | 2023-11-08 18:19:53 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
490 | 2023-11-04 04:24:47 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
489 | 2023-11-02 14:39:57 | ditch | 3 | 83667 | 674 | 4.250 | 19686.4 |
488 | 2023-10-21 10:17:53 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
487 | 2023-10-17 07:48:57 | ditch | 2 | 53800 | 93 | 1.563 | 34421.0 |
486 | 2023-10-17 07:48:54 | ditch | 3 | 83667 | 674 | 3.780 | 22134.1 |
485 | 2023-10-16 18:31:18 | ditch | 1 | 28756 | 9 | 0.970 | 29645.4 |
484 | 2023-10-13 16:50:18 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
483 | 2023-10-05 14:19:16 | ditch | 3 | 83667 | 674 | 5.813 | 14393.1 |
482 | 2023-10-05 01:56:20 | ditch | 1 | 28756 | 9 | 0.453 | 63479.0 |
481 | 2023-09-30 08:36:04 | ditch | 3 | 83667 | 674 | 4.046 | 20678.9 |
480 | 2023-09-29 05:39:05 | ditch | 1 | 28756 | 9 | 0.483 | 59536.2 |
479 | 2023-09-28 01:17:06 | ditch | 3 | 83667 | 674 | 3.656 | 22884.8 |
478 | 2023-09-21 04:18:13 | ditch | 3 | 83667 | 674 | 3.830 | 21845.2 |
477 | 2023-09-13 12:51:34 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
476 | 2023-09-01 23:33:13 | ditch | 1 | 28756 | 9 | 0.483 | 59536.2 |
475 | 2023-08-05 19:45:26 | ditch | 1 | 28756 | 9 | 0.486 | 59168.7 |
474 | 2023-07-16 07:51:13 | ditch | 3 | 83667 | 674 | 3.373 | 24804.9 |
473 | 2023-07-12 16:13:24 | ditch | 3 | 83667 | 674 | 3.283 | 25484.9 |
472 | 2023-06-29 18:08:37 | ditch | 3 | 83667 | 674 | 3.296 | 25384.4 |
471 | 2023-06-05 07:24:23 | ditch | 1 | 28756 | 9 | 0.420 | 68466.7 |
470 | 2023-04-24 14:47:10 | ditch | 1 | 28756 | 9 | 0.440 | 65354.5 |
469 | 2023-03-27 10:46:33 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
468 | 2023-03-22 23:31:22 | ditch | 3 | 83667 | 674 | 3.486 | 24000.9 |
467 | 2023-01-12 06:12:25 | ditch | 1 | 28756 | 9 | 0.420 | 68466.7 |
466 | 2023-01-10 21:52:45 | ditch | 1 | 28756 | 9 | 0.420 | 68466.7 |
465 | 2022-12-22 02:41:55 | ditch | 3 | 83667 | 674 | 3.826 | 21868.0 |
464 | 2022-11-25 03:21:02 | ditch | 1 | 28756 | 9 | 0.440 | 65354.5 |
463 | 2022-10-26 00:15:51 | ditch | 3 | 83667 | 674 | 3.233 | 25879.1 |
462 | 2022-10-17 04:44:01 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
461 | 2022-09-24 16:53:11 | ditch | 1 | 28756 | 9 | 0.483 | 59536.2 |
460 | 2022-09-21 02:38:59 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
459 | 2022-08-20 01:22:36 | ditch | 3 | 83667 | 674 | 3.346 | 25005.1 |
458 | 2022-08-14 03:27:15 | ditch | 1 | 28756 | 9 | 0.453 | 63479.0 |
457 | 2022-08-07 01:19:48 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
456 | 2022-07-30 02:33:38 | ditch | 1 | 28756 | 9 | 0.440 | 65354.5 |
455 | 2022-07-03 10:18:43 | ditch | 1 | 28756 | 9 | 0.483 | 59536.2 |
454 | 2022-06-16 10:15:56 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
453 | 2022-06-08 12:58:23 | ditch | 1 | 28756 | 9 | 0.470 | 61183.0 |
452 | 2022-05-28 19:33:21 | ditch | 1 | 28756 | 9 | 0.420 | 68466.7 |
451 | 2022-05-26 02:36:20 | ditch | 1 | 28756 | 9 | 0.453 | 63479.0 |
450 | 2022-03-22 09:06:29 | ditch | 3 | 83667 | 674 | 4.046 | 20678.9 |
449 | 2022-03-20 00:54:01 | ditch | 3 | 83667 | 674 | 3.220 | 25983.5 |
448 | 2022-02-11 21:35:02 | ditch | 1 | 28756 | 9 | 0.453 | 63479.0 |
447 | 2022-02-10 10:45:01 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
446 | 2021-11-09 17:50:47 | ditch | 2 | 53800 | 93 | 1.690 | 31834.3 |
445 | 2021-11-02 18:35:52 | ditch | 1 | 28756 | 9 | 0.420 | 68466.7 |
444 | 2021-11-02 09:19:12 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
443 | 2021-10-08 19:49:16 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
442 | 2021-09-17 07:33:29 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
441 | 2021-08-02 23:28:42 | ditch | 1 | 28756 | 9 | 0.530 | 54256.6 |
440 | 2021-07-03 17:36:52 | ditch | 2 | 53800 | 93 | 1.623 | 33148.5 |
439 | 2021-06-29 23:33:03 | ditch | 1 | 28756 | 9 | 0.530 | 54256.6 |
438 | 2021-05-28 19:17:57 | ditch | 3 | 83667 | 674 | 3.876 | 21585.9 |
437 | 2021-05-24 15:08:23 | ditch | 3 | 83667 | 674 | 7.906 | 10582.7 |
436 | 2021-05-19 10:54:18 | ditch | 2 | 53800 | 93 | 1.373 | 39184.3 |
435 | 2021-04-25 02:11:19 | ditch | 1 | 28756 | 9 | 0.500 | 57512.0 |
434 | 2021-04-17 07:28:51 | ditch | 2 | 53800 | 93 | 1.546 | 34799.5 |
433 | 2021-04-11 00:00:00 | ditch | 1 | 28756 | 9 | 0.546 | 52666.7 |
432 | 2021-03-15 00:25:00 | ditch | 1 | 28756 | 9 | 0.513 | 56054.6 |
431 | 2021-02-18 03:00:27 | ditch | 1 | 28756 | 9 | 0.453 | 63479.0 |
430 | 2021-01-29 20:04:48 | ditch | 2 | 53800 | 93 | 1.373 | 39184.3 |
429 | 2021-01-28 15:12:26 | ditch | 3 | 83667 | 674 | 3.893 | 21491.7 |
428 | 2021-01-26 11:05:56 | ditch | 3 | 83667 | 674 | 3.483 | 24021.5 |
427 | 2021-01-20 08:38:29 | ditch | 1 | 28756 | 9 | 0.436 | 65954.1 |
426 | 2021-01-09 17:34:56 | ditch | 3 | 83667 | 674 | 3.750 | 22311.2 |
425 | 2021-01-01 13:43:58 | ditch | 2 | 53800 | 93 | 1.393 | 38621.7 |
424 | 2020-11-26 19:24:49 | ditch | 2 | 53800 | 93 | 1.343 | 40059.6 |