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 |
| 529 | 2025-12-03 07:48:37 | roofer | 1 | 48755 | 10 | 0.796 | 61250.0 |
| 528 | 2025-12-01 13:20:02 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
| 527 | 2025-11-24 15:07:46 | roofer | 2 | 82551 | 113 | 2.796 | 29524.7 |
| 526 | 2025-11-22 19:06:14 | roofer | 2 | 82551 | 113 | 2.763 | 29877.3 |
| 525 | 2025-11-21 19:53:52 | roofer | 2 | 82551 | 113 | 4.563 | 18091.4 |
| 524 | 2025-11-19 21:43:43 | roofer | 1 | 48755 | 10 | 1.106 | 44082.3 |
| 523 | 2025-11-15 08:15:31 | roofer | 1 | 48755 | 10 | 0.780 | 62506.4 |
| 522 | 2025-11-12 03:58:16 | roofer | 1 | 48755 | 10 | 0.766 | 63648.8 |
| 521 | 2025-11-12 03:57:43 | roofer | 1 | 48755 | 10 | 0.796 | 61250.0 |
| 520 | 2025-11-12 01:14:24 | roofer | 1 | 48755 | 10 | 0.970 | 50262.9 |
| 519 | 2025-11-01 12:31:23 | roofer | 2 | 82551 | 113 | 2.220 | 37185.1 |
| 518 | 2025-10-31 20:55:11 | roofer | 2 | 82551 | 113 | 2.623 | 31472.0 |
| 517 | 2025-10-27 08:57:36 | roofer | 2 | 82551 | 113 | 2.236 | 36919.1 |
| 516 | 2025-10-08 03:41:48 | roofer | 1 | 48755 | 10 | 0.860 | 56691.9 |
| 515 | 2025-10-04 05:43:06 | roofer | 1 | 48755 | 10 | 0.796 | 61250.0 |
| 514 | 2025-09-30 00:16:41 | roofer | 2 | 82551 | 113 | 10.046 | 8217.3 |
| 513 | 2025-09-24 19:03:36 | roofer | 2 | 82551 | 113 | 2.533 | 32590.2 |
| 512 | 2025-09-22 10:01:00 | roofer | 2 | 82551 | 113 | 2.390 | 34540.2 |
| 511 | 2025-09-18 21:35:26 | roofer | 2 | 82551 | 113 | 2.656 | 31080.9 |
| 510 | 2025-09-18 15:59:55 | roofer | 2 | 82551 | 113 | 2.296 | 35954.3 |
| 509 | 2025-09-09 11:52:35 | roofer | 2 | 82551 | 113 | 2.686 | 30733.8 |
| 508 | 2025-09-07 06:28:18 | roofer | 1 | 48755 | 10 | 0.813 | 59969.2 |
| 507 | 2025-09-04 01:22:18 | roofer | 1 | 48755 | 10 | 0.843 | 57835.1 |
| 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 |