History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"effacement"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 398 | 2025-10-24 23:55:45 | effacement | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 397 | 2025-10-24 12:29:11 | effacement | 1 | 67641 | 2 | 1.123 | 60232.4 |
| 396 | 2025-10-24 07:06:40 | effacement | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 395 | 2025-10-22 23:12:11 | effacement | 1 | 67641 | 2 | 5.530 | 12231.6 |
| 394 | 2025-10-22 23:11:34 | effacement | 1 | 67641 | 2 | 4.436 | 15248.2 |
| 393 | 2025-10-22 12:26:38 | effacement | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 392 | 2025-10-22 12:26:26 | effacement | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 391 | 2025-09-27 06:41:30 | effacement | 1 | 67641 | 2 | 1.266 | 53428.9 |
| 390 | 2025-09-21 01:49:43 | effacement | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 389 | 2025-09-12 08:16:23 | effacement | 2 | 108824 | 4 | 2.906 | 37448.0 |
| 388 | 2025-09-11 15:40:53 | effacement | 3 | 140603 | 23 | 5.250 | 26781.5 |
| 387 | 2025-09-06 09:53:07 | effacement | 3 | 140603 | 23 | 5.500 | 25564.2 |
| 386 | 2025-09-06 02:16:58 | effacement | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 385 | 2025-09-05 23:07:22 | effacement | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 384 | 2025-08-20 07:36:52 | effacement | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 383 | 2025-08-09 07:40:40 | effacement | 1 | 67641 | 2 | 4.983 | 13574.4 |
| 382 | 2025-08-07 20:39:41 | effacement | 1 | 67641 | 2 | 3.466 | 19515.6 |
| 381 | 2025-08-03 02:40:42 | effacement | 1 | 67641 | 2 | 5.250 | 12884.0 |
| 380 | 2025-08-02 18:25:51 | effacement | 1 | 67641 | 2 | 4.826 | 14016.0 |
| 379 | 2025-07-26 13:06:22 | effacement | 1 | 67641 | 2 | 2.266 | 29850.4 |
| 378 | 2025-07-25 04:47:34 | effacement | 1 | 67641 | 2 | 4.953 | 13656.6 |
| 377 | 2025-07-23 18:06:07 | effacement | 1 | 67641 | 2 | 3.656 | 18501.4 |
| 376 | 2025-07-20 22:07:28 | effacement | 1 | 67641 | 2 | 1.126 | 60071.9 |
| 375 | 2025-07-19 09:36:46 | effacement | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 374 | 2025-07-15 17:03:59 | effacement | 1 | 67641 | 2 | 6.953 | 9728.3 |
| 373 | 2025-07-10 17:50:23 | effacement | 1 | 67641 | 2 | 5.580 | 12122.0 |
| 372 | 2025-07-07 19:38:03 | effacement | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 371 | 2025-07-06 22:52:27 | effacement | 1 | 67641 | 2 | 2.986 | 22652.7 |
| 370 | 2025-06-22 06:15:16 | effacement | 1 | 67641 | 2 | 5.360 | 12619.6 |
| 369 | 2025-06-10 08:45:09 | effacement | 1 | 67641 | 2 | 5.143 | 13152.1 |
| 368 | 2025-05-14 06:08:39 | effacement | 1 | 67641 | 2 | 5.296 | 12772.1 |
| 367 | 2025-05-04 05:22:43 | effacement | 1 | 67641 | 2 | 5.466 | 12374.9 |
| 366 | 2025-03-29 17:14:30 | effacement | 1 | 67641 | 2 | 5.626 | 12022.9 |
| 365 | 2025-03-25 09:42:21 | effacement | 1 | 67641 | 2 | 2.656 | 25467.2 |
| 364 | 2025-03-20 01:00:41 | effacement | 1 | 67641 | 2 | 5.110 | 13237.0 |
| 363 | 2025-03-18 06:46:47 | effacement | 1 | 67641 | 2 | 4.546 | 14879.2 |
| 362 | 2025-02-27 08:28:44 | effacement | 2 | 108824 | 4 | 10.966 | 9923.8 |
| 361 | 2025-02-27 07:20:43 | effacement | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 360 | 2025-02-21 14:15:47 | effacement | 1 | 67641 | 2 | 3.500 | 19326.0 |
| 359 | 2025-02-20 09:40:22 | effacement | 1 | 67641 | 2 | 8.423 | 8030.5 |
| 358 | 2025-02-18 12:48:07 | effacement | 3 | 140603 | 23 | 39.406 | 3568.1 |
| 357 | 2025-02-14 05:47:47 | effacement | 3 | 140603 | 23 | 26.516 | 5302.6 |
| 356 | 2025-02-13 04:05:15 | effacement | 2 | 108824 | 4 | 23.220 | 4686.6 |
| 355 | 2025-02-13 04:04:06 | effacement | 1 | 67641 | 2 | 5.966 | 11337.7 |
| 354 | 2025-02-12 07:28:01 | effacement | 3 | 140603 | 23 | 40.423 | 3478.3 |
| 353 | 2025-02-12 03:08:47 | effacement | 2 | 108824 | 4 | 14.046 | 7747.7 |
| 352 | 2025-02-12 03:07:18 | effacement | 1 | 67641 | 2 | 1.500 | 45094.0 |
| 351 | 2025-02-12 03:04:44 | effacement | 4 | 161450 | 105 | 41.766 | 3865.6 |
| 350 | 2025-02-11 22:21:17 | effacement | 4 | 161450 | 105 | 58.376 | 2765.7 |
| 349 | 2025-02-11 21:58:31 | effacement | 4 | 161450 | 105 | 53.846 | 2998.4 |
| 348 | 2025-02-11 18:33:10 | effacement | 4 | 161450 | 105 | 74.963 | 2153.7 |
| 347 | 2025-02-11 18:33:04 | effacement | 3 | 140603 | 23 | 27.513 | 5110.4 |
| 346 | 2025-02-11 18:33:03 | effacement | 2 | 108824 | 4 | 14.390 | 7562.5 |
| 345 | 2025-02-11 18:30:52 | effacement | 1 | 67641 | 2 | 5.393 | 12542.4 |
| 344 | 2025-01-13 11:52:38 | effacement | 3 | 140603 | 23 | 28.046 | 5013.3 |
| 343 | 2025-01-12 01:27:42 | effacement | 1 | 67641 | 2 | 2.733 | 24749.7 |
| 342 | 2025-01-11 18:48:00 | effacement | 3 | 140603 | 23 | 24.690 | 5694.7 |
| 341 | 2025-01-11 18:48:06 | effacement | 2 | 108824 | 4 | 14.360 | 7578.3 |
| 340 | 2025-01-11 18:45:11 | effacement | 1 | 67641 | 2 | 5.550 | 12187.6 |
| 339 | 2025-01-10 08:33:10 | effacement | 4 | 161450 | 105 | 52.190 | 3093.5 |
| 338 | 2025-01-08 12:08:11 | effacement | 4 | 161450 | 105 | 40.953 | 3942.3 |
| 337 | 2025-01-07 16:00:13 | effacement | 4 | 161450 | 105 | 78.686 | 2051.8 |
| 336 | 2025-01-07 14:44:27 | effacement | 4 | 161450 | 105 | 50.033 | 3226.9 |
| 335 | 2025-01-07 14:19:22 | effacement | 1 | 67641 | 2 | 0.983 | 68810.8 |
| 334 | 2024-12-15 07:32:34 | effacement | 3 | 140603 | 23 | 27.470 | 5118.4 |
| 333 | 2024-12-13 01:34:06 | effacement | 3 | 140603 | 23 | 20.940 | 6714.6 |
| 332 | 2024-12-12 02:48:38 | effacement | 3 | 140603 | 23 | 22.940 | 6129.2 |
| 331 | 2024-12-12 02:48:39 | effacement | 2 | 108824 | 4 | 14.220 | 7652.9 |
| 330 | 2024-12-12 02:46:00 | effacement | 1 | 67641 | 2 | 3.810 | 17753.5 |
| 329 | 2024-12-11 13:19:32 | effacement | 1 | 67641 | 2 | 2.643 | 25592.5 |
| 328 | 2024-12-08 10:07:17 | effacement | 1 | 67641 | 2 | 2.813 | 24045.9 |
| 327 | 2024-12-02 22:44:05 | effacement | 2 | 108824 | 4 | 15.000 | 7254.9 |
| 326 | 2024-12-02 22:41:17 | effacement | 1 | 67641 | 2 | 2.800 | 24157.5 |
| 325 | 2024-11-07 21:13:49 | effacement | 3 | 140603 | 23 | 34.410 | 4086.1 |
| 324 | 2024-11-07 21:12:27 | effacement | 1 | 67641 | 2 | 2.516 | 26884.3 |
| 323 | 2024-11-03 13:30:43 | effacement | 3 | 140603 | 23 | 42.093 | 3340.3 |
| 322 | 2024-11-02 20:08:46 | effacement | 3 | 140603 | 23 | 15.500 | 9071.2 |
| 321 | 2024-11-02 20:08:26 | effacement | 2 | 108824 | 4 | 21.780 | 4996.5 |
| 320 | 2024-11-02 18:03:38 | effacement | 3 | 140603 | 23 | 36.503 | 3851.8 |
| 319 | 2024-11-02 18:03:41 | effacement | 2 | 108824 | 4 | 13.356 | 8147.9 |
| 318 | 2024-11-02 18:02:16 | effacement | 3 | 140603 | 23 | 38.983 | 3606.8 |
| 317 | 2024-11-02 17:59:27 | effacement | 1 | 67641 | 2 | 2.796 | 24192.1 |
| 316 | 2024-11-01 03:36:25 | effacement | 2 | 108824 | 4 | 7.236 | 15039.2 |
| 315 | 2024-11-01 03:35:40 | effacement | 1 | 67641 | 2 | 5.673 | 11923.3 |
| 314 | 2024-10-19 02:29:35 | effacement | 1 | 67641 | 2 | 5.813 | 11636.2 |
| 313 | 2024-09-25 16:37:08 | effacement | 1 | 67641 | 2 | 3.860 | 17523.6 |
| 312 | 2024-09-24 09:58:41 | effacement | 2 | 108824 | 4 | 32.173 | 3382.5 |
| 311 | 2024-09-18 23:08:21 | effacement | 2 | 108824 | 4 | 25.376 | 4288.5 |
| 310 | 2024-09-18 23:05:28 | effacement | 1 | 67641 | 2 | 2.923 | 23141.0 |
| 309 | 2024-09-02 09:15:19 | effacement | 1 | 67641 | 2 | 5.186 | 13043.0 |
| 308 | 2024-08-31 09:37:37 | effacement | 3 | 140603 | 23 | 46.706 | 3010.4 |
| 307 | 2024-08-27 20:37:39 | effacement | 3 | 140603 | 23 | 56.566 | 2485.6 |
| 306 | 2024-08-18 06:00:11 | effacement | 3 | 140603 | 23 | 28.050 | 5012.6 |
| 305 | 2024-08-10 00:40:38 | effacement | 3 | 140603 | 23 | 30.470 | 4614.5 |
| 304 | 2024-08-07 18:17:23 | effacement | 3 | 140603 | 23 | 11.003 | 12778.6 |
| 303 | 2024-08-07 18:17:22 | effacement | 2 | 108824 | 4 | 5.343 | 20367.6 |
| 302 | 2024-08-07 18:17:15 | effacement | 3 | 140603 | 23 | 11.563 | 12159.7 |
| 301 | 2024-08-07 17:31:26 | effacement | 1 | 67641 | 2 | 3.843 | 17601.1 |
| 300 | 2024-08-05 06:39:00 | effacement | 1 | 67641 | 2 | 2.110 | 32057.3 |
| 299 | 2024-07-26 03:12:08 | effacement | 3 | 140603 | 23 | 34.753 | 4045.8 |