History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crewman"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 363 | 2025-09-21 15:32:50 | crewman | 2 | 107671 | 8 | 3.250 | 33129.5 |
| 362 | 2025-09-18 12:39:56 | crewman | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 361 | 2025-08-30 04:24:50 | crewman | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 360 | 2025-08-17 07:04:16 | crewman | 3 | 134027 | 129 | 16.313 | 8216.0 |
| 359 | 2025-08-12 04:05:51 | crewman | 3 | 134027 | 129 | 14.826 | 9040.0 |
| 358 | 2025-08-10 00:22:36 | crewman | 2 | 107671 | 8 | 6.860 | 15695.5 |
| 357 | 2025-08-09 00:58:11 | crewman | 1 | 69583 | 2 | 6.860 | 10143.3 |
| 356 | 2025-08-08 20:29:53 | crewman | 3 | 134027 | 129 | 7.080 | 18930.4 |
| 355 | 2025-08-07 04:56:55 | crewman | 3 | 134027 | 129 | 16.846 | 7956.0 |
| 354 | 2025-08-05 23:33:36 | crewman | 3 | 134027 | 129 | 22.626 | 5923.6 |
| 353 | 2025-08-05 23:33:32 | crewman | 3 | 134027 | 129 | 16.250 | 8247.8 |
| 352 | 2025-08-05 07:26:32 | crewman | 2 | 107671 | 8 | 15.080 | 7140.0 |
| 351 | 2025-08-04 15:12:13 | crewman | 1 | 69583 | 2 | 2.783 | 25002.9 |
| 350 | 2025-08-04 11:22:34 | crewman | 3 | 134027 | 129 | 33.626 | 3985.8 |
| 349 | 2025-08-04 10:42:19 | crewman | 2 | 107671 | 8 | 8.610 | 12505.3 |
| 348 | 2025-08-03 09:42:58 | crewman | 1 | 69583 | 2 | 1.293 | 53815.2 |
| 347 | 2025-08-01 05:54:47 | crewman | 1 | 69583 | 2 | 4.076 | 17071.4 |
| 346 | 2025-07-31 06:31:16 | crewman | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 345 | 2025-07-27 01:03:43 | crewman | 1 | 69583 | 2 | 3.186 | 21840.2 |
| 344 | 2025-07-26 05:24:01 | crewman | 1 | 69583 | 2 | 5.063 | 13743.4 |
| 343 | 2025-07-25 09:34:07 | crewman | 1 | 69583 | 2 | 4.440 | 15671.8 |
| 342 | 2025-07-24 20:08:28 | crewman | 1 | 69583 | 2 | 2.936 | 23699.9 |
| 341 | 2025-07-24 16:50:06 | crewman | 1 | 69583 | 2 | 5.110 | 13617.0 |
| 340 | 2025-07-24 02:01:14 | crewman | 1 | 69583 | 2 | 6.000 | 11597.2 |
| 339 | 2025-07-23 15:49:10 | crewman | 1 | 69583 | 2 | 8.156 | 8531.5 |
| 338 | 2025-07-23 15:18:38 | crewman | 1 | 69583 | 2 | 3.376 | 20611.1 |
| 337 | 2025-07-14 07:27:47 | crewman | 3 | 134027 | 129 | 34.050 | 3936.2 |
| 336 | 2025-07-13 10:53:09 | crewman | 3 | 134027 | 129 | 16.596 | 8075.9 |
| 335 | 2025-07-12 16:09:10 | crewman | 3 | 134027 | 129 | 7.110 | 18850.5 |
| 334 | 2025-07-09 13:01:09 | crewman | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 333 | 2025-07-08 10:37:51 | crewman | 1 | 69583 | 2 | 7.453 | 9336.2 |
| 332 | 2025-06-28 05:11:38 | crewman | 1 | 69583 | 2 | 3.420 | 20345.9 |
| 331 | 2025-06-25 00:04:02 | crewman | 1 | 69583 | 2 | 5.796 | 12005.3 |
| 330 | 2025-06-18 10:15:52 | crewman | 1 | 69583 | 2 | 4.966 | 14011.9 |
| 329 | 2025-06-18 03:02:31 | crewman | 1 | 69583 | 2 | 10.970 | 6343.0 |
| 328 | 2025-06-14 03:51:53 | crewman | 1 | 69583 | 2 | 8.063 | 8629.9 |
| 327 | 2025-06-11 19:46:29 | crewman | 1 | 69583 | 2 | 2.593 | 26834.9 |
| 326 | 2025-06-09 21:09:08 | crewman | 1 | 69583 | 2 | 3.000 | 23194.3 |
| 325 | 2025-06-08 07:02:04 | crewman | 3 | 134027 | 129 | 21.423 | 6256.2 |
| 324 | 2025-06-08 03:14:44 | crewman | 3 | 134027 | 129 | 42.953 | 3120.3 |
| 323 | 2025-06-06 06:26:59 | crewman | 2 | 107671 | 8 | 16.093 | 6690.5 |
| 322 | 2025-06-06 03:21:01 | crewman | 3 | 134027 | 129 | 31.626 | 4237.9 |
| 321 | 2025-06-05 11:57:56 | crewman | 1 | 69583 | 2 | 1.326 | 52475.9 |
| 320 | 2025-06-05 02:41:41 | crewman | 1 | 69583 | 2 | 9.470 | 7347.7 |
| 319 | 2025-05-22 05:23:16 | crewman | 1 | 69583 | 2 | 3.173 | 21929.7 |
| 318 | 2025-05-22 00:22:02 | crewman | 1 | 69583 | 2 | 5.890 | 11813.8 |
| 317 | 2025-05-20 00:26:56 | crewman | 1 | 69583 | 2 | 8.716 | 7983.4 |
| 316 | 2025-05-18 02:52:26 | crewman | 1 | 69583 | 2 | 7.453 | 9336.2 |
| 315 | 2025-05-17 07:50:11 | crewman | 1 | 69583 | 2 | 2.373 | 29322.8 |
| 314 | 2025-05-16 10:40:29 | crewman | 1 | 69583 | 2 | 4.143 | 16795.3 |
| 313 | 2025-05-08 03:15:04 | crewman | 3 | 134027 | 129 | 27.643 | 4848.5 |
| 312 | 2025-05-07 03:15:57 | crewman | 3 | 134027 | 129 | 33.220 | 4034.5 |
| 311 | 2025-04-23 21:40:38 | crewman | 2 | 107671 | 8 | 17.533 | 6141.0 |
| 310 | 2025-04-23 21:17:55 | crewman | 3 | 134027 | 129 | 30.983 | 4325.8 |
| 309 | 2025-04-22 04:06:43 | crewman | 1 | 69583 | 2 | 4.236 | 16426.6 |
| 308 | 2025-04-16 03:41:50 | crewman | 1 | 69583 | 2 | 7.876 | 8834.8 |
| 307 | 2025-04-14 10:16:20 | crewman | 1 | 69583 | 2 | 6.280 | 11080.1 |
| 306 | 2025-04-14 04:53:29 | crewman | 2 | 107671 | 8 | 15.220 | 7074.3 |
| 305 | 2025-04-14 01:06:03 | crewman | 1 | 69583 | 2 | 5.830 | 11935.3 |
| 304 | 2025-04-04 05:36:43 | crewman | 2 | 107671 | 8 | 17.813 | 6044.5 |
| 303 | 2025-04-03 11:44:53 | crewman | 1 | 69583 | 2 | 5.656 | 12302.5 |
| 302 | 2025-03-20 05:46:13 | crewman | 1 | 69583 | 2 | 6.296 | 11051.9 |
| 301 | 2025-03-15 19:45:22 | crewman | 1 | 69583 | 2 | 4.093 | 17000.5 |
| 300 | 2025-03-13 08:33:01 | crewman | 1 | 69583 | 2 | 3.190 | 21812.9 |
| 299 | 2025-03-11 19:39:29 | crewman | 1 | 69583 | 2 | 8.830 | 7880.3 |
| 298 | 2025-03-07 14:15:23 | crewman | 1 | 69583 | 2 | 2.943 | 23643.6 |
| 297 | 2025-03-06 18:02:28 | crewman | 3 | 134027 | 129 | 35.330 | 3793.6 |
| 296 | 2025-03-04 04:40:06 | crewman | 3 | 134027 | 129 | 35.643 | 3760.3 |
| 295 | 2025-03-03 15:20:24 | crewman | 1 | 69583 | 2 | 4.920 | 14142.9 |
| 294 | 2025-03-03 00:36:40 | crewman | 1 | 69583 | 2 | 2.593 | 26834.9 |
| 293 | 2025-02-11 12:08:04 | crewman | 3 | 134027 | 129 | 49.190 | 2724.7 |
| 292 | 2025-02-09 10:07:29 | crewman | 1 | 69583 | 2 | 14.610 | 4762.7 |
| 291 | 2025-02-09 09:56:59 | crewman | 2 | 107671 | 8 | 20.643 | 5215.9 |
| 290 | 2025-02-09 09:15:56 | crewman | 3 | 134027 | 129 | 7.140 | 18771.3 |
| 289 | 2025-02-09 03:15:10 | crewman | 3 | 134027 | 129 | 48.003 | 2792.1 |
| 288 | 2025-02-09 03:15:07 | crewman | 2 | 107671 | 8 | 17.593 | 6120.1 |
| 287 | 2025-02-09 03:11:14 | crewman | 1 | 69583 | 2 | 4.483 | 15521.5 |
| 286 | 2025-01-09 18:00:49 | crewman | 1 | 69583 | 2 | 3.796 | 18330.6 |
| 285 | 2025-01-05 17:51:29 | crewman | 1 | 69583 | 2 | 5.393 | 12902.5 |
| 284 | 2024-12-30 23:26:49 | crewman | 1 | 69583 | 2 | 5.986 | 11624.3 |
| 283 | 2024-12-10 03:26:36 | crewman | 2 | 107671 | 8 | 7.830 | 13751.1 |
| 282 | 2024-12-10 03:26:30 | crewman | 1 | 69583 | 2 | 6.406 | 10862.2 |
| 281 | 2024-12-09 19:25:54 | crewman | 3 | 134027 | 129 | 25.500 | 5256.0 |
| 280 | 2024-12-08 03:04:14 | crewman | 1 | 69583 | 2 | 5.890 | 11813.8 |
| 279 | 2024-12-07 14:57:18 | crewman | 3 | 134027 | 129 | 33.660 | 3981.8 |
| 278 | 2024-12-03 08:36:11 | crewman | 3 | 134027 | 129 | 29.546 | 4536.2 |
| 277 | 2024-12-03 03:17:46 | crewman | 3 | 134027 | 129 | 22.016 | 6087.7 |
| 276 | 2024-11-24 15:12:43 | crewman | 1 | 69583 | 2 | 5.830 | 11935.3 |
| 275 | 2024-11-06 21:56:42 | crewman | 2 | 107671 | 8 | 14.703 | 7323.1 |
| 274 | 2024-11-06 21:56:33 | crewman | 1 | 69583 | 2 | 6.513 | 10683.7 |
| 273 | 2024-11-04 07:47:59 | crewman | 1 | 69583 | 2 | 6.013 | 11572.1 |
| 272 | 2024-11-01 16:54:57 | crewman | 1 | 69583 | 2 | 5.593 | 12441.1 |
| 271 | 2024-10-30 05:39:00 | crewman | 2 | 107671 | 8 | 12.956 | 8310.5 |
| 270 | 2024-10-30 01:23:41 | crewman | 2 | 107671 | 8 | 3.906 | 27565.5 |
| 269 | 2024-10-30 01:23:22 | crewman | 3 | 134027 | 129 | 6.373 | 21030.4 |
| 268 | 2024-10-16 18:42:14 | crewman | 3 | 134027 | 129 | 35.190 | 3808.7 |
| 267 | 2024-10-15 17:16:43 | crewman | 3 | 134027 | 129 | 33.423 | 4010.0 |
| 266 | 2024-10-13 22:29:37 | crewman | 3 | 134027 | 129 | 33.753 | 3970.8 |
| 265 | 2024-10-13 22:29:33 | crewman | 2 | 107671 | 8 | 16.906 | 6368.8 |
| 264 | 2024-10-13 22:27:25 | crewman | 1 | 69583 | 2 | 1.500 | 46388.7 |