History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"larch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
516 | 2024-04-28 04:44:01 | larch | 1 | 28756 | 7 | 0.560 | 51350.0 |
515 | 2024-04-04 23:02:35 | larch | 1 | 28756 | 7 | 1.873 | 15352.9 |
514 | 2024-04-03 03:38:07 | larch | 1 | 28756 | 7 | 1.220 | 23570.5 |
513 | 2024-04-02 23:35:44 | larch | 2 | 53800 | 102 | 6.063 | 8873.5 |
512 | 2024-04-02 15:30:32 | larch | 2 | 53800 | 102 | 1.516 | 35488.1 |
511 | 2024-03-31 07:45:42 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
510 | 2024-03-29 08:22:37 | larch | 1 | 28756 | 7 | 1.670 | 17219.2 |
509 | 2024-03-03 21:30:47 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
508 | 2024-03-01 16:41:35 | larch | 1 | 28756 | 7 | 0.576 | 49923.6 |
507 | 2024-03-01 04:05:25 | larch | 1 | 28756 | 7 | 0.530 | 54256.6 |
506 | 2024-02-28 02:33:18 | larch | 2 | 53800 | 102 | 1.420 | 37887.3 |
505 | 2024-02-28 02:33:16 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
504 | 2024-01-30 23:19:41 | larch | 1 | 28756 | 7 | 1.123 | 25606.4 |
503 | 2024-01-28 22:11:25 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
502 | 2023-12-14 12:34:33 | larch | 2 | 53800 | 102 | 1.640 | 32804.9 |
501 | 2023-12-08 10:10:07 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
500 | 2023-12-07 03:41:17 | larch | 2 | 53800 | 102 | 1.656 | 32487.9 |
499 | 2023-12-05 23:55:17 | larch | 2 | 53800 | 102 | 1.530 | 35163.4 |
498 | 2023-11-13 19:59:13 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
497 | 2023-11-11 21:41:39 | larch | 1 | 28756 | 7 | 0.440 | 65354.5 |
496 | 2023-11-10 17:43:44 | larch | 2 | 53800 | 102 | 1.826 | 29463.3 |
495 | 2023-11-03 12:48:02 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
494 | 2023-10-21 09:27:11 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
493 | 2023-10-17 16:37:15 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
492 | 2023-10-17 10:05:39 | larch | 2 | 53800 | 102 | 1.610 | 33416.1 |
491 | 2023-10-10 23:37:28 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
490 | 2023-10-08 20:02:24 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
489 | 2023-10-05 06:46:12 | larch | 1 | 28756 | 7 | 0.530 | 54256.6 |
488 | 2023-09-27 08:29:03 | larch | 1 | 28756 | 7 | 1.093 | 26309.2 |
487 | 2023-09-21 05:33:59 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
486 | 2023-09-13 16:25:07 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
485 | 2023-09-03 06:11:42 | larch | 2 | 53800 | 102 | 1.593 | 33772.8 |
484 | 2023-07-12 14:31:05 | larch | 1 | 28756 | 7 | 0.450 | 63902.2 |
483 | 2023-06-18 14:12:27 | larch | 1 | 28756 | 7 | 0.483 | 59536.2 |
482 | 2023-04-17 23:32:34 | larch | 1 | 28756 | 7 | 0.623 | 46157.3 |
481 | 2023-03-02 23:48:10 | larch | 1 | 28756 | 7 | 0.533 | 53951.2 |
480 | 2023-02-09 15:53:37 | larch | 1 | 28756 | 7 | 0.483 | 59536.2 |
479 | 2023-02-04 07:56:16 | larch | 2 | 53800 | 102 | 1.640 | 32804.9 |
478 | 2022-12-07 11:25:03 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
477 | 2022-11-25 07:47:59 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
476 | 2022-11-17 03:03:53 | larch | 2 | 53800 | 102 | 1.716 | 31352.0 |
475 | 2022-11-10 13:41:48 | larch | 1 | 28756 | 7 | 0.486 | 59168.7 |
474 | 2022-09-19 12:56:46 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
473 | 2022-08-23 08:06:48 | larch | 1 | 28756 | 7 | 0.483 | 59536.2 |
472 | 2022-08-15 23:38:32 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
471 | 2022-08-14 16:00:36 | larch | 1 | 28756 | 7 | 0.513 | 56054.6 |
470 | 2022-08-06 01:05:38 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
469 | 2022-07-30 09:25:45 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
468 | 2022-07-29 00:12:47 | larch | 1 | 28756 | 7 | 0.483 | 59536.2 |
467 | 2022-07-25 02:38:32 | larch | 1 | 28756 | 7 | 0.483 | 59536.2 |
466 | 2022-06-20 20:20:28 | larch | 2 | 53800 | 102 | 1.406 | 38264.6 |
465 | 2022-04-03 02:15:12 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
464 | 2022-04-02 03:30:20 | larch | 1 | 28756 | 7 | 0.486 | 59168.7 |
463 | 2022-02-04 11:25:45 | larch | 2 | 53800 | 102 | 1.670 | 32215.6 |
462 | 2022-01-01 15:21:48 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
461 | 2021-12-12 22:38:34 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
460 | 2021-12-09 17:13:55 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
459 | 2021-11-07 15:54:01 | larch | 2 | 53800 | 102 | 1.390 | 38705.0 |
458 | 2021-11-06 05:37:34 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
457 | 2021-11-05 14:54:18 | larch | 2 | 53800 | 102 | 1.876 | 28678.0 |
456 | 2021-09-27 22:46:57 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
455 | 2021-09-25 19:07:47 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
454 | 2021-09-02 09:11:25 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
453 | 2021-08-30 02:05:44 | larch | 2 | 53800 | 102 | 1.436 | 37465.2 |
452 | 2021-08-30 02:04:44 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
451 | 2021-08-19 19:53:59 | larch | 1 | 28756 | 7 | 0.533 | 53951.2 |
450 | 2021-08-17 16:12:50 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
449 | 2021-08-07 01:09:54 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
448 | 2021-06-05 02:21:19 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
447 | 2021-05-29 09:58:02 | larch | 1 | 28756 | 7 | 1.046 | 27491.4 |
446 | 2021-05-10 21:20:03 | larch | 1 | 28756 | 7 | 0.533 | 53951.2 |
445 | 2021-04-09 15:14:47 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
444 | 2021-02-26 14:17:42 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
443 | 2021-01-24 06:45:43 | larch | 1 | 28756 | 7 | 0.440 | 65354.5 |
442 | 2020-11-29 00:13:26 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
441 | 2020-11-21 19:29:20 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
440 | 2020-10-30 00:01:46 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
439 | 2020-10-05 04:01:09 | larch | 1 | 28756 | 7 | 0.436 | 65954.1 |
438 | 2020-09-18 12:03:33 | larch | 1 | 28756 | 7 | 0.466 | 61708.2 |
437 | 2020-08-29 03:10:44 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
436 | 2020-08-25 09:49:18 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
435 | 2020-08-23 05:09:43 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
434 | 2020-08-17 18:05:52 | larch | 1 | 28756 | 7 | 0.486 | 59168.7 |
433 | 2020-08-16 05:02:34 | larch | 1 | 28756 | 7 | 0.516 | 55728.7 |
432 | 2020-08-13 08:36:41 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
431 | 2020-07-26 10:24:43 | larch | 1 | 28756 | 7 | 0.546 | 52666.7 |
430 | 2020-07-23 20:40:54 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
429 | 2020-05-19 15:38:08 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
428 | 2020-05-12 18:25:39 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
427 | 2020-03-25 12:45:54 | larch | 1 | 28756 | 7 | 1.060 | 27128.3 |
426 | 2020-03-25 03:33:48 | larch | 1 | 28756 | 7 | 0.580 | 49579.3 |
425 | 2020-03-23 12:26:52 | larch | 1 | 28756 | 7 | 0.513 | 56054.6 |
424 | 2020-03-22 07:18:55 | larch | 1 | 28756 | 7 | 0.533 | 53951.2 |
423 | 2020-03-22 06:32:11 | larch | 1 | 28756 | 7 | 0.453 | 63479.0 |
422 | 2020-03-21 03:59:07 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |
421 | 2020-03-18 00:30:18 | larch | 1 | 28756 | 7 | 0.470 | 61183.0 |
420 | 2020-02-23 21:20:50 | larch | 1 | 28756 | 7 | 0.546 | 52666.7 |
419 | 2020-02-20 10:23:03 | larch | 1 | 28756 | 7 | 1.033 | 27837.4 |
418 | 2020-02-18 01:55:15 | larch | 1 | 28756 | 7 | 0.456 | 63061.4 |
417 | 2020-02-16 16:51:16 | larch | 1 | 28756 | 7 | 0.500 | 57512.0 |