History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johnny"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 341 | 2025-09-03 18:35:08 | johnny | 1 | 48755 | 1 | 0.750 | 65006.7 |
| 340 | 2025-08-20 17:57:17 | johnny | 3 | 112716 | 141 | 5.126 | 21989.1 |
| 339 | 2025-08-14 21:07:38 | johnny | 3 | 112716 | 141 | 18.186 | 6198.0 |
| 338 | 2025-08-11 20:04:14 | johnny | 3 | 112716 | 141 | 24.706 | 4562.3 |
| 337 | 2025-08-10 06:13:32 | johnny | 2 | 82551 | 8 | 4.966 | 16623.2 |
| 336 | 2025-08-08 23:14:04 | johnny | 3 | 112716 | 141 | 5.326 | 21163.3 |
| 335 | 2025-08-06 12:58:09 | johnny | 3 | 112716 | 141 | 13.373 | 8428.6 |
| 334 | 2025-08-05 08:25:27 | johnny | 3 | 112716 | 141 | 17.470 | 6452.0 |
| 333 | 2025-08-04 05:38:23 | johnny | 1 | 48755 | 1 | 0.830 | 58741.0 |
| 332 | 2025-08-03 21:08:04 | johnny | 3 | 112716 | 141 | 21.113 | 5338.7 |
| 331 | 2025-08-03 21:02:12 | johnny | 2 | 82551 | 8 | 13.423 | 6150.0 |
| 330 | 2025-07-31 06:48:55 | johnny | 1 | 48755 | 1 | 4.000 | 12188.8 |
| 329 | 2025-07-26 19:47:34 | johnny | 1 | 48755 | 1 | 5.016 | 9719.9 |
| 328 | 2025-07-25 06:31:04 | johnny | 1 | 48755 | 1 | 1.983 | 24586.5 |
| 327 | 2025-07-24 07:34:04 | johnny | 1 | 48755 | 1 | 2.873 | 16970.1 |
| 326 | 2025-07-10 23:10:27 | johnny | 1 | 48755 | 1 | 4.940 | 9869.4 |
| 325 | 2025-07-10 22:54:00 | johnny | 1 | 48755 | 1 | 4.203 | 11600.0 |
| 324 | 2025-07-04 06:23:06 | johnny | 1 | 48755 | 1 | 1.940 | 25131.4 |
| 323 | 2025-06-23 23:53:23 | johnny | 1 | 48755 | 1 | 5.876 | 8297.3 |
| 322 | 2025-06-18 07:18:58 | johnny | 1 | 48755 | 1 | 2.796 | 17437.4 |
| 321 | 2025-06-14 07:22:26 | johnny | 1 | 48755 | 1 | 1.813 | 26891.9 |
| 320 | 2025-06-06 16:32:57 | johnny | 1 | 48755 | 1 | 4.220 | 11553.3 |
| 319 | 2025-06-04 06:12:44 | johnny | 1 | 48755 | 1 | 4.030 | 12098.0 |
| 318 | 2025-05-22 20:49:32 | johnny | 3 | 112716 | 141 | 20.310 | 5549.8 |
| 317 | 2025-05-21 19:01:45 | johnny | 3 | 112716 | 141 | 6.626 | 17011.2 |
| 316 | 2025-05-21 07:09:09 | johnny | 2 | 82551 | 8 | 12.500 | 6604.1 |
| 315 | 2025-05-18 23:47:32 | johnny | 1 | 48755 | 1 | 1.720 | 28345.9 |
| 314 | 2025-05-15 10:38:26 | johnny | 3 | 112716 | 141 | 18.580 | 6066.5 |
| 313 | 2025-05-11 18:06:49 | johnny | 1 | 48755 | 1 | 0.783 | 62266.9 |
| 312 | 2025-05-06 16:33:04 | johnny | 1 | 48755 | 1 | 3.436 | 14189.5 |
| 311 | 2025-05-06 02:46:52 | johnny | 1 | 48755 | 1 | 4.030 | 12098.0 |
| 310 | 2025-04-25 13:45:14 | johnny | 1 | 48755 | 1 | 0.826 | 59025.4 |
| 309 | 2025-04-09 06:35:45 | johnny | 1 | 48755 | 1 | 5.640 | 8644.5 |
| 308 | 2025-04-05 15:38:12 | johnny | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 307 | 2025-04-05 10:44:01 | johnny | 2 | 82551 | 8 | 3.810 | 21666.9 |
| 306 | 2025-04-03 20:12:15 | johnny | 3 | 112716 | 141 | 22.940 | 4913.5 |
| 305 | 2025-04-03 18:52:12 | johnny | 3 | 112716 | 141 | 5.406 | 20850.2 |
| 304 | 2025-04-02 10:46:37 | johnny | 3 | 112716 | 141 | 20.033 | 5626.5 |
| 303 | 2025-03-31 08:56:42 | johnny | 3 | 112716 | 141 | 20.156 | 5592.2 |
| 302 | 2025-03-31 07:42:24 | johnny | 1 | 48755 | 1 | 3.843 | 12686.7 |
| 301 | 2025-03-30 09:07:41 | johnny | 3 | 112716 | 141 | 5.000 | 22543.2 |
| 300 | 2025-03-28 03:40:41 | johnny | 1 | 48755 | 1 | 3.763 | 12956.4 |
| 299 | 2025-03-24 10:07:37 | johnny | 3 | 112716 | 141 | 19.063 | 5912.8 |
| 298 | 2025-03-21 21:29:32 | johnny | 3 | 112716 | 141 | 8.610 | 13091.3 |
| 297 | 2025-03-18 06:34:42 | johnny | 1 | 48755 | 1 | 4.266 | 11428.7 |
| 296 | 2025-03-16 14:48:22 | johnny | 1 | 48755 | 1 | 5.690 | 8568.5 |
| 295 | 2025-03-10 13:51:48 | johnny | 2 | 82551 | 8 | 10.266 | 8041.2 |
| 294 | 2025-03-06 16:16:02 | johnny | 2 | 82551 | 8 | 12.000 | 6879.3 |
| 293 | 2025-03-06 16:14:22 | johnny | 1 | 48755 | 1 | 3.030 | 16090.8 |
| 292 | 2025-03-05 22:23:28 | johnny | 1 | 48755 | 1 | 6.033 | 8081.4 |
| 291 | 2025-03-02 06:47:31 | johnny | 3 | 112716 | 141 | 25.393 | 4438.9 |
| 290 | 2025-02-27 05:15:54 | johnny | 3 | 112716 | 141 | 26.410 | 4267.9 |
| 289 | 2025-02-25 12:25:37 | johnny | 3 | 112716 | 141 | 31.720 | 3553.5 |
| 288 | 2025-02-25 01:38:42 | johnny | 3 | 112716 | 141 | 36.126 | 3120.1 |
| 287 | 2025-02-24 22:09:42 | johnny | 3 | 112716 | 141 | 27.280 | 4131.8 |
| 286 | 2025-02-24 22:09:43 | johnny | 2 | 82551 | 8 | 16.220 | 5089.5 |
| 285 | 2025-02-24 22:09:40 | johnny | 1 | 48755 | 1 | 5.516 | 8838.8 |
| 284 | 2025-02-18 03:24:01 | johnny | 1 | 48755 | 1 | 4.266 | 11428.7 |
| 283 | 2025-02-16 21:16:10 | johnny | 3 | 112716 | 141 | 21.750 | 5182.3 |
| 282 | 2025-02-12 22:30:02 | johnny | 3 | 112716 | 141 | 32.750 | 3441.7 |
| 281 | 2025-02-10 11:06:18 | johnny | 2 | 82551 | 8 | 2.063 | 40015.0 |
| 280 | 2025-01-29 21:27:49 | johnny | 1 | 48755 | 1 | 1.953 | 24964.2 |
| 279 | 2025-01-29 15:31:26 | johnny | 2 | 82551 | 8 | 18.203 | 4535.0 |
| 278 | 2025-01-29 15:30:50 | johnny | 1 | 48755 | 1 | 2.280 | 21383.8 |
| 277 | 2025-01-25 18:36:21 | johnny | 1 | 48755 | 1 | 3.843 | 12686.7 |
| 276 | 2025-01-25 12:16:45 | johnny | 3 | 112716 | 141 | 28.160 | 4002.7 |
| 275 | 2025-01-23 19:39:46 | johnny | 3 | 112716 | 141 | 45.173 | 2495.2 |
| 274 | 2025-01-19 15:49:08 | johnny | 3 | 112716 | 141 | 20.940 | 5382.8 |
| 273 | 2025-01-18 05:02:35 | johnny | 3 | 112716 | 141 | 31.566 | 3570.8 |
| 272 | 2025-01-18 05:02:36 | johnny | 2 | 82551 | 8 | 14.766 | 5590.6 |
| 271 | 2025-01-18 04:50:56 | johnny | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 270 | 2024-12-29 10:19:30 | johnny | 1 | 48755 | 1 | 2.596 | 18780.8 |
| 269 | 2024-12-28 17:36:06 | johnny | 2 | 82551 | 8 | 7.330 | 11262.1 |
| 268 | 2024-12-26 13:01:06 | johnny | 1 | 48755 | 1 | 3.923 | 12428.0 |
| 267 | 2024-12-21 19:58:12 | johnny | 1 | 48755 | 1 | 4.546 | 10724.8 |
| 266 | 2024-12-21 13:55:45 | johnny | 2 | 82551 | 8 | 10.766 | 7667.8 |
| 265 | 2024-12-19 12:17:44 | johnny | 2 | 82551 | 8 | 12.520 | 6593.5 |
| 264 | 2024-12-15 16:43:34 | johnny | 3 | 112716 | 141 | 5.203 | 21663.7 |
| 263 | 2024-12-15 16:43:33 | johnny | 2 | 82551 | 8 | 2.546 | 32423.8 |
| 262 | 2024-12-15 16:43:31 | johnny | 1 | 48755 | 1 | 0.860 | 56691.9 |
| 261 | 2024-12-11 20:32:20 | johnny | 3 | 112716 | 141 | 23.266 | 4844.7 |
| 260 | 2024-12-11 00:09:48 | johnny | 3 | 112716 | 141 | 36.093 | 3122.9 |
| 259 | 2024-12-10 16:26:57 | johnny | 3 | 112716 | 141 | 16.000 | 7044.8 |
| 258 | 2024-12-10 16:23:24 | johnny | 3 | 112716 | 141 | 5.470 | 20606.2 |
| 257 | 2024-12-10 03:44:15 | johnny | 3 | 112716 | 141 | 4.826 | 23356.0 |
| 256 | 2024-12-03 08:46:13 | johnny | 2 | 82551 | 8 | 8.190 | 10079.5 |
| 255 | 2024-11-28 09:57:49 | johnny | 1 | 48755 | 1 | 1.906 | 25579.7 |
| 254 | 2024-11-10 19:26:23 | johnny | 2 | 82551 | 8 | 12.516 | 6595.6 |
| 253 | 2024-11-10 15:19:42 | johnny | 1 | 48755 | 1 | 0.796 | 61250.0 |
| 252 | 2024-11-09 15:24:34 | johnny | 2 | 82551 | 8 | 17.720 | 4658.6 |
| 251 | 2024-11-09 15:00:45 | johnny | 3 | 112716 | 141 | 32.220 | 3498.3 |
| 250 | 2024-11-09 06:04:08 | johnny | 1 | 48755 | 1 | 0.783 | 62266.9 |
| 249 | 2024-11-01 04:58:52 | johnny | 3 | 112716 | 141 | 27.143 | 4152.7 |
| 248 | 2024-10-31 19:44:14 | johnny | 3 | 112716 | 141 | 27.830 | 4050.2 |
| 247 | 2024-10-30 15:05:26 | johnny | 3 | 112716 | 141 | 27.860 | 4045.8 |
| 246 | 2024-10-29 02:31:00 | johnny | 1 | 48755 | 1 | 4.033 | 12089.0 |
| 245 | 2024-10-18 22:28:16 | johnny | 1 | 48755 | 1 | 5.983 | 8148.9 |
| 244 | 2024-10-11 08:56:47 | johnny | 2 | 82551 | 8 | 11.596 | 7118.9 |
| 243 | 2024-10-10 07:14:59 | johnny | 2 | 82551 | 8 | 11.156 | 7399.7 |
| 242 | 2024-10-10 07:14:56 | johnny | 2 | 82551 | 8 | 12.170 | 6783.2 |