History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"boots"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1081 | 2024-04-27 20:17:18 | boots | 1 | 28756 | 30 | 0.513 | 56054.6 |
| 1080 | 2024-04-14 20:41:32 | boots | 1 | 28756 | 30 | 0.670 | 42919.4 |
| 1079 | 2024-04-13 16:01:39 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1078 | 2024-04-03 02:49:34 | boots | 1 | 28756 | 30 | 1.796 | 16011.1 |
| 1077 | 2024-04-02 12:25:08 | boots | 2 | 53800 | 317 | 1.656 | 32487.9 |
| 1076 | 2024-03-30 22:27:27 | boots | 2 | 53800 | 317 | 3.533 | 15227.9 |
| 1075 | 2024-03-30 21:59:28 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1074 | 2024-03-28 23:58:17 | boots | 2 | 53800 | 317 | 2.236 | 24060.8 |
| 1073 | 2024-03-28 23:58:04 | boots | 1 | 28756 | 30 | 1.703 | 16885.5 |
| 1072 | 2024-03-28 23:57:47 | boots | 2 | 53800 | 317 | 5.360 | 10037.3 |
| 1071 | 2024-03-28 23:07:47 | boots | 1 | 28756 | 30 | 0.643 | 44721.6 |
| 1070 | 2024-03-27 22:49:54 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1069 | 2024-03-10 19:55:46 | boots | 2 | 53800 | 317 | 1.686 | 31909.8 |
| 1068 | 2024-03-05 06:24:34 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1067 | 2024-03-01 22:34:15 | boots | 1 | 28756 | 30 | 1.033 | 27837.4 |
| 1066 | 2024-02-27 19:24:57 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1065 | 2024-02-19 17:48:54 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1064 | 2024-02-02 15:54:02 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1063 | 2024-01-23 23:22:00 | boots | 1 | 28756 | 30 | 0.486 | 59168.7 |
| 1062 | 2023-12-20 10:18:16 | boots | 1 | 28756 | 30 | 0.486 | 59168.7 |
| 1061 | 2023-12-13 01:44:13 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1060 | 2023-12-10 22:52:32 | boots | 2 | 53800 | 317 | 1.720 | 31279.1 |
| 1059 | 2023-12-09 03:23:48 | boots | 2 | 53800 | 317 | 1.513 | 35558.5 |
| 1058 | 2023-11-29 03:04:49 | boots | 1 | 28756 | 30 | 0.530 | 54256.6 |
| 1057 | 2023-11-28 23:26:45 | boots | 2 | 53800 | 317 | 1.643 | 32745.0 |
| 1056 | 2023-11-27 07:40:11 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1055 | 2023-11-26 03:58:02 | boots | 2 | 53800 | 317 | 1.533 | 35094.6 |
| 1054 | 2023-11-16 09:18:31 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1053 | 2023-11-15 07:53:04 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1052 | 2023-11-11 07:07:53 | boots | 1 | 28756 | 30 | 0.483 | 59536.2 |
| 1051 | 2023-11-10 16:42:50 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1050 | 2023-11-03 00:35:10 | boots | 1 | 28756 | 30 | 0.450 | 63902.2 |
| 1049 | 2023-11-01 00:05:25 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1048 | 2023-10-27 13:37:53 | boots | 2 | 53800 | 317 | 2.186 | 24611.2 |
| 1047 | 2023-10-19 20:19:34 | boots | 1 | 28756 | 30 | 0.466 | 61708.2 |
| 1046 | 2023-10-18 23:48:23 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1045 | 2023-10-13 14:37:39 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1044 | 2023-10-07 17:06:41 | boots | 1 | 28756 | 30 | 0.440 | 65354.5 |
| 1043 | 2023-10-07 06:58:09 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1042 | 2023-09-25 11:20:07 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1041 | 2023-09-21 18:30:18 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1040 | 2023-08-25 23:06:00 | boots | 2 | 53800 | 317 | 1.393 | 38621.7 |
| 1039 | 2023-08-23 09:03:53 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1038 | 2023-08-04 05:24:18 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1037 | 2023-06-28 11:28:34 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1036 | 2023-05-29 09:35:06 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1035 | 2023-05-20 05:23:24 | boots | 1 | 28756 | 30 | 0.393 | 73170.5 |
| 1034 | 2023-05-10 13:30:11 | boots | 2 | 53800 | 317 | 1.356 | 39675.5 |
| 1033 | 2023-05-06 13:56:51 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1032 | 2023-05-04 08:02:16 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1031 | 2023-04-28 19:00:43 | boots | 1 | 28756 | 30 | 0.466 | 61708.2 |
| 1030 | 2023-03-13 17:18:06 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 1029 | 2023-02-18 07:01:53 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 1028 | 2023-02-17 11:07:21 | boots | 1 | 28756 | 30 | 0.440 | 65354.5 |
| 1027 | 2023-02-16 08:16:24 | boots | 2 | 53800 | 317 | 1.546 | 34799.5 |
| 1026 | 2023-01-21 19:17:32 | boots | 1 | 28756 | 30 | 0.483 | 59536.2 |
| 1025 | 2023-01-19 20:10:59 | boots | 1 | 28756 | 30 | 0.483 | 59536.2 |
| 1024 | 2022-12-15 10:56:11 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1023 | 2022-12-07 16:18:19 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1022 | 2022-12-05 19:47:54 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1021 | 2022-11-28 01:00:36 | boots | 2 | 53800 | 317 | 1.360 | 39558.8 |
| 1020 | 2022-11-14 11:48:41 | boots | 1 | 28756 | 30 | 0.533 | 53951.2 |
| 1019 | 2022-11-10 19:15:56 | boots | 1 | 28756 | 30 | 0.440 | 65354.5 |
| 1018 | 2022-10-19 21:03:58 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1017 | 2022-09-18 23:38:38 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1016 | 2022-09-08 01:46:08 | boots | 1 | 28756 | 30 | 0.466 | 61708.2 |
| 1015 | 2022-09-05 09:11:31 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1014 | 2022-08-22 11:22:19 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1013 | 2022-08-07 23:54:16 | boots | 1 | 28756 | 30 | 0.830 | 34645.8 |
| 1012 | 2022-08-06 06:34:23 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1011 | 2022-07-18 14:58:59 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 1010 | 2022-07-14 23:31:00 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1009 | 2022-05-31 15:54:41 | boots | 1 | 28756 | 30 | 0.440 | 65354.5 |
| 1008 | 2022-05-27 22:30:21 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 1007 | 2022-05-08 18:15:43 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1006 | 2022-05-01 00:25:45 | boots | 2 | 53800 | 317 | 1.360 | 39558.8 |
| 1005 | 2022-04-13 10:25:18 | boots | 1 | 28756 | 30 | 0.673 | 42728.1 |
| 1004 | 2022-04-11 23:47:18 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 1003 | 2022-04-09 11:25:14 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 1002 | 2022-02-03 19:16:06 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 1001 | 2022-01-09 22:52:13 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 1000 | 2022-01-07 20:05:57 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 999 | 2021-12-31 17:18:08 | boots | 2 | 53800 | 317 | 1.436 | 37465.2 |
| 998 | 2021-11-20 12:18:10 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 997 | 2021-11-06 00:31:14 | boots | 1 | 28756 | 30 | 0.483 | 59536.2 |
| 996 | 2021-11-03 02:30:32 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 995 | 2021-10-25 16:58:56 | boots | 1 | 28756 | 30 | 0.533 | 53951.2 |
| 994 | 2021-10-11 18:15:18 | boots | 2 | 53800 | 317 | 1.563 | 34421.0 |
| 993 | 2021-09-27 19:34:26 | boots | 1 | 28756 | 30 | 0.500 | 57512.0 |
| 992 | 2021-08-30 12:32:55 | boots | 1 | 28756 | 30 | 0.486 | 59168.7 |
| 991 | 2021-08-16 17:29:56 | boots | 2 | 53800 | 317 | 1.360 | 39558.8 |
| 990 | 2021-08-13 02:00:27 | boots | 1 | 28756 | 30 | 0.470 | 61183.0 |
| 989 | 2021-08-10 00:27:56 | boots | 1 | 28756 | 30 | 0.453 | 63479.0 |
| 988 | 2021-08-03 07:39:21 | boots | 1 | 28756 | 30 | 0.483 | 59536.2 |
| 987 | 2021-07-30 20:28:53 | boots | 1 | 28756 | 30 | 0.436 | 65954.1 |
| 986 | 2021-07-14 07:55:08 | boots | 1 | 28756 | 30 | 0.920 | 31256.5 |
| 985 | 2021-07-12 23:49:01 | boots | 1 | 28756 | 30 | 0.513 | 56054.6 |
| 984 | 2021-06-19 23:57:04 | boots | 1 | 28756 | 30 | 0.530 | 54256.6 |
| 983 | 2021-06-19 03:59:38 | boots | 1 | 28756 | 30 | 0.516 | 55728.7 |
| 982 | 2021-06-18 00:40:13 | boots | 1 | 28756 | 30 | 0.440 | 65354.5 |