History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bantam"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
355 | 2024-04-06 00:01:08 | bantam | 1 | 48755 | 2 | 2.000 | 24377.5 |
354 | 2024-03-31 13:53:05 | bantam | 1 | 48755 | 2 | 2.640 | 18467.8 |
353 | 2024-03-28 19:39:18 | bantam | 1 | 48755 | 2 | 2.936 | 16605.9 |
352 | 2024-03-06 23:56:33 | bantam | 1 | 48755 | 2 | 1.186 | 41108.8 |
351 | 2024-02-23 19:38:29 | bantam | 2 | 82551 | 23 | 2.530 | 32628.9 |
350 | 2024-02-06 15:31:31 | bantam | 1 | 48755 | 2 | 1.796 | 27146.4 |
349 | 2024-02-02 20:09:43 | bantam | 1 | 48755 | 2 | 1.843 | 26454.2 |
348 | 2024-01-19 20:55:47 | bantam | 1 | 48755 | 2 | 0.783 | 62266.9 |
347 | 2024-01-16 00:09:17 | bantam | 3 | 112716 | 462 | 4.966 | 22697.5 |
346 | 2024-01-15 13:43:03 | bantam | 2 | 82551 | 23 | 2.796 | 29524.7 |
345 | 2023-12-27 03:09:25 | bantam | 1 | 48755 | 2 | 0.876 | 55656.4 |
344 | 2023-12-18 13:02:34 | bantam | 3 | 112716 | 462 | 5.486 | 20546.1 |
343 | 2023-12-18 13:02:32 | bantam | 2 | 82551 | 23 | 2.420 | 34112.0 |
342 | 2023-11-20 09:00:09 | bantam | 2 | 82551 | 23 | 2.220 | 37185.1 |
341 | 2023-11-17 05:14:46 | bantam | 1 | 48755 | 2 | 0.906 | 53813.5 |
340 | 2023-11-16 18:42:12 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
339 | 2023-11-12 03:13:00 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
338 | 2023-11-07 07:54:03 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
337 | 2023-11-03 15:00:25 | bantam | 1 | 48755 | 2 | 0.780 | 62506.4 |
336 | 2023-11-01 23:57:03 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
335 | 2023-11-01 15:50:15 | bantam | 2 | 82551 | 23 | 2.326 | 35490.5 |
334 | 2023-10-22 13:18:07 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
333 | 2023-10-18 16:42:28 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
332 | 2023-10-18 13:38:56 | bantam | 1 | 48755 | 2 | 0.796 | 61250.0 |
331 | 2023-10-11 18:19:58 | bantam | 1 | 48755 | 2 | 0.970 | 50262.9 |
330 | 2023-09-23 18:55:41 | bantam | 1 | 48755 | 2 | 0.856 | 56956.8 |
329 | 2023-09-15 11:52:11 | bantam | 1 | 48755 | 2 | 0.810 | 60191.4 |
328 | 2023-09-03 04:54:03 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
327 | 2023-08-20 16:32:49 | bantam | 2 | 82551 | 23 | 2.296 | 35954.3 |
326 | 2023-07-09 06:58:26 | bantam | 1 | 48755 | 2 | 0.733 | 66514.3 |
325 | 2023-06-09 07:16:03 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
324 | 2023-05-03 16:09:48 | bantam | 2 | 82551 | 23 | 2.140 | 38575.2 |
323 | 2023-04-01 18:08:04 | bantam | 1 | 48755 | 2 | 0.753 | 64747.7 |
322 | 2023-03-31 13:03:33 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
321 | 2023-03-28 22:54:56 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
320 | 2023-03-03 02:07:44 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
319 | 2023-02-07 02:22:04 | bantam | 2 | 82551 | 23 | 2.420 | 34112.0 |
318 | 2023-01-11 20:43:27 | bantam | 1 | 48755 | 2 | 0.830 | 58741.0 |
317 | 2022-12-27 13:58:26 | bantam | 1 | 48755 | 2 | 0.826 | 59025.4 |
316 | 2022-11-19 02:37:39 | bantam | 2 | 82551 | 23 | 2.140 | 38575.2 |
315 | 2022-10-30 12:47:49 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
314 | 2022-09-13 04:58:59 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
313 | 2022-09-11 16:34:37 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
312 | 2022-08-27 19:10:16 | bantam | 1 | 48755 | 2 | 0.876 | 55656.4 |
311 | 2022-07-30 07:58:08 | bantam | 1 | 48755 | 2 | 0.780 | 62506.4 |
310 | 2022-07-18 00:25:28 | bantam | 1 | 48755 | 2 | 0.733 | 66514.3 |
309 | 2022-06-22 21:19:53 | bantam | 2 | 82551 | 23 | 2.173 | 37989.4 |
308 | 2022-06-18 16:03:52 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
307 | 2022-05-24 20:41:30 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
306 | 2022-05-21 11:02:40 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
305 | 2022-04-09 17:09:11 | bantam | 2 | 82551 | 23 | 2.203 | 37472.1 |
304 | 2022-03-15 21:26:30 | bantam | 2 | 82551 | 23 | 2.500 | 33020.4 |
303 | 2022-02-17 10:14:52 | bantam | 1 | 48755 | 2 | 0.940 | 51867.0 |
302 | 2022-02-13 07:37:32 | bantam | 1 | 48755 | 2 | 0.846 | 57630.0 |
301 | 2022-02-10 19:59:00 | bantam | 2 | 82551 | 23 | 2.390 | 34540.2 |
300 | 2022-01-27 13:42:27 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
299 | 2021-12-28 13:14:06 | bantam | 1 | 48755 | 2 | 0.873 | 55847.7 |
298 | 2021-12-19 06:51:15 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
297 | 2021-11-30 07:53:03 | bantam | 2 | 82551 | 23 | 2.500 | 33020.4 |
296 | 2021-11-10 16:19:15 | bantam | 1 | 48755 | 2 | 0.780 | 62506.4 |
295 | 2021-11-08 20:26:23 | bantam | 1 | 48755 | 2 | 0.856 | 56956.8 |
294 | 2021-09-16 15:40:01 | bantam | 1 | 48755 | 2 | 0.826 | 59025.4 |
293 | 2021-08-09 05:38:36 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
292 | 2021-08-05 18:38:45 | bantam | 1 | 48755 | 2 | 0.796 | 61250.0 |
291 | 2021-07-29 10:59:24 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
290 | 2021-07-24 03:42:00 | bantam | 1 | 48755 | 2 | 0.846 | 57630.0 |
289 | 2021-05-13 23:56:47 | bantam | 1 | 48755 | 2 | 0.906 | 53813.5 |
288 | 2021-05-01 17:38:32 | bantam | 1 | 48755 | 2 | 0.906 | 53813.5 |
287 | 2021-04-13 00:30:55 | bantam | 1 | 48755 | 2 | 0.876 | 55656.4 |
286 | 2021-03-16 19:24:18 | bantam | 1 | 48755 | 2 | 0.780 | 62506.4 |
285 | 2021-02-19 19:21:19 | bantam | 1 | 48755 | 2 | 0.873 | 55847.7 |
284 | 2021-01-29 07:52:44 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
283 | 2021-01-27 06:20:07 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
282 | 2021-01-27 05:45:04 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
281 | 2021-01-26 17:23:59 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
280 | 2020-11-13 22:24:41 | bantam | 1 | 48755 | 2 | 0.920 | 52994.6 |
279 | 2020-11-04 22:05:49 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
278 | 2020-10-30 21:23:46 | bantam | 1 | 48755 | 2 | 0.796 | 61250.0 |
277 | 2020-10-26 13:26:42 | bantam | 1 | 48755 | 2 | 0.860 | 56691.9 |
276 | 2020-10-12 09:08:01 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
275 | 2020-09-27 17:42:42 | bantam | 1 | 48755 | 2 | 0.750 | 65006.7 |
274 | 2020-09-26 07:56:39 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
273 | 2020-08-06 01:57:52 | bantam | 1 | 48755 | 2 | 0.763 | 63899.1 |
272 | 2020-07-27 23:05:19 | bantam | 1 | 48755 | 2 | 0.843 | 57835.1 |
271 | 2020-07-22 19:57:36 | bantam | 1 | 48755 | 2 | 0.780 | 62506.4 |
270 | 2020-07-12 08:19:27 | bantam | 1 | 48755 | 2 | 0.796 | 61250.0 |
269 | 2020-05-10 13:52:59 | bantam | 1 | 48755 | 2 | 0.826 | 59025.4 |
268 | 2020-04-20 21:06:56 | bantam | 1 | 48755 | 2 | 0.766 | 63648.8 |
267 | 2020-03-25 18:26:42 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
266 | 2020-03-23 12:39:32 | bantam | 1 | 48755 | 2 | 0.876 | 55656.4 |
265 | 2020-03-23 06:58:40 | bantam | 1 | 48755 | 2 | 0.906 | 53813.5 |
264 | 2020-03-23 03:56:50 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
263 | 2020-03-21 10:28:36 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
262 | 2020-03-18 01:44:13 | bantam | 1 | 48755 | 2 | 0.890 | 54780.9 |
261 | 2020-02-22 20:51:35 | bantam | 1 | 48755 | 2 | 1.890 | 25796.3 |
260 | 2020-02-19 10:29:23 | bantam | 1 | 48755 | 2 | 0.873 | 55847.7 |
259 | 2020-02-12 09:28:10 | bantam | 1 | 48755 | 2 | 0.873 | 55847.7 |
258 | 2020-02-03 10:19:57 | bantam | 1 | 48755 | 2 | 1.626 | 29984.6 |
257 | 2020-02-01 08:03:36 | bantam | 1 | 48755 | 2 | 2.236 | 21804.6 |
256 | 2020-01-31 08:34:28 | bantam | 1 | 48755 | 2 | 1.050 | 46433.3 |