History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"books"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1154 | 2024-04-27 15:43:13 | books | 1 | 28756 | 23 | 0.656 | 43835.4 |
1153 | 2024-04-27 03:58:03 | books | 1 | 28756 | 23 | 0.593 | 48492.4 |
1152 | 2024-04-25 02:11:18 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1151 | 2024-04-22 06:07:35 | books | 1 | 28756 | 23 | 1.110 | 25906.3 |
1150 | 2024-04-04 13:51:05 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1149 | 2024-04-03 04:33:21 | books | 1 | 28756 | 23 | 1.453 | 19790.8 |
1148 | 2024-04-01 09:24:13 | books | 2 | 53800 | 259 | 1.716 | 31352.0 |
1147 | 2024-04-01 09:24:10 | books | 1 | 28756 | 23 | 1.046 | 27491.4 |
1146 | 2024-04-01 09:24:01 | books | 2 | 53800 | 259 | 1.716 | 31352.0 |
1145 | 2024-04-01 09:23:53 | books | 1 | 28756 | 23 | 1.123 | 25606.4 |
1144 | 2024-04-01 04:19:06 | books | 1 | 28756 | 23 | 0.560 | 51350.0 |
1143 | 2024-03-29 02:15:39 | books | 1 | 28756 | 23 | 1.750 | 16432.0 |
1142 | 2024-03-16 01:26:34 | books | 1 | 28756 | 23 | 1.173 | 24514.9 |
1141 | 2024-03-04 02:49:12 | books | 2 | 53800 | 259 | 1.576 | 34137.1 |
1140 | 2024-03-04 02:49:11 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1139 | 2024-03-01 21:35:28 | books | 2 | 53800 | 259 | 3.643 | 14768.0 |
1138 | 2024-03-01 21:33:04 | books | 1 | 28756 | 23 | 0.530 | 54256.6 |
1137 | 2024-02-28 01:04:47 | books | 1 | 28756 | 23 | 0.530 | 54256.6 |
1136 | 2024-02-03 01:16:43 | books | 1 | 28756 | 23 | 1.046 | 27491.4 |
1135 | 2024-01-31 13:01:07 | books | 1 | 28756 | 23 | 0.546 | 52666.7 |
1134 | 2024-01-28 22:06:21 | books | 1 | 28756 | 23 | 0.513 | 56054.6 |
1133 | 2024-01-27 01:06:12 | books | 1 | 28756 | 23 | 0.516 | 55728.7 |
1132 | 2024-01-03 11:43:15 | books | 2 | 53800 | 259 | 3.453 | 15580.7 |
1131 | 2024-01-02 22:46:50 | books | 1 | 28756 | 23 | 0.470 | 61183.0 |
1130 | 2024-01-01 10:21:46 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1129 | 2023-12-30 00:56:22 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1128 | 2023-12-26 20:00:52 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1127 | 2023-12-12 02:20:01 | books | 1 | 28756 | 23 | 0.516 | 55728.7 |
1126 | 2023-12-10 22:52:28 | books | 1 | 28756 | 23 | 0.530 | 54256.6 |
1125 | 2023-12-08 07:12:17 | books | 2 | 53800 | 259 | 1.560 | 34487.2 |
1124 | 2023-12-06 04:58:31 | books | 1 | 28756 | 23 | 0.563 | 51076.4 |
1123 | 2023-12-03 21:43:56 | books | 1 | 28756 | 23 | 0.563 | 51076.4 |
1122 | 2023-12-02 17:31:22 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1121 | 2023-12-01 17:00:04 | books | 1 | 28756 | 23 | 0.466 | 61708.2 |
1120 | 2023-12-01 06:07:34 | books | 2 | 53800 | 259 | 1.623 | 33148.5 |
1119 | 2023-12-01 01:34:06 | books | 1 | 28756 | 23 | 0.530 | 54256.6 |
1118 | 2023-11-15 07:52:51 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1117 | 2023-11-13 21:52:39 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1116 | 2023-11-12 12:18:35 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1115 | 2023-11-11 07:08:23 | books | 1 | 28756 | 23 | 0.440 | 65354.5 |
1114 | 2023-11-11 05:27:20 | books | 1 | 28756 | 23 | 0.533 | 53951.2 |
1113 | 2023-11-10 09:24:38 | books | 1 | 28756 | 23 | 0.440 | 65354.5 |
1112 | 2023-10-31 23:29:41 | books | 2 | 53800 | 259 | 1.623 | 33148.5 |
1111 | 2023-10-31 23:15:29 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1110 | 2023-10-31 21:42:44 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1109 | 2023-10-27 13:13:33 | books | 2 | 53800 | 259 | 1.440 | 37361.1 |
1108 | 2023-10-24 22:28:15 | books | 1 | 28756 | 23 | 0.436 | 65954.1 |
1107 | 2023-10-19 20:19:02 | books | 1 | 28756 | 23 | 0.436 | 65954.1 |
1106 | 2023-10-19 09:07:18 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1105 | 2023-10-18 22:36:15 | books | 1 | 28756 | 23 | 0.440 | 65354.5 |
1104 | 2023-10-17 02:11:08 | books | 1 | 28756 | 23 | 0.546 | 52666.7 |
1103 | 2023-10-12 02:35:40 | books | 1 | 28756 | 23 | 0.516 | 55728.7 |
1102 | 2023-10-05 19:36:05 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1101 | 2023-10-04 00:11:21 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1100 | 2023-09-23 00:38:42 | books | 1 | 28756 | 23 | 0.466 | 61708.2 |
1099 | 2023-09-21 15:03:43 | books | 1 | 28756 | 23 | 0.516 | 55728.7 |
1098 | 2023-09-21 04:49:28 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1097 | 2023-09-20 21:44:39 | books | 1 | 28756 | 23 | 0.470 | 61183.0 |
1096 | 2023-09-17 12:25:16 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1095 | 2023-09-17 06:10:16 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1094 | 2023-09-15 23:57:58 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1093 | 2023-09-12 18:12:01 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1092 | 2023-09-10 06:35:15 | books | 1 | 28756 | 23 | 0.513 | 56054.6 |
1091 | 2023-08-22 10:13:49 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1090 | 2023-08-21 22:08:37 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1089 | 2023-08-19 20:01:14 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1088 | 2023-06-09 22:07:35 | books | 1 | 28756 | 23 | 0.436 | 65954.1 |
1087 | 2023-06-06 15:03:52 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1086 | 2023-05-20 05:11:33 | books | 1 | 28756 | 23 | 0.450 | 63902.2 |
1085 | 2023-02-28 17:05:58 | books | 1 | 28756 | 23 | 0.436 | 65954.1 |
1084 | 2023-01-04 06:02:28 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1083 | 2022-11-22 13:39:42 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1082 | 2022-09-24 01:09:09 | books | 1 | 28756 | 23 | 0.436 | 65954.1 |
1081 | 2022-08-31 12:07:20 | books | 1 | 28756 | 23 | 1.046 | 27491.4 |
1080 | 2022-08-18 15:53:22 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1079 | 2022-08-14 14:46:03 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1078 | 2022-08-07 18:18:42 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1077 | 2022-08-06 03:34:49 | books | 1 | 28756 | 23 | 0.440 | 65354.5 |
1076 | 2022-07-01 22:47:32 | books | 2 | 53800 | 259 | 1.390 | 38705.0 |
1075 | 2022-05-13 01:55:46 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1074 | 2022-05-07 08:23:21 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1073 | 2022-04-12 18:49:34 | books | 1 | 28756 | 23 | 0.906 | 31739.5 |
1072 | 2022-04-11 16:55:03 | books | 1 | 28756 | 23 | 0.686 | 41918.4 |
1071 | 2022-04-10 17:05:58 | books | 1 | 28756 | 23 | 0.513 | 56054.6 |
1070 | 2022-04-09 22:14:51 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1069 | 2022-02-08 09:42:21 | books | 1 | 28756 | 23 | 0.483 | 59536.2 |
1068 | 2022-01-24 03:19:18 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1067 | 2021-12-15 00:20:50 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1066 | 2021-11-20 18:28:23 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1065 | 2021-11-17 13:30:56 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1064 | 2021-11-07 11:05:38 | books | 1 | 28756 | 23 | 0.530 | 54256.6 |
1063 | 2021-10-03 05:46:25 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1062 | 2021-08-31 19:32:15 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1061 | 2021-08-26 19:18:44 | books | 1 | 28756 | 23 | 0.486 | 59168.7 |
1060 | 2021-08-14 09:19:58 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1059 | 2021-08-04 08:58:03 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1058 | 2021-07-09 01:48:10 | books | 1 | 28756 | 23 | 0.453 | 63479.0 |
1057 | 2021-07-09 00:31:59 | books | 1 | 28756 | 23 | 0.450 | 63902.2 |
1056 | 2021-07-08 04:39:26 | books | 1 | 28756 | 23 | 0.500 | 57512.0 |
1055 | 2021-07-08 02:59:35 | books | 1 | 28756 | 23 | 0.533 | 53951.2 |