History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"painted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
472 | 2024-05-07 07:45:20 | painted | 3 | 134027 | 769 | 7.763 | 17264.8 |
471 | 2024-05-06 13:27:00 | painted | 3 | 134027 | 769 | 25.640 | 5227.3 |
470 | 2024-05-06 12:52:08 | painted | 3 | 134027 | 769 | 16.690 | 8030.4 |
469 | 2024-05-06 12:19:27 | painted | 3 | 134027 | 769 | 21.206 | 6320.2 |
468 | 2024-05-06 12:19:15 | painted | 2 | 107671 | 83 | 7.580 | 14204.6 |
467 | 2024-05-05 20:10:45 | painted | 2 | 107671 | 83 | 11.063 | 9732.5 |
466 | 2024-05-05 20:10:48 | painted | 1 | 69583 | 9 | 4.170 | 16686.6 |
465 | 2024-05-05 14:53:17 | painted | 2 | 107671 | 83 | 3.643 | 29555.6 |
464 | 2024-05-03 12:40:07 | painted | 2 | 107671 | 83 | 3.530 | 30501.7 |
463 | 2024-04-05 00:12:05 | painted | 3 | 134027 | 769 | 17.516 | 7651.7 |
462 | 2024-04-03 19:42:53 | painted | 3 | 134027 | 769 | 20.906 | 6410.9 |
461 | 2024-04-03 14:00:19 | painted | 3 | 134027 | 769 | 8.720 | 15370.1 |
460 | 2024-04-02 23:01:55 | painted | 3 | 134027 | 769 | 16.796 | 7979.7 |
459 | 2024-04-02 04:31:37 | painted | 3 | 134027 | 769 | 6.000 | 22337.8 |
458 | 2024-04-01 21:57:30 | painted | 1 | 69583 | 9 | 1.093 | 63662.4 |
457 | 2024-03-31 14:03:55 | painted | 1 | 69583 | 9 | 4.330 | 16070.0 |
456 | 2024-03-29 05:41:16 | painted | 1 | 69583 | 9 | 2.360 | 29484.3 |
455 | 2024-01-07 20:51:21 | painted | 3 | 134027 | 769 | 6.486 | 20664.0 |
454 | 2024-01-07 20:51:23 | painted | 2 | 107671 | 83 | 3.250 | 33129.5 |
453 | 2023-12-24 10:07:52 | painted | 1 | 69583 | 9 | 1.233 | 56433.9 |
452 | 2023-12-23 13:13:04 | painted | 2 | 107671 | 83 | 2.970 | 36252.9 |
451 | 2023-12-06 10:13:30 | painted | 3 | 134027 | 769 | 6.283 | 21331.7 |
450 | 2023-11-27 18:01:26 | painted | 1 | 69583 | 9 | 1.483 | 46920.4 |
449 | 2023-11-18 14:49:03 | painted | 1 | 69583 | 9 | 1.093 | 63662.4 |
448 | 2023-11-14 12:33:52 | painted | 1 | 69583 | 9 | 1.156 | 60192.9 |
447 | 2023-11-06 10:54:26 | painted | 1 | 69583 | 9 | 1.263 | 55093.4 |
446 | 2023-10-23 18:41:43 | painted | 1 | 69583 | 9 | 1.203 | 57841.2 |
445 | 2023-10-19 06:19:55 | painted | 1 | 69583 | 9 | 1.186 | 58670.3 |
444 | 2023-10-16 20:59:07 | painted | 1 | 69583 | 9 | 1.203 | 57841.2 |
443 | 2023-10-12 07:49:37 | painted | 1 | 69583 | 9 | 1.156 | 60192.9 |
442 | 2023-09-26 13:16:22 | painted | 1 | 69583 | 9 | 1.250 | 55666.4 |
441 | 2023-09-24 11:05:53 | painted | 2 | 107671 | 83 | 3.000 | 35890.3 |
440 | 2023-09-11 15:38:33 | painted | 3 | 134027 | 769 | 8.376 | 16001.3 |
439 | 2023-09-11 08:44:21 | painted | 1 | 69583 | 9 | 1.283 | 54234.6 |
438 | 2023-09-03 22:07:44 | painted | 3 | 134027 | 769 | 5.856 | 22887.1 |
437 | 2023-08-07 10:26:30 | painted | 1 | 69583 | 9 | 1.093 | 63662.4 |
436 | 2023-08-04 14:56:22 | painted | 1 | 69583 | 9 | 1.266 | 54962.9 |
435 | 2023-07-04 21:08:49 | painted | 2 | 107671 | 83 | 4.000 | 26917.8 |
434 | 2023-05-09 03:00:05 | painted | 1 | 69583 | 9 | 2.173 | 32021.6 |
433 | 2023-04-27 03:05:29 | painted | 1 | 69583 | 9 | 1.096 | 63488.1 |
432 | 2023-03-25 11:59:34 | painted | 2 | 107671 | 83 | 3.233 | 33303.7 |
431 | 2023-03-02 03:29:31 | painted | 1 | 69583 | 9 | 1.063 | 65459.1 |
430 | 2023-01-22 06:34:07 | painted | 1 | 69583 | 9 | 1.076 | 64668.2 |
429 | 2022-12-26 10:04:48 | painted | 1 | 69583 | 9 | 1.063 | 65459.1 |
428 | 2022-12-24 05:35:36 | painted | 2 | 107671 | 83 | 2.890 | 37256.4 |
427 | 2022-12-17 06:52:33 | painted | 3 | 134027 | 769 | 6.270 | 21375.9 |
426 | 2022-10-07 22:20:50 | painted | 1 | 69583 | 9 | 1.093 | 63662.4 |
425 | 2022-09-14 22:59:24 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
424 | 2022-08-21 09:02:54 | painted | 2 | 107671 | 83 | 2.860 | 37647.2 |
423 | 2022-08-09 11:34:08 | painted | 3 | 134027 | 769 | 5.893 | 22743.4 |
422 | 2022-07-18 15:40:08 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
421 | 2022-07-16 08:09:58 | painted | 1 | 69583 | 9 | 1.186 | 58670.3 |
420 | 2022-06-21 06:28:29 | painted | 1 | 69583 | 9 | 1.076 | 64668.2 |
419 | 2022-03-16 04:09:14 | painted | 1 | 69583 | 9 | 1.453 | 47889.2 |
418 | 2022-03-02 01:39:00 | painted | 1 | 69583 | 9 | 1.250 | 55666.4 |
417 | 2022-02-24 07:05:25 | painted | 1 | 69583 | 9 | 1.266 | 54962.9 |
416 | 2022-02-23 17:35:37 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
415 | 2022-02-22 17:38:26 | painted | 1 | 69583 | 9 | 1.140 | 61037.7 |
414 | 2022-02-21 08:39:06 | painted | 1 | 69583 | 9 | 1.673 | 41591.8 |
413 | 2022-02-20 12:58:57 | painted | 1 | 69583 | 9 | 1.216 | 57222.9 |
412 | 2022-02-19 09:29:31 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
411 | 2022-02-18 08:06:54 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
410 | 2022-02-17 12:09:21 | painted | 1 | 69583 | 9 | 2.203 | 31585.6 |
409 | 2022-02-16 17:30:35 | painted | 1 | 69583 | 9 | 1.220 | 57035.2 |
408 | 2022-02-15 13:51:19 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
407 | 2022-02-14 16:16:42 | painted | 1 | 69583 | 9 | 1.326 | 52475.9 |
406 | 2022-02-13 16:57:07 | painted | 1 | 69583 | 9 | 1.296 | 53690.6 |
405 | 2022-02-05 22:24:04 | painted | 1 | 69583 | 9 | 1.233 | 56433.9 |
404 | 2022-02-04 23:24:33 | painted | 1 | 69583 | 9 | 1.373 | 50679.5 |
403 | 2022-02-03 19:32:35 | painted | 1 | 69583 | 9 | 1.170 | 59472.6 |
402 | 2022-02-02 19:45:29 | painted | 1 | 69583 | 9 | 2.593 | 26834.9 |
401 | 2022-02-01 18:14:24 | painted | 1 | 69583 | 9 | 1.283 | 54234.6 |
400 | 2022-01-31 18:27:18 | painted | 1 | 69583 | 9 | 1.156 | 60192.9 |
399 | 2021-12-24 06:38:52 | painted | 1 | 69583 | 9 | 1.250 | 55666.4 |
398 | 2021-11-19 12:56:42 | painted | 2 | 107671 | 83 | 3.153 | 34148.7 |
397 | 2021-11-18 09:21:16 | painted | 1 | 69583 | 9 | 1.360 | 51164.0 |
396 | 2021-10-27 01:52:49 | painted | 1 | 69583 | 9 | 1.190 | 58473.1 |
395 | 2021-10-25 01:38:38 | painted | 1 | 69583 | 9 | 1.080 | 64428.7 |
394 | 2021-09-06 16:04:28 | painted | 1 | 69583 | 9 | 1.110 | 62687.4 |
393 | 2021-08-24 08:07:34 | painted | 1 | 69583 | 9 | 1.140 | 61037.7 |
392 | 2021-08-22 03:58:50 | painted | 1 | 69583 | 9 | 1.093 | 63662.4 |
391 | 2021-08-15 13:59:25 | painted | 1 | 69583 | 9 | 1.090 | 63837.6 |
390 | 2021-07-07 23:16:33 | painted | 1 | 69583 | 9 | 1.250 | 55666.4 |
389 | 2021-06-21 02:43:46 | painted | 1 | 69583 | 9 | 1.216 | 57222.9 |
388 | 2021-05-23 12:01:52 | painted | 1 | 69583 | 9 | 1.266 | 54962.9 |
387 | 2021-05-22 18:42:53 | painted | 1 | 69583 | 9 | 1.343 | 51811.6 |
386 | 2021-05-21 21:46:34 | painted | 1 | 69583 | 9 | 1.233 | 56433.9 |
385 | 2021-05-14 22:12:12 | painted | 1 | 69583 | 9 | 1.233 | 56433.9 |
384 | 2021-04-22 05:18:16 | painted | 1 | 69583 | 9 | 1.156 | 60192.9 |
383 | 2021-03-24 13:43:21 | painted | 1 | 69583 | 9 | 1.203 | 57841.2 |
382 | 2021-02-12 01:26:07 | painted | 1 | 69583 | 9 | 1.216 | 57222.9 |
381 | 2021-02-07 01:04:26 | painted | 1 | 69583 | 9 | 1.123 | 61961.7 |
380 | 2021-01-07 06:56:39 | painted | 1 | 69583 | 9 | 1.216 | 57222.9 |
379 | 2020-12-09 10:35:25 | painted | 1 | 69583 | 9 | 1.173 | 59320.5 |
378 | 2020-11-07 20:56:38 | painted | 1 | 69583 | 9 | 2.486 | 27989.9 |
377 | 2020-11-05 02:01:17 | painted | 1 | 69583 | 9 | 1.250 | 55666.4 |
376 | 2020-10-30 23:52:35 | painted | 1 | 69583 | 9 | 1.263 | 55093.4 |
375 | 2020-08-21 10:34:34 | painted | 1 | 69583 | 9 | 1.233 | 56433.9 |
374 | 2020-08-01 07:16:06 | painted | 1 | 69583 | 9 | 1.330 | 52318.0 |
373 | 2020-07-25 00:07:18 | painted | 1 | 69583 | 9 | 1.126 | 61796.6 |