History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roofer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
506 | 2025-08-29 22:43:04 | roofer | 2 | 82551 | 113 | 2.233 | 36968.7 |
505 | 2025-08-25 00:15:39 | roofer | 1 | 48755 | 10 | 2.266 | 21515.9 |
504 | 2025-07-31 22:28:00 | roofer | 1 | 48755 | 10 | 5.733 | 8504.3 |
503 | 2025-07-31 16:26:24 | roofer | 1 | 48755 | 10 | 2.203 | 22131.2 |
502 | 2025-07-27 15:22:46 | roofer | 1 | 48755 | 10 | 5.720 | 8523.6 |
501 | 2025-07-26 10:13:29 | roofer | 2 | 82551 | 113 | 5.923 | 13937.4 |
500 | 2025-07-24 03:38:19 | roofer | 1 | 48755 | 10 | 1.813 | 26891.9 |
499 | 2025-07-23 22:24:40 | roofer | 1 | 48755 | 10 | 4.966 | 9817.8 |
498 | 2025-07-23 15:43:27 | roofer | 1 | 48755 | 10 | 3.546 | 13749.3 |
497 | 2025-07-23 01:09:57 | roofer | 1 | 48755 | 10 | 1.966 | 24799.1 |
496 | 2025-07-22 20:46:56 | roofer | 1 | 48755 | 10 | 3.220 | 15141.3 |
495 | 2025-07-22 16:35:59 | roofer | 1 | 48755 | 10 | 2.343 | 20808.8 |
494 | 2025-07-22 06:42:34 | roofer | 2 | 82551 | 113 | 9.076 | 9095.5 |
493 | 2025-07-16 00:30:23 | roofer | 1 | 48755 | 10 | 0.890 | 54780.9 |
492 | 2025-07-15 05:43:00 | roofer | 1 | 48755 | 10 | 1.953 | 24964.2 |
491 | 2025-07-13 15:17:49 | roofer | 1 | 48755 | 10 | 0.923 | 52822.3 |
490 | 2025-07-12 02:11:16 | roofer | 1 | 48755 | 10 | 0.876 | 55656.4 |
489 | 2025-07-06 19:17:25 | roofer | 1 | 48755 | 10 | 0.763 | 63899.1 |
488 | 2025-07-06 11:03:18 | roofer | 1 | 48755 | 10 | 0.843 | 57835.1 |
487 | 2025-07-01 21:15:59 | roofer | 1 | 48755 | 10 | 2.110 | 23106.6 |
486 | 2025-06-27 12:55:33 | roofer | 1 | 48755 | 10 | 0.783 | 62266.9 |
485 | 2025-06-24 14:35:05 | roofer | 1 | 48755 | 10 | 5.016 | 9719.9 |
484 | 2025-06-22 00:39:31 | roofer | 1 | 48755 | 10 | 2.546 | 19149.6 |
483 | 2025-06-20 06:43:59 | roofer | 2 | 82551 | 113 | 12.170 | 6783.2 |
482 | 2025-06-18 15:39:50 | roofer | 2 | 82551 | 113 | 15.250 | 5413.2 |
481 | 2025-06-18 07:32:31 | roofer | 2 | 82551 | 113 | 6.313 | 13076.4 |
480 | 2025-06-18 04:18:50 | roofer | 1 | 48755 | 10 | 5.860 | 8320.0 |
479 | 2025-06-17 23:49:54 | roofer | 1 | 48755 | 10 | 2.533 | 19247.9 |
478 | 2025-06-17 14:58:46 | roofer | 1 | 48755 | 10 | 1.796 | 27146.4 |
477 | 2025-06-17 06:39:39 | roofer | 2 | 82551 | 113 | 2.546 | 32423.8 |
476 | 2025-06-14 05:00:02 | roofer | 1 | 48755 | 10 | 4.903 | 9943.9 |
475 | 2025-06-08 20:08:09 | roofer | 1 | 48755 | 10 | 3.983 | 12240.8 |
474 | 2025-06-06 10:37:29 | roofer | 1 | 48755 | 10 | 6.296 | 7743.8 |
473 | 2025-06-04 14:38:54 | roofer | 1 | 48755 | 10 | 3.156 | 15448.4 |
472 | 2025-06-04 08:55:06 | roofer | 2 | 82551 | 113 | 12.860 | 6419.2 |
471 | 2025-05-30 21:14:05 | roofer | 1 | 48755 | 10 | 2.250 | 21668.9 |
470 | 2025-05-30 01:01:21 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
469 | 2025-05-29 09:07:03 | roofer | 1 | 48755 | 10 | 4.220 | 11553.3 |
468 | 2025-05-26 13:22:54 | roofer | 2 | 82551 | 113 | 12.143 | 6798.2 |
467 | 2025-05-25 19:58:55 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
466 | 2025-05-25 19:50:43 | roofer | 1 | 48755 | 10 | 0.846 | 57630.0 |
465 | 2025-05-24 19:05:40 | roofer | 2 | 82551 | 113 | 20.470 | 4032.8 |
464 | 2025-05-17 03:38:39 | roofer | 1 | 48755 | 10 | 4.813 | 10129.9 |
463 | 2025-05-10 07:19:47 | roofer | 1 | 48755 | 10 | 3.810 | 12796.6 |
462 | 2025-05-10 04:46:07 | roofer | 1 | 48755 | 10 | 4.110 | 11862.5 |
461 | 2025-05-04 14:34:26 | roofer | 1 | 48755 | 10 | 4.140 | 11776.6 |
460 | 2025-05-04 06:21:31 | roofer | 2 | 82551 | 113 | 12.923 | 6387.9 |
459 | 2025-05-01 19:18:56 | roofer | 2 | 82551 | 113 | 2.190 | 37694.5 |
458 | 2025-04-29 20:52:27 | roofer | 1 | 48755 | 10 | 2.626 | 18566.3 |
457 | 2025-04-28 21:15:47 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
456 | 2025-04-19 23:37:31 | roofer | 1 | 48755 | 10 | 3.746 | 13015.2 |
455 | 2025-04-17 02:43:54 | roofer | 1 | 48755 | 10 | 1.720 | 28345.9 |
454 | 2025-04-13 18:47:02 | roofer | 1 | 48755 | 10 | 0.906 | 53813.5 |
453 | 2025-04-09 04:18:47 | roofer | 1 | 48755 | 10 | 4.533 | 10755.6 |
452 | 2025-04-01 16:34:16 | roofer | 1 | 48755 | 10 | 0.796 | 61250.0 |
451 | 2025-03-28 22:10:29 | roofer | 1 | 48755 | 10 | 4.643 | 10500.8 |
450 | 2025-03-26 06:23:13 | roofer | 2 | 82551 | 113 | 6.626 | 12458.6 |
449 | 2025-03-19 00:55:34 | roofer | 1 | 48755 | 10 | 0.830 | 58741.0 |
448 | 2025-03-14 20:39:42 | roofer | 1 | 48755 | 10 | 2.266 | 21515.9 |
447 | 2025-03-10 11:36:38 | roofer | 1 | 48755 | 10 | 2.156 | 22613.6 |
446 | 2025-03-10 08:59:43 | roofer | 2 | 82551 | 113 | 15.173 | 5440.7 |
445 | 2025-03-09 08:27:44 | roofer | 2 | 82551 | 113 | 12.486 | 6611.5 |
444 | 2025-03-09 06:35:32 | roofer | 2 | 82551 | 113 | 6.140 | 13444.8 |
443 | 2025-03-09 00:41:10 | roofer | 2 | 82551 | 113 | 12.266 | 6730.1 |
442 | 2025-03-08 21:12:38 | roofer | 1 | 48755 | 10 | 4.060 | 12008.6 |
441 | 2025-03-08 21:10:09 | roofer | 2 | 82551 | 113 | 7.186 | 11487.8 |
440 | 2025-02-25 23:59:56 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
439 | 2025-02-25 21:02:46 | roofer | 1 | 48755 | 10 | 4.736 | 10294.6 |
438 | 2025-02-18 18:57:21 | roofer | 1 | 48755 | 10 | 2.250 | 21668.9 |
437 | 2025-02-14 22:41:00 | roofer | 1 | 48755 | 10 | 2.873 | 16970.1 |
436 | 2025-02-10 02:48:53 | roofer | 1 | 48755 | 10 | 2.236 | 21804.6 |
435 | 2025-02-05 04:21:26 | roofer | 1 | 48755 | 10 | 0.873 | 55847.7 |
434 | 2025-01-08 21:38:34 | roofer | 1 | 48755 | 10 | 3.626 | 13445.9 |
433 | 2025-01-06 03:34:44 | roofer | 1 | 48755 | 10 | 2.360 | 20658.9 |
432 | 2024-12-27 08:52:13 | roofer | 1 | 48755 | 10 | 3.623 | 13457.1 |
431 | 2024-12-09 17:19:37 | roofer | 1 | 48755 | 10 | 6.046 | 8064.0 |
430 | 2024-12-06 23:49:25 | roofer | 1 | 48755 | 10 | 0.783 | 62266.9 |
429 | 2024-12-06 22:12:40 | roofer | 2 | 82551 | 113 | 12.836 | 6431.2 |
428 | 2024-12-06 19:11:32 | roofer | 2 | 82551 | 113 | 9.953 | 8294.1 |
427 | 2024-12-05 17:47:21 | roofer | 2 | 82551 | 113 | 6.653 | 12408.1 |
426 | 2024-12-04 17:56:40 | roofer | 2 | 82551 | 113 | 7.613 | 10843.4 |
425 | 2024-11-27 01:59:39 | roofer | 2 | 82551 | 113 | 8.110 | 10178.9 |
424 | 2024-11-27 01:59:36 | roofer | 1 | 48755 | 10 | 2.873 | 16970.1 |
423 | 2024-11-14 20:05:29 | roofer | 1 | 48755 | 10 | 3.763 | 12956.4 |
422 | 2024-11-09 11:15:55 | roofer | 1 | 48755 | 10 | 4.063 | 11999.8 |
421 | 2024-11-08 13:37:41 | roofer | 1 | 48755 | 10 | 1.313 | 37132.5 |
420 | 2024-11-06 11:49:08 | roofer | 1 | 48755 | 10 | 2.046 | 23829.4 |
419 | 2024-10-29 16:47:27 | roofer | 2 | 82551 | 113 | 13.140 | 6282.4 |
418 | 2024-10-29 16:43:43 | roofer | 2 | 82551 | 113 | 7.330 | 11262.1 |
417 | 2024-10-28 06:20:23 | roofer | 1 | 48755 | 10 | 3.046 | 16006.2 |
416 | 2024-10-09 20:50:51 | roofer | 1 | 48755 | 10 | 5.516 | 8838.8 |
415 | 2024-10-09 01:29:56 | roofer | 1 | 48755 | 10 | 4.030 | 12098.0 |
414 | 2024-09-27 13:45:03 | roofer | 1 | 48755 | 10 | 6.076 | 8024.2 |
413 | 2024-09-11 14:26:48 | roofer | 2 | 82551 | 113 | 16.456 | 5016.5 |
412 | 2024-09-08 21:00:35 | roofer | 1 | 48755 | 10 | 8.000 | 6094.4 |
411 | 2024-09-08 05:17:11 | roofer | 1 | 48755 | 10 | 8.420 | 5790.4 |
410 | 2024-09-04 10:57:19 | roofer | 1 | 48755 | 10 | 3.830 | 12729.8 |
409 | 2024-08-28 00:28:09 | roofer | 1 | 48755 | 10 | 8.970 | 5435.3 |
408 | 2024-08-15 16:50:17 | roofer | 1 | 48755 | 10 | 8.853 | 5507.2 |
407 | 2024-08-12 22:19:07 | roofer | 1 | 48755 | 10 | 5.000 | 9751.0 |