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 |
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 |
406 | 2024-08-08 14:29:05 | roofer | 1 | 48755 | 10 | 3.750 | 13001.3 |
405 | 2024-08-03 22:45:28 | roofer | 1 | 48755 | 10 | 1.640 | 29728.7 |
404 | 2024-08-01 06:49:53 | roofer | 1 | 48755 | 10 | 2.110 | 23106.6 |
403 | 2024-07-29 09:51:35 | roofer | 2 | 82551 | 113 | 2.860 | 28864.0 |
402 | 2024-07-29 06:41:49 | roofer | 2 | 82551 | 113 | 13.796 | 5983.7 |
401 | 2024-07-28 23:03:16 | roofer | 1 | 48755 | 10 | 1.780 | 27390.4 |
400 | 2024-07-28 23:02:32 | roofer | 2 | 82551 | 113 | 4.700 | 17564.0 |
399 | 2024-07-28 22:28:36 | roofer | 2 | 82551 | 113 | 7.783 | 10606.6 |
398 | 2024-07-28 22:28:12 | roofer | 1 | 48755 | 10 | 1.373 | 35509.8 |
397 | 2024-07-27 07:25:06 | roofer | 1 | 48755 | 10 | 3.546 | 13749.3 |
396 | 2024-07-25 04:55:54 | roofer | 1 | 48755 | 10 | 2.970 | 16415.8 |
395 | 2024-07-13 01:01:50 | roofer | 1 | 48755 | 10 | 4.470 | 10907.2 |
394 | 2024-07-08 01:37:09 | roofer | 1 | 48755 | 10 | 3.030 | 16090.8 |
393 | 2024-07-01 17:30:20 | roofer | 1 | 48755 | 10 | 3.000 | 16251.7 |