History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"optimal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
335 | 2025-04-16 15:46:28 | optimal | 1 | 69583 | 3 | 5.016 | 13872.2 |
334 | 2025-04-14 14:08:28 | optimal | 1 | 69583 | 3 | 5.873 | 11847.9 |
333 | 2025-04-08 01:43:25 | optimal | 1 | 69583 | 3 | 5.656 | 12302.5 |
332 | 2025-03-29 16:58:16 | optimal | 1 | 69583 | 3 | 6.643 | 10474.6 |
331 | 2025-03-20 18:30:46 | optimal | 1 | 69583 | 3 | 2.860 | 24329.7 |
330 | 2025-03-15 01:12:24 | optimal | 1 | 69583 | 3 | 2.716 | 25619.7 |
329 | 2025-03-07 13:54:39 | optimal | 1 | 69583 | 3 | 4.063 | 17126.0 |
328 | 2025-03-06 09:32:59 | optimal | 1 | 69583 | 3 | 3.923 | 17737.2 |
327 | 2025-02-04 04:38:10 | optimal | 1 | 69583 | 3 | 3.203 | 21724.3 |
326 | 2025-02-04 03:52:59 | optimal | 1 | 69583 | 3 | 3.110 | 22374.0 |
325 | 2025-01-25 19:47:04 | optimal | 1 | 69583 | 3 | 5.673 | 12265.6 |
324 | 2025-01-19 10:06:10 | optimal | 1 | 69583 | 3 | 5.110 | 13617.0 |
323 | 2025-01-04 02:41:58 | optimal | 1 | 69583 | 3 | 3.483 | 19977.9 |
322 | 2024-12-16 14:08:33 | optimal | 1 | 69583 | 3 | 7.126 | 9764.7 |
321 | 2024-11-29 10:10:20 | optimal | 1 | 69583 | 3 | 6.030 | 11539.5 |
320 | 2024-11-17 00:50:18 | optimal | 1 | 69583 | 3 | 2.923 | 23805.3 |
319 | 2024-10-27 02:09:45 | optimal | 1 | 69583 | 3 | 5.623 | 12374.7 |
318 | 2024-10-08 02:38:17 | optimal | 1 | 69583 | 3 | 10.046 | 6926.4 |
317 | 2024-09-11 00:59:51 | optimal | 1 | 69583 | 3 | 8.923 | 7798.2 |
316 | 2024-09-08 14:35:09 | optimal | 1 | 69583 | 3 | 4.950 | 14057.2 |
315 | 2024-09-02 21:18:06 | optimal | 1 | 69583 | 3 | 12.266 | 5672.8 |
314 | 2024-08-10 09:42:27 | optimal | 1 | 69583 | 3 | 1.280 | 54361.7 |
313 | 2024-08-04 02:49:45 | optimal | 1 | 69583 | 3 | 5.860 | 11874.2 |
312 | 2024-07-30 22:58:31 | optimal | 1 | 69583 | 3 | 1.170 | 59472.6 |
311 | 2024-07-19 16:26:31 | optimal | 1 | 69583 | 3 | 8.313 | 8370.4 |
310 | 2024-07-16 18:55:55 | optimal | 1 | 69583 | 3 | 1.250 | 55666.4 |
309 | 2024-07-12 19:57:07 | optimal | 3 | 134027 | 101 | 22.516 | 5952.5 |
308 | 2024-07-12 02:43:57 | optimal | 3 | 134027 | 101 | 34.660 | 3866.9 |
307 | 2024-07-11 20:42:43 | optimal | 3 | 134027 | 101 | 31.940 | 4196.2 |
306 | 2024-07-11 05:31:17 | optimal | 3 | 134027 | 101 | 21.863 | 6130.3 |
305 | 2024-07-11 05:08:43 | optimal | 3 | 134027 | 101 | 18.376 | 7293.6 |
304 | 2024-07-11 05:08:18 | optimal | 3 | 134027 | 101 | 28.843 | 4646.8 |
303 | 2024-07-07 02:11:13 | optimal | 1 | 69583 | 3 | 2.343 | 29698.3 |
302 | 2024-07-07 01:50:10 | optimal | 1 | 69583 | 3 | 6.313 | 11022.2 |
301 | 2024-07-03 04:08:07 | optimal | 1 | 69583 | 3 | 2.280 | 30518.9 |
300 | 2024-06-29 16:44:11 | optimal | 1 | 69583 | 3 | 6.766 | 10284.2 |
299 | 2024-06-22 23:53:57 | optimal | 1 | 69583 | 3 | 3.406 | 20429.5 |
298 | 2024-06-19 01:55:13 | optimal | 1 | 69583 | 3 | 4.373 | 15912.0 |
297 | 2024-06-18 02:08:54 | optimal | 1 | 69583 | 3 | 5.350 | 13006.2 |
296 | 2024-06-13 05:04:14 | optimal | 1 | 69583 | 3 | 3.750 | 18555.5 |
295 | 2024-06-11 02:15:23 | optimal | 3 | 134027 | 101 | 37.300 | 3593.2 |
294 | 2024-06-07 06:40:26 | optimal | 3 | 134027 | 101 | 11.233 | 11931.5 |
293 | 2024-06-07 06:40:22 | optimal | 2 | 107671 | 10 | 6.873 | 15665.8 |
292 | 2024-06-07 02:27:59 | optimal | 3 | 134027 | 101 | 34.143 | 3925.5 |
291 | 2024-06-07 02:27:23 | optimal | 2 | 107671 | 10 | 19.063 | 5648.2 |
290 | 2024-06-07 02:13:49 | optimal | 1 | 69583 | 3 | 1.906 | 36507.3 |
289 | 2024-06-06 02:33:45 | optimal | 1 | 69583 | 3 | 6.593 | 10554.1 |
288 | 2024-05-05 00:30:25 | optimal | 3 | 134027 | 101 | 23.500 | 5703.3 |
287 | 2024-05-04 16:53:59 | optimal | 3 | 134027 | 101 | 14.876 | 9009.6 |
286 | 2024-05-04 12:17:04 | optimal | 2 | 107671 | 10 | 3.560 | 30244.7 |
285 | 2024-05-04 12:16:31 | optimal | 3 | 134027 | 101 | 7.186 | 18651.1 |
284 | 2024-05-03 20:09:56 | optimal | 2 | 107671 | 10 | 3.186 | 33795.0 |
283 | 2024-05-03 16:07:00 | optimal | 3 | 134027 | 101 | 7.810 | 17160.9 |
282 | 2024-05-02 19:46:00 | optimal | 3 | 134027 | 101 | 17.686 | 7578.1 |
281 | 2024-05-02 19:46:04 | optimal | 2 | 107671 | 10 | 3.856 | 27923.0 |
280 | 2024-05-02 18:55:20 | optimal | 1 | 69583 | 3 | 1.233 | 56433.9 |
279 | 2024-05-02 16:17:55 | optimal | 1 | 69583 | 3 | 1.310 | 53116.8 |
278 | 2024-05-02 16:17:11 | optimal | 3 | 134027 | 101 | 19.970 | 6711.4 |
277 | 2024-05-02 16:17:07 | optimal | 2 | 107671 | 10 | 4.953 | 21738.5 |
276 | 2024-03-30 14:53:47 | optimal | 1 | 69583 | 3 | 3.563 | 19529.3 |
275 | 2024-03-29 14:04:06 | optimal | 1 | 69583 | 3 | 1.373 | 50679.5 |
274 | 2024-03-13 11:28:07 | optimal | 1 | 69583 | 3 | 4.080 | 17054.7 |
273 | 2024-03-13 11:27:18 | optimal | 1 | 69583 | 3 | 4.076 | 17071.4 |
272 | 2024-03-06 06:00:28 | optimal | 1 | 69583 | 3 | 2.720 | 25582.0 |
271 | 2024-02-28 02:45:41 | optimal | 1 | 69583 | 3 | 1.330 | 52318.0 |
270 | 2024-02-10 18:06:52 | optimal | 3 | 134027 | 101 | 6.390 | 20974.5 |
269 | 2024-02-05 10:06:14 | optimal | 3 | 134027 | 101 | 9.846 | 13612.3 |
268 | 2024-02-03 03:39:10 | optimal | 1 | 69583 | 3 | 1.250 | 55666.4 |
267 | 2024-02-03 03:32:06 | optimal | 2 | 107671 | 10 | 2.843 | 37872.3 |
266 | 2024-02-02 17:02:47 | optimal | 2 | 107671 | 10 | 3.000 | 35890.3 |
265 | 2024-02-02 16:57:19 | optimal | 3 | 134027 | 101 | 7.016 | 19103.1 |
264 | 2024-02-02 04:31:12 | optimal | 2 | 107671 | 10 | 2.720 | 39584.9 |
263 | 2024-02-02 04:30:40 | optimal | 3 | 134027 | 101 | 6.766 | 19808.9 |
262 | 2024-01-07 22:17:09 | optimal | 3 | 134027 | 101 | 5.890 | 22755.0 |
261 | 2024-01-02 12:09:52 | optimal | 1 | 69583 | 3 | 1.216 | 57222.9 |
260 | 2024-01-02 10:46:56 | optimal | 3 | 134027 | 101 | 5.893 | 22743.4 |
259 | 2023-12-17 09:41:26 | optimal | 1 | 69583 | 3 | 1.093 | 63662.4 |
258 | 2023-11-20 17:56:35 | optimal | 1 | 69583 | 3 | 1.280 | 54361.7 |
257 | 2023-11-18 21:05:17 | optimal | 1 | 69583 | 3 | 1.060 | 65644.3 |
256 | 2023-11-14 10:05:07 | optimal | 3 | 134027 | 101 | 5.953 | 22514.2 |
255 | 2023-10-07 06:57:18 | optimal | 1 | 69583 | 3 | 1.190 | 58473.1 |
254 | 2023-10-04 02:26:01 | optimal | 1 | 69583 | 3 | 1.826 | 38106.8 |
253 | 2023-10-04 02:25:51 | optimal | 1 | 69583 | 3 | 1.436 | 48456.1 |
252 | 2023-09-26 09:45:38 | optimal | 1 | 69583 | 3 | 1.423 | 48898.8 |
251 | 2023-09-24 12:15:14 | optimal | 1 | 69583 | 3 | 1.156 | 60192.9 |
250 | 2023-08-16 17:14:59 | optimal | 3 | 134027 | 101 | 6.326 | 21186.7 |
249 | 2023-07-31 09:27:53 | optimal | 1 | 69583 | 3 | 1.063 | 65459.1 |
248 | 2023-06-07 05:47:34 | optimal | 1 | 69583 | 3 | 1.186 | 58670.3 |
247 | 2023-04-29 06:29:37 | optimal | 3 | 134027 | 101 | 5.610 | 23890.7 |
246 | 2023-04-26 22:32:24 | optimal | 1 | 69583 | 3 | 1.063 | 65459.1 |
245 | 2023-04-02 22:55:07 | optimal | 1 | 69583 | 3 | 1.203 | 57841.2 |
244 | 2023-02-16 14:24:46 | optimal | 1 | 69583 | 3 | 1.203 | 57841.2 |
243 | 2023-02-12 05:03:53 | optimal | 1 | 69583 | 3 | 1.030 | 67556.3 |
242 | 2023-02-08 16:33:46 | optimal | 1 | 69583 | 3 | 1.046 | 66522.9 |
241 | 2023-02-03 05:51:59 | optimal | 3 | 134027 | 101 | 5.466 | 24520.1 |
240 | 2022-12-14 04:01:09 | optimal | 1 | 69583 | 3 | 2.376 | 29285.8 |
239 | 2022-11-21 08:44:39 | optimal | 1 | 69583 | 3 | 1.093 | 63662.4 |
238 | 2022-11-18 13:50:42 | optimal | 1 | 69583 | 3 | 1.063 | 65459.1 |
237 | 2022-11-14 21:21:42 | optimal | 3 | 134027 | 101 | 12.550 | 10679.4 |
236 | 2022-10-11 05:52:34 | optimal | 1 | 69583 | 3 | 1.033 | 67360.1 |