History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smartie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
334 | 2025-08-27 08:39:50 | smartie | 1 | 69583 | 2 | 1.233 | 56433.9 |
333 | 2025-08-19 09:44:12 | smartie | 1 | 69583 | 2 | 2.826 | 24622.4 |
332 | 2025-08-17 14:34:32 | smartie | 1 | 69583 | 2 | 6.110 | 11388.4 |
331 | 2025-08-13 20:15:50 | smartie | 1 | 69583 | 2 | 1.296 | 53690.6 |
330 | 2025-08-04 21:02:43 | smartie | 1 | 69583 | 2 | 4.986 | 13955.7 |
329 | 2025-08-01 08:47:12 | smartie | 1 | 69583 | 2 | 5.046 | 13789.7 |
328 | 2025-08-01 05:41:27 | smartie | 1 | 69583 | 2 | 8.686 | 8010.9 |
327 | 2025-07-26 12:44:57 | smartie | 1 | 69583 | 2 | 2.780 | 25029.9 |
326 | 2025-07-25 09:00:43 | smartie | 1 | 69583 | 2 | 3.203 | 21724.3 |
325 | 2025-07-24 11:27:13 | smartie | 1 | 69583 | 2 | 4.720 | 14742.2 |
324 | 2025-07-15 19:31:54 | smartie | 1 | 69583 | 2 | 2.000 | 34791.5 |
323 | 2025-07-14 18:08:10 | smartie | 3 | 134027 | 265 | 39.033 | 3433.7 |
322 | 2025-07-13 14:11:11 | smartie | 1 | 69583 | 2 | 1.250 | 55666.4 |
321 | 2025-07-13 08:46:28 | smartie | 3 | 134027 | 265 | 7.046 | 19021.7 |
320 | 2025-07-11 06:13:26 | smartie | 2 | 107671 | 20 | 12.470 | 8634.4 |
319 | 2025-07-11 05:51:45 | smartie | 3 | 134027 | 265 | 45.410 | 2951.5 |
318 | 2025-07-10 21:59:01 | smartie | 1 | 69583 | 2 | 8.593 | 8097.6 |
317 | 2025-07-08 18:21:15 | smartie | 1 | 69583 | 2 | 1.266 | 54962.9 |
316 | 2025-07-02 00:49:08 | smartie | 1 | 69583 | 2 | 5.296 | 13138.8 |
315 | 2025-07-01 20:28:20 | smartie | 1 | 69583 | 2 | 6.860 | 10143.3 |
314 | 2025-06-29 21:51:26 | smartie | 1 | 69583 | 2 | 3.106 | 22402.8 |
313 | 2025-06-26 05:14:54 | smartie | 1 | 69583 | 2 | 7.436 | 9357.6 |
312 | 2025-06-22 02:09:53 | smartie | 1 | 69583 | 2 | 3.156 | 22047.8 |
311 | 2025-06-20 03:19:25 | smartie | 2 | 107671 | 20 | 12.346 | 8721.1 |
310 | 2025-06-11 12:45:58 | smartie | 1 | 69583 | 2 | 1.110 | 62687.4 |
309 | 2025-06-08 18:04:26 | smartie | 1 | 69583 | 2 | 5.533 | 12576.0 |
308 | 2025-06-08 16:07:16 | smartie | 3 | 134027 | 265 | 45.486 | 2946.6 |
307 | 2025-06-08 14:26:16 | smartie | 1 | 69583 | 2 | 5.533 | 12576.0 |
306 | 2025-06-08 08:53:58 | smartie | 1 | 69583 | 2 | 7.016 | 9917.8 |
305 | 2025-06-08 02:15:35 | smartie | 3 | 134027 | 265 | 35.690 | 3755.3 |
304 | 2025-06-07 10:56:34 | smartie | 3 | 134027 | 265 | 6.970 | 19229.1 |
303 | 2025-06-05 15:31:28 | smartie | 3 | 134027 | 265 | 7.250 | 18486.5 |
302 | 2025-05-31 20:30:07 | smartie | 1 | 69583 | 2 | 4.623 | 15051.5 |
301 | 2025-05-27 14:56:34 | smartie | 1 | 69583 | 2 | 3.016 | 23071.3 |
300 | 2025-05-26 05:05:58 | smartie | 1 | 69583 | 2 | 7.253 | 9593.7 |
299 | 2025-05-25 17:29:43 | smartie | 1 | 69583 | 2 | 1.266 | 54962.9 |
298 | 2025-05-22 08:44:04 | smartie | 1 | 69583 | 2 | 3.843 | 18106.4 |
297 | 2025-05-18 18:57:57 | smartie | 1 | 69583 | 2 | 1.313 | 52995.4 |
296 | 2025-05-08 18:02:47 | smartie | 1 | 69583 | 2 | 2.766 | 25156.5 |
295 | 2025-04-28 03:35:41 | smartie | 3 | 134027 | 265 | 52.833 | 2536.8 |
294 | 2025-04-23 15:10:38 | smartie | 3 | 134027 | 265 | 20.126 | 6659.4 |
293 | 2025-04-21 18:36:20 | smartie | 2 | 107671 | 20 | 14.516 | 7417.4 |
292 | 2025-04-21 10:55:48 | smartie | 3 | 134027 | 265 | 36.233 | 3699.0 |
291 | 2025-04-20 20:49:07 | smartie | 1 | 69583 | 2 | 5.216 | 13340.3 |
290 | 2025-04-20 08:12:00 | smartie | 1 | 69583 | 2 | 6.846 | 10164.0 |
289 | 2025-04-20 08:02:47 | smartie | 1 | 69583 | 2 | 2.750 | 25302.9 |
288 | 2025-04-20 04:42:51 | smartie | 1 | 69583 | 2 | 4.923 | 14134.3 |
287 | 2025-04-07 05:51:14 | smartie | 1 | 69583 | 2 | 5.766 | 12067.8 |
286 | 2025-04-03 19:11:06 | smartie | 1 | 69583 | 2 | 1.173 | 59320.5 |
285 | 2025-03-23 17:25:44 | smartie | 1 | 69583 | 2 | 3.686 | 18877.6 |
284 | 2025-03-20 10:50:36 | smartie | 1 | 69583 | 2 | 4.203 | 16555.6 |
283 | 2025-03-20 06:50:40 | smartie | 1 | 69583 | 2 | 4.280 | 16257.7 |
282 | 2025-03-19 21:41:27 | smartie | 1 | 69583 | 2 | 4.326 | 16084.8 |
281 | 2025-03-14 06:43:49 | smartie | 1 | 69583 | 2 | 4.966 | 14011.9 |
280 | 2025-03-12 13:32:53 | smartie | 1 | 69583 | 2 | 1.186 | 58670.3 |
279 | 2025-02-18 23:27:12 | smartie | 1 | 69583 | 2 | 2.953 | 23563.5 |
278 | 2025-02-05 07:09:06 | smartie | 1 | 69583 | 2 | 6.203 | 11217.6 |
277 | 2025-02-04 13:38:38 | smartie | 1 | 69583 | 2 | 6.576 | 10581.4 |
276 | 2025-01-25 15:46:53 | smartie | 1 | 69583 | 2 | 3.440 | 20227.6 |
275 | 2024-12-26 14:14:13 | smartie | 3 | 134027 | 265 | 16.923 | 7919.8 |
274 | 2024-12-26 11:14:15 | smartie | 3 | 134027 | 265 | 42.220 | 3174.5 |
273 | 2024-12-26 09:14:39 | smartie | 3 | 134027 | 265 | 41.283 | 3246.5 |
272 | 2024-12-26 01:08:11 | smartie | 3 | 134027 | 265 | 34.660 | 3866.9 |
271 | 2024-12-26 01:08:12 | smartie | 2 | 107671 | 20 | 17.796 | 6050.3 |
270 | 2024-12-26 01:07:59 | smartie | 1 | 69583 | 2 | 5.940 | 11714.3 |
269 | 2024-11-10 22:12:51 | smartie | 2 | 107671 | 20 | 24.110 | 4465.8 |
268 | 2024-11-10 10:56:19 | smartie | 3 | 134027 | 265 | 33.846 | 3959.9 |
267 | 2024-11-10 01:47:41 | smartie | 3 | 134027 | 265 | 24.313 | 5512.6 |
266 | 2024-11-09 18:38:54 | smartie | 3 | 134027 | 265 | 43.173 | 3104.4 |
265 | 2024-11-09 18:38:54 | smartie | 2 | 107671 | 20 | 17.860 | 6028.6 |
264 | 2024-11-09 11:13:26 | smartie | 1 | 69583 | 2 | 1.156 | 60192.9 |
263 | 2024-10-09 17:06:47 | smartie | 1 | 69583 | 2 | 3.593 | 19366.3 |
262 | 2024-10-07 12:59:37 | smartie | 1 | 69583 | 2 | 6.236 | 11158.3 |
261 | 2024-09-14 03:05:30 | smartie | 1 | 69583 | 2 | 9.280 | 7498.2 |
260 | 2024-09-08 19:51:30 | smartie | 1 | 69583 | 2 | 2.783 | 25002.9 |
259 | 2024-09-06 04:07:10 | smartie | 1 | 69583 | 2 | 5.816 | 11964.1 |
258 | 2024-08-29 10:23:25 | smartie | 1 | 69583 | 2 | 4.906 | 14183.2 |
257 | 2024-08-24 18:36:16 | smartie | 1 | 69583 | 2 | 4.686 | 14849.1 |
256 | 2024-08-14 20:10:32 | smartie | 1 | 69583 | 2 | 7.953 | 8749.3 |
255 | 2024-08-11 13:23:56 | smartie | 1 | 69583 | 2 | 4.440 | 15671.8 |
254 | 2024-07-31 08:22:37 | smartie | 1 | 69583 | 2 | 4.576 | 15206.1 |
253 | 2024-07-23 08:26:15 | smartie | 1 | 69583 | 2 | 5.173 | 13451.2 |
252 | 2024-07-16 19:09:52 | smartie | 1 | 69583 | 2 | 4.216 | 16504.5 |
251 | 2024-07-13 18:06:09 | smartie | 1 | 69583 | 2 | 4.343 | 16021.9 |
250 | 2024-07-11 09:14:57 | smartie | 1 | 69583 | 2 | 5.733 | 12137.3 |
249 | 2024-06-20 14:35:23 | smartie | 1 | 69583 | 2 | 2.936 | 23699.9 |
248 | 2024-06-20 11:31:41 | smartie | 1 | 69583 | 2 | 4.250 | 16372.5 |
247 | 2024-06-13 03:09:11 | smartie | 1 | 69583 | 2 | 2.986 | 23303.1 |
246 | 2024-04-13 18:03:54 | smartie | 3 | 134027 | 265 | 13.046 | 10273.4 |
245 | 2024-04-13 18:03:47 | smartie | 2 | 107671 | 20 | 4.576 | 23529.5 |
244 | 2024-04-13 05:13:12 | smartie | 2 | 107671 | 20 | 3.393 | 31733.3 |
243 | 2024-04-13 05:12:56 | smartie | 3 | 134027 | 265 | 7.903 | 16959.0 |
242 | 2024-04-06 07:15:03 | smartie | 3 | 134027 | 265 | 11.033 | 12147.8 |
241 | 2024-04-06 06:27:32 | smartie | 3 | 134027 | 265 | 19.610 | 6834.6 |
240 | 2024-04-06 06:27:30 | smartie | 2 | 107671 | 20 | 5.906 | 18230.8 |
239 | 2024-04-05 13:51:14 | smartie | 3 | 134027 | 265 | 24.173 | 5544.5 |
238 | 2024-04-05 13:51:07 | smartie | 1 | 69583 | 2 | 3.093 | 22496.9 |
237 | 2024-04-05 13:50:57 | smartie | 3 | 134027 | 265 | 11.720 | 11435.8 |
236 | 2024-04-05 13:50:56 | smartie | 2 | 107671 | 20 | 4.016 | 26810.5 |
235 | 2024-04-05 13:50:54 | smartie | 1 | 69583 | 2 | 2.860 | 24329.7 |