History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ainsell"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1240 | 2024-05-05 01:40:33 | ainsell | 4 | 151207 | 1427 | 22.860 | 6614.5 |
1239 | 2024-04-30 19:05:10 | ainsell | 4 | 151207 | 1427 | 12.313 | 12280.3 |
1238 | 2024-04-26 18:12:44 | ainsell | 4 | 151207 | 1427 | 11.156 | 13553.9 |
1237 | 2024-04-26 09:09:13 | ainsell | 4 | 151207 | 1427 | 29.736 | 5085.0 |
1236 | 2024-04-24 22:43:05 | ainsell | 4 | 151207 | 1427 | 13.890 | 10886.0 |
1235 | 2024-04-20 22:36:59 | ainsell | 4 | 151207 | 1427 | 39.703 | 3808.5 |
1234 | 2024-04-20 22:36:57 | ainsell | 2 | 107671 | 6 | 10.923 | 9857.3 |
1233 | 2024-04-20 22:36:39 | ainsell | 4 | 151207 | 1427 | 22.453 | 6734.4 |
1232 | 2024-04-20 22:36:41 | ainsell | 3 | 134027 | 97 | 16.953 | 7905.8 |
1231 | 2024-04-20 22:36:53 | ainsell | 1 | 69583 | 2 | 3.266 | 21305.3 |
1230 | 2024-04-20 22:36:40 | ainsell | 2 | 107671 | 6 | 5.483 | 19637.2 |
1229 | 2024-04-20 22:36:37 | ainsell | 1 | 69583 | 2 | 1.906 | 36507.3 |
1228 | 2024-04-09 00:49:04 | ainsell | 1 | 69583 | 2 | 1.313 | 52995.4 |
1227 | 2024-04-08 23:01:30 | ainsell | 1 | 69583 | 2 | 1.173 | 59320.5 |
1226 | 2024-03-30 04:56:12 | ainsell | 1 | 69583 | 2 | 3.580 | 19436.6 |
1225 | 2024-03-27 12:30:03 | ainsell | 3 | 134027 | 97 | 17.423 | 7692.5 |
1224 | 2024-03-27 11:52:50 | ainsell | 3 | 134027 | 97 | 27.046 | 4955.5 |
1223 | 2024-03-25 18:45:29 | ainsell | 2 | 107671 | 6 | 3.720 | 28943.8 |
1222 | 2024-03-25 18:45:17 | ainsell | 3 | 134027 | 97 | 7.610 | 17612.0 |
1221 | 2024-03-25 08:49:24 | ainsell | 2 | 107671 | 6 | 3.486 | 30886.7 |
1220 | 2024-03-18 09:01:38 | ainsell | 1 | 69583 | 2 | 1.470 | 47335.4 |
1219 | 2024-03-18 08:43:43 | ainsell | 2 | 107671 | 6 | 3.530 | 30501.7 |
1218 | 2024-03-18 08:43:27 | ainsell | 3 | 134027 | 97 | 6.923 | 19359.7 |
1217 | 2024-03-11 12:41:31 | ainsell | 3 | 134027 | 97 | 17.610 | 7610.8 |
1216 | 2024-03-11 12:41:33 | ainsell | 3 | 134027 | 97 | 9.876 | 13571.0 |
1215 | 2024-03-05 03:51:11 | ainsell | 4 | 151207 | 1427 | 31.330 | 4826.3 |
1214 | 2024-03-04 04:11:33 | ainsell | 4 | 151207 | 1427 | 39.583 | 3820.0 |
1213 | 2024-03-04 01:40:48 | ainsell | 4 | 151207 | 1427 | 12.703 | 11903.3 |
1212 | 2024-03-04 01:10:13 | ainsell | 4 | 151207 | 1427 | 34.596 | 4370.6 |
1211 | 2024-02-28 13:09:35 | ainsell | 1 | 69583 | 2 | 1.190 | 58473.1 |
1210 | 2024-02-26 01:23:45 | ainsell | 2 | 107671 | 6 | 17.373 | 6197.6 |
1209 | 2024-02-26 01:23:29 | ainsell | 3 | 134027 | 97 | 8.080 | 16587.5 |
1208 | 2024-02-24 13:28:51 | ainsell | 4 | 151207 | 1427 | 10.313 | 14661.8 |
1207 | 2024-02-22 07:38:55 | ainsell | 2 | 107671 | 6 | 3.250 | 33129.5 |
1206 | 2024-02-22 07:38:39 | ainsell | 3 | 134027 | 97 | 7.766 | 17258.2 |
1205 | 2024-02-21 19:14:33 | ainsell | 3 | 134027 | 97 | 16.453 | 8146.1 |
1204 | 2024-02-18 10:28:44 | ainsell | 1 | 69583 | 2 | 3.890 | 17887.7 |
1203 | 2024-02-17 20:29:21 | ainsell | 3 | 134027 | 97 | 13.660 | 9811.6 |
1202 | 2024-02-17 03:00:33 | ainsell | 3 | 134027 | 97 | 8.593 | 15597.2 |
1201 | 2024-02-14 22:30:52 | ainsell | 1 | 69583 | 2 | 1.296 | 53690.6 |
1200 | 2024-02-14 22:29:54 | ainsell | 2 | 107671 | 6 | 3.720 | 28943.8 |
1199 | 2024-02-14 22:29:32 | ainsell | 3 | 134027 | 97 | 7.890 | 16986.9 |
1198 | 2024-01-31 15:09:48 | ainsell | 4 | 151207 | 1427 | 11.186 | 13517.5 |
1197 | 2024-01-31 13:37:23 | ainsell | 4 | 151207 | 1427 | 14.686 | 10296.0 |
1196 | 2024-01-31 04:25:41 | ainsell | 4 | 151207 | 1427 | 12.940 | 11685.2 |
1195 | 2024-01-04 18:03:54 | ainsell | 1 | 69583 | 2 | 1.123 | 61961.7 |
1194 | 2023-12-27 22:31:03 | ainsell | 1 | 69583 | 2 | 1.063 | 65459.1 |
1193 | 2023-12-21 02:13:01 | ainsell | 1 | 69583 | 2 | 1.203 | 57841.2 |
1192 | 2023-12-17 20:41:47 | ainsell | 1 | 69583 | 2 | 1.203 | 57841.2 |
1191 | 2023-11-28 06:50:08 | ainsell | 2 | 107671 | 6 | 3.376 | 31893.1 |
1190 | 2023-11-27 05:33:01 | ainsell | 1 | 69583 | 2 | 1.233 | 56433.9 |
1189 | 2023-11-23 05:52:14 | ainsell | 3 | 134027 | 97 | 5.860 | 22871.5 |
1188 | 2023-11-21 02:26:16 | ainsell | 1 | 69583 | 2 | 1.080 | 64428.7 |
1187 | 2023-11-20 00:42:12 | ainsell | 4 | 151207 | 1427 | 11.580 | 13057.6 |
1186 | 2023-10-31 04:29:53 | ainsell | 1 | 69583 | 2 | 1.250 | 55666.4 |
1185 | 2023-10-15 10:48:15 | ainsell | 1 | 69583 | 2 | 1.186 | 58670.3 |
1184 | 2023-10-15 01:19:42 | ainsell | 1 | 69583 | 2 | 1.080 | 64428.7 |
1183 | 2023-08-31 21:35:06 | ainsell | 4 | 151207 | 1427 | 12.736 | 11872.4 |
1182 | 2023-08-28 09:46:09 | ainsell | 2 | 107671 | 6 | 3.126 | 34443.7 |
1181 | 2023-08-23 20:56:47 | ainsell | 3 | 134027 | 97 | 6.483 | 20673.6 |
1180 | 2023-08-21 12:25:10 | ainsell | 4 | 151207 | 1427 | 10.936 | 13826.5 |
1179 | 2023-08-15 01:06:58 | ainsell | 1 | 69583 | 2 | 1.110 | 62687.4 |
1178 | 2023-08-10 17:39:12 | ainsell | 1 | 69583 | 2 | 2.470 | 28171.3 |
1177 | 2023-07-05 23:42:49 | ainsell | 4 | 151207 | 1427 | 10.860 | 13923.3 |
1176 | 2023-05-13 15:46:46 | ainsell | 2 | 107671 | 6 | 2.906 | 37051.3 |
1175 | 2023-05-11 09:48:18 | ainsell | 1 | 69583 | 2 | 1.076 | 64668.2 |
1174 | 2023-05-07 21:41:34 | ainsell | 3 | 134027 | 97 | 5.826 | 23005.0 |
1173 | 2023-05-06 12:32:38 | ainsell | 4 | 151207 | 1427 | 9.906 | 15264.2 |
1172 | 2023-04-23 02:21:15 | ainsell | 1 | 69583 | 2 | 1.173 | 59320.5 |
1171 | 2023-03-07 19:25:01 | ainsell | 1 | 69583 | 2 | 1.076 | 64668.2 |
1170 | 2023-02-22 04:35:58 | ainsell | 2 | 107671 | 6 | 5.690 | 18922.8 |
1169 | 2023-02-15 19:18:35 | ainsell | 3 | 134027 | 97 | 6.406 | 20922.1 |
1168 | 2023-02-12 20:27:00 | ainsell | 4 | 151207 | 1427 | 11.970 | 12632.2 |
1167 | 2023-01-26 19:16:53 | ainsell | 4 | 151207 | 1427 | 11.470 | 13182.8 |
1166 | 2022-12-30 12:12:15 | ainsell | 1 | 69583 | 2 | 2.156 | 32274.1 |
1165 | 2022-12-27 19:17:10 | ainsell | 1 | 69583 | 2 | 1.203 | 57841.2 |
1164 | 2022-12-02 11:24:44 | ainsell | 2 | 107671 | 6 | 3.063 | 35152.1 |
1163 | 2022-11-25 23:00:15 | ainsell | 4 | 151207 | 1427 | 10.250 | 14751.9 |
1162 | 2022-11-25 12:05:47 | ainsell | 3 | 134027 | 97 | 5.986 | 22390.1 |
1161 | 2022-09-15 10:19:12 | ainsell | 1 | 69583 | 2 | 1.093 | 63662.4 |
1160 | 2022-09-02 02:07:07 | ainsell | 1 | 69583 | 2 | 1.110 | 62687.4 |
1159 | 2022-07-03 21:07:05 | ainsell | 1 | 69583 | 2 | 1.233 | 56433.9 |
1158 | 2022-06-29 20:53:28 | ainsell | 1 | 69583 | 2 | 1.093 | 63662.4 |
1157 | 2022-06-26 18:25:13 | ainsell | 4 | 151207 | 1427 | 11.203 | 13497.0 |
1156 | 2022-06-26 01:20:31 | ainsell | 4 | 151207 | 1427 | 11.360 | 13310.5 |
1155 | 2022-06-12 07:09:27 | ainsell | 1 | 69583 | 2 | 1.126 | 61796.6 |
1154 | 2022-06-10 07:14:42 | ainsell | 4 | 151207 | 1427 | 11.736 | 12884.0 |
1153 | 2022-06-10 06:10:12 | ainsell | 4 | 151207 | 1427 | 10.923 | 13843.0 |
1152 | 2022-06-02 07:05:28 | ainsell | 4 | 151207 | 1427 | 10.000 | 15120.7 |
1151 | 2022-05-13 19:04:58 | ainsell | 4 | 151207 | 1427 | 13.063 | 11575.2 |
1150 | 2022-05-04 16:05:21 | ainsell | 4 | 151207 | 1427 | 11.593 | 13043.0 |
1149 | 2022-05-01 18:30:28 | ainsell | 4 | 151207 | 1427 | 10.830 | 13961.9 |
1148 | 2022-04-30 17:46:20 | ainsell | 4 | 151207 | 1427 | 11.063 | 13667.8 |
1147 | 2022-04-27 19:12:00 | ainsell | 4 | 151207 | 1427 | 12.236 | 12357.6 |
1146 | 2022-04-27 01:38:20 | ainsell | 4 | 151207 | 1427 | 10.846 | 13941.3 |
1145 | 2022-04-26 10:37:54 | ainsell | 4 | 151207 | 1427 | 11.096 | 13627.2 |
1144 | 2022-04-26 08:23:13 | ainsell | 3 | 134027 | 97 | 6.093 | 21996.9 |
1143 | 2022-04-26 02:32:31 | ainsell | 1 | 69583 | 2 | 1.253 | 55533.1 |
1142 | 2022-04-25 20:35:25 | ainsell | 4 | 151207 | 1427 | 10.266 | 14728.9 |
1141 | 2022-04-25 07:50:42 | ainsell | 4 | 151207 | 1427 | 10.080 | 15000.7 |