History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"licencees"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 394 | 2024-12-16 06:44:33 | licencees | 3 | 148641 | 37 | 37.173 | 3998.6 |
| 393 | 2024-12-16 06:43:54 | licencees | 2 | 121436 | 13 | 27.690 | 4385.6 |
| 392 | 2024-12-16 06:43:45 | licencees | 3 | 148641 | 37 | 33.206 | 4476.3 |
| 391 | 2024-12-16 06:42:48 | licencees | 1 | 81242 | 5 | 6.390 | 12713.9 |
| 390 | 2024-12-15 22:50:20 | licencees | 3 | 148641 | 37 | 41.036 | 3622.2 |
| 389 | 2024-12-15 22:48:38 | licencees | 1 | 81242 | 5 | 6.610 | 12290.8 |
| 388 | 2024-11-28 18:11:34 | licencees | 1 | 81242 | 5 | 4.296 | 18911.1 |
| 387 | 2024-11-17 23:04:04 | licencees | 3 | 148641 | 37 | 34.376 | 4324.0 |
| 386 | 2024-11-17 23:03:57 | licencees | 2 | 121436 | 13 | 16.300 | 7450.1 |
| 385 | 2024-11-17 23:03:32 | licencees | 1 | 81242 | 5 | 5.236 | 15516.0 |
| 384 | 2024-11-17 11:01:55 | licencees | 3 | 148641 | 37 | 38.360 | 3874.9 |
| 383 | 2024-11-17 11:01:10 | licencees | 2 | 121436 | 13 | 17.686 | 6866.2 |
| 382 | 2024-11-13 09:56:50 | licencees | 3 | 148641 | 37 | 33.610 | 4422.5 |
| 381 | 2024-11-13 09:56:49 | licencees | 2 | 121436 | 13 | 9.330 | 13015.6 |
| 380 | 2024-11-13 09:55:50 | licencees | 1 | 81242 | 5 | 3.766 | 21572.5 |
| 379 | 2024-11-10 18:12:54 | licencees | 1 | 81242 | 5 | 9.610 | 8453.9 |
| 378 | 2024-10-24 13:26:43 | licencees | 1 | 81242 | 5 | 3.203 | 25364.3 |
| 377 | 2024-10-17 22:17:06 | licencees | 1 | 81242 | 5 | 9.466 | 8582.5 |
| 376 | 2024-10-13 21:27:01 | licencees | 3 | 148641 | 37 | 35.973 | 4132.0 |
| 375 | 2024-10-11 07:56:17 | licencees | 3 | 148641 | 37 | 25.110 | 5919.6 |
| 374 | 2024-10-11 06:36:18 | licencees | 3 | 148641 | 37 | 27.780 | 5350.6 |
| 373 | 2024-10-11 06:36:19 | licencees | 2 | 121436 | 13 | 17.796 | 6823.8 |
| 372 | 2024-10-11 06:34:11 | licencees | 1 | 81242 | 5 | 3.123 | 26014.1 |
| 371 | 2024-10-09 21:15:24 | licencees | 4 | 165329 | 335 | 62.280 | 2654.6 |
| 370 | 2024-10-09 19:22:03 | licencees | 4 | 165329 | 335 | 57.810 | 2859.9 |
| 369 | 2024-10-09 04:59:08 | licencees | 4 | 165329 | 335 | 63.606 | 2599.3 |
| 368 | 2024-10-08 19:31:49 | licencees | 4 | 165329 | 335 | 80.536 | 2052.9 |
| 367 | 2024-10-08 19:31:49 | licencees | 2 | 121436 | 13 | 33.143 | 3664.0 |
| 366 | 2024-10-08 19:31:48 | licencees | 3 | 148641 | 37 | 28.473 | 5220.4 |
| 365 | 2024-10-08 02:31:32 | licencees | 1 | 81242 | 5 | 5.000 | 16248.4 |
| 364 | 2024-09-03 21:28:01 | licencees | 1 | 81242 | 5 | 5.733 | 14170.9 |
| 363 | 2024-08-29 14:38:41 | licencees | 1 | 81242 | 5 | 1.236 | 65729.8 |
| 362 | 2024-08-16 20:16:40 | licencees | 1 | 81242 | 5 | 9.873 | 8228.7 |
| 361 | 2024-08-05 20:12:02 | licencees | 1 | 81242 | 5 | 5.016 | 16196.6 |
| 360 | 2024-08-05 08:20:37 | licencees | 1 | 81242 | 5 | 4.956 | 16392.7 |
| 359 | 2024-08-04 19:53:48 | licencees | 1 | 81242 | 5 | 5.283 | 15378.0 |
| 358 | 2024-08-02 11:01:49 | licencees | 1 | 81242 | 5 | 3.406 | 23852.6 |
| 357 | 2024-08-01 00:08:59 | licencees | 1 | 81242 | 5 | 6.670 | 12180.2 |
| 356 | 2024-07-31 22:39:16 | licencees | 1 | 81242 | 5 | 4.766 | 17046.2 |
| 355 | 2024-07-22 20:23:13 | licencees | 1 | 81242 | 5 | 5.110 | 15898.6 |
| 354 | 2024-07-20 01:26:37 | licencees | 1 | 81242 | 5 | 5.080 | 15992.5 |
| 353 | 2024-07-19 17:10:41 | licencees | 1 | 81242 | 5 | 2.530 | 32111.5 |
| 352 | 2024-07-07 22:56:14 | licencees | 1 | 81242 | 5 | 6.580 | 12346.8 |
| 351 | 2024-06-24 09:39:02 | licencees | 1 | 81242 | 5 | 3.750 | 21664.5 |
| 350 | 2024-06-24 01:34:38 | licencees | 1 | 81242 | 5 | 2.330 | 34867.8 |
| 349 | 2024-06-16 10:00:19 | licencees | 1 | 81242 | 5 | 3.563 | 22801.6 |
| 348 | 2024-06-13 17:10:25 | licencees | 1 | 81242 | 5 | 4.953 | 16402.6 |
| 347 | 2024-06-11 22:28:46 | licencees | 1 | 81242 | 5 | 4.826 | 16834.2 |
| 346 | 2024-06-09 05:57:37 | licencees | 1 | 81242 | 5 | 4.860 | 16716.5 |
| 345 | 2024-06-03 03:14:49 | licencees | 1 | 81242 | 5 | 1.250 | 64993.6 |
| 344 | 2024-06-02 17:12:13 | licencees | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 343 | 2024-05-14 09:44:33 | licencees | 3 | 148641 | 37 | 21.470 | 6923.2 |
| 342 | 2024-05-14 03:35:36 | licencees | 2 | 121436 | 13 | 3.403 | 35685.0 |
| 341 | 2024-05-11 06:13:35 | licencees | 1 | 81242 | 5 | 1.610 | 50460.9 |
| 340 | 2024-05-08 07:27:30 | licencees | 2 | 121436 | 13 | 8.096 | 14999.5 |
| 339 | 2024-05-08 06:25:51 | licencees | 1 | 81242 | 5 | 4.200 | 19343.3 |
| 338 | 2024-05-07 00:18:23 | licencees | 3 | 148641 | 37 | 7.063 | 21045.0 |
| 337 | 2024-05-03 04:27:28 | licencees | 1 | 81242 | 5 | 3.000 | 27080.7 |
| 336 | 2024-04-28 03:13:40 | licencees | 1 | 81242 | 5 | 3.110 | 26122.8 |
| 335 | 2024-04-26 14:47:48 | licencees | 1 | 81242 | 5 | 1.530 | 53099.3 |
| 334 | 2024-04-20 12:57:23 | licencees | 3 | 148641 | 37 | 11.546 | 12873.8 |
| 333 | 2024-04-20 06:25:49 | licencees | 3 | 148641 | 37 | 20.076 | 7403.9 |
| 332 | 2024-04-19 16:55:15 | licencees | 3 | 148641 | 37 | 33.343 | 4457.9 |
| 331 | 2024-04-19 16:55:12 | licencees | 2 | 121436 | 13 | 9.873 | 12299.8 |
| 330 | 2024-04-19 14:53:31 | licencees | 1 | 81242 | 5 | 1.373 | 59171.2 |
| 329 | 2024-04-18 07:32:10 | licencees | 4 | 165329 | 335 | 43.643 | 3788.2 |
| 328 | 2024-04-18 07:31:55 | licencees | 4 | 165329 | 335 | 18.093 | 9137.7 |
| 327 | 2024-04-16 19:10:02 | licencees | 4 | 165329 | 335 | 40.173 | 4115.4 |
| 326 | 2024-04-16 19:09:59 | licencees | 3 | 148641 | 37 | 29.096 | 5108.6 |
| 325 | 2024-04-16 19:10:03 | licencees | 2 | 121436 | 13 | 9.093 | 13354.9 |
| 324 | 2024-04-16 17:22:00 | licencees | 1 | 81242 | 5 | 1.673 | 48560.7 |
| 323 | 2024-04-13 14:50:37 | licencees | 1 | 81242 | 5 | 1.346 | 60358.1 |
| 322 | 2024-04-01 17:44:08 | licencees | 2 | 121436 | 13 | 7.610 | 15957.4 |
| 321 | 2024-04-01 15:03:22 | licencees | 1 | 81242 | 5 | 1.500 | 54161.3 |
| 320 | 2024-03-30 19:23:03 | licencees | 1 | 81242 | 5 | 4.533 | 17922.3 |
| 319 | 2024-03-18 00:14:21 | licencees | 4 | 165329 | 335 | 43.096 | 3836.3 |
| 318 | 2024-03-16 19:02:54 | licencees | 4 | 165329 | 335 | 32.186 | 5136.7 |
| 317 | 2024-03-16 19:02:56 | licencees | 3 | 148641 | 37 | 17.406 | 8539.6 |
| 316 | 2024-03-16 19:02:58 | licencees | 2 | 121436 | 13 | 4.233 | 28687.9 |
| 315 | 2024-03-16 18:56:58 | licencees | 1 | 81242 | 5 | 1.406 | 57782.4 |
| 314 | 2024-03-12 00:09:05 | licencees | 1 | 81242 | 5 | 1.423 | 57092.1 |
| 313 | 2024-03-07 03:11:02 | licencees | 2 | 121436 | 13 | 7.843 | 15483.4 |
| 312 | 2024-03-02 05:58:16 | licencees | 1 | 81242 | 5 | 4.596 | 17676.7 |
| 311 | 2024-02-28 23:51:52 | licencees | 1 | 81242 | 5 | 2.560 | 31735.2 |
| 310 | 2024-01-30 06:47:14 | licencees | 1 | 81242 | 5 | 1.436 | 56575.2 |
| 309 | 2024-01-29 11:46:35 | licencees | 1 | 81242 | 5 | 1.403 | 57905.9 |
| 308 | 2024-01-29 11:46:32 | licencees | 1 | 81242 | 5 | 1.720 | 47233.7 |
| 307 | 2024-01-18 08:51:43 | licencees | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 306 | 2024-01-15 18:25:36 | licencees | 1 | 81242 | 5 | 1.360 | 59736.8 |
| 305 | 2023-12-29 13:12:46 | licencees | 1 | 81242 | 5 | 1.186 | 68500.8 |
| 304 | 2023-12-25 06:17:20 | licencees | 1 | 81242 | 5 | 1.203 | 67532.8 |
| 303 | 2023-12-08 05:21:41 | licencees | 1 | 81242 | 5 | 1.390 | 58447.5 |
| 302 | 2023-11-22 23:49:51 | licencees | 2 | 121436 | 13 | 3.156 | 38477.8 |
| 301 | 2023-11-03 13:14:38 | licencees | 1 | 81242 | 5 | 1.393 | 58321.6 |
| 300 | 2023-10-30 17:02:38 | licencees | 3 | 148641 | 37 | 7.703 | 19296.5 |
| 299 | 2023-10-26 20:14:16 | licencees | 1 | 81242 | 5 | 1.216 | 66810.9 |
| 298 | 2023-10-17 13:44:37 | licencees | 1 | 81242 | 5 | 1.216 | 66810.9 |
| 297 | 2023-09-09 03:07:58 | licencees | 1 | 81242 | 5 | 1.206 | 67364.8 |
| 296 | 2023-08-23 10:29:15 | licencees | 2 | 121436 | 13 | 3.156 | 38477.8 |
| 295 | 2023-08-14 10:54:42 | licencees | 1 | 81242 | 5 | 1.216 | 66810.9 |