History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"banana"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1189 | 2024-03-28 08:28:04 | banana | 1 | 48755 | 5 | 0.953 | 51159.5 |
1188 | 2024-02-26 01:54:24 | banana | 1 | 48755 | 5 | 1.346 | 36222.1 |
1187 | 2024-02-04 10:43:59 | banana | 3 | 112716 | 441 | 14.546 | 7748.9 |
1186 | 2024-02-03 23:28:23 | banana | 3 | 112716 | 441 | 5.420 | 20796.3 |
1185 | 2024-02-02 01:05:05 | banana | 2 | 82551 | 34 | 2.170 | 38041.9 |
1184 | 2024-01-31 02:38:04 | banana | 3 | 112716 | 441 | 11.580 | 9733.7 |
1183 | 2024-01-30 19:52:15 | banana | 2 | 82551 | 34 | 2.643 | 31233.8 |
1182 | 2024-01-30 19:51:03 | banana | 3 | 112716 | 441 | 6.093 | 18499.3 |
1181 | 2024-01-30 12:33:56 | banana | 2 | 82551 | 34 | 2.670 | 30918.0 |
1180 | 2024-01-30 12:33:35 | banana | 3 | 112716 | 441 | 7.156 | 15751.3 |
1179 | 2024-01-30 08:48:08 | banana | 2 | 82551 | 34 | 2.673 | 30883.3 |
1178 | 2024-01-30 08:47:36 | banana | 3 | 112716 | 441 | 5.766 | 19548.4 |
1177 | 2024-01-19 07:18:01 | banana | 3 | 112716 | 441 | 6.076 | 18551.0 |
1176 | 2024-01-07 06:22:04 | banana | 1 | 48755 | 5 | 0.856 | 56956.8 |
1175 | 2023-12-29 02:25:48 | banana | 2 | 82551 | 34 | 2.686 | 30733.8 |
1174 | 2023-12-12 07:35:09 | banana | 3 | 112716 | 441 | 10.610 | 10623.6 |
1173 | 2023-12-12 07:35:14 | banana | 2 | 82551 | 34 | 2.686 | 30733.8 |
1172 | 2023-11-30 14:38:29 | banana | 3 | 112716 | 441 | 6.030 | 18692.5 |
1171 | 2023-11-30 14:38:21 | banana | 2 | 82551 | 34 | 2.500 | 33020.4 |
1170 | 2023-11-19 16:37:42 | banana | 3 | 112716 | 441 | 5.486 | 20546.1 |
1169 | 2023-11-19 16:37:44 | banana | 2 | 82551 | 34 | 2.546 | 32423.8 |
1168 | 2023-11-11 00:53:39 | banana | 1 | 48755 | 5 | 0.843 | 57835.1 |
1167 | 2023-11-09 01:46:55 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1166 | 2023-11-07 11:47:07 | banana | 1 | 48755 | 5 | 0.826 | 59025.4 |
1165 | 2023-10-31 22:16:46 | banana | 1 | 48755 | 5 | 0.830 | 58741.0 |
1164 | 2023-10-31 15:21:27 | banana | 3 | 112716 | 441 | 4.970 | 22679.3 |
1163 | 2023-10-31 15:21:24 | banana | 2 | 82551 | 34 | 2.173 | 37989.4 |
1162 | 2023-10-30 22:28:06 | banana | 3 | 112716 | 441 | 5.766 | 19548.4 |
1161 | 2023-10-27 17:09:16 | banana | 1 | 48755 | 5 | 0.780 | 62506.4 |
1160 | 2023-10-20 20:24:29 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1159 | 2023-10-18 04:36:43 | banana | 1 | 48755 | 5 | 0.763 | 63899.1 |
1158 | 2023-10-17 14:50:28 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1157 | 2023-10-15 15:54:31 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1156 | 2023-10-12 08:47:23 | banana | 1 | 48755 | 5 | 1.516 | 32160.3 |
1155 | 2023-10-04 09:19:18 | banana | 1 | 48755 | 5 | 1.910 | 25526.2 |
1154 | 2023-10-02 11:58:22 | banana | 2 | 82551 | 34 | 2.330 | 35429.6 |
1153 | 2023-09-23 18:42:11 | banana | 1 | 48755 | 5 | 0.780 | 62506.4 |
1152 | 2023-09-12 10:58:35 | banana | 1 | 48755 | 5 | 0.830 | 58741.0 |
1151 | 2023-08-25 05:06:27 | banana | 1 | 48755 | 5 | 0.780 | 62506.4 |
1150 | 2023-08-06 13:35:56 | banana | 3 | 112716 | 441 | 4.733 | 23814.9 |
1149 | 2023-07-13 20:35:21 | banana | 2 | 82551 | 34 | 2.126 | 38829.3 |
1148 | 2023-07-09 23:16:16 | banana | 1 | 48755 | 5 | 1.720 | 28345.9 |
1147 | 2023-05-27 08:37:03 | banana | 1 | 48755 | 5 | 0.813 | 59969.2 |
1146 | 2023-04-18 11:26:10 | banana | 3 | 112716 | 441 | 4.656 | 24208.8 |
1145 | 2023-04-02 10:42:09 | banana | 1 | 48755 | 5 | 0.893 | 54596.9 |
1144 | 2023-03-31 12:18:22 | banana | 1 | 48755 | 5 | 0.843 | 57835.1 |
1143 | 2023-03-30 15:05:34 | banana | 2 | 82551 | 34 | 2.140 | 38575.2 |
1142 | 2023-03-22 03:42:10 | banana | 1 | 48755 | 5 | 0.736 | 66243.2 |
1141 | 2023-01-26 14:48:18 | banana | 3 | 112716 | 441 | 5.500 | 20493.8 |
1140 | 2023-01-08 14:43:24 | banana | 1 | 48755 | 5 | 0.826 | 59025.4 |
1139 | 2022-12-28 06:24:45 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1138 | 2022-12-25 23:10:06 | banana | 2 | 82551 | 34 | 2.313 | 35690.0 |
1137 | 2022-12-14 22:45:28 | banana | 3 | 112716 | 441 | 5.690 | 19809.5 |
1136 | 2022-11-08 03:00:47 | banana | 3 | 112716 | 441 | 4.936 | 22835.5 |
1135 | 2022-10-06 19:44:03 | banana | 1 | 48755 | 5 | 0.826 | 59025.4 |
1134 | 2022-09-13 20:46:39 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1133 | 2022-09-10 11:37:49 | banana | 1 | 48755 | 5 | 0.813 | 59969.2 |
1132 | 2022-09-02 09:21:32 | banana | 1 | 48755 | 5 | 0.970 | 50262.9 |
1131 | 2022-08-28 00:00:22 | banana | 2 | 82551 | 34 | 2.250 | 36689.3 |
1130 | 2022-08-15 15:53:31 | banana | 1 | 48755 | 5 | 0.843 | 57835.1 |
1129 | 2022-08-06 12:28:56 | banana | 1 | 48755 | 5 | 0.783 | 62266.9 |
1128 | 2022-07-18 09:49:33 | banana | 1 | 48755 | 5 | 0.733 | 66514.3 |
1127 | 2022-07-17 21:30:49 | banana | 1 | 48755 | 5 | 0.843 | 57835.1 |
1126 | 2022-06-25 07:55:16 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1125 | 2022-06-24 20:17:28 | banana | 1 | 48755 | 5 | 0.766 | 63648.8 |
1124 | 2022-06-10 21:07:28 | banana | 3 | 112716 | 441 | 4.830 | 23336.6 |
1123 | 2022-05-31 22:25:06 | banana | 1 | 48755 | 5 | 0.763 | 63899.1 |
1122 | 2022-05-28 22:25:44 | banana | 1 | 48755 | 5 | 0.780 | 62506.4 |
1121 | 2022-05-24 20:01:13 | banana | 1 | 48755 | 5 | 0.766 | 63648.8 |
1120 | 2022-02-20 19:28:37 | banana | 1 | 48755 | 5 | 0.830 | 58741.0 |
1119 | 2022-02-07 10:38:33 | banana | 1 | 48755 | 5 | 0.893 | 54596.9 |
1118 | 2022-02-06 09:31:49 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1117 | 2022-02-05 08:14:22 | banana | 1 | 48755 | 5 | 0.970 | 50262.9 |
1116 | 2022-02-04 08:25:11 | banana | 1 | 48755 | 5 | 0.953 | 51159.5 |
1115 | 2022-02-04 00:36:34 | banana | 1 | 48755 | 5 | 0.843 | 57835.1 |
1114 | 2022-02-03 02:48:59 | banana | 1 | 48755 | 5 | 1.156 | 42175.6 |
1113 | 2022-02-02 08:13:02 | banana | 1 | 48755 | 5 | 0.873 | 55847.7 |
1112 | 2022-02-01 20:25:54 | banana | 1 | 48755 | 5 | 0.766 | 63648.8 |
1111 | 2022-02-01 06:06:10 | banana | 1 | 48755 | 5 | 0.923 | 52822.3 |
1110 | 2022-01-31 04:03:09 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1109 | 2022-01-30 09:47:23 | banana | 1 | 48755 | 5 | 0.750 | 65006.7 |
1108 | 2022-01-29 09:00:38 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1107 | 2021-11-21 16:45:08 | banana | 1 | 48755 | 5 | 0.796 | 61250.0 |
1106 | 2021-11-19 09:35:21 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1105 | 2021-11-16 02:01:52 | banana | 1 | 48755 | 5 | 0.766 | 63648.8 |
1104 | 2021-10-09 12:16:57 | banana | 1 | 48755 | 5 | 0.893 | 54596.9 |
1103 | 2021-10-07 11:16:17 | banana | 1 | 48755 | 5 | 0.846 | 57630.0 |
1102 | 2021-08-31 19:28:40 | banana | 1 | 48755 | 5 | 0.796 | 61250.0 |
1101 | 2021-08-16 13:27:54 | banana | 1 | 48755 | 5 | 0.860 | 56691.9 |
1100 | 2021-08-14 19:00:40 | banana | 2 | 82551 | 34 | 2.390 | 34540.2 |
1099 | 2021-08-13 05:55:05 | banana | 1 | 48755 | 5 | 0.780 | 62506.4 |
1098 | 2021-08-12 03:01:45 | banana | 2 | 82551 | 34 | 2.580 | 31996.5 |
1097 | 2021-07-29 03:11:42 | banana | 2 | 82551 | 34 | 2.123 | 38884.1 |
1096 | 2021-07-28 02:11:33 | banana | 2 | 82551 | 34 | 2.170 | 38041.9 |
1095 | 2021-07-27 06:13:39 | banana | 2 | 82551 | 34 | 2.326 | 35490.5 |
1094 | 2021-07-26 15:18:22 | banana | 2 | 82551 | 34 | 2.253 | 36640.5 |
1093 | 2021-07-24 02:08:42 | banana | 2 | 82551 | 34 | 2.466 | 33475.7 |
1092 | 2021-07-23 03:47:40 | banana | 2 | 82551 | 34 | 2.156 | 38289.0 |
1091 | 2021-07-22 09:23:57 | banana | 2 | 82551 | 34 | 2.373 | 34787.6 |
1090 | 2021-07-21 17:10:25 | banana | 2 | 82551 | 34 | 2.203 | 37472.1 |