History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"water"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1070 | 2025-04-16 08:42:33 | water | 2 | 53800 | 377 | 7.656 | 7027.2 |
1069 | 2025-04-16 02:44:08 | water | 2 | 53800 | 377 | 8.060 | 6674.9 |
1068 | 2025-04-15 22:29:40 | water | 2 | 53800 | 377 | 11.656 | 4615.6 |
1067 | 2025-04-15 05:21:42 | water | 1 | 28756 | 26 | 2.596 | 11077.0 |
1066 | 2025-04-15 03:52:39 | water | 2 | 53800 | 377 | 8.000 | 6725.0 |
1065 | 2025-04-04 11:57:29 | water | 1 | 28756 | 26 | 2.656 | 10826.8 |
1064 | 2025-03-29 16:06:16 | water | 1 | 28756 | 26 | 3.670 | 7835.4 |
1063 | 2025-03-27 16:10:57 | water | 1 | 28756 | 26 | 2.343 | 12273.2 |
1062 | 2025-03-27 07:28:57 | water | 1 | 28756 | 26 | 2.063 | 13938.9 |
1061 | 2025-03-17 15:05:00 | water | 1 | 28756 | 26 | 1.406 | 20452.3 |
1060 | 2025-03-15 08:29:33 | water | 2 | 53800 | 377 | 5.376 | 10007.4 |
1059 | 2025-03-15 08:02:04 | water | 1 | 28756 | 26 | 1.750 | 16432.0 |
1058 | 2025-03-13 17:27:57 | water | 1 | 28756 | 26 | 0.766 | 37540.5 |
1057 | 2025-03-12 20:51:10 | water | 1 | 28756 | 26 | 2.266 | 12690.2 |
1056 | 2025-03-11 08:35:55 | water | 1 | 28756 | 26 | 0.516 | 55728.7 |
1055 | 2025-03-07 19:39:54 | water | 1 | 28756 | 26 | 1.140 | 25224.6 |
1054 | 2025-02-26 17:22:59 | water | 2 | 53800 | 377 | 11.643 | 4620.8 |
1053 | 2025-02-26 10:35:49 | water | 2 | 53800 | 377 | 6.720 | 8006.0 |
1052 | 2025-02-26 08:43:54 | water | 2 | 53800 | 377 | 5.013 | 10732.1 |
1051 | 2025-02-26 08:18:01 | water | 1 | 28756 | 26 | 0.470 | 61183.0 |
1050 | 2025-02-25 04:48:16 | water | 1 | 28756 | 26 | 0.966 | 29768.1 |
1049 | 2025-02-24 02:31:56 | water | 1 | 28756 | 26 | 2.326 | 12362.9 |
1048 | 2025-02-16 20:33:34 | water | 1 | 28756 | 26 | 3.390 | 8482.6 |
1047 | 2025-02-16 12:00:28 | water | 1 | 28756 | 26 | 2.736 | 10510.2 |
1046 | 2025-02-16 11:12:44 | water | 1 | 28756 | 26 | 2.190 | 13130.6 |
1045 | 2025-01-27 04:18:26 | water | 2 | 53800 | 377 | 6.466 | 8320.4 |
1044 | 2025-01-26 12:18:22 | water | 2 | 53800 | 377 | 6.216 | 8655.1 |
1043 | 2025-01-26 11:51:39 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
1042 | 2025-01-26 03:35:18 | water | 1 | 28756 | 26 | 2.690 | 10690.0 |
1041 | 2025-01-05 18:26:58 | water | 1 | 28756 | 26 | 2.346 | 12257.5 |
1040 | 2024-12-28 04:49:32 | water | 2 | 53800 | 377 | 8.466 | 6354.8 |
1039 | 2024-12-27 18:27:45 | water | 2 | 53800 | 377 | 4.206 | 12791.3 |
1038 | 2024-12-27 14:09:22 | water | 2 | 53800 | 377 | 9.813 | 5482.5 |
1037 | 2024-12-27 11:26:44 | water | 2 | 53800 | 377 | 7.376 | 7293.9 |
1036 | 2024-12-27 11:26:25 | water | 1 | 28756 | 26 | 1.346 | 21364.0 |
1035 | 2024-12-27 02:36:08 | water | 1 | 28756 | 26 | 1.236 | 23265.4 |
1034 | 2024-12-25 16:06:55 | water | 1 | 28756 | 26 | 2.476 | 11613.9 |
1033 | 2024-11-27 10:16:03 | water | 2 | 53800 | 377 | 9.423 | 5709.4 |
1032 | 2024-11-27 01:37:09 | water | 1 | 28756 | 26 | 2.563 | 11219.7 |
1031 | 2024-11-27 00:40:13 | water | 2 | 53800 | 377 | 11.860 | 4536.3 |
1030 | 2024-11-26 21:58:19 | water | 2 | 53800 | 377 | 8.093 | 6647.7 |
1029 | 2024-11-26 21:31:46 | water | 1 | 28756 | 26 | 1.390 | 20687.8 |
1028 | 2024-11-25 13:46:10 | water | 1 | 28756 | 26 | 2.890 | 9950.2 |
1027 | 2024-11-07 05:45:15 | water | 1 | 28756 | 26 | 2.250 | 12780.4 |
1026 | 2024-11-01 01:50:30 | water | 2 | 53800 | 377 | 3.830 | 14047.0 |
1025 | 2024-10-28 00:41:20 | water | 1 | 28756 | 26 | 0.546 | 52666.7 |
1024 | 2024-10-28 00:19:04 | water | 2 | 53800 | 377 | 8.016 | 6711.6 |
1023 | 2024-10-27 22:34:06 | water | 2 | 53800 | 377 | 7.703 | 6984.3 |
1022 | 2024-10-27 21:16:22 | water | 1 | 28756 | 26 | 0.486 | 59168.7 |
1021 | 2024-10-26 11:17:42 | water | 1 | 28756 | 26 | 1.283 | 22413.1 |
1020 | 2024-10-08 02:25:34 | water | 1 | 28756 | 26 | 3.126 | 9199.0 |
1019 | 2024-10-07 04:21:22 | water | 1 | 28756 | 26 | 4.156 | 6919.2 |
1018 | 2024-09-27 23:15:20 | water | 1 | 28756 | 26 | 2.783 | 10332.7 |
1017 | 2024-09-27 20:34:23 | water | 1 | 28756 | 26 | 2.580 | 11145.7 |
1016 | 2024-09-26 08:04:53 | water | 1 | 28756 | 26 | 2.186 | 13154.6 |
1015 | 2024-09-07 11:49:33 | water | 1 | 28756 | 26 | 3.516 | 8178.6 |
1014 | 2024-08-29 20:32:05 | water | 1 | 28756 | 26 | 1.750 | 16432.0 |
1013 | 2024-08-29 19:28:25 | water | 2 | 53800 | 377 | 15.376 | 3499.0 |
1012 | 2024-08-29 11:04:46 | water | 2 | 53800 | 377 | 13.796 | 3899.7 |
1011 | 2024-08-29 08:44:03 | water | 2 | 53800 | 377 | 17.203 | 3127.4 |
1010 | 2024-08-28 18:28:11 | water | 2 | 53800 | 377 | 8.343 | 6448.5 |
1009 | 2024-08-28 17:54:46 | water | 1 | 28756 | 26 | 0.453 | 63479.0 |
1008 | 2024-08-28 13:12:04 | water | 1 | 28756 | 26 | 1.813 | 15861.0 |
1007 | 2024-08-26 18:53:52 | water | 1 | 28756 | 26 | 4.703 | 6114.4 |
1006 | 2024-08-09 18:08:42 | water | 1 | 28756 | 26 | 1.123 | 25606.4 |
1005 | 2024-08-08 12:22:00 | water | 1 | 28756 | 26 | 0.546 | 52666.7 |
1004 | 2024-08-02 07:40:30 | water | 1 | 28756 | 26 | 1.720 | 16718.6 |
1003 | 2024-08-01 08:06:36 | water | 1 | 28756 | 26 | 1.720 | 16718.6 |
1002 | 2024-08-01 04:17:13 | water | 1 | 28756 | 26 | 1.966 | 14626.7 |
1001 | 2024-07-30 03:56:25 | water | 2 | 53800 | 377 | 4.423 | 12163.7 |
1000 | 2024-07-29 20:57:04 | water | 2 | 53800 | 377 | 6.843 | 7862.0 |
999 | 2024-07-29 18:17:10 | water | 2 | 53800 | 377 | 2.623 | 20510.9 |
998 | 2024-07-29 17:31:19 | water | 1 | 28756 | 26 | 0.546 | 52666.7 |
997 | 2024-07-29 09:53:16 | water | 1 | 28756 | 26 | 0.516 | 55728.7 |
996 | 2024-07-27 13:25:46 | water | 1 | 28756 | 26 | 1.703 | 16885.5 |
995 | 2024-07-23 08:28:30 | water | 1 | 28756 | 26 | 2.453 | 11722.8 |
994 | 2024-07-23 07:22:35 | water | 1 | 28756 | 26 | 0.780 | 36866.7 |
993 | 2024-07-19 09:19:54 | water | 1 | 28756 | 26 | 1.936 | 14853.3 |
992 | 2024-07-10 04:03:21 | water | 1 | 28756 | 26 | 1.516 | 18968.3 |
991 | 2024-07-06 16:38:49 | water | 1 | 28756 | 26 | 2.016 | 14263.9 |
990 | 2024-07-05 22:10:15 | water | 1 | 28756 | 26 | 2.003 | 14356.5 |
989 | 2024-07-05 13:59:11 | water | 1 | 28756 | 26 | 3.033 | 9481.0 |
988 | 2024-07-03 07:11:31 | water | 2 | 53800 | 377 | 4.673 | 11512.9 |
987 | 2024-07-03 05:57:38 | water | 1 | 28756 | 26 | 2.093 | 13739.1 |
986 | 2024-07-02 00:21:50 | water | 1 | 28756 | 26 | 2.716 | 10587.6 |
985 | 2024-06-29 20:53:00 | water | 2 | 53800 | 377 | 5.296 | 10158.6 |
984 | 2024-06-29 17:36:44 | water | 2 | 53800 | 377 | 2.513 | 21408.7 |
983 | 2024-06-29 15:28:33 | water | 2 | 53800 | 377 | 8.343 | 6448.5 |
982 | 2024-06-29 15:08:27 | water | 1 | 28756 | 26 | 1.483 | 19390.4 |
981 | 2024-06-29 08:59:23 | water | 1 | 28756 | 26 | 0.563 | 51076.4 |
980 | 2024-06-27 20:48:01 | water | 1 | 28756 | 26 | 2.940 | 9781.0 |
979 | 2024-06-14 03:55:43 | water | 1 | 28756 | 26 | 1.500 | 19170.7 |
978 | 2024-06-04 11:45:07 | water | 1 | 28756 | 26 | 1.750 | 16432.0 |
977 | 2024-06-03 05:34:59 | water | 1 | 28756 | 26 | 0.483 | 59536.2 |
976 | 2024-06-02 10:50:35 | water | 1 | 28756 | 26 | 0.533 | 53951.2 |
975 | 2024-05-31 23:04:24 | water | 2 | 53800 | 377 | 5.953 | 9037.5 |
974 | 2024-05-31 21:57:20 | water | 2 | 53800 | 377 | 1.923 | 27977.1 |
973 | 2024-05-30 11:23:07 | water | 2 | 53800 | 377 | 4.503 | 11947.6 |
972 | 2024-05-30 11:03:21 | water | 1 | 28756 | 26 | 2.000 | 14378.0 |
971 | 2024-05-29 20:46:33 | water | 2 | 53800 | 377 | 5.936 | 9063.3 |