History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"merchants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 408 | 2025-11-24 04:00:03 | merchants | 1 | 81242 | 2 | 9.800 | 8290.0 |
| 407 | 2025-11-19 03:37:35 | merchants | 1 | 81242 | 2 | 1.890 | 42985.2 |
| 406 | 2025-11-19 02:05:00 | merchants | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 405 | 2025-11-13 19:29:15 | merchants | 1 | 81242 | 2 | 1.716 | 47343.8 |
| 404 | 2025-11-09 07:32:46 | merchants | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 403 | 2025-11-08 15:22:45 | merchants | 2 | 121436 | 6 | 3.330 | 36467.3 |
| 402 | 2025-11-08 11:11:31 | merchants | 3 | 148641 | 45 | 6.483 | 22927.8 |
| 401 | 2025-11-05 12:26:04 | merchants | 4 | 165329 | 363 | 12.030 | 13743.1 |
| 400 | 2025-10-30 08:02:03 | merchants | 4 | 165329 | 363 | 59.346 | 2785.8 |
| 399 | 2025-10-25 10:14:01 | merchants | 1 | 81242 | 2 | 1.893 | 42917.1 |
| 398 | 2025-10-19 03:04:56 | merchants | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 397 | 2025-10-19 03:04:55 | merchants | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 396 | 2025-10-17 04:34:54 | merchants | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 395 | 2025-10-02 07:27:24 | merchants | 3 | 148641 | 45 | 6.296 | 23608.8 |
| 394 | 2025-10-01 21:16:26 | merchants | 1 | 81242 | 2 | 1.266 | 64172.2 |
| 393 | 2025-09-28 08:51:19 | merchants | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 392 | 2025-09-27 21:45:31 | merchants | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 391 | 2025-09-27 10:05:33 | merchants | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 390 | 2025-09-22 10:58:51 | merchants | 4 | 165329 | 363 | 11.970 | 13811.9 |
| 389 | 2025-09-21 10:38:20 | merchants | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 388 | 2025-09-21 05:17:24 | merchants | 1 | 81242 | 2 | 1.300 | 62493.8 |
| 387 | 2025-09-17 02:45:12 | merchants | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 386 | 2025-09-15 04:41:26 | merchants | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 385 | 2025-08-28 08:19:16 | merchants | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 384 | 2025-08-17 03:25:27 | merchants | 1 | 81242 | 2 | 3.046 | 26671.7 |
| 383 | 2025-08-12 08:39:13 | merchants | 1 | 81242 | 2 | 6.923 | 11735.1 |
| 382 | 2025-08-06 14:37:20 | merchants | 4 | 165329 | 363 | 49.206 | 3359.9 |
| 381 | 2025-08-05 12:36:42 | merchants | 1 | 81242 | 2 | 3.250 | 24997.5 |
| 380 | 2025-08-01 02:23:40 | merchants | 4 | 165329 | 363 | 54.863 | 3013.5 |
| 379 | 2025-07-28 21:30:32 | merchants | 4 | 165329 | 363 | 62.973 | 2625.4 |
| 378 | 2025-07-25 17:26:04 | merchants | 1 | 81242 | 2 | 5.876 | 13826.1 |
| 377 | 2025-07-22 11:26:48 | merchants | 1 | 81242 | 2 | 7.060 | 11507.4 |
| 376 | 2025-07-19 00:14:02 | merchants | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 375 | 2025-07-16 01:24:27 | merchants | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 374 | 2025-07-13 12:58:01 | merchants | 4 | 165329 | 363 | 11.110 | 14881.1 |
| 373 | 2025-07-02 07:03:52 | merchants | 3 | 148641 | 45 | 25.470 | 5835.9 |
| 372 | 2025-06-30 22:28:22 | merchants | 3 | 148641 | 45 | 7.953 | 18689.9 |
| 371 | 2025-06-30 07:43:29 | merchants | 3 | 148641 | 45 | 37.706 | 3942.1 |
| 370 | 2025-06-28 16:37:38 | merchants | 2 | 121436 | 6 | 15.143 | 8019.3 |
| 369 | 2025-06-28 14:46:59 | merchants | 3 | 148641 | 45 | 46.126 | 3222.5 |
| 368 | 2025-06-28 09:18:26 | merchants | 3 | 148641 | 45 | 37.453 | 3968.7 |
| 367 | 2025-06-28 04:43:15 | merchants | 4 | 165329 | 363 | 59.676 | 2770.4 |
| 366 | 2025-06-26 22:14:30 | merchants | 1 | 81242 | 2 | 6.766 | 12007.4 |
| 365 | 2025-06-26 18:23:39 | merchants | 4 | 165329 | 363 | 73.366 | 2253.5 |
| 364 | 2025-06-26 14:43:09 | merchants | 2 | 121436 | 6 | 22.156 | 5481.0 |
| 363 | 2025-06-24 21:47:00 | merchants | 3 | 148641 | 45 | 8.046 | 18473.9 |
| 362 | 2025-06-23 07:59:50 | merchants | 1 | 81242 | 2 | 4.123 | 19704.6 |
| 361 | 2025-06-14 11:14:46 | merchants | 1 | 81242 | 2 | 3.966 | 20484.6 |
| 360 | 2025-05-31 06:23:12 | merchants | 1 | 81242 | 2 | 6.890 | 11791.3 |
| 359 | 2025-05-26 17:26:07 | merchants | 2 | 121436 | 6 | 13.423 | 9046.9 |
| 358 | 2025-05-21 02:02:01 | merchants | 3 | 148641 | 45 | 49.750 | 2987.8 |
| 357 | 2025-05-20 06:29:20 | merchants | 1 | 81242 | 2 | 6.750 | 12035.9 |
| 356 | 2025-05-17 05:59:19 | merchants | 1 | 81242 | 2 | 7.110 | 11426.4 |
| 355 | 2025-05-16 03:11:24 | merchants | 1 | 81242 | 2 | 7.033 | 11551.5 |
| 354 | 2025-05-12 14:35:40 | merchants | 2 | 121436 | 6 | 14.250 | 8521.8 |
| 353 | 2025-05-11 21:39:06 | merchants | 3 | 148641 | 45 | 39.406 | 3772.0 |
| 352 | 2025-05-08 11:08:19 | merchants | 1 | 81242 | 2 | 3.126 | 25989.1 |
| 351 | 2025-05-05 22:41:54 | merchants | 1 | 81242 | 2 | 6.763 | 12012.7 |
| 350 | 2025-05-04 15:38:24 | merchants | 4 | 165329 | 363 | 46.596 | 3548.1 |
| 349 | 2025-05-04 06:07:01 | merchants | 4 | 165329 | 363 | 59.110 | 2797.0 |
| 348 | 2025-05-02 02:32:08 | merchants | 4 | 165329 | 363 | 71.550 | 2310.7 |
| 347 | 2025-04-29 05:50:31 | merchants | 1 | 81242 | 2 | 5.220 | 15563.6 |
| 346 | 2025-04-06 03:07:47 | merchants | 1 | 81242 | 2 | 3.983 | 20397.2 |
| 345 | 2025-04-02 14:53:15 | merchants | 4 | 165329 | 363 | 73.346 | 2254.1 |
| 344 | 2025-03-31 17:16:47 | merchants | 4 | 165329 | 363 | 91.460 | 1807.7 |
| 343 | 2025-03-29 12:27:31 | merchants | 2 | 121436 | 6 | 20.940 | 5799.2 |
| 342 | 2025-03-29 03:15:36 | merchants | 4 | 165329 | 363 | 77.036 | 2146.1 |
| 341 | 2025-03-24 02:28:36 | merchants | 3 | 148641 | 45 | 27.123 | 5480.3 |
| 340 | 2025-03-20 00:18:55 | merchants | 3 | 148641 | 45 | 43.723 | 3399.6 |
| 339 | 2025-03-17 18:53:49 | merchants | 1 | 81242 | 2 | 5.953 | 13647.2 |
| 338 | 2025-03-17 07:16:42 | merchants | 3 | 148641 | 45 | 28.563 | 5204.0 |
| 337 | 2025-03-08 08:34:55 | merchants | 1 | 81242 | 2 | 9.966 | 8151.9 |
| 336 | 2025-03-07 10:14:27 | merchants | 3 | 148641 | 45 | 19.766 | 7520.0 |
| 335 | 2025-02-25 10:48:20 | merchants | 3 | 148641 | 45 | 7.283 | 20409.3 |
| 334 | 2025-02-23 19:15:39 | merchants | 3 | 148641 | 45 | 32.390 | 4589.1 |
| 333 | 2025-02-21 05:26:59 | merchants | 1 | 81242 | 2 | 9.623 | 8442.5 |
| 332 | 2025-02-19 00:24:06 | merchants | 3 | 148641 | 45 | 32.050 | 4637.8 |
| 331 | 2025-02-15 02:18:19 | merchants | 3 | 148641 | 45 | 28.826 | 5156.5 |
| 330 | 2025-01-30 17:31:36 | merchants | 3 | 148641 | 45 | 41.816 | 3554.6 |
| 329 | 2025-01-30 17:29:01 | merchants | 1 | 81242 | 2 | 2.516 | 32290.1 |
| 328 | 2025-01-29 22:38:44 | merchants | 3 | 148641 | 45 | 33.766 | 4402.1 |
| 327 | 2025-01-25 16:19:51 | merchants | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 326 | 2025-01-20 22:09:26 | merchants | 2 | 121436 | 6 | 18.046 | 6729.2 |
| 325 | 2025-01-20 22:06:44 | merchants | 1 | 81242 | 2 | 4.970 | 16346.5 |
| 324 | 2025-01-19 17:01:42 | merchants | 3 | 148641 | 45 | 38.096 | 3901.7 |
| 323 | 2025-01-18 20:14:07 | merchants | 3 | 148641 | 45 | 27.796 | 5347.6 |
| 322 | 2025-01-18 20:13:45 | merchants | 1 | 81242 | 2 | 6.936 | 11713.1 |
| 321 | 2024-12-30 16:04:02 | merchants | 3 | 148641 | 45 | 36.660 | 4054.6 |
| 320 | 2024-12-30 01:01:00 | merchants | 3 | 148641 | 45 | 49.330 | 3013.2 |
| 319 | 2024-12-29 11:48:58 | merchants | 1 | 81242 | 2 | 5.236 | 15516.0 |
| 318 | 2024-12-26 08:42:53 | merchants | 1 | 81242 | 2 | 6.843 | 11872.3 |
| 317 | 2024-12-25 18:46:11 | merchants | 2 | 121436 | 6 | 14.190 | 8557.9 |
| 316 | 2024-12-19 15:57:50 | merchants | 2 | 121436 | 6 | 16.063 | 7560.0 |
| 315 | 2024-12-19 15:57:44 | merchants | 1 | 81242 | 2 | 6.813 | 11924.6 |
| 314 | 2024-12-19 06:12:59 | merchants | 3 | 148641 | 45 | 37.993 | 3912.3 |
| 313 | 2024-12-18 00:58:53 | merchants | 1 | 81242 | 2 | 6.750 | 12035.9 |
| 312 | 2024-11-29 15:45:05 | merchants | 3 | 148641 | 45 | 34.333 | 4329.4 |
| 311 | 2024-11-25 17:32:26 | merchants | 3 | 148641 | 45 | 55.563 | 2675.2 |
| 310 | 2024-11-24 10:38:21 | merchants | 3 | 148641 | 45 | 36.926 | 4025.4 |
| 309 | 2024-11-23 09:46:05 | merchants | 3 | 148641 | 45 | 38.003 | 3911.3 |