History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spaniel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
326 | 2025-05-27 18:46:55 | spaniel | 2 | 107671 | 25 | 3.640 | 29579.9 |
325 | 2025-05-25 12:52:12 | spaniel | 1 | 69583 | 3 | 1.263 | 55093.4 |
324 | 2025-05-19 23:23:42 | spaniel | 1 | 69583 | 3 | 8.736 | 7965.1 |
323 | 2025-05-13 23:58:10 | spaniel | 1 | 69583 | 3 | 8.876 | 7839.5 |
322 | 2025-05-03 16:46:08 | spaniel | 1 | 69583 | 3 | 1.280 | 54361.7 |
321 | 2025-05-01 20:43:00 | spaniel | 1 | 69583 | 3 | 6.593 | 10554.1 |
320 | 2025-04-29 10:29:18 | spaniel | 1 | 69583 | 3 | 2.686 | 25905.8 |
319 | 2025-04-23 07:01:25 | spaniel | 1 | 69583 | 3 | 3.736 | 18625.0 |
318 | 2025-04-19 22:13:52 | spaniel | 1 | 69583 | 3 | 6.156 | 11303.3 |
317 | 2025-04-14 20:42:03 | spaniel | 1 | 69583 | 3 | 2.500 | 27833.2 |
316 | 2025-04-14 00:26:50 | spaniel | 1 | 69583 | 3 | 3.296 | 21111.3 |
315 | 2025-04-04 12:31:08 | spaniel | 2 | 107671 | 25 | 17.003 | 6332.5 |
314 | 2025-04-02 23:53:47 | spaniel | 1 | 69583 | 3 | 3.610 | 19275.1 |
313 | 2025-03-30 23:32:56 | spaniel | 1 | 69583 | 3 | 3.093 | 22496.9 |
312 | 2025-03-28 21:58:01 | spaniel | 1 | 69583 | 3 | 4.173 | 16674.6 |
311 | 2025-03-23 07:08:13 | spaniel | 3 | 134027 | 335 | 18.126 | 7394.2 |
310 | 2025-03-19 22:53:01 | spaniel | 1 | 69583 | 3 | 4.063 | 17126.0 |
309 | 2025-03-15 18:06:39 | spaniel | 1 | 69583 | 3 | 2.640 | 26357.2 |
308 | 2025-03-13 14:00:50 | spaniel | 3 | 134027 | 335 | 26.173 | 5120.8 |
307 | 2025-03-13 12:24:49 | spaniel | 3 | 134027 | 335 | 27.940 | 4797.0 |
306 | 2025-03-13 12:25:02 | spaniel | 2 | 107671 | 25 | 14.596 | 7376.7 |
305 | 2025-03-13 12:24:40 | spaniel | 1 | 69583 | 3 | 2.983 | 23326.5 |
304 | 2025-03-12 20:31:37 | spaniel | 1 | 69583 | 3 | 8.450 | 8234.7 |
303 | 2025-03-03 04:28:36 | spaniel | 1 | 69583 | 3 | 4.423 | 15732.1 |
302 | 2025-02-25 06:06:14 | spaniel | 1 | 69583 | 3 | 3.030 | 22964.7 |
301 | 2025-02-13 23:39:17 | spaniel | 1 | 69583 | 3 | 6.656 | 10454.2 |
300 | 2025-01-24 19:44:50 | spaniel | 1 | 69583 | 3 | 1.313 | 52995.4 |
299 | 2025-01-17 05:03:07 | spaniel | 1 | 69583 | 3 | 6.220 | 11187.0 |
298 | 2025-01-15 09:58:05 | spaniel | 1 | 69583 | 3 | 3.266 | 21305.3 |
297 | 2025-01-12 04:02:16 | spaniel | 1 | 69583 | 3 | 3.763 | 18491.4 |
296 | 2024-12-24 17:11:31 | spaniel | 1 | 69583 | 3 | 2.626 | 26497.7 |
295 | 2024-12-17 23:16:03 | spaniel | 1 | 69583 | 3 | 4.876 | 14270.5 |
294 | 2024-12-16 00:25:21 | spaniel | 1 | 69583 | 3 | 5.860 | 11874.2 |
293 | 2024-12-09 23:19:16 | spaniel | 1 | 69583 | 3 | 5.970 | 11655.4 |
292 | 2024-11-28 08:48:36 | spaniel | 2 | 107671 | 25 | 13.923 | 7733.3 |
291 | 2024-11-28 08:48:30 | spaniel | 3 | 134027 | 335 | 10.593 | 12652.4 |
290 | 2024-11-22 09:47:35 | spaniel | 2 | 107671 | 25 | 15.516 | 6939.4 |
289 | 2024-11-21 01:25:44 | spaniel | 2 | 107671 | 25 | 4.826 | 22310.6 |
288 | 2024-11-20 04:23:30 | spaniel | 3 | 134027 | 335 | 35.253 | 3801.9 |
287 | 2024-11-19 16:09:15 | spaniel | 3 | 134027 | 335 | 33.820 | 3963.0 |
286 | 2024-11-18 15:08:11 | spaniel | 3 | 134027 | 335 | 41.003 | 3268.7 |
285 | 2024-11-18 15:08:00 | spaniel | 2 | 107671 | 25 | 25.143 | 4282.3 |
284 | 2024-11-17 15:27:16 | spaniel | 1 | 69583 | 3 | 6.000 | 11597.2 |
283 | 2024-11-14 15:42:39 | spaniel | 1 | 69583 | 3 | 3.656 | 19032.5 |
282 | 2024-11-11 22:57:06 | spaniel | 1 | 69583 | 3 | 6.450 | 10788.1 |
281 | 2024-11-07 17:23:41 | spaniel | 1 | 69583 | 3 | 3.716 | 18725.2 |
280 | 2024-10-22 22:44:25 | spaniel | 1 | 69583 | 3 | 5.236 | 13289.3 |
279 | 2024-10-16 06:57:21 | spaniel | 1 | 69583 | 3 | 4.970 | 14000.6 |
278 | 2024-10-15 00:34:29 | spaniel | 3 | 134027 | 335 | 29.876 | 4486.1 |
277 | 2024-10-14 19:17:09 | spaniel | 2 | 107671 | 25 | 17.376 | 6196.5 |
276 | 2024-10-14 18:22:57 | spaniel | 3 | 134027 | 335 | 46.910 | 2857.1 |
275 | 2024-10-13 23:42:44 | spaniel | 3 | 134027 | 335 | 32.053 | 4181.4 |
274 | 2024-10-13 22:45:29 | spaniel | 1 | 69583 | 3 | 3.016 | 23071.3 |
273 | 2024-10-13 11:45:48 | spaniel | 3 | 134027 | 335 | 40.343 | 3322.2 |
272 | 2024-10-13 11:45:45 | spaniel | 2 | 107671 | 25 | 10.706 | 10057.1 |
271 | 2024-10-07 20:08:50 | spaniel | 1 | 69583 | 3 | 9.030 | 7705.8 |
270 | 2024-09-11 08:09:17 | spaniel | 1 | 69583 | 3 | 8.563 | 8126.0 |
269 | 2024-08-29 16:03:23 | spaniel | 3 | 134027 | 335 | 49.363 | 2715.1 |
268 | 2024-08-28 19:36:53 | spaniel | 3 | 134027 | 335 | 65.396 | 2049.5 |
267 | 2024-08-28 18:17:07 | spaniel | 3 | 134027 | 335 | 70.613 | 1898.0 |
266 | 2024-08-28 16:17:54 | spaniel | 3 | 134027 | 335 | 52.456 | 2555.0 |
265 | 2024-08-28 16:17:51 | spaniel | 2 | 107671 | 25 | 27.690 | 3888.4 |
264 | 2024-08-28 16:05:52 | spaniel | 1 | 69583 | 3 | 8.046 | 8648.1 |
263 | 2024-08-28 10:21:58 | spaniel | 1 | 69583 | 3 | 12.453 | 5587.6 |
262 | 2024-08-22 15:26:28 | spaniel | 1 | 69583 | 3 | 8.576 | 8113.7 |
261 | 2024-08-20 09:01:58 | spaniel | 1 | 69583 | 3 | 8.640 | 8053.6 |
260 | 2024-08-14 09:36:36 | spaniel | 1 | 69583 | 3 | 9.173 | 7585.6 |
259 | 2024-08-11 04:06:20 | spaniel | 1 | 69583 | 3 | 3.233 | 21522.7 |
258 | 2024-07-27 12:31:49 | spaniel | 1 | 69583 | 3 | 4.876 | 14270.5 |
257 | 2024-07-24 03:02:53 | spaniel | 1 | 69583 | 3 | 4.373 | 15912.0 |
256 | 2024-07-21 05:50:19 | spaniel | 1 | 69583 | 3 | 2.920 | 23829.8 |
255 | 2024-07-20 15:55:49 | spaniel | 1 | 69583 | 3 | 4.266 | 16311.1 |
254 | 2024-07-06 15:16:17 | spaniel | 1 | 69583 | 3 | 2.953 | 23563.5 |
253 | 2024-06-22 23:53:16 | spaniel | 1 | 69583 | 3 | 4.296 | 16197.2 |
252 | 2024-06-21 19:52:25 | spaniel | 1 | 69583 | 3 | 6.563 | 10602.3 |
251 | 2024-06-10 21:45:19 | spaniel | 1 | 69583 | 3 | 6.266 | 11104.9 |
250 | 2024-05-16 05:04:29 | spaniel | 3 | 134027 | 335 | 19.313 | 6939.7 |
249 | 2024-05-16 02:03:53 | spaniel | 3 | 134027 | 335 | 13.796 | 9714.9 |
248 | 2024-05-15 18:08:14 | spaniel | 3 | 134027 | 335 | 17.686 | 7578.1 |
247 | 2024-05-01 18:24:35 | spaniel | 1 | 69583 | 3 | 1.296 | 53690.6 |
246 | 2024-04-27 09:53:27 | spaniel | 1 | 69583 | 3 | 2.326 | 29915.3 |
245 | 2024-03-30 04:59:01 | spaniel | 1 | 69583 | 3 | 3.983 | 17470.0 |
244 | 2024-03-28 17:06:32 | spaniel | 1 | 69583 | 3 | 1.233 | 56433.9 |
243 | 2024-03-25 13:11:58 | spaniel | 1 | 69583 | 3 | 1.123 | 61961.7 |
242 | 2024-03-12 02:37:17 | spaniel | 1 | 69583 | 3 | 1.156 | 60192.9 |
241 | 2024-03-01 21:00:42 | spaniel | 3 | 134027 | 335 | 13.110 | 10223.3 |
240 | 2024-02-28 15:10:58 | spaniel | 3 | 134027 | 335 | 18.983 | 7060.4 |
239 | 2024-02-27 00:06:07 | spaniel | 2 | 107671 | 25 | 2.890 | 37256.4 |
238 | 2024-02-26 15:36:32 | spaniel | 3 | 134027 | 335 | 13.466 | 9953.0 |
237 | 2024-02-22 20:40:48 | spaniel | 2 | 107671 | 25 | 3.093 | 34811.2 |
236 | 2024-02-22 08:51:56 | spaniel | 3 | 134027 | 335 | 12.110 | 11067.5 |
235 | 2024-02-21 18:42:41 | spaniel | 3 | 134027 | 335 | 10.703 | 12522.4 |
234 | 2024-02-21 18:42:39 | spaniel | 2 | 107671 | 25 | 8.253 | 13046.3 |
233 | 2024-02-21 09:19:00 | spaniel | 1 | 69583 | 3 | 4.110 | 16930.2 |
232 | 2023-12-15 19:50:10 | spaniel | 1 | 69583 | 3 | 1.250 | 55666.4 |
231 | 2023-12-15 16:28:00 | spaniel | 1 | 69583 | 3 | 3.623 | 19205.9 |
230 | 2023-12-13 04:09:46 | spaniel | 1 | 69583 | 3 | 1.296 | 53690.6 |
229 | 2023-11-22 07:12:10 | spaniel | 1 | 69583 | 3 | 1.093 | 63662.4 |
228 | 2023-11-10 02:26:19 | spaniel | 1 | 69583 | 3 | 1.203 | 57841.2 |
227 | 2023-10-08 23:49:37 | spaniel | 3 | 134027 | 335 | 7.296 | 18369.9 |