History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canister"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2024-05-01 11:23:27 | canister | 1 | 82945 | 6 | 5.016 | 16536.1 |
344 | 2024-04-29 21:31:49 | canister | 1 | 82945 | 6 | 4.890 | 16962.2 |
343 | 2024-04-06 18:16:35 | canister | 1 | 82945 | 6 | 4.173 | 19876.6 |
342 | 2024-03-30 14:50:07 | canister | 2 | 121059 | 24 | 9.016 | 13427.1 |
341 | 2024-03-30 13:16:43 | canister | 1 | 82945 | 6 | 2.423 | 34232.4 |
340 | 2024-03-30 10:26:30 | canister | 2 | 121059 | 24 | 4.360 | 27765.8 |
339 | 2024-03-30 10:26:09 | canister | 3 | 146162 | 215 | 8.593 | 17009.4 |
338 | 2024-03-30 06:41:46 | canister | 1 | 82945 | 6 | 3.343 | 24811.5 |
337 | 2024-03-28 21:57:59 | canister | 3 | 146162 | 215 | 23.063 | 6337.5 |
336 | 2024-03-28 21:58:02 | canister | 2 | 121059 | 24 | 4.640 | 26090.3 |
335 | 2024-03-28 06:52:15 | canister | 1 | 82945 | 6 | 1.470 | 56425.2 |
334 | 2024-03-28 06:52:12 | canister | 2 | 121059 | 24 | 3.673 | 32959.2 |
333 | 2024-03-28 06:51:42 | canister | 3 | 146162 | 215 | 8.283 | 17646.0 |
332 | 2024-03-27 16:55:47 | canister | 1 | 82945 | 6 | 1.533 | 54106.3 |
331 | 2024-03-26 03:25:00 | canister | 3 | 146162 | 215 | 6.766 | 21602.4 |
330 | 2024-02-28 11:11:25 | canister | 1 | 82945 | 6 | 1.640 | 50576.2 |
329 | 2023-12-29 23:20:08 | canister | 3 | 146162 | 215 | 7.576 | 19292.8 |
328 | 2023-12-29 23:20:10 | canister | 2 | 121059 | 24 | 4.080 | 29671.3 |
327 | 2023-12-21 09:07:12 | canister | 1 | 82945 | 6 | 1.343 | 61761.0 |
326 | 2023-12-18 08:22:29 | canister | 3 | 146162 | 215 | 8.046 | 18165.8 |
325 | 2023-12-18 08:22:32 | canister | 2 | 121059 | 24 | 4.046 | 29920.7 |
324 | 2023-12-03 15:16:17 | canister | 3 | 146162 | 215 | 8.000 | 18270.3 |
323 | 2023-12-03 15:11:41 | canister | 3 | 146162 | 215 | 7.530 | 19410.6 |
322 | 2023-12-03 15:06:43 | canister | 3 | 146162 | 215 | 6.763 | 21612.0 |
321 | 2023-12-01 01:01:45 | canister | 3 | 146162 | 215 | 7.720 | 18932.9 |
320 | 2023-11-19 20:47:54 | canister | 1 | 82945 | 6 | 1.483 | 55930.5 |
319 | 2023-11-14 08:59:47 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
318 | 2023-11-09 14:53:36 | canister | 1 | 82945 | 6 | 1.343 | 61761.0 |
317 | 2023-11-07 15:09:41 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
316 | 2023-10-29 09:18:54 | canister | 1 | 82945 | 6 | 1.533 | 54106.3 |
315 | 2023-10-27 18:52:01 | canister | 1 | 82945 | 6 | 1.360 | 60989.0 |
314 | 2023-10-13 19:15:25 | canister | 1 | 82945 | 6 | 1.376 | 60279.8 |
313 | 2023-10-08 05:55:21 | canister | 1 | 82945 | 6 | 1.330 | 62364.7 |
312 | 2023-09-28 23:26:14 | canister | 1 | 82945 | 6 | 1.390 | 59672.7 |
311 | 2023-08-28 18:01:54 | canister | 3 | 146162 | 215 | 6.940 | 21060.8 |
310 | 2023-08-04 15:34:08 | canister | 1 | 82945 | 6 | 1.280 | 64800.8 |
309 | 2023-07-12 11:42:40 | canister | 1 | 82945 | 6 | 1.436 | 57761.1 |
308 | 2023-07-08 17:09:58 | canister | 1 | 82945 | 6 | 1.406 | 58993.6 |
307 | 2023-05-14 22:59:19 | canister | 3 | 146162 | 215 | 6.513 | 22441.6 |
306 | 2023-05-02 01:43:07 | canister | 1 | 82945 | 6 | 1.436 | 57761.1 |
305 | 2023-03-21 12:23:27 | canister | 1 | 82945 | 6 | 1.313 | 63172.1 |
304 | 2023-02-22 19:47:14 | canister | 3 | 146162 | 215 | 7.673 | 19048.9 |
303 | 2023-02-22 14:52:33 | canister | 1 | 82945 | 6 | 1.300 | 63803.8 |
302 | 2022-12-23 01:32:32 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
301 | 2022-12-04 05:37:36 | canister | 3 | 146162 | 215 | 7.750 | 18859.6 |
300 | 2022-12-03 09:15:21 | canister | 1 | 82945 | 6 | 1.466 | 56579.1 |
299 | 2022-09-11 04:37:40 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
298 | 2022-08-03 04:15:06 | canister | 1 | 82945 | 6 | 1.360 | 60989.0 |
297 | 2022-07-12 03:29:02 | canister | 3 | 146162 | 215 | 6.436 | 22710.1 |
296 | 2022-05-13 14:17:56 | canister | 3 | 146162 | 215 | 8.296 | 17618.4 |
295 | 2022-04-24 15:58:01 | canister | 1 | 82945 | 6 | 1.560 | 53169.9 |
294 | 2022-04-05 04:12:01 | canister | 1 | 82945 | 6 | 1.873 | 44284.6 |
293 | 2022-04-01 17:25:11 | canister | 1 | 82945 | 6 | 1.563 | 53067.8 |
292 | 2022-01-13 20:26:21 | canister | 1 | 82945 | 6 | 1.390 | 59672.7 |
291 | 2022-01-11 17:07:10 | canister | 1 | 82945 | 6 | 1.343 | 61761.0 |
290 | 2021-12-14 22:11:48 | canister | 1 | 82945 | 6 | 1.580 | 52496.8 |
289 | 2021-11-07 16:40:14 | canister | 1 | 82945 | 6 | 1.453 | 57085.3 |
288 | 2021-09-20 23:13:08 | canister | 1 | 82945 | 6 | 1.470 | 56425.2 |
287 | 2021-09-07 16:09:57 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
286 | 2021-09-01 08:21:35 | canister | 1 | 82945 | 6 | 1.373 | 60411.5 |
285 | 2021-07-12 00:39:43 | canister | 1 | 82945 | 6 | 1.330 | 62364.7 |
284 | 2021-05-31 08:15:40 | canister | 1 | 82945 | 6 | 1.483 | 55930.5 |
283 | 2021-04-30 13:00:59 | canister | 1 | 82945 | 6 | 1.500 | 55296.7 |
282 | 2021-03-29 21:43:56 | canister | 1 | 82945 | 6 | 1.453 | 57085.3 |
281 | 2021-03-03 19:08:26 | canister | 1 | 82945 | 6 | 1.486 | 55817.6 |
280 | 2021-02-24 23:04:20 | canister | 1 | 82945 | 6 | 1.453 | 57085.3 |
279 | 2021-02-20 11:21:43 | canister | 1 | 82945 | 6 | 1.330 | 62364.7 |
278 | 2021-02-07 17:50:53 | canister | 1 | 82945 | 6 | 1.390 | 59672.7 |
277 | 2021-01-13 13:37:34 | canister | 1 | 82945 | 6 | 1.360 | 60989.0 |
276 | 2020-11-19 22:11:08 | canister | 1 | 82945 | 6 | 1.516 | 54713.1 |
275 | 2020-11-11 07:25:10 | canister | 1 | 82945 | 6 | 1.563 | 53067.8 |
274 | 2020-11-08 03:04:31 | canister | 1 | 82945 | 6 | 1.390 | 59672.7 |
273 | 2020-11-07 23:01:41 | canister | 1 | 82945 | 6 | 1.406 | 58993.6 |
272 | 2020-10-20 04:33:37 | canister | 1 | 82945 | 6 | 1.450 | 57203.4 |
271 | 2020-09-30 20:06:44 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
270 | 2020-08-23 22:59:44 | canister | 1 | 82945 | 6 | 1.466 | 56579.1 |
269 | 2020-08-21 03:04:17 | canister | 1 | 82945 | 6 | 1.486 | 55817.6 |
268 | 2020-08-16 12:46:47 | canister | 1 | 82945 | 6 | 1.470 | 56425.2 |
267 | 2020-05-25 10:19:48 | canister | 1 | 82945 | 6 | 1.406 | 58993.6 |
266 | 2020-05-15 06:02:16 | canister | 1 | 82945 | 6 | 1.513 | 54821.5 |
265 | 2020-03-22 21:45:43 | canister | 1 | 82945 | 6 | 1.483 | 55930.5 |
264 | 2020-03-10 00:32:34 | canister | 1 | 82945 | 6 | 1.516 | 54713.1 |
263 | 2020-02-28 02:13:57 | canister | 1 | 82945 | 6 | 2.580 | 32149.2 |
262 | 2020-02-18 02:35:14 | canister | 1 | 82945 | 6 | 3.216 | 25791.4 |
261 | 2020-02-13 02:27:17 | canister | 1 | 82945 | 6 | 1.673 | 49578.6 |
260 | 2020-02-12 14:24:10 | canister | 1 | 82945 | 6 | 1.470 | 56425.2 |
259 | 2020-02-08 06:19:39 | canister | 1 | 82945 | 6 | 3.203 | 25896.0 |
258 | 2020-02-08 00:59:42 | canister | 1 | 82945 | 6 | 3.390 | 24467.6 |
257 | 2020-02-03 03:52:09 | canister | 1 | 82945 | 6 | 3.360 | 24686.0 |
256 | 2020-02-02 11:34:40 | canister | 1 | 82945 | 6 | 1.580 | 52496.8 |
255 | 2020-01-30 12:41:17 | canister | 1 | 82945 | 6 | 1.406 | 58993.6 |
254 | 2020-01-22 19:21:09 | canister | 1 | 82945 | 6 | 1.670 | 49667.7 |
253 | 2020-01-21 21:49:31 | canister | 1 | 82945 | 6 | 2.123 | 39069.7 |
252 | 2020-01-15 17:51:53 | canister | 2 | 121059 | 24 | 8.263 | 14650.7 |
251 | 2020-01-15 11:57:58 | canister | 1 | 82945 | 6 | 1.673 | 49578.6 |
250 | 2020-01-10 07:23:38 | canister | 1 | 82945 | 6 | 3.233 | 25655.7 |
249 | 2020-01-03 05:08:20 | canister | 1 | 82945 | 6 | 1.720 | 48223.8 |
248 | 2019-12-31 21:54:48 | canister | 1 | 82945 | 6 | 1.296 | 64000.8 |
247 | 2019-12-30 05:08:32 | canister | 1 | 82945 | 6 | 1.563 | 53067.8 |
246 | 2019-11-15 09:51:20 | canister | 1 | 82945 | 6 | 1.453 | 57085.3 |