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 |
| 346 | 2025-10-24 20:27:52 | smartie | 1 | 69583 | 2 | 1.356 | 51314.9 |
| 345 | 2025-10-21 01:36:48 | smartie | 1 | 69583 | 2 | 5.626 | 12368.1 |
| 344 | 2025-10-20 11:50:12 | smartie | 1 | 69583 | 2 | 3.266 | 21305.3 |
| 343 | 2025-10-19 23:09:02 | smartie | 1 | 69583 | 2 | 1.200 | 57985.8 |
| 342 | 2025-10-16 05:26:11 | smartie | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 341 | 2025-10-13 10:05:46 | smartie | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 340 | 2025-09-28 08:51:40 | smartie | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 339 | 2025-09-22 05:16:46 | smartie | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 338 | 2025-09-22 05:16:39 | smartie | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 337 | 2025-09-20 18:10:42 | smartie | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 336 | 2025-09-15 14:48:54 | smartie | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 335 | 2025-09-07 19:30:12 | smartie | 1 | 69583 | 2 | 1.170 | 59472.6 |
| 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 |