History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"haffits"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 330 | 2025-12-06 22:02:49 | haffits | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 329 | 2025-12-05 12:32:27 | haffits | 2 | 107671 | 16 | 3.720 | 28943.8 |
| 328 | 2025-12-04 07:55:41 | haffits | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 327 | 2025-11-29 00:32:15 | haffits | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 326 | 2025-11-25 07:10:47 | haffits | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 325 | 2025-11-17 17:58:32 | haffits | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 324 | 2025-11-10 21:53:27 | haffits | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 323 | 2025-11-09 02:05:05 | haffits | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 322 | 2025-11-01 23:27:38 | haffits | 1 | 69583 | 3 | 2.266 | 30707.4 |
| 321 | 2025-10-25 04:55:46 | haffits | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 320 | 2025-10-23 18:34:14 | haffits | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 319 | 2025-10-18 17:42:12 | haffits | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 318 | 2025-10-16 08:27:37 | haffits | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 317 | 2025-10-12 16:59:00 | haffits | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 316 | 2025-10-02 02:26:44 | haffits | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 315 | 2025-09-19 16:13:52 | haffits | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 314 | 2025-09-18 17:11:01 | haffits | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 313 | 2025-09-07 22:07:02 | haffits | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 312 | 2025-08-18 01:56:14 | haffits | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 311 | 2025-08-16 21:50:21 | haffits | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 310 | 2025-08-13 01:27:29 | haffits | 1 | 69583 | 3 | 3.033 | 22942.0 |
| 309 | 2025-08-12 05:26:23 | haffits | 1 | 69583 | 3 | 2.500 | 27833.2 |
| 308 | 2025-08-07 20:30:36 | haffits | 1 | 69583 | 3 | 6.076 | 11452.1 |
| 307 | 2025-08-01 22:48:19 | haffits | 1 | 69583 | 3 | 5.523 | 12598.8 |
| 306 | 2025-07-31 22:35:09 | haffits | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 305 | 2025-07-27 02:15:59 | haffits | 1 | 69583 | 3 | 4.753 | 14639.8 |
| 304 | 2025-07-24 15:28:21 | haffits | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 303 | 2025-07-24 06:09:43 | haffits | 1 | 69583 | 3 | 6.563 | 10602.3 |
| 302 | 2025-07-23 21:06:19 | haffits | 1 | 69583 | 3 | 4.750 | 14649.1 |
| 301 | 2025-07-21 18:59:34 | haffits | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 300 | 2025-07-17 12:56:21 | haffits | 1 | 69583 | 3 | 7.283 | 9554.2 |
| 299 | 2025-07-16 11:49:08 | haffits | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 298 | 2025-07-16 01:09:29 | haffits | 1 | 69583 | 3 | 6.206 | 11212.2 |
| 297 | 2025-07-11 03:25:58 | haffits | 1 | 69583 | 3 | 6.000 | 11597.2 |
| 296 | 2025-07-09 19:34:19 | haffits | 1 | 69583 | 3 | 8.326 | 8357.3 |
| 295 | 2025-07-07 15:03:59 | haffits | 1 | 69583 | 3 | 4.843 | 14367.7 |
| 294 | 2025-07-07 07:15:08 | haffits | 1 | 69583 | 3 | 6.030 | 11539.5 |
| 293 | 2025-07-05 11:29:09 | haffits | 1 | 69583 | 3 | 9.266 | 7509.5 |
| 292 | 2025-07-05 07:32:47 | haffits | 1 | 69583 | 3 | 6.283 | 11074.8 |
| 291 | 2025-07-04 15:44:28 | haffits | 1 | 69583 | 3 | 4.233 | 16438.2 |
| 290 | 2025-06-29 17:24:44 | haffits | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 289 | 2025-06-22 09:44:57 | haffits | 1 | 69583 | 3 | 3.860 | 18026.7 |
| 288 | 2025-06-21 17:02:16 | haffits | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 287 | 2025-06-16 10:32:57 | haffits | 1 | 69583 | 3 | 6.406 | 10862.2 |
| 286 | 2025-06-16 04:53:50 | haffits | 1 | 69583 | 3 | 5.860 | 11874.2 |
| 285 | 2025-06-10 22:06:21 | haffits | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 284 | 2025-06-07 14:06:16 | haffits | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 283 | 2025-06-05 23:29:50 | haffits | 3 | 134027 | 191 | 35.126 | 3815.6 |
| 282 | 2025-06-05 21:14:16 | haffits | 3 | 134027 | 191 | 33.063 | 4053.7 |
| 281 | 2025-06-03 20:53:01 | haffits | 3 | 134027 | 191 | 35.173 | 3810.5 |
| 280 | 2025-05-22 09:29:09 | haffits | 1 | 69583 | 3 | 6.580 | 10574.9 |
| 279 | 2025-05-18 02:54:17 | haffits | 1 | 69583 | 3 | 6.080 | 11444.6 |
| 278 | 2025-05-16 10:57:01 | haffits | 1 | 69583 | 3 | 6.296 | 11051.9 |
| 277 | 2025-05-10 21:58:11 | haffits | 1 | 69583 | 3 | 6.076 | 11452.1 |
| 276 | 2025-05-07 13:58:32 | haffits | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 275 | 2025-04-29 07:02:50 | haffits | 3 | 134027 | 191 | 5.733 | 23378.2 |
| 274 | 2025-04-23 23:26:31 | haffits | 3 | 134027 | 191 | 26.053 | 5144.4 |
| 273 | 2025-04-23 21:15:25 | haffits | 3 | 134027 | 191 | 28.313 | 4733.8 |
| 272 | 2025-04-23 15:03:48 | haffits | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 271 | 2025-04-21 20:42:37 | haffits | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 270 | 2025-04-21 10:23:57 | haffits | 3 | 134027 | 191 | 40.910 | 3276.1 |
| 269 | 2025-04-20 22:02:33 | haffits | 3 | 134027 | 191 | 31.346 | 4275.7 |
| 268 | 2025-04-20 20:51:32 | haffits | 3 | 134027 | 191 | 32.860 | 4078.7 |
| 267 | 2025-04-18 09:04:38 | haffits | 2 | 107671 | 16 | 16.156 | 6664.5 |
| 266 | 2025-04-18 05:47:01 | haffits | 3 | 134027 | 191 | 20.250 | 6618.6 |
| 265 | 2025-04-18 01:27:08 | haffits | 1 | 69583 | 3 | 6.453 | 10783.0 |
| 264 | 2025-04-16 09:53:10 | haffits | 1 | 69583 | 3 | 7.296 | 9537.1 |
| 263 | 2025-04-10 21:26:11 | haffits | 1 | 69583 | 3 | 2.733 | 25460.3 |
| 262 | 2025-04-04 15:43:44 | haffits | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 261 | 2025-03-25 00:51:05 | haffits | 2 | 107671 | 16 | 15.860 | 6788.8 |
| 260 | 2025-03-24 05:43:04 | haffits | 2 | 107671 | 16 | 12.576 | 8561.6 |
| 259 | 2025-03-21 12:29:32 | haffits | 2 | 107671 | 16 | 16.610 | 6482.3 |
| 258 | 2025-03-20 16:26:01 | haffits | 1 | 69583 | 3 | 5.203 | 13373.6 |
| 257 | 2025-03-19 10:09:14 | haffits | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 256 | 2025-03-17 04:32:19 | haffits | 1 | 69583 | 3 | 5.923 | 11747.9 |
| 255 | 2025-03-15 14:12:53 | haffits | 1 | 69583 | 3 | 3.093 | 22496.9 |
| 254 | 2025-03-12 04:43:05 | haffits | 1 | 69583 | 3 | 7.016 | 9917.8 |
| 253 | 2025-03-11 11:13:02 | haffits | 3 | 134027 | 191 | 47.533 | 2819.7 |
| 252 | 2025-03-10 12:45:37 | haffits | 3 | 134027 | 191 | 41.906 | 3198.3 |
| 251 | 2025-03-10 07:38:23 | haffits | 3 | 134027 | 191 | 35.470 | 3778.6 |
| 250 | 2025-03-10 07:21:43 | haffits | 3 | 134027 | 191 | 40.690 | 3293.9 |
| 249 | 2025-03-10 03:39:08 | haffits | 3 | 134027 | 191 | 26.676 | 5024.3 |
| 248 | 2025-03-10 03:39:00 | haffits | 2 | 107671 | 16 | 16.673 | 6457.8 |
| 247 | 2025-03-10 03:28:05 | haffits | 1 | 69583 | 3 | 10.313 | 6747.1 |
| 246 | 2025-02-24 14:01:16 | haffits | 1 | 69583 | 3 | 3.373 | 20629.4 |
| 245 | 2025-02-12 19:13:21 | haffits | 1 | 69583 | 3 | 5.766 | 12067.8 |
| 244 | 2025-01-22 10:31:02 | haffits | 1 | 69583 | 3 | 4.326 | 16084.8 |
| 243 | 2025-01-20 05:52:05 | haffits | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 242 | 2025-01-19 12:02:07 | haffits | 1 | 69583 | 3 | 3.406 | 20429.5 |
| 241 | 2025-01-05 08:27:01 | haffits | 1 | 69583 | 3 | 5.423 | 12831.1 |
| 240 | 2024-12-21 02:44:38 | haffits | 1 | 69583 | 3 | 6.653 | 10458.9 |
| 239 | 2024-12-21 02:35:34 | haffits | 3 | 134027 | 191 | 32.236 | 4157.7 |
| 238 | 2024-12-21 02:35:29 | haffits | 2 | 107671 | 16 | 15.970 | 6742.1 |
| 237 | 2024-12-19 07:17:37 | haffits | 3 | 134027 | 191 | 29.033 | 4616.4 |
| 236 | 2024-12-19 07:17:39 | haffits | 2 | 107671 | 16 | 16.406 | 6562.9 |
| 235 | 2024-12-19 07:17:25 | haffits | 1 | 69583 | 3 | 6.080 | 11444.6 |
| 234 | 2024-12-15 10:33:05 | haffits | 1 | 69583 | 3 | 3.033 | 22942.0 |
| 233 | 2024-12-05 22:37:28 | haffits | 3 | 134027 | 191 | 17.376 | 7713.3 |
| 232 | 2024-12-05 14:19:09 | haffits | 3 | 134027 | 191 | 32.923 | 4070.9 |
| 231 | 2024-12-05 13:35:24 | haffits | 1 | 69583 | 3 | 2.500 | 27833.2 |