History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"excess"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-04-25 18:20:22 | excess | 1 | 48755 | 2 | 0.953 | 51159.5 |
400 | 2024-03-31 06:00:14 | excess | 1 | 48755 | 2 | 1.000 | 48755.0 |
399 | 2024-03-29 21:21:19 | excess | 1 | 48755 | 2 | 3.030 | 16090.8 |
398 | 2024-03-21 22:58:45 | excess | 2 | 82551 | 24 | 5.576 | 14804.7 |
397 | 2024-03-21 22:42:55 | excess | 3 | 112716 | 317 | 6.220 | 18121.5 |
396 | 2024-03-19 17:18:42 | excess | 2 | 82551 | 24 | 2.186 | 37763.5 |
395 | 2024-03-19 17:18:07 | excess | 3 | 112716 | 317 | 5.546 | 20323.8 |
394 | 2024-03-18 21:15:01 | excess | 3 | 112716 | 317 | 11.766 | 9579.8 |
393 | 2024-03-17 19:57:37 | excess | 2 | 82551 | 24 | 5.326 | 15499.6 |
392 | 2024-03-17 19:36:27 | excess | 3 | 112716 | 317 | 5.720 | 19705.6 |
391 | 2024-03-17 19:36:30 | excess | 2 | 82551 | 24 | 2.720 | 30349.6 |
390 | 2024-03-17 19:36:22 | excess | 1 | 48755 | 2 | 0.923 | 52822.3 |
389 | 2024-03-17 19:35:56 | excess | 3 | 112716 | 317 | 9.013 | 12505.9 |
388 | 2024-03-17 03:27:55 | excess | 3 | 112716 | 317 | 4.640 | 24292.2 |
387 | 2024-03-02 15:37:48 | excess | 1 | 48755 | 2 | 2.126 | 22932.7 |
386 | 2024-02-09 10:22:17 | excess | 2 | 82551 | 24 | 2.403 | 34353.3 |
385 | 2024-01-18 14:06:10 | excess | 2 | 82551 | 24 | 2.156 | 38289.0 |
384 | 2024-01-15 10:07:36 | excess | 3 | 112716 | 317 | 6.063 | 18590.8 |
383 | 2024-01-12 12:40:57 | excess | 2 | 82551 | 24 | 2.436 | 33887.9 |
382 | 2024-01-02 18:28:52 | excess | 1 | 48755 | 2 | 0.843 | 57835.1 |
381 | 2023-12-16 01:55:06 | excess | 3 | 112716 | 317 | 5.576 | 20214.5 |
380 | 2023-12-07 15:31:17 | excess | 1 | 48755 | 2 | 0.780 | 62506.4 |
379 | 2023-12-03 11:34:36 | excess | 1 | 48755 | 2 | 1.123 | 43415.0 |
378 | 2023-12-03 11:34:35 | excess | 1 | 48755 | 2 | 0.830 | 58741.0 |
377 | 2023-11-30 00:03:40 | excess | 3 | 112716 | 317 | 5.483 | 20557.4 |
376 | 2023-11-17 12:02:41 | excess | 1 | 48755 | 2 | 0.813 | 59969.2 |
375 | 2023-11-16 10:12:15 | excess | 2 | 82551 | 24 | 2.063 | 40015.0 |
374 | 2023-11-06 18:20:29 | excess | 1 | 48755 | 2 | 0.796 | 61250.0 |
373 | 2023-11-03 10:54:25 | excess | 1 | 48755 | 2 | 0.750 | 65006.7 |
372 | 2023-10-24 17:08:22 | excess | 1 | 48755 | 2 | 0.750 | 65006.7 |
371 | 2023-10-18 18:03:58 | excess | 1 | 48755 | 2 | 0.813 | 59969.2 |
370 | 2023-10-18 07:09:29 | excess | 1 | 48755 | 2 | 0.856 | 56956.8 |
369 | 2023-10-14 02:25:26 | excess | 1 | 48755 | 2 | 0.796 | 61250.0 |
368 | 2023-09-25 15:39:53 | excess | 1 | 48755 | 2 | 0.856 | 56956.8 |
367 | 2023-09-24 12:48:20 | excess | 1 | 48755 | 2 | 0.873 | 55847.7 |
366 | 2023-09-17 00:51:13 | excess | 1 | 48755 | 2 | 0.860 | 56691.9 |
365 | 2023-08-27 23:12:02 | excess | 3 | 112716 | 317 | 4.516 | 24959.3 |
364 | 2023-08-19 15:48:23 | excess | 1 | 48755 | 2 | 0.733 | 66514.3 |
363 | 2023-08-17 03:13:01 | excess | 2 | 82551 | 24 | 2.080 | 39688.0 |
362 | 2023-07-02 15:42:28 | excess | 3 | 112716 | 317 | 4.610 | 24450.3 |
361 | 2023-07-01 10:07:27 | excess | 1 | 48755 | 2 | 1.626 | 29984.6 |
360 | 2023-05-26 03:03:40 | excess | 3 | 112716 | 317 | 4.546 | 24794.5 |
359 | 2023-05-21 18:26:19 | excess | 1 | 48755 | 2 | 0.750 | 65006.7 |
358 | 2023-05-21 05:40:18 | excess | 3 | 112716 | 317 | 5.296 | 21283.2 |
357 | 2023-05-11 10:40:20 | excess | 3 | 112716 | 317 | 4.486 | 25126.2 |
356 | 2023-05-01 03:23:34 | excess | 2 | 82551 | 24 | 2.076 | 39764.5 |
355 | 2023-05-01 02:41:37 | excess | 3 | 112716 | 317 | 4.530 | 24882.1 |
354 | 2023-03-22 04:09:10 | excess | 3 | 112716 | 317 | 4.500 | 25048.0 |
353 | 2023-03-21 16:28:10 | excess | 1 | 48755 | 2 | 0.813 | 59969.2 |
352 | 2023-03-19 11:02:02 | excess | 1 | 48755 | 2 | 0.813 | 59969.2 |
351 | 2023-02-27 10:03:48 | excess | 3 | 112716 | 317 | 4.440 | 25386.5 |
350 | 2023-02-20 07:08:52 | excess | 3 | 112716 | 317 | 5.186 | 21734.7 |
349 | 2023-02-10 09:18:50 | excess | 2 | 82551 | 24 | 2.013 | 41008.9 |
348 | 2023-01-06 18:00:30 | excess | 1 | 48755 | 2 | 1.423 | 34262.1 |
347 | 2022-12-03 13:27:42 | excess | 1 | 48755 | 2 | 0.736 | 66243.2 |
346 | 2022-12-02 12:41:36 | excess | 3 | 112716 | 317 | 4.483 | 25143.0 |
345 | 2022-11-22 03:28:56 | excess | 2 | 82551 | 24 | 2.093 | 39441.5 |
344 | 2022-10-09 12:08:30 | excess | 1 | 48755 | 2 | 0.846 | 57630.0 |
343 | 2022-07-27 11:55:39 | excess | 1 | 48755 | 2 | 0.750 | 65006.7 |
342 | 2022-06-26 04:50:38 | excess | 2 | 82551 | 24 | 2.106 | 39198.0 |
341 | 2022-06-19 23:04:04 | excess | 3 | 112716 | 317 | 4.563 | 24702.2 |
340 | 2022-06-01 02:06:20 | excess | 3 | 112716 | 317 | 4.530 | 24882.1 |
339 | 2022-05-30 09:06:53 | excess | 1 | 48755 | 2 | 0.716 | 68093.6 |
338 | 2022-05-28 03:55:07 | excess | 1 | 48755 | 2 | 0.733 | 66514.3 |
337 | 2022-05-21 19:08:32 | excess | 3 | 112716 | 317 | 4.513 | 24975.8 |
336 | 2022-05-19 21:22:23 | excess | 1 | 48755 | 2 | 0.766 | 63648.8 |
335 | 2022-04-12 12:37:14 | excess | 3 | 112716 | 317 | 4.640 | 24292.2 |
334 | 2022-03-25 23:15:26 | excess | 1 | 48755 | 2 | 0.733 | 66514.3 |
333 | 2022-02-24 13:08:24 | excess | 1 | 48755 | 2 | 0.750 | 65006.7 |
332 | 2022-01-07 12:45:42 | excess | 3 | 112716 | 317 | 6.280 | 17948.4 |
331 | 2021-12-24 09:45:56 | excess | 3 | 112716 | 317 | 4.593 | 24540.8 |
330 | 2021-12-11 21:01:54 | excess | 1 | 48755 | 2 | 0.873 | 55847.7 |
329 | 2021-10-08 18:14:03 | excess | 3 | 112716 | 317 | 4.716 | 23900.8 |
328 | 2021-09-01 06:48:50 | excess | 1 | 48755 | 2 | 0.733 | 66514.3 |
327 | 2021-08-19 19:38:32 | excess | 1 | 48755 | 2 | 0.860 | 56691.9 |
326 | 2021-08-17 15:37:16 | excess | 1 | 48755 | 2 | 0.733 | 66514.3 |
325 | 2021-08-16 17:53:02 | excess | 3 | 112716 | 317 | 5.013 | 22484.7 |
324 | 2021-08-15 17:55:17 | excess | 3 | 112716 | 317 | 6.123 | 18408.6 |
323 | 2021-08-14 20:51:31 | excess | 3 | 112716 | 317 | 4.843 | 23274.0 |
322 | 2021-08-12 18:32:13 | excess | 3 | 112716 | 317 | 4.546 | 24794.5 |
321 | 2021-08-07 23:12:02 | excess | 3 | 112716 | 317 | 5.736 | 19650.6 |
320 | 2021-08-05 08:17:21 | excess | 3 | 112716 | 317 | 4.703 | 23966.8 |
319 | 2021-07-30 07:10:20 | excess | 3 | 112716 | 317 | 4.530 | 24882.1 |
318 | 2021-07-11 08:55:33 | excess | 3 | 112716 | 317 | 4.783 | 23566.0 |
317 | 2021-07-09 19:38:18 | excess | 3 | 112716 | 317 | 4.706 | 23951.6 |
316 | 2021-07-05 23:58:15 | excess | 3 | 112716 | 317 | 5.423 | 20784.8 |
315 | 2021-06-29 21:50:53 | excess | 3 | 112716 | 317 | 5.046 | 22337.7 |
314 | 2021-06-29 07:22:06 | excess | 3 | 112716 | 317 | 5.750 | 19602.8 |
313 | 2021-06-28 06:55:26 | excess | 3 | 112716 | 317 | 5.013 | 22484.7 |
312 | 2021-06-28 02:43:30 | excess | 3 | 112716 | 317 | 6.466 | 17432.1 |
311 | 2021-06-27 16:51:03 | excess | 3 | 112716 | 317 | 4.580 | 24610.5 |
310 | 2021-06-26 17:33:58 | excess | 3 | 112716 | 317 | 4.610 | 24450.3 |
309 | 2021-06-26 03:25:15 | excess | 3 | 112716 | 317 | 5.470 | 20606.2 |
308 | 2021-06-25 16:10:33 | excess | 3 | 112716 | 317 | 5.046 | 22337.7 |
307 | 2021-06-24 16:53:29 | excess | 3 | 112716 | 317 | 7.420 | 15190.8 |
306 | 2021-06-23 22:09:30 | excess | 3 | 112716 | 317 | 5.466 | 20621.3 |
305 | 2021-06-23 10:04:45 | excess | 3 | 112716 | 317 | 4.780 | 23580.8 |
304 | 2021-06-22 20:26:31 | excess | 3 | 112716 | 317 | 4.516 | 24959.3 |
303 | 2021-06-22 02:03:59 | excess | 3 | 112716 | 317 | 5.216 | 21609.7 |
302 | 2021-06-20 18:33:23 | excess | 3 | 112716 | 317 | 4.843 | 23274.0 |