History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bandmaster"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
293 | 2024-04-25 21:51:35 | bandmaster | 1 | 67641 | 2 | 1.643 | 41169.2 |
292 | 2024-04-19 07:37:25 | bandmaster | 4 | 161450 | 141 | 11.110 | 14532.0 |
291 | 2024-04-12 02:36:22 | bandmaster | 2 | 108824 | 5 | 3.563 | 30542.8 |
290 | 2024-04-12 02:33:15 | bandmaster | 1 | 67641 | 2 | 5.203 | 13000.4 |
289 | 2024-04-10 18:30:46 | bandmaster | 1 | 67641 | 2 | 4.360 | 15514.0 |
288 | 2024-04-07 13:58:25 | bandmaster | 2 | 108824 | 5 | 4.126 | 26375.2 |
287 | 2024-04-07 12:49:52 | bandmaster | 4 | 161450 | 141 | 15.173 | 10640.6 |
286 | 2024-04-07 12:49:29 | bandmaster | 3 | 140603 | 21 | 15.016 | 9363.5 |
285 | 2024-04-06 23:59:12 | bandmaster | 4 | 161450 | 141 | 35.550 | 4541.5 |
284 | 2024-04-03 20:16:57 | bandmaster | 2 | 108824 | 5 | 7.563 | 14389.0 |
283 | 2024-04-03 20:13:58 | bandmaster | 1 | 67641 | 2 | 1.250 | 54112.8 |
282 | 2024-04-03 20:13:52 | bandmaster | 1 | 67641 | 2 | 1.236 | 54725.7 |
281 | 2024-04-03 20:11:31 | bandmaster | 3 | 140603 | 21 | 12.270 | 11459.1 |
280 | 2024-04-03 10:07:15 | bandmaster | 4 | 161450 | 141 | 32.376 | 4986.7 |
279 | 2024-03-31 17:36:27 | bandmaster | 3 | 140603 | 21 | 19.533 | 7198.2 |
278 | 2024-03-30 17:31:17 | bandmaster | 4 | 161450 | 141 | 33.923 | 4759.3 |
277 | 2024-03-27 18:23:59 | bandmaster | 4 | 161450 | 141 | 32.596 | 4953.1 |
276 | 2024-03-27 18:24:07 | bandmaster | 3 | 140603 | 21 | 19.953 | 7046.7 |
275 | 2024-03-27 18:24:03 | bandmaster | 2 | 108824 | 5 | 9.703 | 11215.5 |
274 | 2024-03-27 16:31:53 | bandmaster | 1 | 67641 | 2 | 2.406 | 28113.5 |
273 | 2024-03-08 02:46:02 | bandmaster | 1 | 67641 | 2 | 1.203 | 56226.9 |
272 | 2024-03-06 09:41:44 | bandmaster | 3 | 140603 | 21 | 23.550 | 5970.4 |
271 | 2024-03-06 09:41:45 | bandmaster | 2 | 108824 | 5 | 7.796 | 13959.0 |
270 | 2024-03-06 09:39:46 | bandmaster | 1 | 67641 | 2 | 2.516 | 26884.3 |
269 | 2024-03-05 01:28:58 | bandmaster | 4 | 161450 | 141 | 33.876 | 4765.9 |
268 | 2024-03-04 09:08:02 | bandmaster | 4 | 161450 | 141 | 27.770 | 5813.8 |
267 | 2024-02-28 13:22:17 | bandmaster | 1 | 67641 | 2 | 1.123 | 60232.4 |
266 | 2024-02-21 18:37:06 | bandmaster | 3 | 140603 | 21 | 8.766 | 16039.6 |
265 | 2024-02-20 17:15:59 | bandmaster | 1 | 67641 | 2 | 2.453 | 27574.8 |
264 | 2024-02-20 09:37:44 | bandmaster | 3 | 140603 | 21 | 11.983 | 11733.5 |
263 | 2024-02-19 09:09:31 | bandmaster | 4 | 161450 | 141 | 13.470 | 11985.9 |
262 | 2024-02-18 08:39:18 | bandmaster | 4 | 161450 | 141 | 46.443 | 3476.3 |
261 | 2024-02-16 15:58:37 | bandmaster | 3 | 140603 | 21 | 28.330 | 4963.0 |
260 | 2024-02-16 15:58:35 | bandmaster | 4 | 161450 | 141 | 26.986 | 5982.7 |
259 | 2024-02-16 15:58:33 | bandmaster | 2 | 108824 | 5 | 3.623 | 30037.0 |
258 | 2024-02-16 07:06:19 | bandmaster | 1 | 67641 | 2 | 1.310 | 51634.4 |
257 | 2024-01-29 09:24:43 | bandmaster | 1 | 67641 | 2 | 1.093 | 61885.6 |
256 | 2024-01-26 23:09:59 | bandmaster | 1 | 67641 | 2 | 1.173 | 57665.0 |
255 | 2024-01-21 04:24:19 | bandmaster | 1 | 67641 | 2 | 1.140 | 59334.2 |
254 | 2024-01-12 14:10:53 | bandmaster | 1 | 67641 | 2 | 2.233 | 30291.5 |
253 | 2024-01-09 09:15:58 | bandmaster | 1 | 67641 | 2 | 1.033 | 65480.2 |
252 | 2023-12-15 03:01:03 | bandmaster | 1 | 67641 | 2 | 1.003 | 67438.7 |
251 | 2023-11-03 17:14:08 | bandmaster | 1 | 67641 | 2 | 2.216 | 30523.9 |
250 | 2023-10-17 04:33:05 | bandmaster | 1 | 67641 | 2 | 1.280 | 52844.5 |
249 | 2023-09-03 15:49:03 | bandmaster | 1 | 67641 | 2 | 2.190 | 30886.3 |
248 | 2023-08-27 12:58:47 | bandmaster | 1 | 67641 | 2 | 1.000 | 67641.0 |
247 | 2023-05-29 04:03:23 | bandmaster | 1 | 67641 | 2 | 0.983 | 68810.8 |
246 | 2023-05-03 14:18:46 | bandmaster | 1 | 67641 | 2 | 1.140 | 59334.2 |
245 | 2023-03-23 07:50:58 | bandmaster | 1 | 67641 | 2 | 1.186 | 57032.9 |
244 | 2023-01-09 07:36:52 | bandmaster | 1 | 67641 | 2 | 0.983 | 68810.8 |
243 | 2023-01-02 15:39:21 | bandmaster | 1 | 67641 | 2 | 1.000 | 67641.0 |
242 | 2022-11-14 16:04:53 | bandmaster | 3 | 140603 | 21 | 5.580 | 25197.7 |
241 | 2022-10-05 15:03:25 | bandmaster | 1 | 67641 | 2 | 1.110 | 60937.8 |
240 | 2022-08-26 00:38:44 | bandmaster | 1 | 67641 | 2 | 1.110 | 60937.8 |
239 | 2022-05-21 12:03:19 | bandmaster | 1 | 67641 | 2 | 1.033 | 65480.2 |
238 | 2022-05-09 07:48:40 | bandmaster | 3 | 140603 | 21 | 5.673 | 24784.6 |
237 | 2022-03-31 23:48:49 | bandmaster | 1 | 67641 | 2 | 1.186 | 57032.9 |
236 | 2022-02-02 21:08:03 | bandmaster | 1 | 67641 | 2 | 1.156 | 58513.0 |
235 | 2021-12-01 02:10:33 | bandmaster | 1 | 67641 | 2 | 1.190 | 56841.2 |
234 | 2021-11-28 21:54:14 | bandmaster | 1 | 67641 | 2 | 1.046 | 64666.3 |
233 | 2021-10-08 10:19:49 | bandmaster | 1 | 67641 | 2 | 1.000 | 67641.0 |
232 | 2021-09-06 08:32:51 | bandmaster | 1 | 67641 | 2 | 1.033 | 65480.2 |
231 | 2021-08-17 14:03:24 | bandmaster | 1 | 67641 | 2 | 1.106 | 61158.2 |
230 | 2021-08-11 09:18:26 | bandmaster | 1 | 67641 | 2 | 1.016 | 66575.8 |
229 | 2021-07-19 04:55:48 | bandmaster | 3 | 140603 | 21 | 5.266 | 26700.2 |
228 | 2021-05-08 11:15:23 | bandmaster | 3 | 140603 | 21 | 5.516 | 25490.0 |
227 | 2021-04-26 13:44:22 | bandmaster | 1 | 67641 | 2 | 1.050 | 64420.0 |
226 | 2021-04-14 10:38:09 | bandmaster | 1 | 67641 | 2 | 1.233 | 54858.9 |
225 | 2021-04-06 22:26:53 | bandmaster | 3 | 140603 | 21 | 5.440 | 25846.1 |
224 | 2021-02-14 20:14:19 | bandmaster | 3 | 140603 | 21 | 6.920 | 20318.4 |
223 | 2021-01-27 23:09:26 | bandmaster | 1 | 67641 | 2 | 1.250 | 54112.8 |
222 | 2021-01-22 03:11:34 | bandmaster | 3 | 140603 | 21 | 6.236 | 22547.0 |
221 | 2021-01-14 07:24:38 | bandmaster | 1 | 67641 | 2 | 1.030 | 65670.9 |
220 | 2020-11-02 12:52:48 | bandmaster | 4 | 161450 | 141 | 11.796 | 13686.8 |
219 | 2020-10-15 23:36:58 | bandmaster | 1 | 67641 | 2 | 1.093 | 61885.6 |
218 | 2020-10-15 09:42:48 | bandmaster | 1 | 67641 | 2 | 2.030 | 33320.7 |
217 | 2020-10-07 10:28:21 | bandmaster | 3 | 140603 | 21 | 7.156 | 19648.3 |
216 | 2020-10-04 07:51:56 | bandmaster | 1 | 67641 | 2 | 1.033 | 65480.2 |
215 | 2020-08-24 19:22:39 | bandmaster | 1 | 67641 | 2 | 1.013 | 66773.0 |
214 | 2020-08-05 07:05:48 | bandmaster | 3 | 140603 | 21 | 6.140 | 22899.5 |
213 | 2020-06-11 00:13:13 | bandmaster | 1 | 67641 | 2 | 1.063 | 63632.2 |
212 | 2020-03-25 02:58:14 | bandmaster | 1 | 67641 | 2 | 1.173 | 57665.0 |
211 | 2020-02-26 18:01:16 | bandmaster | 1 | 67641 | 2 | 1.173 | 57665.0 |
210 | 2020-02-25 18:33:17 | bandmaster | 4 | 161450 | 141 | 12.563 | 12851.2 |
209 | 2020-02-25 02:46:04 | bandmaster | 4 | 161450 | 141 | 15.766 | 10240.4 |
208 | 2020-02-23 13:34:18 | bandmaster | 4 | 161450 | 141 | 17.126 | 9427.2 |
207 | 2020-02-21 11:23:59 | bandmaster | 4 | 161450 | 141 | 13.906 | 11610.1 |
206 | 2020-02-21 01:16:50 | bandmaster | 4 | 161450 | 141 | 12.283 | 13144.2 |
205 | 2020-02-20 16:19:14 | bandmaster | 4 | 161450 | 141 | 11.453 | 14096.7 |
204 | 2020-02-15 05:23:46 | bandmaster | 1 | 67641 | 2 | 2.593 | 26086.0 |
203 | 2020-02-10 15:08:42 | bandmaster | 1 | 67641 | 2 | 1.250 | 54112.8 |
202 | 2020-02-09 19:51:07 | bandmaster | 1 | 67641 | 2 | 2.486 | 27208.8 |
201 | 2020-02-08 09:50:54 | bandmaster | 1 | 67641 | 2 | 1.283 | 52721.0 |
200 | 2020-02-05 02:54:27 | bandmaster | 1 | 67641 | 2 | 1.236 | 54725.7 |
199 | 2020-01-31 14:15:26 | bandmaster | 4 | 161450 | 141 | 14.720 | 10968.1 |
198 | 2020-01-22 07:40:16 | bandmaster | 1 | 67641 | 2 | 3.906 | 17317.2 |
197 | 2020-01-14 16:27:51 | bandmaster | 4 | 161450 | 141 | 14.076 | 11469.9 |
196 | 2020-01-14 10:18:14 | bandmaster | 2 | 108824 | 5 | 6.703 | 16235.1 |
195 | 2020-01-14 10:18:09 | bandmaster | 3 | 140603 | 21 | 10.360 | 13571.7 |
194 | 2020-01-14 10:17:29 | bandmaster | 4 | 161450 | 141 | 22.346 | 7225.0 |