History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bannered"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
289 | 2024-04-06 08:25:25 | bannered | 1 | 82945 | 4 | 5.610 | 14785.2 |
288 | 2024-04-06 04:02:53 | bannered | 3 | 146162 | 245 | 19.516 | 7489.3 |
287 | 2024-04-04 08:18:52 | bannered | 2 | 121059 | 31 | 6.000 | 20176.5 |
286 | 2024-04-04 07:25:58 | bannered | 3 | 146162 | 245 | 17.843 | 8191.6 |
285 | 2024-04-03 12:57:28 | bannered | 2 | 121059 | 31 | 13.186 | 9180.9 |
284 | 2024-04-03 12:57:13 | bannered | 1 | 82945 | 4 | 1.656 | 50087.6 |
283 | 2024-04-03 08:14:27 | bannered | 3 | 146162 | 245 | 7.890 | 18525.0 |
282 | 2024-04-03 00:10:38 | bannered | 3 | 146162 | 245 | 10.610 | 13775.9 |
281 | 2024-04-02 09:14:37 | bannered | 1 | 82945 | 4 | 1.420 | 58412.0 |
280 | 2024-04-02 09:14:33 | bannered | 2 | 121059 | 31 | 3.626 | 33386.4 |
279 | 2024-04-02 09:14:02 | bannered | 3 | 146162 | 245 | 8.563 | 17069.0 |
278 | 2024-04-01 18:35:20 | bannered | 3 | 146162 | 245 | 16.533 | 8840.6 |
277 | 2024-04-01 18:35:21 | bannered | 2 | 121059 | 31 | 8.890 | 13617.4 |
276 | 2024-04-01 18:33:20 | bannered | 1 | 82945 | 4 | 1.703 | 48705.2 |
275 | 2024-03-28 06:51:46 | bannered | 1 | 82945 | 4 | 2.330 | 35598.7 |
274 | 2024-03-13 17:30:58 | bannered | 1 | 82945 | 4 | 1.436 | 57761.1 |
273 | 2024-03-07 04:08:02 | bannered | 1 | 82945 | 4 | 1.690 | 49079.9 |
272 | 2024-03-01 15:44:46 | bannered | 2 | 121059 | 31 | 4.436 | 27290.1 |
271 | 2024-03-01 09:45:11 | bannered | 3 | 146162 | 245 | 22.220 | 6577.9 |
270 | 2024-03-01 06:55:48 | bannered | 2 | 121059 | 31 | 4.530 | 26723.8 |
269 | 2024-03-01 06:55:37 | bannered | 3 | 146162 | 245 | 7.156 | 20425.1 |
268 | 2024-03-01 06:53:47 | bannered | 2 | 121059 | 31 | 3.813 | 31749.0 |
267 | 2024-03-01 06:53:43 | bannered | 3 | 146162 | 245 | 7.483 | 19532.5 |
266 | 2024-03-01 06:53:40 | bannered | 1 | 82945 | 4 | 1.376 | 60279.8 |
265 | 2024-02-29 04:12:01 | bannered | 1 | 82945 | 4 | 1.456 | 56967.7 |
264 | 2024-02-20 11:11:14 | bannered | 1 | 82945 | 4 | 2.873 | 28870.5 |
263 | 2024-02-17 01:03:23 | bannered | 1 | 82945 | 4 | 1.470 | 56425.2 |
262 | 2024-02-12 09:20:10 | bannered | 1 | 82945 | 4 | 1.313 | 63172.1 |
261 | 2024-02-07 19:55:43 | bannered | 3 | 146162 | 245 | 22.893 | 6384.6 |
260 | 2024-02-07 19:40:52 | bannered | 2 | 121059 | 31 | 7.423 | 16308.6 |
259 | 2024-02-05 04:03:47 | bannered | 3 | 146162 | 245 | 7.580 | 19282.6 |
258 | 2024-01-31 07:29:47 | bannered | 2 | 121059 | 31 | 3.780 | 32026.2 |
257 | 2024-01-31 07:29:43 | bannered | 3 | 146162 | 245 | 7.513 | 19454.5 |
256 | 2024-01-31 03:09:55 | bannered | 1 | 82945 | 4 | 1.440 | 57600.7 |
255 | 2024-01-31 03:09:07 | bannered | 3 | 146162 | 245 | 12.656 | 11548.8 |
254 | 2024-01-31 03:08:22 | bannered | 2 | 121059 | 31 | 3.593 | 33693.0 |
253 | 2024-01-31 03:08:19 | bannered | 3 | 146162 | 245 | 6.970 | 20970.2 |
252 | 2024-01-31 03:08:15 | bannered | 1 | 82945 | 4 | 2.280 | 36379.4 |
251 | 2024-01-04 10:00:11 | bannered | 1 | 82945 | 4 | 1.500 | 55296.7 |
250 | 2024-01-01 02:46:35 | bannered | 1 | 82945 | 4 | 1.500 | 55296.7 |
249 | 2023-12-21 07:58:27 | bannered | 2 | 121059 | 31 | 3.203 | 37795.5 |
248 | 2023-12-05 15:06:48 | bannered | 1 | 82945 | 4 | 1.283 | 64649.3 |
247 | 2023-11-24 01:27:22 | bannered | 1 | 82945 | 4 | 1.266 | 65517.4 |
246 | 2023-11-02 14:28:17 | bannered | 1 | 82945 | 4 | 1.263 | 65673.0 |
245 | 2023-10-18 23:37:56 | bannered | 1 | 82945 | 4 | 1.440 | 57600.7 |
244 | 2023-10-01 03:23:05 | bannered | 1 | 82945 | 4 | 1.436 | 57761.1 |
243 | 2023-09-21 14:10:11 | bannered | 2 | 121059 | 31 | 3.690 | 32807.3 |
242 | 2023-09-19 14:49:51 | bannered | 1 | 82945 | 4 | 1.486 | 55817.6 |
241 | 2023-07-11 15:45:05 | bannered | 1 | 82945 | 4 | 1.343 | 61761.0 |
240 | 2023-07-06 16:34:00 | bannered | 1 | 82945 | 4 | 1.530 | 54212.4 |
239 | 2023-06-30 20:12:52 | bannered | 2 | 121059 | 31 | 8.016 | 15102.2 |
238 | 2023-06-24 15:58:08 | bannered | 1 | 82945 | 4 | 1.313 | 63172.1 |
237 | 2023-04-17 17:58:01 | bannered | 1 | 82945 | 4 | 1.483 | 55930.5 |
236 | 2023-03-21 20:35:03 | bannered | 2 | 121059 | 31 | 3.390 | 35710.6 |
235 | 2023-03-09 03:06:56 | bannered | 1 | 82945 | 4 | 1.343 | 61761.0 |
234 | 2023-02-09 09:59:49 | bannered | 1 | 82945 | 4 | 1.313 | 63172.1 |
233 | 2022-12-21 10:21:47 | bannered | 2 | 121059 | 31 | 3.233 | 37444.8 |
232 | 2022-12-07 05:28:21 | bannered | 1 | 82945 | 4 | 1.266 | 65517.4 |
231 | 2022-11-17 07:10:43 | bannered | 1 | 82945 | 4 | 1.453 | 57085.3 |
230 | 2022-11-13 15:29:05 | bannered | 1 | 82945 | 4 | 1.263 | 65673.0 |
229 | 2022-09-13 17:29:52 | bannered | 1 | 82945 | 4 | 1.376 | 60279.8 |
228 | 2022-08-27 14:08:09 | bannered | 1 | 82945 | 4 | 1.280 | 64800.8 |
227 | 2022-08-17 06:46:34 | bannered | 2 | 121059 | 31 | 3.530 | 34294.3 |
226 | 2022-08-14 21:53:44 | bannered | 2 | 121059 | 31 | 3.296 | 36729.1 |
225 | 2022-08-07 11:45:45 | bannered | 1 | 82945 | 4 | 1.266 | 65517.4 |
224 | 2022-07-20 19:00:22 | bannered | 1 | 82945 | 4 | 1.330 | 62364.7 |
223 | 2022-07-17 01:41:51 | bannered | 1 | 82945 | 4 | 1.486 | 55817.6 |
222 | 2022-07-16 11:49:48 | bannered | 1 | 82945 | 4 | 1.376 | 60279.8 |
221 | 2022-06-25 20:02:54 | bannered | 1 | 82945 | 4 | 1.280 | 64800.8 |
220 | 2022-06-09 04:58:47 | bannered | 1 | 82945 | 4 | 1.283 | 64649.3 |
219 | 2022-05-09 14:10:12 | bannered | 1 | 82945 | 4 | 1.516 | 54713.1 |
218 | 2022-04-01 07:16:27 | bannered | 1 | 82945 | 4 | 1.296 | 64000.8 |
217 | 2022-03-30 04:20:10 | bannered | 1 | 82945 | 4 | 1.360 | 60989.0 |
216 | 2022-03-16 07:55:46 | bannered | 1 | 82945 | 4 | 1.533 | 54106.3 |
215 | 2022-03-13 07:44:09 | bannered | 2 | 121059 | 31 | 3.313 | 36540.6 |
214 | 2022-03-12 21:12:33 | bannered | 1 | 82945 | 4 | 1.313 | 63172.1 |
213 | 2021-12-31 18:29:19 | bannered | 1 | 82945 | 4 | 1.326 | 62552.8 |
212 | 2021-12-29 15:54:22 | bannered | 1 | 82945 | 4 | 1.420 | 58412.0 |
211 | 2021-12-19 09:44:24 | bannered | 2 | 121059 | 31 | 4.033 | 30017.1 |
210 | 2021-11-29 04:51:23 | bannered | 1 | 82945 | 4 | 1.403 | 59119.7 |
209 | 2021-10-28 04:59:19 | bannered | 1 | 82945 | 4 | 1.330 | 62364.7 |
208 | 2021-10-26 03:20:37 | bannered | 1 | 82945 | 4 | 1.546 | 53651.4 |
207 | 2021-09-29 05:38:18 | bannered | 1 | 82945 | 4 | 1.283 | 64649.3 |
206 | 2021-08-26 06:35:50 | bannered | 1 | 82945 | 4 | 1.283 | 64649.3 |
205 | 2021-07-01 03:20:47 | bannered | 1 | 82945 | 4 | 1.280 | 64800.8 |
204 | 2021-05-25 12:35:17 | bannered | 1 | 82945 | 4 | 1.423 | 58288.8 |
203 | 2021-03-28 18:48:04 | bannered | 1 | 82945 | 4 | 1.296 | 64000.8 |
202 | 2021-02-20 00:38:48 | bannered | 1 | 82945 | 4 | 1.483 | 55930.5 |
201 | 2021-02-06 17:14:20 | bannered | 1 | 82945 | 4 | 1.420 | 58412.0 |
200 | 2021-01-12 14:19:08 | bannered | 1 | 82945 | 4 | 1.280 | 64800.8 |
199 | 2020-11-21 02:23:55 | bannered | 1 | 82945 | 4 | 1.296 | 64000.8 |
198 | 2020-11-18 02:54:52 | bannered | 1 | 82945 | 4 | 1.390 | 59672.7 |
197 | 2020-11-13 13:25:19 | bannered | 1 | 82945 | 4 | 1.360 | 60989.0 |
196 | 2020-11-12 07:47:42 | bannered | 1 | 82945 | 4 | 1.376 | 60279.8 |
195 | 2020-10-25 20:47:40 | bannered | 1 | 82945 | 4 | 1.436 | 57761.1 |
194 | 2020-08-20 09:56:54 | bannered | 1 | 82945 | 4 | 1.326 | 62552.8 |
193 | 2020-07-30 07:15:56 | bannered | 1 | 82945 | 4 | 1.326 | 62552.8 |
192 | 2020-05-09 23:04:16 | bannered | 1 | 82945 | 4 | 1.343 | 61761.0 |
191 | 2020-04-16 10:12:20 | bannered | 1 | 82945 | 4 | 1.360 | 60989.0 |
190 | 2020-03-22 11:09:46 | bannered | 1 | 82945 | 4 | 1.563 | 53067.8 |