History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"payees"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
469 | 2024-04-22 23:30:16 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
468 | 2024-04-09 08:29:25 | payees | 2 | 82551 | 75 | 2.233 | 36968.7 |
467 | 2024-04-04 19:52:51 | payees | 3 | 112716 | 1308 | 8.170 | 13796.3 |
466 | 2024-04-03 19:40:15 | payees | 3 | 112716 | 1308 | 18.003 | 6261.0 |
465 | 2024-04-03 16:05:55 | payees | 2 | 82551 | 75 | 4.593 | 17973.2 |
464 | 2024-04-03 16:05:24 | payees | 2 | 82551 | 75 | 4.923 | 16768.4 |
463 | 2024-04-03 16:05:20 | payees | 1 | 48755 | 3 | 2.080 | 23439.9 |
462 | 2024-04-03 16:04:59 | payees | 3 | 112716 | 1308 | 6.800 | 16575.9 |
461 | 2024-04-03 11:24:33 | payees | 3 | 112716 | 1308 | 20.953 | 5379.5 |
460 | 2024-04-03 09:58:43 | payees | 3 | 112716 | 1308 | 17.613 | 6399.6 |
459 | 2024-04-03 09:58:45 | payees | 2 | 82551 | 75 | 5.623 | 14681.0 |
458 | 2024-04-03 09:58:31 | payees | 1 | 48755 | 3 | 3.186 | 15302.9 |
457 | 2024-03-31 17:58:21 | payees | 1 | 48755 | 3 | 1.906 | 25579.7 |
456 | 2024-03-30 00:55:52 | payees | 1 | 48755 | 3 | 2.936 | 16605.9 |
455 | 2024-03-01 12:08:36 | payees | 2 | 82551 | 75 | 2.640 | 31269.3 |
454 | 2024-03-01 01:49:28 | payees | 2 | 82551 | 75 | 2.610 | 31628.7 |
453 | 2024-03-01 01:48:04 | payees | 3 | 112716 | 1308 | 5.563 | 20261.7 |
452 | 2024-02-29 16:46:21 | payees | 3 | 112716 | 1308 | 11.533 | 9773.3 |
451 | 2024-02-28 08:05:52 | payees | 2 | 82551 | 75 | 3.626 | 22766.4 |
450 | 2024-02-28 08:05:33 | payees | 3 | 112716 | 1308 | 7.000 | 16102.3 |
449 | 2024-02-27 20:09:27 | payees | 1 | 48755 | 3 | 0.826 | 59025.4 |
448 | 2024-02-27 20:09:21 | payees | 3 | 112716 | 1308 | 5.313 | 21215.1 |
447 | 2024-02-27 20:09:19 | payees | 2 | 82551 | 75 | 2.263 | 36478.6 |
446 | 2024-01-16 13:50:44 | payees | 3 | 112716 | 1308 | 5.016 | 22471.3 |
445 | 2024-01-16 11:23:35 | payees | 3 | 112716 | 1308 | 4.796 | 23502.1 |
444 | 2024-01-16 11:23:33 | payees | 2 | 82551 | 75 | 2.233 | 36968.7 |
443 | 2024-01-08 04:11:38 | payees | 3 | 112716 | 1308 | 5.856 | 19248.0 |
442 | 2024-01-07 05:55:45 | payees | 3 | 112716 | 1308 | 4.843 | 23274.0 |
441 | 2024-01-05 11:44:15 | payees | 1 | 48755 | 3 | 0.860 | 56691.9 |
440 | 2023-12-13 23:58:50 | payees | 3 | 112716 | 1308 | 5.220 | 21593.1 |
439 | 2023-12-13 23:58:48 | payees | 2 | 82551 | 75 | 2.186 | 37763.5 |
438 | 2023-12-11 07:02:54 | payees | 2 | 82551 | 75 | 2.203 | 37472.1 |
437 | 2023-11-16 16:43:34 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
436 | 2023-11-11 16:51:46 | payees | 1 | 48755 | 3 | 0.830 | 58741.0 |
435 | 2023-11-03 05:28:47 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
434 | 2023-11-01 05:43:48 | payees | 1 | 48755 | 3 | 1.686 | 28917.6 |
433 | 2023-10-26 10:05:22 | payees | 1 | 48755 | 3 | 0.763 | 63899.1 |
432 | 2023-10-23 05:53:50 | payees | 1 | 48755 | 3 | 0.860 | 56691.9 |
431 | 2023-10-21 07:25:04 | payees | 1 | 48755 | 3 | 0.903 | 53992.2 |
430 | 2023-10-20 09:40:15 | payees | 3 | 112716 | 1308 | 6.670 | 16899.0 |
429 | 2023-10-17 08:12:35 | payees | 3 | 112716 | 1308 | 6.326 | 17817.9 |
428 | 2023-10-14 17:13:29 | payees | 3 | 112716 | 1308 | 4.766 | 23650.0 |
427 | 2023-10-12 10:20:03 | payees | 1 | 48755 | 3 | 0.780 | 62506.4 |
426 | 2023-09-25 01:18:47 | payees | 1 | 48755 | 3 | 0.780 | 62506.4 |
425 | 2023-09-24 05:46:07 | payees | 1 | 48755 | 3 | 0.873 | 55847.7 |
424 | 2023-09-08 09:36:58 | payees | 2 | 82551 | 75 | 2.390 | 34540.2 |
423 | 2023-08-20 15:49:20 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
422 | 2023-07-25 12:57:30 | payees | 3 | 112716 | 1308 | 6.063 | 18590.8 |
421 | 2023-06-30 15:48:09 | payees | 1 | 48755 | 3 | 0.906 | 53813.5 |
420 | 2023-05-27 00:21:44 | payees | 2 | 82551 | 75 | 2.153 | 38342.3 |
419 | 2023-05-25 02:42:11 | payees | 1 | 48755 | 3 | 0.766 | 63648.8 |
418 | 2023-05-15 20:25:23 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
417 | 2023-04-28 00:40:08 | payees | 3 | 112716 | 1308 | 5.000 | 22543.2 |
416 | 2023-04-06 05:35:43 | payees | 3 | 112716 | 1308 | 4.686 | 24053.8 |
415 | 2023-03-18 18:39:37 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
414 | 2023-03-11 18:36:15 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
413 | 2023-03-11 03:41:44 | payees | 1 | 48755 | 3 | 0.876 | 55656.4 |
412 | 2023-03-07 20:51:42 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
411 | 2023-03-05 02:57:12 | payees | 2 | 82551 | 75 | 2.220 | 37185.1 |
410 | 2023-01-28 13:27:11 | payees | 3 | 112716 | 1308 | 4.860 | 23192.6 |
409 | 2023-01-04 10:51:17 | payees | 3 | 112716 | 1308 | 4.766 | 23650.0 |
408 | 2023-01-01 11:11:21 | payees | 1 | 48755 | 3 | 1.720 | 28345.9 |
407 | 2022-12-23 20:46:20 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
406 | 2022-12-13 19:10:15 | payees | 3 | 112716 | 1308 | 5.343 | 21096.0 |
405 | 2022-12-12 04:25:43 | payees | 2 | 82551 | 75 | 2.220 | 37185.1 |
404 | 2022-12-02 09:14:44 | payees | 3 | 112716 | 1308 | 4.656 | 24208.8 |
403 | 2022-11-17 00:04:26 | payees | 1 | 48755 | 3 | 0.890 | 54780.9 |
402 | 2022-11-15 22:35:32 | payees | 1 | 48755 | 3 | 0.763 | 63899.1 |
401 | 2022-11-12 13:59:26 | payees | 3 | 112716 | 1308 | 5.296 | 21283.2 |
400 | 2022-11-08 14:10:31 | payees | 3 | 112716 | 1308 | 5.203 | 21663.7 |
399 | 2022-11-07 09:31:33 | payees | 3 | 112716 | 1308 | 5.606 | 20106.3 |
398 | 2022-11-02 03:35:41 | payees | 3 | 112716 | 1308 | 4.703 | 23966.8 |
397 | 2022-09-21 06:38:41 | payees | 1 | 48755 | 3 | 0.766 | 63648.8 |
396 | 2022-09-13 16:25:43 | payees | 3 | 112716 | 1308 | 4.893 | 23036.2 |
395 | 2022-09-08 10:33:31 | payees | 3 | 112716 | 1308 | 4.903 | 22989.2 |
394 | 2022-07-26 17:45:20 | payees | 1 | 48755 | 3 | 0.766 | 63648.8 |
393 | 2022-07-01 12:33:36 | payees | 2 | 82551 | 75 | 2.186 | 37763.5 |
392 | 2022-05-02 16:46:11 | payees | 1 | 48755 | 3 | 0.890 | 54780.9 |
391 | 2022-04-30 12:18:07 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
390 | 2022-03-25 08:26:26 | payees | 1 | 48755 | 3 | 0.813 | 59969.2 |
389 | 2022-02-12 17:39:34 | payees | 2 | 82551 | 75 | 2.983 | 27673.8 |
388 | 2022-01-17 09:58:27 | payees | 1 | 48755 | 3 | 0.796 | 61250.0 |
387 | 2022-01-15 06:08:24 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
386 | 2021-12-31 07:13:28 | payees | 1 | 48755 | 3 | 0.970 | 50262.9 |
385 | 2021-12-11 06:20:20 | payees | 1 | 48755 | 3 | 0.780 | 62506.4 |
384 | 2021-11-24 10:52:25 | payees | 1 | 48755 | 3 | 0.873 | 55847.7 |
383 | 2021-11-23 08:09:01 | payees | 1 | 48755 | 3 | 0.860 | 56691.9 |
382 | 2021-11-22 07:16:32 | payees | 1 | 48755 | 3 | 0.906 | 53813.5 |
381 | 2021-11-13 04:00:10 | payees | 1 | 48755 | 3 | 0.843 | 57835.1 |
380 | 2021-11-03 21:32:49 | payees | 3 | 112716 | 1308 | 6.313 | 17854.6 |
379 | 2021-10-13 09:19:03 | payees | 1 | 48755 | 3 | 0.923 | 52822.3 |
378 | 2021-10-05 21:18:46 | payees | 3 | 112716 | 1308 | 5.750 | 19602.8 |
377 | 2021-09-27 06:21:14 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
376 | 2021-09-27 00:17:23 | payees | 3 | 112716 | 1308 | 5.393 | 20900.4 |
375 | 2021-09-26 15:01:57 | payees | 1 | 48755 | 3 | 0.846 | 57630.0 |
374 | 2021-09-21 23:09:48 | payees | 1 | 48755 | 3 | 0.750 | 65006.7 |
373 | 2021-09-18 17:21:03 | payees | 3 | 112716 | 1308 | 4.766 | 23650.0 |
372 | 2021-09-08 14:01:49 | payees | 3 | 112716 | 1308 | 5.533 | 20371.6 |
371 | 2021-09-04 23:40:16 | payees | 3 | 112716 | 1308 | 5.843 | 19290.8 |
370 | 2021-09-02 23:28:25 | payees | 3 | 112716 | 1308 | 5.470 | 20606.2 |