History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
506 | 2024-04-03 06:29:13 | grist | 1 | 28756 | 9 | 1.716 | 16757.6 |
505 | 2024-03-31 10:40:57 | grist | 2 | 53800 | 165 | 5.626 | 9562.7 |
504 | 2024-03-31 08:02:43 | grist | 1 | 28756 | 9 | 1.013 | 28387.0 |
503 | 2024-03-29 03:05:47 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
502 | 2024-03-27 22:14:56 | grist | 1 | 28756 | 9 | 0.513 | 56054.6 |
501 | 2024-03-27 22:14:46 | grist | 2 | 53800 | 165 | 1.656 | 32487.9 |
500 | 2024-03-27 07:15:28 | grist | 2 | 53800 | 165 | 1.436 | 37465.2 |
499 | 2024-03-04 02:33:07 | grist | 2 | 53800 | 165 | 1.486 | 36204.6 |
498 | 2024-03-04 02:33:04 | grist | 1 | 28756 | 9 | 0.440 | 65354.5 |
497 | 2024-02-27 19:30:31 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
496 | 2024-02-02 21:43:35 | grist | 1 | 28756 | 9 | 0.533 | 53951.2 |
495 | 2024-01-29 14:56:28 | grist | 1 | 28756 | 9 | 0.530 | 54256.6 |
494 | 2024-01-28 17:35:39 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
493 | 2024-01-20 15:57:59 | grist | 1 | 28756 | 9 | 0.580 | 49579.3 |
492 | 2024-01-16 08:36:17 | grist | 2 | 53800 | 165 | 1.576 | 34137.1 |
491 | 2024-01-05 23:58:17 | grist | 2 | 53800 | 165 | 1.360 | 39558.8 |
490 | 2023-12-21 02:22:04 | grist | 2 | 53800 | 165 | 1.420 | 37887.3 |
489 | 2023-12-04 08:15:14 | grist | 2 | 53800 | 165 | 1.640 | 32804.9 |
488 | 2023-12-04 08:15:13 | grist | 2 | 53800 | 165 | 1.626 | 33087.3 |
487 | 2023-12-03 19:41:36 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
486 | 2023-12-03 19:41:35 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
485 | 2023-12-03 03:17:56 | grist | 2 | 53800 | 165 | 1.563 | 34421.0 |
484 | 2023-11-23 21:51:31 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
483 | 2023-11-15 10:16:29 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
482 | 2023-11-12 03:36:57 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
481 | 2023-11-10 10:46:34 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
480 | 2023-11-02 02:50:24 | grist | 1 | 28756 | 9 | 1.016 | 28303.1 |
479 | 2023-10-21 15:55:05 | grist | 1 | 28756 | 9 | 0.956 | 30079.5 |
478 | 2023-10-20 12:17:41 | grist | 2 | 53800 | 165 | 1.720 | 31279.1 |
477 | 2023-10-19 04:03:37 | grist | 2 | 53800 | 165 | 1.343 | 40059.6 |
476 | 2023-10-18 09:51:47 | grist | 1 | 28756 | 9 | 0.530 | 54256.6 |
475 | 2023-10-16 18:27:47 | grist | 2 | 53800 | 165 | 1.390 | 38705.0 |
474 | 2023-10-11 00:38:56 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
473 | 2023-10-05 04:21:56 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
472 | 2023-09-29 10:36:33 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
471 | 2023-09-12 02:02:59 | grist | 1 | 28756 | 9 | 0.546 | 52666.7 |
470 | 2023-09-10 09:55:30 | grist | 1 | 28756 | 9 | 0.516 | 55728.7 |
469 | 2023-09-02 02:51:37 | grist | 2 | 53800 | 165 | 1.530 | 35163.4 |
468 | 2023-07-27 05:42:47 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
467 | 2023-06-20 13:15:31 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
466 | 2023-05-21 20:05:14 | grist | 2 | 53800 | 165 | 1.360 | 39558.8 |
465 | 2023-04-22 16:29:59 | grist | 1 | 28756 | 9 | 0.486 | 59168.7 |
464 | 2023-04-01 22:44:53 | grist | 1 | 28756 | 9 | 0.420 | 68466.7 |
463 | 2023-03-02 04:39:41 | grist | 2 | 53800 | 165 | 1.326 | 40573.2 |
462 | 2023-01-14 17:09:33 | grist | 1 | 28756 | 9 | 0.420 | 68466.7 |
461 | 2023-01-10 06:42:20 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
460 | 2022-12-08 16:08:50 | grist | 2 | 53800 | 165 | 1.326 | 40573.2 |
459 | 2022-11-06 16:20:05 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
458 | 2022-09-26 11:02:04 | grist | 1 | 28756 | 9 | 0.420 | 68466.7 |
457 | 2022-08-26 14:49:54 | grist | 1 | 28756 | 9 | 0.440 | 65354.5 |
456 | 2022-08-01 04:36:40 | grist | 1 | 28756 | 9 | 0.440 | 65354.5 |
455 | 2022-07-21 17:49:09 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
454 | 2022-07-15 19:30:36 | grist | 2 | 53800 | 165 | 1.326 | 40573.2 |
453 | 2022-07-10 02:56:57 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
452 | 2022-07-05 18:11:17 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
451 | 2022-06-27 05:41:09 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
450 | 2022-06-25 08:09:14 | grist | 1 | 28756 | 9 | 0.420 | 68466.7 |
449 | 2022-06-09 11:19:00 | grist | 1 | 28756 | 9 | 0.453 | 63479.0 |
448 | 2022-06-05 20:34:19 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
447 | 2022-03-04 09:05:40 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
446 | 2022-03-02 06:04:58 | grist | 1 | 28756 | 9 | 0.440 | 65354.5 |
445 | 2022-02-22 00:58:46 | grist | 2 | 53800 | 165 | 1.436 | 37465.2 |
444 | 2022-02-15 18:03:38 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
443 | 2021-12-19 03:34:07 | grist | 1 | 28756 | 9 | 0.530 | 54256.6 |
442 | 2021-11-18 05:22:01 | grist | 2 | 53800 | 165 | 1.653 | 32546.9 |
441 | 2021-11-11 03:47:39 | grist | 1 | 28756 | 9 | 0.420 | 68466.7 |
440 | 2021-10-24 03:57:40 | grist | 1 | 28756 | 9 | 0.453 | 63479.0 |
439 | 2021-09-14 07:55:25 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
438 | 2021-09-12 04:21:45 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
437 | 2021-08-23 09:29:38 | grist | 1 | 28756 | 9 | 0.450 | 63902.2 |
436 | 2021-08-08 04:02:34 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
435 | 2021-07-25 16:08:55 | grist | 1 | 28756 | 9 | 0.423 | 67981.1 |
434 | 2021-05-16 01:48:00 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
433 | 2021-04-15 14:33:53 | grist | 1 | 28756 | 9 | 0.516 | 55728.7 |
432 | 2021-04-05 11:15:52 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
431 | 2021-03-18 21:23:01 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
430 | 2021-02-21 17:10:14 | grist | 1 | 28756 | 9 | 0.466 | 61708.2 |
429 | 2020-12-31 01:14:30 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
428 | 2020-12-23 17:20:58 | grist | 2 | 53800 | 165 | 1.610 | 33416.1 |
427 | 2020-11-25 23:36:41 | grist | 1 | 28756 | 9 | 0.440 | 65354.5 |
426 | 2020-11-02 22:16:00 | grist | 2 | 53800 | 165 | 1.546 | 34799.5 |
425 | 2020-11-02 01:31:51 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
424 | 2020-10-14 03:23:28 | grist | 1 | 28756 | 9 | 0.453 | 63479.0 |
423 | 2020-08-26 12:18:39 | grist | 1 | 28756 | 9 | 0.453 | 63479.0 |
422 | 2020-08-19 17:07:59 | grist | 1 | 28756 | 9 | 0.470 | 61183.0 |
421 | 2020-08-12 05:53:44 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
420 | 2020-08-05 11:37:59 | grist | 1 | 28756 | 9 | 0.500 | 57512.0 |
419 | 2020-07-30 22:12:52 | grist | 1 | 28756 | 9 | 0.486 | 59168.7 |
418 | 2020-04-27 19:50:19 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
417 | 2020-03-29 06:44:51 | grist | 1 | 28756 | 9 | 1.030 | 27918.4 |
416 | 2020-03-24 23:14:41 | grist | 1 | 28756 | 9 | 0.436 | 65954.1 |
415 | 2020-03-24 19:16:43 | grist | 1 | 28756 | 9 | 0.466 | 61708.2 |
414 | 2020-03-22 15:36:38 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
413 | 2020-03-22 05:23:02 | grist | 1 | 28756 | 9 | 1.030 | 27918.4 |
412 | 2020-03-21 02:37:45 | grist | 1 | 28756 | 9 | 0.486 | 59168.7 |
411 | 2020-03-18 00:56:35 | grist | 1 | 28756 | 9 | 0.720 | 39938.9 |
410 | 2020-02-24 11:58:39 | grist | 1 | 28756 | 9 | 0.516 | 55728.7 |
409 | 2020-02-24 00:57:49 | grist | 1 | 28756 | 9 | 1.030 | 27918.4 |
408 | 2020-02-22 08:02:00 | grist | 1 | 28756 | 9 | 0.483 | 59536.2 |
407 | 2020-02-18 11:36:40 | grist | 1 | 28756 | 9 | 0.546 | 52666.7 |