History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"respondents"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-04-19 21:15:12 | respondents | 2 | 86808 | 5 | 8.093 | 10726.3 |
529 | 2024-04-19 21:14:30 | respondents | 1 | 49908 | 2 | 1.296 | 38509.3 |
528 | 2024-04-12 14:50:51 | respondents | 3 | 121633 | 26 | 8.450 | 14394.4 |
527 | 2024-04-07 15:20:17 | respondents | 4 | 148819 | 85 | 18.953 | 7852.0 |
526 | 2024-04-06 20:11:51 | respondents | 3 | 121633 | 26 | 12.466 | 9757.2 |
525 | 2024-04-04 14:02:50 | respondents | 2 | 86808 | 5 | 9.156 | 9481.0 |
524 | 2024-04-04 13:56:56 | respondents | 1 | 49908 | 2 | 2.123 | 23508.2 |
523 | 2024-04-04 02:54:47 | respondents | 3 | 121633 | 26 | 17.660 | 6887.5 |
522 | 2024-04-04 01:16:42 | respondents | 4 | 148819 | 85 | 45.253 | 3288.6 |
521 | 2024-04-03 02:08:06 | respondents | 4 | 148819 | 85 | 23.576 | 6312.3 |
520 | 2024-04-03 02:08:20 | respondents | 1 | 49908 | 2 | 2.033 | 24548.9 |
519 | 2024-04-03 02:08:08 | respondents | 3 | 121633 | 26 | 7.893 | 15410.2 |
518 | 2024-04-03 02:08:09 | respondents | 2 | 86808 | 5 | 4.796 | 18100.1 |
517 | 2024-04-03 02:08:03 | respondents | 1 | 49908 | 2 | 1.936 | 25778.9 |
516 | 2024-04-01 14:21:54 | respondents | 5 | 164607 | 474 | 52.533 | 3133.4 |
515 | 2024-03-26 13:40:33 | respondents | 5 | 164607 | 474 | 45.173 | 3643.9 |
514 | 2024-03-23 12:24:53 | respondents | 5 | 164607 | 474 | 14.703 | 11195.5 |
513 | 2024-03-20 16:14:38 | respondents | 2 | 86808 | 5 | 8.843 | 9816.6 |
512 | 2024-03-20 16:14:33 | respondents | 3 | 121633 | 26 | 7.890 | 15416.1 |
511 | 2024-03-20 16:04:15 | respondents | 1 | 49908 | 2 | 0.876 | 56972.6 |
510 | 2024-03-12 12:53:12 | respondents | 2 | 86808 | 5 | 2.966 | 29267.7 |
509 | 2024-03-07 22:50:01 | respondents | 1 | 49908 | 2 | 0.876 | 56972.6 |
508 | 2024-03-05 12:21:47 | respondents | 1 | 49908 | 2 | 0.876 | 56972.6 |
507 | 2024-03-04 20:07:44 | respondents | 5 | 164607 | 474 | 23.876 | 6894.2 |
506 | 2024-03-04 20:03:44 | respondents | 4 | 148819 | 85 | 25.330 | 5875.2 |
505 | 2024-03-04 18:56:45 | respondents | 4 | 148819 | 85 | 35.986 | 4135.5 |
504 | 2024-03-04 10:17:02 | respondents | 4 | 148819 | 85 | 33.296 | 4469.6 |
503 | 2024-03-02 09:35:45 | respondents | 5 | 164607 | 474 | 35.080 | 4692.3 |
502 | 2024-03-02 09:35:43 | respondents | 4 | 148819 | 85 | 28.270 | 5264.2 |
501 | 2024-03-02 09:35:43 | respondents | 3 | 121633 | 26 | 18.873 | 6444.8 |
500 | 2024-03-02 09:35:39 | respondents | 2 | 86808 | 5 | 5.923 | 14656.1 |
499 | 2024-03-02 09:35:30 | respondents | 1 | 49908 | 2 | 2.110 | 23653.1 |
498 | 2024-03-02 09:35:13 | respondents | 1 | 49908 | 2 | 2.923 | 17074.2 |
497 | 2024-02-08 08:59:43 | respondents | 1 | 49908 | 2 | 0.903 | 55269.1 |
496 | 2024-02-06 05:22:16 | respondents | 5 | 164607 | 474 | 16.873 | 9755.6 |
495 | 2024-02-05 08:50:05 | respondents | 5 | 164607 | 474 | 28.270 | 5822.7 |
494 | 2024-02-02 09:33:48 | respondents | 5 | 164607 | 474 | 14.720 | 11182.5 |
493 | 2024-01-31 19:38:36 | respondents | 1 | 49908 | 2 | 0.843 | 59202.8 |
492 | 2024-01-31 16:53:52 | respondents | 1 | 49908 | 2 | 0.876 | 56972.6 |
491 | 2024-01-31 03:04:21 | respondents | 1 | 49908 | 2 | 0.860 | 58032.6 |
490 | 2024-01-23 05:38:43 | respondents | 5 | 164607 | 474 | 20.843 | 7897.5 |
489 | 2024-01-23 02:24:37 | respondents | 5 | 164607 | 474 | 25.470 | 6462.8 |
488 | 2024-01-22 23:22:48 | respondents | 5 | 164607 | 474 | 13.953 | 11797.2 |
487 | 2024-01-20 12:08:00 | respondents | 4 | 148819 | 85 | 9.750 | 15263.5 |
486 | 2024-01-18 10:01:32 | respondents | 4 | 148819 | 85 | 15.750 | 9448.8 |
485 | 2024-01-15 00:29:31 | respondents | 1 | 49908 | 2 | 0.830 | 60130.1 |
484 | 2023-12-21 22:02:51 | respondents | 3 | 121633 | 26 | 9.390 | 12953.5 |
483 | 2023-11-27 05:46:39 | respondents | 2 | 86808 | 5 | 2.126 | 40831.6 |
482 | 2023-11-24 10:07:46 | respondents | 1 | 49908 | 2 | 0.780 | 63984.6 |
481 | 2023-11-23 03:13:28 | respondents | 5 | 164607 | 474 | 18.610 | 8845.1 |
480 | 2023-11-23 03:13:34 | respondents | 4 | 148819 | 85 | 11.830 | 12579.8 |
479 | 2023-11-09 05:44:31 | respondents | 1 | 49908 | 2 | 0.750 | 66544.0 |
478 | 2023-11-07 06:50:40 | respondents | 1 | 49908 | 2 | 0.750 | 66544.0 |
477 | 2023-10-31 17:43:45 | respondents | 5 | 164607 | 474 | 17.110 | 9620.5 |
476 | 2023-10-31 09:46:32 | respondents | 4 | 148819 | 85 | 9.736 | 15285.4 |
475 | 2023-10-24 02:31:53 | respondents | 5 | 164607 | 474 | 19.236 | 8557.2 |
474 | 2023-09-23 05:59:53 | respondents | 3 | 121633 | 26 | 4.563 | 26656.4 |
473 | 2023-09-22 07:29:56 | respondents | 5 | 164607 | 474 | 15.156 | 10860.8 |
472 | 2023-09-22 04:35:50 | respondents | 5 | 164607 | 474 | 18.470 | 8912.1 |
471 | 2023-09-10 23:29:22 | respondents | 1 | 49908 | 2 | 0.780 | 63984.6 |
470 | 2023-08-25 18:26:05 | respondents | 2 | 86808 | 5 | 2.106 | 41219.4 |
469 | 2023-08-17 19:02:05 | respondents | 5 | 164607 | 474 | 17.080 | 9637.4 |
468 | 2023-08-16 20:33:04 | respondents | 5 | 164607 | 474 | 13.346 | 12333.8 |
467 | 2023-08-16 18:38:56 | respondents | 5 | 164607 | 474 | 13.173 | 12495.8 |
466 | 2023-08-15 15:58:24 | respondents | 5 | 164607 | 474 | 20.750 | 7932.9 |
465 | 2023-08-15 14:06:24 | respondents | 5 | 164607 | 474 | 14.500 | 11352.2 |
464 | 2023-08-15 07:26:15 | respondents | 5 | 164607 | 474 | 13.206 | 12464.6 |
463 | 2023-08-13 10:11:40 | respondents | 5 | 164607 | 474 | 13.313 | 12364.4 |
462 | 2023-08-11 16:51:49 | respondents | 5 | 164607 | 474 | 15.843 | 10389.9 |
461 | 2023-08-10 06:34:25 | respondents | 5 | 164607 | 474 | 14.253 | 11548.9 |
460 | 2023-08-09 07:25:40 | respondents | 5 | 164607 | 474 | 13.563 | 12136.5 |
459 | 2023-08-08 00:28:20 | respondents | 4 | 148819 | 85 | 8.266 | 18003.8 |
458 | 2023-08-06 17:57:36 | respondents | 5 | 164607 | 474 | 14.326 | 11490.1 |
457 | 2023-08-06 11:57:32 | respondents | 5 | 164607 | 474 | 13.143 | 12524.3 |
456 | 2023-08-04 17:21:38 | respondents | 5 | 164607 | 474 | 15.373 | 10707.5 |
455 | 2023-08-02 20:36:15 | respondents | 5 | 164607 | 474 | 16.920 | 9728.5 |
454 | 2023-07-31 06:56:56 | respondents | 5 | 164607 | 474 | 13.580 | 12121.3 |
453 | 2023-07-20 08:01:09 | respondents | 5 | 164607 | 474 | 13.376 | 12306.1 |
452 | 2023-07-15 13:02:07 | respondents | 5 | 164607 | 474 | 13.830 | 11902.2 |
451 | 2023-07-14 17:51:47 | respondents | 5 | 164607 | 474 | 14.203 | 11589.6 |
450 | 2023-07-09 21:54:15 | respondents | 5 | 164607 | 474 | 13.296 | 12380.2 |
449 | 2023-07-08 18:58:03 | respondents | 5 | 164607 | 474 | 15.533 | 10597.2 |
448 | 2023-07-07 23:05:42 | respondents | 5 | 164607 | 474 | 15.690 | 10491.2 |
447 | 2023-07-06 17:08:33 | respondents | 5 | 164607 | 474 | 14.736 | 11170.4 |
446 | 2023-07-03 08:58:30 | respondents | 3 | 121633 | 26 | 4.593 | 26482.3 |
445 | 2023-06-23 04:01:10 | respondents | 5 | 164607 | 474 | 13.203 | 12467.4 |
444 | 2023-06-17 00:38:50 | respondents | 1 | 49908 | 2 | 0.766 | 65154.0 |
443 | 2023-05-15 07:34:54 | respondents | 5 | 164607 | 474 | 14.720 | 11182.5 |
442 | 2023-05-14 16:42:47 | respondents | 2 | 86808 | 5 | 2.406 | 36079.8 |
441 | 2023-04-19 10:51:30 | respondents | 4 | 148819 | 85 | 8.110 | 18350.1 |
440 | 2023-04-08 01:51:13 | respondents | 5 | 164607 | 474 | 15.253 | 10791.8 |
439 | 2023-03-31 18:35:41 | respondents | 1 | 49908 | 2 | 0.750 | 66544.0 |
438 | 2023-03-26 17:57:41 | respondents | 3 | 121633 | 26 | 4.530 | 26850.6 |
437 | 2023-02-26 03:46:26 | respondents | 5 | 164607 | 474 | 13.156 | 12511.9 |
436 | 2023-02-26 00:11:26 | respondents | 5 | 164607 | 474 | 13.080 | 12584.6 |
435 | 2023-02-21 00:40:50 | respondents | 2 | 86808 | 5 | 2.156 | 40263.5 |
434 | 2023-01-20 16:49:31 | respondents | 4 | 148819 | 85 | 8.080 | 18418.2 |
433 | 2023-01-19 20:40:18 | respondents | 5 | 164607 | 474 | 13.330 | 12348.6 |
432 | 2023-01-15 13:44:50 | respondents | 1 | 49908 | 2 | 0.766 | 65154.0 |
431 | 2023-01-07 17:34:46 | respondents | 5 | 164607 | 474 | 15.530 | 10599.3 |