History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bandana"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
382 | 2024-05-07 09:34:05 | bandana | 2 | 107671 | 25 | 9.890 | 10886.9 |
381 | 2024-05-02 23:13:21 | bandana | 2 | 107671 | 25 | 7.626 | 14118.9 |
380 | 2024-05-02 21:16:27 | bandana | 3 | 134027 | 172 | 7.343 | 18252.3 |
379 | 2024-05-01 22:30:49 | bandana | 3 | 134027 | 172 | 17.296 | 7749.0 |
378 | 2024-05-01 20:00:54 | bandana | 3 | 134027 | 172 | 8.766 | 15289.4 |
377 | 2024-04-30 12:22:19 | bandana | 3 | 134027 | 172 | 7.016 | 19103.1 |
376 | 2024-04-26 10:01:23 | bandana | 1 | 69583 | 4 | 1.390 | 50059.7 |
375 | 2024-04-04 02:52:21 | bandana | 1 | 69583 | 4 | 5.563 | 12508.2 |
374 | 2024-04-03 20:25:27 | bandana | 1 | 69583 | 4 | 1.796 | 38743.3 |
373 | 2024-04-03 04:56:33 | bandana | 3 | 134027 | 172 | 14.596 | 9182.4 |
372 | 2024-04-02 18:45:26 | bandana | 3 | 134027 | 172 | 16.530 | 8108.1 |
371 | 2024-04-01 18:43:16 | bandana | 3 | 134027 | 172 | 18.750 | 7148.1 |
370 | 2024-04-01 16:58:11 | bandana | 2 | 107671 | 25 | 13.203 | 8155.0 |
369 | 2024-04-01 16:57:42 | bandana | 3 | 134027 | 172 | 19.940 | 6721.5 |
368 | 2024-04-01 16:57:55 | bandana | 1 | 69583 | 4 | 2.780 | 25029.9 |
367 | 2024-04-01 16:57:51 | bandana | 1 | 69583 | 4 | 3.173 | 21929.7 |
366 | 2024-04-01 16:57:37 | bandana | 2 | 107671 | 25 | 7.953 | 13538.4 |
365 | 2024-03-28 05:30:10 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
364 | 2024-03-13 16:01:35 | bandana | 2 | 107671 | 25 | 3.470 | 31029.1 |
363 | 2024-02-26 02:14:15 | bandana | 2 | 107671 | 25 | 11.393 | 9450.6 |
362 | 2024-02-26 02:14:09 | bandana | 3 | 134027 | 172 | 8.140 | 16465.2 |
361 | 2024-02-26 02:11:33 | bandana | 1 | 69583 | 4 | 3.953 | 17602.6 |
360 | 2023-12-25 09:18:28 | bandana | 1 | 69583 | 4 | 1.140 | 61037.7 |
359 | 2023-12-22 07:31:08 | bandana | 3 | 134027 | 172 | 5.830 | 22989.2 |
358 | 2023-11-30 20:26:48 | bandana | 2 | 107671 | 25 | 3.716 | 28975.0 |
357 | 2023-11-30 20:26:40 | bandana | 3 | 134027 | 172 | 7.030 | 19065.0 |
356 | 2023-11-29 20:32:48 | bandana | 2 | 107671 | 25 | 5.766 | 18673.4 |
355 | 2023-11-29 16:08:20 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
354 | 2023-11-20 07:42:17 | bandana | 2 | 107671 | 25 | 2.903 | 37089.6 |
353 | 2023-11-20 05:05:28 | bandana | 3 | 134027 | 172 | 14.970 | 8953.0 |
352 | 2023-11-12 22:01:33 | bandana | 1 | 69583 | 4 | 1.076 | 64668.2 |
351 | 2023-11-09 02:15:40 | bandana | 1 | 69583 | 4 | 1.076 | 64668.2 |
350 | 2023-10-30 18:53:03 | bandana | 3 | 134027 | 172 | 6.876 | 19492.0 |
349 | 2023-10-30 18:53:01 | bandana | 2 | 107671 | 25 | 3.390 | 31761.4 |
348 | 2023-10-27 17:23:56 | bandana | 1 | 69583 | 4 | 1.313 | 52995.4 |
347 | 2023-10-20 19:42:55 | bandana | 1 | 69583 | 4 | 1.360 | 51164.0 |
346 | 2023-10-18 04:48:28 | bandana | 1 | 69583 | 4 | 2.686 | 25905.8 |
345 | 2023-10-14 03:06:04 | bandana | 1 | 69583 | 4 | 1.140 | 61037.7 |
344 | 2023-10-13 10:50:14 | bandana | 1 | 69583 | 4 | 1.250 | 55666.4 |
343 | 2023-10-04 04:34:21 | bandana | 1 | 69583 | 4 | 1.250 | 55666.4 |
342 | 2023-09-23 18:45:43 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
341 | 2023-09-22 04:27:03 | bandana | 3 | 134027 | 172 | 5.906 | 22693.4 |
340 | 2023-09-12 11:04:02 | bandana | 1 | 69583 | 4 | 1.080 | 64428.7 |
339 | 2023-08-28 21:45:12 | bandana | 2 | 107671 | 25 | 2.856 | 37699.9 |
338 | 2023-08-09 12:31:03 | bandana | 1 | 69583 | 4 | 1.126 | 61796.6 |
337 | 2023-07-26 04:25:10 | bandana | 1 | 69583 | 4 | 1.063 | 65459.1 |
336 | 2023-07-01 03:13:54 | bandana | 3 | 134027 | 172 | 6.126 | 21878.4 |
335 | 2023-05-16 11:45:34 | bandana | 2 | 107671 | 25 | 2.860 | 37647.2 |
334 | 2023-05-11 16:02:14 | bandana | 1 | 69583 | 4 | 1.203 | 57841.2 |
333 | 2023-04-21 15:38:41 | bandana | 1 | 69583 | 4 | 1.216 | 57222.9 |
332 | 2023-03-21 21:03:50 | bandana | 3 | 134027 | 172 | 6.046 | 22167.9 |
331 | 2023-02-20 12:10:55 | bandana | 2 | 107671 | 25 | 2.876 | 37437.8 |
330 | 2023-01-26 01:44:46 | bandana | 3 | 134027 | 172 | 6.126 | 21878.4 |
329 | 2023-01-09 06:02:36 | bandana | 1 | 69583 | 4 | 1.076 | 64668.2 |
328 | 2022-12-21 12:26:09 | bandana | 3 | 134027 | 172 | 11.470 | 11685.0 |
327 | 2022-12-11 21:44:20 | bandana | 3 | 134027 | 172 | 6.190 | 21652.2 |
326 | 2022-12-04 06:03:15 | bandana | 2 | 107671 | 25 | 2.813 | 38276.2 |
325 | 2022-11-07 05:28:44 | bandana | 3 | 134027 | 172 | 5.936 | 22578.7 |
324 | 2022-10-25 12:02:27 | bandana | 3 | 134027 | 172 | 6.123 | 21889.1 |
323 | 2022-09-25 10:36:30 | bandana | 1 | 69583 | 4 | 1.076 | 64668.2 |
322 | 2022-09-25 08:12:26 | bandana | 3 | 134027 | 172 | 6.046 | 22167.9 |
321 | 2022-09-01 17:00:59 | bandana | 1 | 69583 | 4 | 1.063 | 65459.1 |
320 | 2022-08-20 03:48:20 | bandana | 3 | 134027 | 172 | 5.750 | 23309.0 |
319 | 2022-07-18 03:07:08 | bandana | 2 | 107671 | 25 | 2.906 | 37051.3 |
318 | 2022-07-08 14:48:11 | bandana | 1 | 69583 | 4 | 1.216 | 57222.9 |
317 | 2022-06-12 01:11:24 | bandana | 1 | 69583 | 4 | 1.250 | 55666.4 |
316 | 2022-03-18 03:40:20 | bandana | 3 | 134027 | 172 | 7.046 | 19021.7 |
315 | 2022-03-08 22:06:31 | bandana | 1 | 69583 | 4 | 1.890 | 36816.4 |
314 | 2022-03-04 19:33:52 | bandana | 2 | 107671 | 25 | 2.856 | 37699.9 |
313 | 2022-02-21 14:17:07 | bandana | 1 | 69583 | 4 | 1.406 | 49490.0 |
312 | 2021-12-21 10:40:33 | bandana | 1 | 69583 | 4 | 1.296 | 53690.6 |
311 | 2021-12-05 03:22:00 | bandana | 3 | 134027 | 172 | 7.000 | 19146.7 |
310 | 2021-11-30 18:33:50 | bandana | 2 | 107671 | 25 | 3.670 | 29338.1 |
309 | 2021-11-28 16:10:57 | bandana | 2 | 107671 | 25 | 3.516 | 30623.2 |
308 | 2021-11-16 20:53:21 | bandana | 1 | 69583 | 4 | 1.093 | 63662.4 |
307 | 2021-10-22 08:21:00 | bandana | 1 | 69583 | 4 | 1.313 | 52995.4 |
306 | 2021-10-20 07:10:38 | bandana | 1 | 69583 | 4 | 1.080 | 64428.7 |
305 | 2021-10-03 22:21:19 | bandana | 2 | 107671 | 25 | 2.813 | 38276.2 |
304 | 2021-09-14 13:10:24 | bandana | 1 | 69583 | 4 | 1.236 | 56296.9 |
303 | 2021-09-12 09:28:51 | bandana | 1 | 69583 | 4 | 1.186 | 58670.3 |
302 | 2021-08-23 15:10:58 | bandana | 1 | 69583 | 4 | 1.126 | 61796.6 |
301 | 2021-08-13 23:18:51 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
300 | 2021-05-13 05:59:59 | bandana | 1 | 69583 | 4 | 1.343 | 51811.6 |
299 | 2021-02-09 13:24:26 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
298 | 2020-11-07 20:25:46 | bandana | 1 | 69583 | 4 | 1.123 | 61961.7 |
297 | 2020-10-30 08:23:49 | bandana | 1 | 69583 | 4 | 1.233 | 56433.9 |
296 | 2020-10-11 13:52:22 | bandana | 1 | 69583 | 4 | 1.173 | 59320.5 |
295 | 2020-08-03 00:19:57 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
294 | 2020-06-13 23:38:26 | bandana | 1 | 69583 | 4 | 1.110 | 62687.4 |
293 | 2020-05-04 17:06:53 | bandana | 1 | 69583 | 4 | 1.186 | 58670.3 |
292 | 2020-03-25 07:43:34 | bandana | 1 | 69583 | 4 | 1.080 | 64428.7 |
291 | 2020-03-20 18:50:15 | bandana | 1 | 69583 | 4 | 1.173 | 59320.5 |
290 | 2020-03-05 06:48:36 | bandana | 3 | 134027 | 172 | 5.970 | 22450.1 |
289 | 2020-02-29 04:46:45 | bandana | 1 | 69583 | 4 | 1.373 | 50679.5 |
288 | 2020-02-27 00:51:58 | bandana | 3 | 134027 | 172 | 7.843 | 17088.7 |
287 | 2020-02-21 07:07:22 | bandana | 1 | 69583 | 4 | 1.453 | 47889.2 |
286 | 2020-02-12 22:20:02 | bandana | 1 | 69583 | 4 | 2.656 | 26198.4 |
285 | 2020-02-10 09:57:29 | bandana | 1 | 69583 | 4 | 2.783 | 25002.9 |
284 | 2020-02-09 12:42:57 | bandana | 3 | 134027 | 172 | 7.456 | 17975.7 |
283 | 2020-02-06 12:27:21 | bandana | 3 | 134027 | 172 | 6.123 | 21889.1 |