History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shelly"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
371 | 2024-04-27 21:52:00 | shelly | 1 | 48755 | 6 | 3.500 | 13930.0 |
370 | 2024-04-22 23:27:29 | shelly | 1 | 48755 | 6 | 0.953 | 51159.5 |
369 | 2024-04-05 19:01:12 | shelly | 1 | 48755 | 6 | 3.376 | 14441.6 |
368 | 2024-04-01 18:20:08 | shelly | 2 | 82551 | 68 | 2.530 | 32628.9 |
367 | 2024-03-31 19:17:02 | shelly | 3 | 112716 | 593 | 7.860 | 14340.5 |
366 | 2024-03-31 19:07:16 | shelly | 3 | 112716 | 593 | 12.580 | 8959.9 |
365 | 2024-03-29 07:03:56 | shelly | 1 | 48755 | 6 | 2.063 | 23633.1 |
364 | 2024-03-05 22:30:03 | shelly | 2 | 82551 | 68 | 6.550 | 12603.2 |
363 | 2024-03-05 18:39:55 | shelly | 3 | 112716 | 593 | 15.643 | 7205.5 |
362 | 2024-03-05 03:38:25 | shelly | 2 | 82551 | 68 | 5.890 | 14015.4 |
361 | 2024-03-05 03:33:21 | shelly | 3 | 112716 | 593 | 6.516 | 17298.3 |
360 | 2024-03-04 09:36:49 | shelly | 3 | 112716 | 593 | 12.546 | 8984.2 |
359 | 2024-03-04 09:36:50 | shelly | 2 | 82551 | 68 | 7.906 | 10441.6 |
358 | 2024-03-04 09:36:41 | shelly | 1 | 48755 | 6 | 2.890 | 16870.2 |
357 | 2024-03-04 09:36:28 | shelly | 3 | 112716 | 593 | 14.750 | 7641.8 |
356 | 2024-03-04 09:36:26 | shelly | 2 | 82551 | 68 | 7.093 | 11638.4 |
355 | 2024-03-04 09:36:26 | shelly | 1 | 48755 | 6 | 0.953 | 51159.5 |
354 | 2024-02-28 02:44:03 | shelly | 1 | 48755 | 6 | 2.483 | 19635.5 |
353 | 2024-02-20 22:00:49 | shelly | 1 | 48755 | 6 | 2.063 | 23633.1 |
352 | 2024-01-01 11:15:30 | shelly | 1 | 48755 | 6 | 0.800 | 60943.8 |
351 | 2023-12-05 18:50:04 | shelly | 3 | 112716 | 593 | 4.656 | 24208.8 |
350 | 2023-12-03 16:43:56 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
349 | 2023-11-23 20:57:55 | shelly | 2 | 82551 | 68 | 2.406 | 34310.5 |
348 | 2023-11-23 20:57:48 | shelly | 3 | 112716 | 593 | 5.486 | 20546.1 |
347 | 2023-11-22 22:38:22 | shelly | 1 | 48755 | 6 | 0.860 | 56691.9 |
346 | 2023-11-20 21:26:03 | shelly | 1 | 48755 | 6 | 0.843 | 57835.1 |
345 | 2023-11-18 19:08:47 | shelly | 1 | 48755 | 6 | 1.250 | 39004.0 |
344 | 2023-11-09 14:30:33 | shelly | 1 | 48755 | 6 | 0.810 | 60191.4 |
343 | 2023-11-02 15:59:07 | shelly | 1 | 48755 | 6 | 0.826 | 59025.4 |
342 | 2023-10-31 09:21:50 | shelly | 1 | 48755 | 6 | 0.876 | 55656.4 |
341 | 2023-10-28 01:31:19 | shelly | 1 | 48755 | 6 | 0.843 | 57835.1 |
340 | 2023-10-24 05:01:48 | shelly | 1 | 48755 | 6 | 0.876 | 55656.4 |
339 | 2023-10-13 22:53:49 | shelly | 1 | 48755 | 6 | 0.830 | 58741.0 |
338 | 2023-09-24 08:22:14 | shelly | 1 | 48755 | 6 | 0.830 | 58741.0 |
337 | 2023-09-22 16:27:31 | shelly | 1 | 48755 | 6 | 0.810 | 60191.4 |
336 | 2023-09-17 21:44:15 | shelly | 1 | 48755 | 6 | 0.860 | 56691.9 |
335 | 2023-09-04 07:43:40 | shelly | 3 | 112716 | 593 | 5.190 | 21717.9 |
334 | 2023-07-11 16:16:48 | shelly | 1 | 48755 | 6 | 0.736 | 66243.2 |
333 | 2023-07-05 02:19:33 | shelly | 1 | 48755 | 6 | 0.826 | 59025.4 |
332 | 2023-04-11 04:06:18 | shelly | 1 | 48755 | 6 | 0.736 | 66243.2 |
331 | 2023-03-27 16:20:18 | shelly | 1 | 48755 | 6 | 0.846 | 57630.0 |
330 | 2023-02-04 07:24:01 | shelly | 1 | 48755 | 6 | 0.763 | 63899.1 |
329 | 2023-01-30 03:45:30 | shelly | 3 | 112716 | 593 | 4.546 | 24794.5 |
328 | 2023-01-25 11:00:22 | shelly | 3 | 112716 | 593 | 5.046 | 22337.7 |
327 | 2022-12-11 10:09:10 | shelly | 3 | 112716 | 593 | 5.640 | 19985.1 |
326 | 2022-12-09 06:33:22 | shelly | 1 | 48755 | 6 | 0.763 | 63899.1 |
325 | 2022-12-02 01:36:20 | shelly | 1 | 48755 | 6 | 0.750 | 65006.7 |
324 | 2022-11-11 21:27:08 | shelly | 3 | 112716 | 593 | 5.016 | 22471.3 |
323 | 2022-08-12 07:41:25 | shelly | 1 | 48755 | 6 | 0.826 | 59025.4 |
322 | 2022-07-28 00:58:22 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
321 | 2022-06-14 16:26:51 | shelly | 3 | 112716 | 593 | 4.596 | 24524.8 |
320 | 2022-06-03 10:45:06 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
319 | 2022-04-22 13:01:58 | shelly | 1 | 48755 | 6 | 1.143 | 42655.3 |
318 | 2022-04-14 20:44:45 | shelly | 1 | 48755 | 6 | 1.060 | 45995.3 |
317 | 2022-03-22 17:40:13 | shelly | 1 | 48755 | 6 | 0.826 | 59025.4 |
316 | 2022-03-20 13:54:13 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
315 | 2022-02-15 23:52:49 | shelly | 1 | 48755 | 6 | 0.906 | 53813.5 |
314 | 2021-12-30 03:34:22 | shelly | 1 | 48755 | 6 | 0.906 | 53813.5 |
313 | 2021-12-24 10:31:47 | shelly | 1 | 48755 | 6 | 0.796 | 61250.0 |
312 | 2021-10-25 05:24:45 | shelly | 1 | 48755 | 6 | 0.860 | 56691.9 |
311 | 2021-09-26 04:01:19 | shelly | 1 | 48755 | 6 | 0.750 | 65006.7 |
310 | 2021-09-23 01:13:18 | shelly | 1 | 48755 | 6 | 0.766 | 63648.8 |
309 | 2021-09-13 06:10:48 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
308 | 2021-08-26 16:10:54 | shelly | 1 | 48755 | 6 | 0.843 | 57835.1 |
307 | 2021-07-05 01:17:15 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
306 | 2021-06-19 22:37:55 | shelly | 1 | 48755 | 6 | 0.890 | 54780.9 |
305 | 2021-06-16 17:52:56 | shelly | 1 | 48755 | 6 | 0.890 | 54780.9 |
304 | 2021-04-24 13:15:28 | shelly | 1 | 48755 | 6 | 0.840 | 58041.7 |
303 | 2021-04-19 00:03:22 | shelly | 1 | 48755 | 6 | 1.813 | 26891.9 |
302 | 2021-03-21 20:44:43 | shelly | 1 | 48755 | 6 | 0.936 | 52088.7 |
301 | 2021-03-13 21:18:07 | shelly | 1 | 48755 | 6 | 0.766 | 63648.8 |
300 | 2021-01-31 11:00:15 | shelly | 1 | 48755 | 6 | 0.796 | 61250.0 |
299 | 2021-01-03 16:04:34 | shelly | 1 | 48755 | 6 | 0.826 | 59025.4 |
298 | 2020-12-10 20:31:13 | shelly | 1 | 48755 | 6 | 0.750 | 65006.7 |
297 | 2020-11-18 05:42:39 | shelly | 1 | 48755 | 6 | 0.796 | 61250.0 |
296 | 2020-10-18 10:13:08 | shelly | 1 | 48755 | 6 | 0.783 | 62266.9 |
295 | 2020-10-18 02:14:25 | shelly | 1 | 48755 | 6 | 0.766 | 63648.8 |
294 | 2020-10-17 01:52:52 | shelly | 1 | 48755 | 6 | 1.466 | 33257.2 |
293 | 2020-10-16 04:09:56 | shelly | 1 | 48755 | 6 | 0.873 | 55847.7 |
292 | 2020-10-11 06:16:35 | shelly | 1 | 48755 | 6 | 0.766 | 63648.8 |
291 | 2020-09-30 03:09:48 | shelly | 1 | 48755 | 6 | 0.750 | 65006.7 |
290 | 2020-09-04 03:14:32 | shelly | 1 | 48755 | 6 | 0.893 | 54596.9 |
289 | 2020-08-28 02:54:52 | shelly | 1 | 48755 | 6 | 0.856 | 56956.8 |
288 | 2020-08-26 14:16:07 | shelly | 1 | 48755 | 6 | 0.813 | 59969.2 |
287 | 2020-08-25 16:25:54 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
286 | 2020-08-17 11:50:31 | shelly | 1 | 48755 | 6 | 0.796 | 61250.0 |
285 | 2020-05-29 23:43:32 | shelly | 1 | 48755 | 6 | 0.733 | 66514.3 |
284 | 2020-05-28 03:08:09 | shelly | 1 | 48755 | 6 | 0.846 | 57630.0 |
283 | 2020-03-27 15:14:50 | shelly | 1 | 48755 | 6 | 0.906 | 53813.5 |
282 | 2020-03-27 00:06:53 | shelly | 1 | 48755 | 6 | 0.766 | 63648.8 |
281 | 2020-03-25 03:00:47 | shelly | 1 | 48755 | 6 | 0.783 | 62266.9 |
280 | 2020-03-23 01:51:02 | shelly | 1 | 48755 | 6 | 0.890 | 54780.9 |
279 | 2020-03-22 17:46:58 | shelly | 1 | 48755 | 6 | 0.953 | 51159.5 |
278 | 2020-03-19 13:46:48 | shelly | 1 | 48755 | 6 | 0.780 | 62506.4 |
277 | 2020-03-04 19:59:54 | shelly | 1 | 48755 | 6 | 0.813 | 59969.2 |
276 | 2020-02-26 18:50:18 | shelly | 1 | 48755 | 6 | 0.906 | 53813.5 |
275 | 2020-02-26 17:43:34 | shelly | 1 | 48755 | 6 | 0.860 | 56691.9 |
274 | 2020-02-22 17:13:22 | shelly | 1 | 48755 | 6 | 0.936 | 52088.7 |
273 | 2020-02-13 21:46:48 | shelly | 1 | 48755 | 6 | 2.860 | 17047.2 |
272 | 2020-02-03 13:10:07 | shelly | 1 | 48755 | 6 | 0.873 | 55847.7 |