History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1240 | 2024-03-04 00:54:24 | spiny | 2 | 53800 | 149 | 3.826 | 14061.7 |
1239 | 2024-03-04 00:52:20 | spiny | 1 | 28756 | 10 | 1.156 | 24875.4 |
1238 | 2024-02-29 23:40:24 | spiny | 1 | 28756 | 10 | 0.530 | 54256.6 |
1237 | 2024-02-26 08:44:18 | spiny | 1 | 28756 | 10 | 0.450 | 63902.2 |
1236 | 2024-02-03 03:21:27 | spiny | 1 | 28756 | 10 | 0.483 | 59536.2 |
1235 | 2024-01-28 23:05:27 | spiny | 1 | 28756 | 10 | 0.530 | 54256.6 |
1234 | 2024-01-27 06:41:13 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1233 | 2024-01-14 10:06:44 | spiny | 1 | 28756 | 10 | 0.470 | 61183.0 |
1232 | 2024-01-02 06:44:21 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1231 | 2023-12-28 02:17:39 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1230 | 2023-12-28 01:41:14 | spiny | 2 | 53800 | 149 | 1.606 | 33499.4 |
1229 | 2023-12-27 03:32:16 | spiny | 2 | 53800 | 149 | 1.420 | 37887.3 |
1228 | 2023-12-17 12:53:32 | spiny | 2 | 53800 | 149 | 1.546 | 34799.5 |
1227 | 2023-11-21 20:42:21 | spiny | 1 | 28756 | 10 | 0.533 | 53951.2 |
1226 | 2023-11-18 22:43:57 | spiny | 2 | 53800 | 149 | 1.563 | 34421.0 |
1225 | 2023-11-13 17:34:18 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1224 | 2023-11-13 09:11:46 | spiny | 1 | 28756 | 10 | 0.563 | 51076.4 |
1223 | 2023-11-10 02:22:20 | spiny | 1 | 28756 | 10 | 0.486 | 59168.7 |
1222 | 2023-11-01 03:44:14 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1221 | 2023-10-29 07:06:11 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1220 | 2023-10-21 13:45:33 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1219 | 2023-10-18 06:55:12 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1218 | 2023-10-15 00:16:16 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1217 | 2023-10-05 04:30:34 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1216 | 2023-09-26 17:49:36 | spiny | 2 | 53800 | 149 | 1.360 | 39558.8 |
1215 | 2023-09-24 15:36:12 | spiny | 1 | 28756 | 10 | 1.000 | 28756.0 |
1214 | 2023-09-19 15:52:02 | spiny | 1 | 28756 | 10 | 0.450 | 63902.2 |
1213 | 2023-08-31 00:19:53 | spiny | 1 | 28756 | 10 | 0.486 | 59168.7 |
1212 | 2023-08-19 01:04:04 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1211 | 2023-06-05 05:28:13 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1210 | 2023-04-20 02:14:31 | spiny | 1 | 28756 | 10 | 0.483 | 59536.2 |
1209 | 2023-03-26 23:25:14 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1208 | 2023-01-10 11:24:20 | spiny | 1 | 28756 | 10 | 0.440 | 65354.5 |
1207 | 2022-12-27 12:14:02 | spiny | 1 | 28756 | 10 | 0.483 | 59536.2 |
1206 | 2022-10-18 02:42:34 | spiny | 1 | 28756 | 10 | 0.466 | 61708.2 |
1205 | 2022-08-20 00:50:13 | spiny | 1 | 28756 | 10 | 0.483 | 59536.2 |
1204 | 2022-06-07 08:15:34 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1203 | 2022-04-05 15:22:32 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1202 | 2022-02-17 04:07:21 | spiny | 1 | 28756 | 10 | 0.440 | 65354.5 |
1201 | 2021-12-15 07:50:22 | spiny | 1 | 28756 | 10 | 0.513 | 56054.6 |
1200 | 2021-12-08 13:21:18 | spiny | 1 | 28756 | 10 | 0.533 | 53951.2 |
1199 | 2021-10-22 01:52:59 | spiny | 1 | 28756 | 10 | 0.513 | 56054.6 |
1198 | 2021-10-13 06:26:21 | spiny | 2 | 53800 | 149 | 1.643 | 32745.0 |
1197 | 2021-09-24 21:28:46 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1196 | 2021-08-25 22:50:31 | spiny | 1 | 28756 | 10 | 0.516 | 55728.7 |
1195 | 2021-07-27 16:10:29 | spiny | 1 | 28756 | 10 | 0.516 | 55728.7 |
1194 | 2021-05-18 13:51:15 | spiny | 1 | 28756 | 10 | 0.483 | 59536.2 |
1193 | 2021-05-15 05:53:16 | spiny | 1 | 28756 | 10 | 1.063 | 27051.7 |
1192 | 2021-05-06 02:30:07 | spiny | 2 | 53800 | 149 | 1.440 | 37361.1 |
1191 | 2021-04-20 09:30:17 | spiny | 2 | 53800 | 149 | 1.423 | 37807.4 |
1190 | 2021-04-18 14:44:35 | spiny | 1 | 28756 | 10 | 0.530 | 54256.6 |
1189 | 2021-03-21 09:45:44 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1188 | 2021-02-24 04:04:37 | spiny | 2 | 53800 | 149 | 1.390 | 38705.0 |
1187 | 2021-02-18 07:07:47 | spiny | 2 | 53800 | 149 | 2.500 | 21520.0 |
1186 | 2021-02-12 14:09:03 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1185 | 2021-01-31 00:23:38 | spiny | 1 | 28756 | 10 | 0.436 | 65954.1 |
1184 | 2021-01-28 15:12:02 | spiny | 1 | 28756 | 10 | 0.546 | 52666.7 |
1183 | 2021-01-03 02:50:57 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1182 | 2020-12-20 03:32:53 | spiny | 2 | 53800 | 149 | 1.483 | 36277.8 |
1181 | 2020-11-29 21:23:40 | spiny | 2 | 53800 | 149 | 1.390 | 38705.0 |
1180 | 2020-11-10 21:31:34 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1179 | 2020-10-30 11:47:19 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1178 | 2020-10-27 07:14:26 | spiny | 1 | 28756 | 10 | 0.500 | 57512.0 |
1177 | 2020-10-23 02:22:46 | spiny | 2 | 53800 | 149 | 1.390 | 38705.0 |
1176 | 2020-10-16 12:52:37 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1175 | 2020-09-24 15:40:14 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1174 | 2020-09-03 10:58:00 | spiny | 2 | 53800 | 149 | 1.576 | 34137.1 |
1173 | 2020-09-01 09:17:16 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1172 | 2020-08-29 02:52:53 | spiny | 1 | 28756 | 10 | 0.470 | 61183.0 |
1171 | 2020-08-29 01:30:00 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1170 | 2020-08-22 12:29:35 | spiny | 2 | 53800 | 149 | 1.623 | 33148.5 |
1169 | 2020-08-20 17:10:22 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1168 | 2020-08-10 21:13:17 | spiny | 1 | 28756 | 10 | 0.450 | 63902.2 |
1167 | 2020-08-07 23:29:19 | spiny | 1 | 28756 | 10 | 0.516 | 55728.7 |
1166 | 2020-07-29 07:15:03 | spiny | 2 | 53800 | 149 | 1.516 | 35488.1 |
1165 | 2020-07-25 03:30:53 | spiny | 2 | 53800 | 149 | 1.423 | 37807.4 |
1164 | 2020-07-19 23:25:03 | spiny | 2 | 53800 | 149 | 1.440 | 37361.1 |
1163 | 2020-07-18 13:27:10 | spiny | 1 | 28756 | 10 | 0.470 | 61183.0 |
1162 | 2020-07-18 05:51:44 | spiny | 2 | 53800 | 149 | 1.453 | 37026.8 |
1161 | 2020-07-17 12:43:35 | spiny | 1 | 28756 | 10 | 0.453 | 63479.0 |
1160 | 2020-07-16 12:09:12 | spiny | 1 | 28756 | 10 | 0.486 | 59168.7 |
1159 | 2020-07-14 21:28:33 | spiny | 2 | 53800 | 149 | 1.436 | 37465.2 |
1158 | 2020-07-14 05:34:00 | spiny | 2 | 53800 | 149 | 1.390 | 38705.0 |
1157 | 2020-06-21 16:09:55 | spiny | 2 | 53800 | 149 | 1.486 | 36204.6 |
1156 | 2020-06-21 04:08:31 | spiny | 2 | 53800 | 149 | 2.296 | 23432.1 |
1155 | 2020-06-21 04:07:15 | spiny | 2 | 53800 | 149 | 1.860 | 28924.7 |
1154 | 2020-06-20 03:31:39 | spiny | 2 | 53800 | 149 | 1.580 | 34050.6 |
1153 | 2020-06-19 19:35:01 | spiny | 2 | 53800 | 149 | 1.936 | 27789.3 |
1152 | 2020-06-19 03:32:45 | spiny | 2 | 53800 | 149 | 1.610 | 33416.1 |
1151 | 2020-06-18 21:57:10 | spiny | 2 | 53800 | 149 | 1.466 | 36698.5 |
1150 | 2020-06-18 09:55:36 | spiny | 2 | 53800 | 149 | 1.436 | 37465.2 |
1149 | 2020-06-18 03:28:38 | spiny | 2 | 53800 | 149 | 1.623 | 33148.5 |
1148 | 2020-06-17 21:54:39 | spiny | 2 | 53800 | 149 | 1.436 | 37465.2 |
1147 | 2020-06-17 10:25:34 | spiny | 2 | 53800 | 149 | 1.390 | 38705.0 |
1146 | 2020-06-17 03:01:23 | spiny | 2 | 53800 | 149 | 1.750 | 30742.9 |
1145 | 2020-06-16 22:23:25 | spiny | 2 | 53800 | 149 | 1.623 | 33148.5 |
1144 | 2020-06-16 00:18:37 | spiny | 2 | 53800 | 149 | 1.503 | 35795.1 |
1143 | 2020-06-15 16:26:40 | spiny | 2 | 53800 | 149 | 1.360 | 39558.8 |
1142 | 2020-06-15 04:25:51 | spiny | 2 | 53800 | 149 | 1.423 | 37807.4 |
1141 | 2020-06-12 18:37:46 | spiny | 2 | 53800 | 149 | 1.483 | 36277.8 |