History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"madcap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-04-13 08:14:28 | madcap | 1 | 48755 | 4 | 0.856 | 56956.8 |
400 | 2024-04-11 01:16:40 | madcap | 3 | 112716 | 203 | 5.906 | 19085.0 |
399 | 2024-04-08 22:12:39 | madcap | 3 | 112716 | 203 | 14.983 | 7522.9 |
398 | 2024-04-06 13:37:12 | madcap | 3 | 112716 | 203 | 13.453 | 8378.5 |
397 | 2024-04-06 13:37:04 | madcap | 2 | 82551 | 13 | 6.436 | 12826.4 |
396 | 2024-04-06 13:36:57 | madcap | 1 | 48755 | 4 | 1.313 | 37132.5 |
395 | 2024-03-30 14:52:20 | madcap | 1 | 48755 | 4 | 2.716 | 17951.0 |
394 | 2024-03-01 09:26:36 | madcap | 3 | 112716 | 203 | 11.593 | 9722.8 |
393 | 2024-02-28 07:40:37 | madcap | 3 | 112716 | 203 | 9.406 | 11983.4 |
392 | 2024-02-28 07:40:36 | madcap | 2 | 82551 | 13 | 6.440 | 12818.5 |
391 | 2024-02-28 07:40:34 | madcap | 1 | 48755 | 4 | 0.936 | 52088.7 |
390 | 2024-01-16 13:41:12 | madcap | 3 | 112716 | 203 | 5.343 | 21096.0 |
389 | 2024-01-16 13:41:13 | madcap | 2 | 82551 | 13 | 2.673 | 30883.3 |
388 | 2024-01-11 19:05:42 | madcap | 3 | 112716 | 203 | 7.830 | 14395.4 |
387 | 2024-01-09 04:05:06 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
386 | 2023-12-31 00:44:27 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
385 | 2023-12-26 03:46:25 | madcap | 2 | 82551 | 13 | 2.606 | 31677.3 |
384 | 2023-12-23 02:12:47 | madcap | 2 | 82551 | 13 | 2.530 | 32628.9 |
383 | 2023-12-23 02:12:43 | madcap | 3 | 112716 | 203 | 5.076 | 22205.7 |
382 | 2023-11-18 08:17:39 | madcap | 1 | 48755 | 4 | 0.796 | 61250.0 |
381 | 2023-11-15 07:58:41 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
380 | 2023-11-13 12:02:07 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
379 | 2023-11-12 07:52:08 | madcap | 1 | 48755 | 4 | 0.873 | 55847.7 |
378 | 2023-11-05 07:57:14 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
377 | 2023-10-22 18:43:39 | madcap | 1 | 48755 | 4 | 1.703 | 28628.9 |
376 | 2023-10-15 13:07:57 | madcap | 1 | 48755 | 4 | 1.000 | 48755.0 |
375 | 2023-09-27 18:47:25 | madcap | 1 | 48755 | 4 | 0.843 | 57835.1 |
374 | 2023-09-26 22:34:46 | madcap | 2 | 82551 | 13 | 2.610 | 31628.7 |
373 | 2023-09-13 14:57:07 | madcap | 1 | 48755 | 4 | 0.826 | 59025.4 |
372 | 2023-09-06 08:36:56 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
371 | 2023-08-17 13:55:57 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
370 | 2023-07-06 18:59:35 | madcap | 2 | 82551 | 13 | 2.406 | 34310.5 |
369 | 2023-05-18 22:09:37 | madcap | 1 | 48755 | 4 | 0.860 | 56691.9 |
368 | 2023-05-13 15:19:13 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
367 | 2023-03-27 02:42:10 | madcap | 2 | 82551 | 13 | 2.110 | 39123.7 |
366 | 2023-03-12 06:53:35 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
365 | 2023-01-24 03:41:11 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
364 | 2023-01-01 20:15:04 | madcap | 1 | 48755 | 4 | 0.733 | 66514.3 |
363 | 2022-12-25 02:12:09 | madcap | 2 | 82551 | 13 | 2.406 | 34310.5 |
362 | 2022-09-21 19:30:50 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
361 | 2022-09-21 14:53:11 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
360 | 2022-08-26 03:19:22 | madcap | 2 | 82551 | 13 | 2.170 | 38041.9 |
359 | 2022-08-07 16:03:38 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
358 | 2022-05-26 04:55:45 | madcap | 1 | 48755 | 4 | 0.733 | 66514.3 |
357 | 2022-05-02 15:22:28 | madcap | 1 | 48755 | 4 | 1.186 | 41108.8 |
356 | 2022-04-30 10:46:10 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
355 | 2022-03-21 07:01:48 | madcap | 2 | 82551 | 13 | 2.126 | 38829.3 |
354 | 2022-01-28 03:46:54 | madcap | 1 | 48755 | 4 | 0.860 | 56691.9 |
353 | 2022-01-21 15:46:32 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
352 | 2021-12-25 02:45:50 | madcap | 2 | 82551 | 13 | 2.500 | 33020.4 |
351 | 2021-12-08 01:18:00 | madcap | 1 | 48755 | 4 | 0.783 | 62266.9 |
350 | 2021-10-11 11:08:46 | madcap | 1 | 48755 | 4 | 0.826 | 59025.4 |
349 | 2021-10-10 12:54:05 | madcap | 3 | 112716 | 203 | 8.576 | 13143.2 |
348 | 2021-08-07 11:40:56 | madcap | 3 | 112716 | 203 | 4.593 | 24540.8 |
347 | 2021-08-07 04:33:49 | madcap | 3 | 112716 | 203 | 4.656 | 24208.8 |
346 | 2021-08-03 08:17:59 | madcap | 3 | 112716 | 203 | 4.703 | 23966.8 |
345 | 2021-07-09 22:34:42 | madcap | 1 | 48755 | 4 | 0.860 | 56691.9 |
344 | 2021-05-04 17:06:45 | madcap | 1 | 48755 | 4 | 0.873 | 55847.7 |
343 | 2021-04-06 02:09:25 | madcap | 1 | 48755 | 4 | 0.843 | 57835.1 |
342 | 2021-04-02 19:15:03 | madcap | 1 | 48755 | 4 | 0.783 | 62266.9 |
341 | 2021-04-01 22:17:54 | madcap | 1 | 48755 | 4 | 0.876 | 55656.4 |
340 | 2021-02-11 07:06:28 | madcap | 1 | 48755 | 4 | 0.893 | 54596.9 |
339 | 2020-12-24 16:11:45 | madcap | 1 | 48755 | 4 | 0.763 | 63899.1 |
338 | 2020-11-02 03:05:13 | madcap | 1 | 48755 | 4 | 0.826 | 59025.4 |
337 | 2020-10-14 02:27:20 | madcap | 1 | 48755 | 4 | 0.813 | 59969.2 |
336 | 2020-09-20 19:41:02 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
335 | 2020-09-07 03:40:08 | madcap | 1 | 48755 | 4 | 0.733 | 66514.3 |
334 | 2020-06-04 19:41:22 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
333 | 2020-06-04 11:08:11 | madcap | 1 | 48755 | 4 | 0.780 | 62506.4 |
332 | 2020-03-26 12:45:56 | madcap | 1 | 48755 | 4 | 0.876 | 55656.4 |
331 | 2020-03-25 21:28:43 | madcap | 1 | 48755 | 4 | 0.763 | 63899.1 |
330 | 2020-03-25 02:28:54 | madcap | 1 | 48755 | 4 | 0.783 | 62266.9 |
329 | 2020-03-23 13:24:12 | madcap | 1 | 48755 | 4 | 1.796 | 27146.4 |
328 | 2020-03-23 06:53:17 | madcap | 1 | 48755 | 4 | 0.860 | 56691.9 |
327 | 2020-03-21 14:44:20 | madcap | 1 | 48755 | 4 | 1.686 | 28917.6 |
326 | 2020-03-18 03:27:10 | madcap | 1 | 48755 | 4 | 0.856 | 56956.8 |
325 | 2020-03-06 19:59:21 | madcap | 1 | 48755 | 4 | 0.750 | 65006.7 |
324 | 2020-03-02 22:33:47 | madcap | 1 | 48755 | 4 | 2.016 | 24184.0 |
323 | 2020-02-29 00:50:10 | madcap | 1 | 48755 | 4 | 1.766 | 27607.6 |
322 | 2020-02-26 22:26:31 | madcap | 1 | 48755 | 4 | 1.923 | 25353.6 |
321 | 2020-02-26 21:24:04 | madcap | 1 | 48755 | 4 | 1.780 | 27390.4 |
320 | 2020-02-15 01:19:25 | madcap | 1 | 48755 | 4 | 1.500 | 32503.3 |
319 | 2020-02-09 00:20:55 | madcap | 1 | 48755 | 4 | 0.936 | 52088.7 |
318 | 2020-02-05 22:16:27 | madcap | 1 | 48755 | 4 | 0.940 | 51867.0 |
317 | 2020-02-03 10:08:38 | madcap | 1 | 48755 | 4 | 1.986 | 24549.3 |
316 | 2020-02-03 01:44:05 | madcap | 1 | 48755 | 4 | 1.846 | 26411.2 |
315 | 2020-01-28 07:51:30 | madcap | 1 | 48755 | 4 | 0.920 | 52994.6 |
314 | 2020-01-22 01:17:35 | madcap | 1 | 48755 | 4 | 3.360 | 14510.4 |
313 | 2020-01-15 23:27:24 | madcap | 1 | 48755 | 4 | 2.220 | 21961.7 |
312 | 2020-01-14 12:39:46 | madcap | 1 | 48755 | 4 | 0.966 | 50471.0 |
311 | 2020-01-12 03:07:17 | madcap | 1 | 48755 | 4 | 1.903 | 25620.1 |
310 | 2020-01-03 08:29:14 | madcap | 1 | 48755 | 4 | 0.843 | 57835.1 |
309 | 2019-12-26 23:57:09 | madcap | 1 | 48755 | 4 | 0.906 | 53813.5 |
308 | 2019-12-26 07:38:14 | madcap | 1 | 48755 | 4 | 0.860 | 56691.9 |
307 | 2019-12-26 06:40:07 | madcap | 1 | 48755 | 4 | 1.923 | 25353.6 |
306 | 2019-12-25 21:45:21 | madcap | 1 | 48755 | 4 | 0.796 | 61250.0 |
305 | 2019-12-17 06:26:56 | madcap | 1 | 48755 | 4 | 0.780 | 62506.4 |
304 | 2019-11-27 01:07:45 | madcap | 1 | 48755 | 4 | 0.906 | 53813.5 |
303 | 2019-11-18 10:45:51 | madcap | 1 | 48755 | 4 | 0.766 | 63648.8 |
302 | 2019-11-12 00:41:12 | madcap | 1 | 48755 | 4 | 0.890 | 54780.9 |