History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"officiant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 388 | 2025-11-29 09:40:28 | officiant | 1 | 81242 | 2 | 1.233 | 65889.7 |
| 387 | 2025-11-08 06:56:07 | officiant | 4 | 165329 | 102 | 11.296 | 14636.1 |
| 386 | 2025-11-03 16:05:34 | officiant | 4 | 165329 | 102 | 41.376 | 3995.8 |
| 385 | 2025-11-03 00:00:45 | officiant | 4 | 165329 | 102 | 10.940 | 15112.3 |
| 384 | 2025-10-30 17:24:23 | officiant | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 383 | 2025-10-24 18:51:20 | officiant | 1 | 81242 | 2 | 1.546 | 52549.8 |
| 382 | 2025-10-08 13:01:05 | officiant | 1 | 81242 | 2 | 1.233 | 65889.7 |
| 381 | 2025-09-14 12:23:49 | officiant | 1 | 81242 | 2 | 1.220 | 66591.8 |
| 380 | 2025-09-12 03:22:01 | officiant | 2 | 121436 | 8 | 3.563 | 34082.5 |
| 379 | 2025-08-19 22:25:46 | officiant | 2 | 121436 | 8 | 3.156 | 38477.8 |
| 378 | 2025-08-17 10:58:55 | officiant | 1 | 81242 | 2 | 3.186 | 25499.7 |
| 377 | 2025-08-10 18:42:36 | officiant | 3 | 148641 | 23 | 17.046 | 8720.0 |
| 376 | 2025-08-10 11:52:19 | officiant | 2 | 121436 | 8 | 12.876 | 9431.2 |
| 375 | 2025-08-08 20:35:19 | officiant | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 374 | 2025-08-04 02:07:36 | officiant | 1 | 81242 | 2 | 1.203 | 67532.8 |
| 373 | 2025-07-31 12:00:12 | officiant | 1 | 81242 | 2 | 2.796 | 29056.5 |
| 372 | 2025-07-16 23:21:23 | officiant | 1 | 81242 | 2 | 5.110 | 15898.6 |
| 371 | 2025-07-08 20:09:48 | officiant | 1 | 81242 | 2 | 1.750 | 46424.0 |
| 370 | 2025-07-08 00:13:33 | officiant | 1 | 81242 | 2 | 5.860 | 13863.8 |
| 369 | 2025-07-07 03:52:56 | officiant | 3 | 148641 | 23 | 18.623 | 7981.6 |
| 368 | 2025-07-05 10:22:00 | officiant | 3 | 148641 | 23 | 37.206 | 3995.1 |
| 367 | 2025-07-05 00:43:43 | officiant | 3 | 148641 | 23 | 30.986 | 4797.0 |
| 366 | 2025-06-30 13:33:37 | officiant | 4 | 165329 | 102 | 53.563 | 3086.6 |
| 365 | 2025-06-28 00:20:23 | officiant | 3 | 148641 | 23 | 26.580 | 5592.2 |
| 364 | 2025-06-22 00:37:20 | officiant | 3 | 148641 | 23 | 37.906 | 3921.3 |
| 363 | 2025-06-19 06:04:16 | officiant | 3 | 148641 | 23 | 32.173 | 4620.1 |
| 362 | 2025-06-18 16:24:27 | officiant | 4 | 165329 | 102 | 41.206 | 4012.3 |
| 361 | 2025-06-18 09:27:50 | officiant | 1 | 81242 | 2 | 9.640 | 8427.6 |
| 360 | 2025-06-17 09:13:29 | officiant | 2 | 121436 | 8 | 4.486 | 27070.0 |
| 359 | 2025-06-17 08:48:39 | officiant | 4 | 165329 | 102 | 12.846 | 12870.1 |
| 358 | 2025-06-17 01:46:33 | officiant | 3 | 148641 | 23 | 28.406 | 5232.7 |
| 357 | 2025-06-15 19:33:15 | officiant | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 356 | 2025-06-11 21:46:23 | officiant | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 355 | 2025-06-05 18:10:56 | officiant | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 354 | 2025-04-05 14:09:47 | officiant | 3 | 148641 | 23 | 5.703 | 26063.7 |
| 353 | 2025-04-02 00:12:10 | officiant | 1 | 81242 | 2 | 9.236 | 8796.2 |
| 352 | 2025-03-23 22:13:47 | officiant | 1 | 81242 | 2 | 6.813 | 11924.6 |
| 351 | 2025-02-18 23:57:56 | officiant | 3 | 148641 | 23 | 44.940 | 3307.5 |
| 350 | 2025-02-18 23:57:55 | officiant | 2 | 121436 | 8 | 11.593 | 10474.9 |
| 349 | 2025-02-18 23:55:57 | officiant | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 348 | 2025-02-18 11:18:46 | officiant | 3 | 148641 | 23 | 44.360 | 3350.8 |
| 347 | 2025-02-14 19:45:56 | officiant | 3 | 148641 | 23 | 32.766 | 4536.4 |
| 346 | 2025-02-14 19:45:58 | officiant | 3 | 148641 | 23 | 19.686 | 7550.6 |
| 345 | 2025-02-08 07:53:44 | officiant | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 344 | 2025-02-05 13:03:56 | officiant | 4 | 165329 | 102 | 62.003 | 2666.5 |
| 343 | 2025-02-05 13:03:57 | officiant | 3 | 148641 | 23 | 35.283 | 4212.8 |
| 342 | 2025-02-05 13:03:55 | officiant | 2 | 121436 | 8 | 23.783 | 5106.0 |
| 341 | 2025-02-05 00:43:08 | officiant | 1 | 81242 | 2 | 5.810 | 13983.1 |
| 340 | 2025-01-22 07:49:29 | officiant | 1 | 81242 | 2 | 9.703 | 8372.9 |
| 339 | 2025-01-16 07:52:16 | officiant | 3 | 148641 | 23 | 28.750 | 5170.1 |
| 338 | 2025-01-16 07:52:08 | officiant | 3 | 148641 | 23 | 32.046 | 4638.4 |
| 337 | 2025-01-14 21:24:36 | officiant | 3 | 148641 | 23 | 43.863 | 3388.8 |
| 336 | 2025-01-14 11:57:32 | officiant | 3 | 148641 | 23 | 32.580 | 4562.3 |
| 335 | 2025-01-14 11:22:36 | officiant | 4 | 165329 | 102 | 52.543 | 3146.5 |
| 334 | 2025-01-14 11:22:43 | officiant | 3 | 148641 | 23 | 33.670 | 4414.6 |
| 333 | 2025-01-14 11:22:46 | officiant | 2 | 121436 | 8 | 13.296 | 9133.3 |
| 332 | 2025-01-14 11:21:38 | officiant | 1 | 81242 | 2 | 7.020 | 11572.9 |
| 331 | 2025-01-05 22:13:32 | officiant | 1 | 81242 | 2 | 1.186 | 68500.8 |
| 330 | 2024-12-25 08:40:21 | officiant | 1 | 81242 | 2 | 3.453 | 23527.9 |
| 329 | 2024-12-21 03:55:22 | officiant | 1 | 81242 | 2 | 6.106 | 13305.3 |
| 328 | 2024-12-17 19:39:53 | officiant | 2 | 121436 | 8 | 16.546 | 7339.3 |
| 327 | 2024-12-17 14:55:28 | officiant | 3 | 148641 | 23 | 27.953 | 5317.5 |
| 326 | 2024-12-15 04:18:56 | officiant | 3 | 148641 | 23 | 40.936 | 3631.1 |
| 325 | 2024-12-11 14:41:16 | officiant | 3 | 148641 | 23 | 34.020 | 4369.2 |
| 324 | 2024-12-05 03:22:45 | officiant | 3 | 148641 | 23 | 47.456 | 3132.2 |
| 323 | 2024-12-05 03:22:51 | officiant | 2 | 121436 | 8 | 14.300 | 8492.0 |
| 322 | 2024-11-19 20:11:50 | officiant | 1 | 81242 | 2 | 6.266 | 12965.5 |
| 321 | 2024-11-16 15:49:04 | officiant | 3 | 148641 | 23 | 31.720 | 4686.0 |
| 320 | 2024-11-16 15:48:57 | officiant | 3 | 148641 | 23 | 18.453 | 8055.1 |
| 319 | 2024-11-16 15:14:48 | officiant | 1 | 81242 | 2 | 1.830 | 44394.5 |
| 318 | 2024-11-07 11:58:21 | officiant | 3 | 148641 | 23 | 38.296 | 3881.4 |
| 317 | 2024-11-07 11:58:19 | officiant | 3 | 148641 | 23 | 38.736 | 3837.3 |
| 316 | 2024-11-07 11:58:23 | officiant | 2 | 121436 | 8 | 15.186 | 7996.6 |
| 315 | 2024-11-07 11:08:51 | officiant | 1 | 81242 | 2 | 3.266 | 24875.1 |
| 314 | 2024-10-29 09:53:28 | officiant | 2 | 121436 | 8 | 10.970 | 11069.8 |
| 313 | 2024-10-28 20:53:36 | officiant | 1 | 81242 | 2 | 3.876 | 20960.3 |
| 312 | 2024-10-21 21:39:10 | officiant | 2 | 121436 | 8 | 15.470 | 7849.8 |
| 311 | 2024-10-19 19:18:54 | officiant | 3 | 148641 | 23 | 35.706 | 4162.9 |
| 310 | 2024-10-19 19:18:58 | officiant | 2 | 121436 | 8 | 25.816 | 4703.9 |
| 309 | 2024-10-17 21:28:09 | officiant | 1 | 81242 | 2 | 9.376 | 8664.9 |
| 308 | 2024-10-06 01:47:59 | officiant | 3 | 148641 | 23 | 37.486 | 3965.2 |
| 307 | 2024-10-01 15:13:21 | officiant | 3 | 148641 | 23 | 58.596 | 2536.7 |
| 306 | 2024-09-25 19:20:32 | officiant | 3 | 148641 | 23 | 42.800 | 3472.9 |
| 305 | 2024-09-22 20:38:04 | officiant | 3 | 148641 | 23 | 57.516 | 2584.3 |
| 304 | 2024-09-22 00:13:27 | officiant | 3 | 148641 | 23 | 54.206 | 2742.2 |
| 303 | 2024-09-22 00:13:26 | officiant | 3 | 148641 | 23 | 32.876 | 4521.3 |
| 302 | 2024-09-22 00:13:29 | officiant | 2 | 121436 | 8 | 26.313 | 4615.1 |
| 301 | 2024-09-16 17:30:42 | officiant | 1 | 81242 | 2 | 4.580 | 17738.4 |
| 300 | 2024-08-28 11:24:59 | officiant | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 299 | 2024-08-06 21:58:23 | officiant | 2 | 121436 | 8 | 8.110 | 14973.6 |
| 298 | 2024-08-04 06:47:08 | officiant | 3 | 148641 | 23 | 37.033 | 4013.7 |
| 297 | 2024-08-04 06:47:00 | officiant | 2 | 121436 | 8 | 20.156 | 6024.8 |
| 296 | 2024-08-04 06:43:05 | officiant | 1 | 81242 | 2 | 2.813 | 28880.9 |
| 295 | 2024-07-20 15:56:56 | officiant | 3 | 148641 | 23 | 12.920 | 11504.7 |
| 294 | 2024-07-20 10:42:04 | officiant | 4 | 165329 | 102 | 36.143 | 4574.3 |
| 293 | 2024-07-19 04:00:19 | officiant | 3 | 148641 | 23 | 19.253 | 7720.4 |
| 292 | 2024-07-17 20:18:30 | officiant | 3 | 148641 | 23 | 39.300 | 3782.2 |
| 291 | 2024-07-17 20:18:31 | officiant | 2 | 121436 | 8 | 15.453 | 7858.4 |
| 290 | 2024-07-17 20:16:07 | officiant | 1 | 81242 | 2 | 1.843 | 44081.4 |
| 289 | 2024-07-17 13:51:15 | officiant | 4 | 165329 | 102 | 42.130 | 3924.3 |