History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affairs"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 362 | 2025-09-04 20:18:34 | affairs | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 361 | 2025-08-28 06:55:09 | affairs | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 360 | 2025-07-24 02:17:54 | affairs | 1 | 69583 | 4 | 6.376 | 10913.3 |
| 359 | 2025-07-23 00:43:48 | affairs | 1 | 69583 | 4 | 8.610 | 8081.6 |
| 358 | 2025-07-15 07:48:36 | affairs | 1 | 69583 | 4 | 2.920 | 23829.8 |
| 357 | 2025-07-14 06:34:26 | affairs | 2 | 107671 | 12 | 13.436 | 8013.6 |
| 356 | 2025-07-13 16:52:13 | affairs | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 355 | 2025-07-07 06:20:39 | affairs | 3 | 134027 | 113 | 50.093 | 2675.6 |
| 354 | 2025-07-07 00:19:53 | affairs | 2 | 107671 | 12 | 22.296 | 4829.2 |
| 353 | 2025-07-05 12:18:01 | affairs | 3 | 134027 | 113 | 28.860 | 4644.0 |
| 352 | 2025-07-04 17:15:02 | affairs | 2 | 107671 | 12 | 17.656 | 6098.3 |
| 351 | 2025-07-03 21:04:53 | affairs | 3 | 134027 | 113 | 12.906 | 10384.9 |
| 350 | 2025-07-03 04:42:50 | affairs | 3 | 134027 | 113 | 6.440 | 20811.6 |
| 349 | 2025-07-02 23:16:58 | affairs | 3 | 134027 | 113 | 28.783 | 4656.5 |
| 348 | 2025-07-02 02:20:49 | affairs | 3 | 134027 | 113 | 26.640 | 5031.0 |
| 347 | 2025-07-01 08:55:30 | affairs | 3 | 134027 | 113 | 6.406 | 20922.1 |
| 346 | 2025-06-30 10:53:06 | affairs | 1 | 69583 | 4 | 6.280 | 11080.1 |
| 345 | 2025-06-23 21:01:15 | affairs | 1 | 69583 | 4 | 6.280 | 11080.1 |
| 344 | 2025-06-23 18:47:12 | affairs | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 343 | 2025-06-21 17:01:04 | affairs | 1 | 69583 | 4 | 1.970 | 35321.3 |
| 342 | 2025-06-16 05:07:35 | affairs | 1 | 69583 | 4 | 7.736 | 8994.7 |
| 341 | 2025-06-14 07:50:33 | affairs | 1 | 69583 | 4 | 7.936 | 8768.0 |
| 340 | 2025-06-10 16:21:52 | affairs | 1 | 69583 | 4 | 6.703 | 10380.9 |
| 339 | 2025-05-23 21:24:50 | affairs | 1 | 69583 | 4 | 3.110 | 22374.0 |
| 338 | 2025-05-22 05:29:49 | affairs | 2 | 107671 | 12 | 15.013 | 7171.9 |
| 337 | 2025-05-21 10:52:28 | affairs | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 336 | 2025-05-16 19:19:32 | affairs | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 335 | 2025-05-11 21:39:30 | affairs | 1 | 69583 | 4 | 2.966 | 23460.2 |
| 334 | 2025-05-03 23:22:22 | affairs | 3 | 134027 | 113 | 27.706 | 4837.5 |
| 333 | 2025-05-03 14:19:51 | affairs | 1 | 69583 | 4 | 6.030 | 11539.5 |
| 332 | 2025-05-03 12:06:07 | affairs | 3 | 134027 | 113 | 5.813 | 23056.4 |
| 331 | 2025-05-03 05:02:16 | affairs | 1 | 69583 | 4 | 2.766 | 25156.5 |
| 330 | 2025-04-22 21:16:17 | affairs | 1 | 69583 | 4 | 6.143 | 11327.2 |
| 329 | 2025-04-16 04:23:59 | affairs | 3 | 134027 | 113 | 22.410 | 5980.7 |
| 328 | 2025-04-14 21:37:40 | affairs | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 327 | 2025-04-14 14:27:10 | affairs | 3 | 134027 | 113 | 17.936 | 7472.5 |
| 326 | 2025-04-12 15:47:41 | affairs | 1 | 69583 | 4 | 5.813 | 11970.2 |
| 325 | 2025-04-11 01:10:00 | affairs | 3 | 134027 | 113 | 32.440 | 4131.5 |
| 324 | 2025-04-10 21:19:51 | affairs | 1 | 69583 | 4 | 3.423 | 20328.1 |
| 323 | 2025-04-08 20:34:01 | affairs | 3 | 134027 | 113 | 19.690 | 6806.9 |
| 322 | 2025-04-06 10:27:53 | affairs | 1 | 69583 | 4 | 5.876 | 11841.9 |
| 321 | 2025-04-05 06:33:23 | affairs | 3 | 134027 | 113 | 5.780 | 23188.1 |
| 320 | 2025-03-30 06:36:29 | affairs | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 319 | 2025-03-29 09:02:13 | affairs | 1 | 69583 | 4 | 4.906 | 14183.2 |
| 318 | 2025-03-21 22:53:31 | affairs | 2 | 107671 | 12 | 3.360 | 32044.9 |
| 317 | 2025-03-20 22:26:49 | affairs | 3 | 134027 | 113 | 6.093 | 21996.9 |
| 316 | 2025-03-19 22:25:36 | affairs | 1 | 69583 | 4 | 5.563 | 12508.2 |
| 315 | 2025-03-19 09:50:30 | affairs | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 314 | 2025-03-15 05:26:49 | affairs | 1 | 69583 | 4 | 9.733 | 7149.2 |
| 313 | 2025-03-12 03:54:01 | affairs | 3 | 134027 | 113 | 24.686 | 5429.3 |
| 312 | 2025-03-10 03:52:13 | affairs | 2 | 107671 | 12 | 15.470 | 6960.0 |
| 311 | 2025-03-10 03:28:26 | affairs | 1 | 69583 | 4 | 7.796 | 8925.5 |
| 310 | 2025-03-08 05:57:20 | affairs | 3 | 134027 | 113 | 36.390 | 3683.1 |
| 309 | 2025-03-07 15:59:35 | affairs | 3 | 134027 | 113 | 33.376 | 4015.7 |
| 308 | 2025-03-07 04:54:39 | affairs | 3 | 134027 | 113 | 24.983 | 5364.7 |
| 307 | 2025-03-07 04:54:38 | affairs | 2 | 107671 | 12 | 16.800 | 6409.0 |
| 306 | 2025-02-24 01:27:00 | affairs | 3 | 134027 | 113 | 33.296 | 4025.3 |
| 305 | 2025-02-24 01:26:59 | affairs | 2 | 107671 | 12 | 11.873 | 9068.6 |
| 304 | 2025-02-24 01:23:25 | affairs | 1 | 69583 | 4 | 6.173 | 11272.2 |
| 303 | 2025-02-13 00:32:35 | affairs | 1 | 69583 | 4 | 5.766 | 12067.8 |
| 302 | 2025-02-05 03:16:30 | affairs | 1 | 69583 | 4 | 3.826 | 18186.9 |
| 301 | 2025-02-01 12:01:03 | affairs | 1 | 69583 | 4 | 5.703 | 12201.1 |
| 300 | 2025-01-15 02:10:26 | affairs | 1 | 69583 | 4 | 4.516 | 15408.1 |
| 299 | 2025-01-12 05:41:53 | affairs | 1 | 69583 | 4 | 5.783 | 12032.3 |
| 298 | 2024-12-04 03:26:53 | affairs | 1 | 69583 | 4 | 5.233 | 13297.0 |
| 297 | 2024-11-08 04:52:46 | affairs | 1 | 69583 | 4 | 7.500 | 9277.7 |
| 296 | 2024-10-26 23:06:06 | affairs | 3 | 134027 | 113 | 31.220 | 4293.0 |
| 295 | 2024-10-20 05:54:23 | affairs | 1 | 69583 | 4 | 2.783 | 25002.9 |
| 294 | 2024-10-13 14:01:15 | affairs | 3 | 134027 | 113 | 24.236 | 5530.1 |
| 293 | 2024-10-11 18:34:02 | affairs | 3 | 134027 | 113 | 34.953 | 3834.5 |
| 292 | 2024-10-11 15:16:10 | affairs | 3 | 134027 | 113 | 31.626 | 4237.9 |
| 291 | 2024-10-11 15:16:06 | affairs | 2 | 107671 | 12 | 15.236 | 7066.9 |
| 290 | 2024-10-07 12:13:51 | affairs | 1 | 69583 | 4 | 12.830 | 5423.5 |
| 289 | 2024-09-29 04:59:16 | affairs | 1 | 69583 | 4 | 8.343 | 8340.3 |
| 288 | 2024-09-25 05:35:41 | affairs | 1 | 69583 | 4 | 10.296 | 6758.3 |
| 287 | 2024-09-11 19:48:48 | affairs | 1 | 69583 | 4 | 12.706 | 5476.4 |
| 286 | 2024-08-28 10:28:59 | affairs | 3 | 134027 | 113 | 62.956 | 2128.9 |
| 285 | 2024-08-28 10:20:02 | affairs | 2 | 107671 | 12 | 18.673 | 5766.1 |
| 284 | 2024-08-28 08:45:52 | affairs | 3 | 134027 | 113 | 31.466 | 4259.4 |
| 283 | 2024-08-28 08:45:50 | affairs | 2 | 107671 | 12 | 29.343 | 3669.4 |
| 282 | 2024-08-27 02:52:07 | affairs | 1 | 69583 | 4 | 9.060 | 7680.2 |
| 281 | 2024-08-27 02:51:49 | affairs | 1 | 69583 | 4 | 10.376 | 6706.1 |
| 280 | 2024-08-17 00:33:37 | affairs | 1 | 69583 | 4 | 13.373 | 5203.2 |
| 279 | 2024-08-16 05:34:56 | affairs | 1 | 69583 | 4 | 11.783 | 5905.4 |
| 278 | 2024-08-11 17:37:52 | affairs | 1 | 69583 | 4 | 2.810 | 24762.6 |
| 277 | 2024-07-25 17:12:17 | affairs | 1 | 69583 | 4 | 1.906 | 36507.3 |
| 276 | 2024-07-17 06:15:51 | affairs | 3 | 134027 | 113 | 33.750 | 3971.2 |
| 275 | 2024-07-17 05:39:33 | affairs | 1 | 69583 | 4 | 1.533 | 45390.1 |
| 274 | 2024-07-15 18:14:57 | affairs | 2 | 107671 | 12 | 21.876 | 4921.9 |
| 273 | 2024-07-15 18:11:43 | affairs | 3 | 134027 | 113 | 12.580 | 10654.0 |
| 272 | 2024-07-15 10:04:00 | affairs | 2 | 107671 | 12 | 10.986 | 9800.7 |
| 271 | 2024-07-15 10:03:50 | affairs | 3 | 134027 | 113 | 18.173 | 7375.1 |
| 270 | 2024-07-15 10:02:48 | affairs | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 269 | 2024-07-13 20:22:07 | affairs | 1 | 69583 | 4 | 2.313 | 30083.4 |
| 268 | 2024-07-11 20:21:02 | affairs | 1 | 69583 | 4 | 6.046 | 11508.9 |
| 267 | 2024-07-08 06:40:22 | affairs | 1 | 69583 | 4 | 6.563 | 10602.3 |
| 266 | 2024-06-16 13:15:21 | affairs | 1 | 69583 | 4 | 4.360 | 15959.4 |
| 265 | 2024-06-07 11:34:10 | affairs | 1 | 69583 | 4 | 3.546 | 19623.0 |
| 264 | 2024-06-02 23:10:25 | affairs | 2 | 107671 | 12 | 13.846 | 7776.3 |
| 263 | 2024-06-01 17:17:08 | affairs | 2 | 107671 | 12 | 3.266 | 32967.2 |