History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hymns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
509 | 2024-04-25 17:16:57 | hymns | 3 | 83667 | 957 | 9.610 | 8706.2 |
508 | 2024-04-24 18:20:44 | hymns | 3 | 83667 | 957 | 4.110 | 20356.9 |
507 | 2024-04-19 14:26:53 | hymns | 1 | 28756 | 3 | 0.560 | 51350.0 |
506 | 2024-04-05 17:19:07 | hymns | 1 | 28756 | 3 | 1.390 | 20687.8 |
505 | 2024-04-01 17:50:42 | hymns | 2 | 53800 | 52 | 3.563 | 15099.6 |
504 | 2024-03-31 17:58:40 | hymns | 3 | 83667 | 957 | 8.873 | 9429.4 |
503 | 2024-03-31 17:58:43 | hymns | 2 | 53800 | 52 | 6.783 | 7931.6 |
502 | 2024-03-31 16:28:24 | hymns | 1 | 28756 | 3 | 0.500 | 57512.0 |
501 | 2024-03-28 22:13:36 | hymns | 3 | 83667 | 957 | 11.423 | 7324.4 |
500 | 2024-03-28 19:37:55 | hymns | 2 | 53800 | 52 | 4.656 | 11555.0 |
499 | 2024-03-28 19:37:55 | hymns | 3 | 83667 | 957 | 4.360 | 19189.7 |
498 | 2024-03-28 19:32:35 | hymns | 1 | 28756 | 3 | 1.653 | 17396.2 |
497 | 2024-03-08 21:30:24 | hymns | 1 | 28756 | 3 | 1.046 | 27491.4 |
496 | 2024-03-08 21:30:21 | hymns | 2 | 53800 | 52 | 3.610 | 14903.0 |
495 | 2024-03-08 21:29:40 | hymns | 3 | 83667 | 957 | 3.953 | 21165.4 |
494 | 2024-03-05 18:32:01 | hymns | 3 | 83667 | 957 | 4.466 | 18734.2 |
493 | 2024-03-04 18:28:44 | hymns | 3 | 83667 | 957 | 14.780 | 5660.8 |
492 | 2024-03-04 18:28:44 | hymns | 2 | 53800 | 52 | 3.623 | 14849.6 |
491 | 2024-03-04 18:20:46 | hymns | 1 | 28756 | 3 | 0.500 | 57512.0 |
490 | 2024-03-01 13:32:18 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
489 | 2024-02-29 07:15:31 | hymns | 1 | 28756 | 3 | 0.516 | 55728.7 |
488 | 2024-02-27 18:42:38 | hymns | 2 | 53800 | 52 | 1.516 | 35488.1 |
487 | 2024-02-27 18:42:11 | hymns | 3 | 83667 | 957 | 3.406 | 24564.6 |
486 | 2024-02-25 22:05:06 | hymns | 3 | 83667 | 957 | 10.466 | 7994.2 |
485 | 2024-02-25 22:05:06 | hymns | 2 | 53800 | 52 | 5.300 | 10150.9 |
484 | 2024-02-25 19:24:22 | hymns | 1 | 28756 | 3 | 0.580 | 49579.3 |
483 | 2024-02-03 17:23:31 | hymns | 1 | 28756 | 3 | 0.516 | 55728.7 |
482 | 2024-01-29 05:02:15 | hymns | 1 | 28756 | 3 | 0.576 | 49923.6 |
481 | 2024-01-26 05:43:41 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
480 | 2024-01-19 15:56:25 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
479 | 2023-12-28 01:26:49 | hymns | 2 | 53800 | 52 | 1.470 | 36598.6 |
478 | 2023-12-12 18:54:49 | hymns | 3 | 83667 | 957 | 3.110 | 26902.6 |
477 | 2023-12-12 18:54:46 | hymns | 2 | 53800 | 52 | 1.313 | 40974.9 |
476 | 2023-12-04 01:38:05 | hymns | 1 | 28756 | 3 | 0.530 | 54256.6 |
475 | 2023-12-04 01:38:04 | hymns | 1 | 28756 | 3 | 0.516 | 55728.7 |
474 | 2023-11-29 09:16:48 | hymns | 3 | 83667 | 957 | 3.220 | 25983.5 |
473 | 2023-11-29 09:16:47 | hymns | 2 | 53800 | 52 | 1.486 | 36204.6 |
472 | 2023-11-17 15:27:42 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
471 | 2023-11-12 12:19:43 | hymns | 3 | 83667 | 957 | 4.080 | 20506.6 |
470 | 2023-11-12 12:19:40 | hymns | 2 | 53800 | 52 | 1.283 | 41933.0 |
469 | 2023-11-11 08:55:08 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
468 | 2023-11-09 19:37:56 | hymns | 1 | 28756 | 3 | 1.033 | 27837.4 |
467 | 2023-10-26 17:42:45 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
466 | 2023-10-20 09:46:04 | hymns | 1 | 28756 | 3 | 0.453 | 63479.0 |
465 | 2023-10-17 08:46:31 | hymns | 1 | 28756 | 3 | 0.420 | 68466.7 |
464 | 2023-10-11 17:12:02 | hymns | 1 | 28756 | 3 | 0.453 | 63479.0 |
463 | 2023-10-04 00:11:21 | hymns | 1 | 28756 | 3 | 0.453 | 63479.0 |
462 | 2023-09-29 02:32:29 | hymns | 2 | 53800 | 52 | 2.763 | 19471.6 |
461 | 2023-09-23 06:27:55 | hymns | 1 | 28756 | 3 | 0.516 | 55728.7 |
460 | 2023-09-10 23:41:02 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
459 | 2023-09-04 17:18:02 | hymns | 1 | 28756 | 3 | 0.470 | 61183.0 |
458 | 2023-07-16 04:15:39 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
457 | 2023-07-09 01:44:03 | hymns | 2 | 53800 | 52 | 1.330 | 40451.1 |
456 | 2023-06-10 10:25:10 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
455 | 2023-04-28 02:06:12 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
454 | 2023-04-01 00:17:18 | hymns | 1 | 28756 | 3 | 0.420 | 68466.7 |
453 | 2023-03-29 21:07:00 | hymns | 1 | 28756 | 3 | 0.546 | 52666.7 |
452 | 2023-03-29 07:20:05 | hymns | 2 | 53800 | 52 | 1.453 | 37026.8 |
451 | 2023-03-20 08:07:15 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
450 | 2023-01-12 15:20:00 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
449 | 2022-12-25 02:03:50 | hymns | 2 | 53800 | 52 | 1.266 | 42496.1 |
448 | 2022-12-16 06:02:32 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
447 | 2022-11-23 08:46:57 | hymns | 3 | 83667 | 957 | 3.343 | 25027.5 |
446 | 2022-11-01 04:24:53 | hymns | 1 | 28756 | 3 | 0.453 | 63479.0 |
445 | 2022-08-25 20:06:26 | hymns | 2 | 53800 | 52 | 1.453 | 37026.8 |
444 | 2022-08-19 09:33:47 | hymns | 1 | 28756 | 3 | 0.470 | 61183.0 |
443 | 2022-06-20 20:15:24 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
442 | 2022-06-18 15:44:06 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
441 | 2022-04-28 15:13:29 | hymns | 3 | 83667 | 957 | 4.346 | 19251.5 |
440 | 2022-04-15 11:03:11 | hymns | 1 | 28756 | 3 | 0.593 | 48492.4 |
439 | 2022-02-15 06:28:00 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
438 | 2021-12-29 11:29:01 | hymns | 3 | 83667 | 957 | 3.953 | 21165.4 |
437 | 2021-12-27 12:23:04 | hymns | 1 | 28756 | 3 | 0.500 | 57512.0 |
436 | 2021-12-04 15:16:14 | hymns | 1 | 28756 | 3 | 0.486 | 59168.7 |
435 | 2021-10-14 03:11:32 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
434 | 2021-10-13 16:49:41 | hymns | 3 | 83667 | 957 | 3.546 | 23594.8 |
433 | 2021-09-20 10:11:31 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
432 | 2021-09-08 00:40:54 | hymns | 1 | 28756 | 3 | 0.470 | 61183.0 |
431 | 2021-08-19 05:06:46 | hymns | 1 | 28756 | 3 | 0.420 | 68466.7 |
430 | 2021-08-16 15:54:33 | hymns | 3 | 83667 | 957 | 3.080 | 27164.6 |
429 | 2021-08-13 11:56:50 | hymns | 3 | 83667 | 957 | 3.140 | 26645.5 |
428 | 2021-06-25 12:01:03 | hymns | 3 | 83667 | 957 | 3.516 | 23796.1 |
427 | 2021-06-17 06:37:51 | hymns | 1 | 28756 | 3 | 0.466 | 61708.2 |
426 | 2021-06-13 19:22:37 | hymns | 1 | 28756 | 3 | 0.516 | 55728.7 |
425 | 2021-06-07 12:17:39 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
424 | 2021-06-06 03:10:52 | hymns | 3 | 83667 | 957 | 3.626 | 23074.2 |
423 | 2021-06-01 04:14:49 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
422 | 2021-05-06 23:03:56 | hymns | 1 | 28756 | 3 | 1.030 | 27918.4 |
421 | 2021-03-16 11:14:45 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
420 | 2021-03-10 22:29:05 | hymns | 1 | 28756 | 3 | 0.440 | 65354.5 |
419 | 2021-02-18 03:36:15 | hymns | 3 | 83667 | 957 | 3.110 | 26902.6 |
418 | 2021-01-26 12:17:53 | hymns | 1 | 28756 | 3 | 0.420 | 68466.7 |
417 | 2020-12-28 14:36:40 | hymns | 1 | 28756 | 3 | 0.470 | 61183.0 |
416 | 2020-12-07 16:13:21 | hymns | 1 | 28756 | 3 | 0.440 | 65354.5 |
415 | 2020-10-14 17:16:46 | hymns | 1 | 28756 | 3 | 0.423 | 67981.1 |
414 | 2020-09-09 17:54:54 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
413 | 2020-09-04 08:29:29 | hymns | 1 | 28756 | 3 | 0.483 | 59536.2 |
412 | 2020-08-29 01:33:54 | hymns | 1 | 28756 | 3 | 0.453 | 63479.0 |
411 | 2020-08-25 20:52:02 | hymns | 1 | 28756 | 3 | 0.436 | 65954.1 |
410 | 2020-08-20 12:56:18 | hymns | 1 | 28756 | 3 | 0.543 | 52957.6 |