History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"phonier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 406 | 2025-05-07 19:15:17 | phonier | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 405 | 2025-05-07 15:57:40 | phonier | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 404 | 2025-05-06 01:51:18 | phonier | 1 | 69583 | 3 | 4.923 | 14134.3 |
| 403 | 2025-04-24 08:01:45 | phonier | 3 | 134027 | 506 | 24.063 | 5569.8 |
| 402 | 2025-04-23 21:57:10 | phonier | 3 | 134027 | 506 | 42.226 | 3174.0 |
| 401 | 2025-04-23 06:47:07 | phonier | 2 | 107671 | 46 | 14.610 | 7369.7 |
| 400 | 2025-04-23 05:04:34 | phonier | 3 | 134027 | 506 | 30.486 | 4396.3 |
| 399 | 2025-04-21 17:58:39 | phonier | 2 | 107671 | 46 | 9.830 | 10953.3 |
| 398 | 2025-04-21 17:30:24 | phonier | 3 | 134027 | 506 | 42.190 | 3176.7 |
| 397 | 2025-04-20 09:18:01 | phonier | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 396 | 2025-04-16 16:13:58 | phonier | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 395 | 2025-04-15 21:59:17 | phonier | 1 | 69583 | 3 | 8.696 | 8001.7 |
| 394 | 2025-04-08 13:23:45 | phonier | 1 | 69583 | 3 | 4.673 | 14890.4 |
| 393 | 2025-04-02 01:36:58 | phonier | 1 | 69583 | 3 | 4.360 | 15959.4 |
| 392 | 2025-03-23 03:28:18 | phonier | 1 | 69583 | 3 | 2.686 | 25905.8 |
| 391 | 2025-03-20 11:39:16 | phonier | 1 | 69583 | 3 | 6.106 | 11395.8 |
| 390 | 2025-03-16 02:05:22 | phonier | 1 | 69583 | 3 | 5.546 | 12546.5 |
| 389 | 2025-03-16 00:53:26 | phonier | 2 | 107671 | 46 | 15.816 | 6807.7 |
| 388 | 2025-03-16 00:53:01 | phonier | 1 | 69583 | 3 | 5.546 | 12546.5 |
| 387 | 2025-03-15 17:10:43 | phonier | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 386 | 2025-03-10 20:59:37 | phonier | 2 | 107671 | 46 | 14.140 | 7614.6 |
| 385 | 2025-03-10 17:58:27 | phonier | 2 | 107671 | 46 | 27.033 | 3982.9 |
| 384 | 2025-03-10 16:32:41 | phonier | 3 | 134027 | 506 | 23.050 | 5814.6 |
| 383 | 2025-03-10 15:25:05 | phonier | 3 | 134027 | 506 | 33.596 | 3989.4 |
| 382 | 2025-03-10 13:44:00 | phonier | 3 | 134027 | 506 | 39.113 | 3426.7 |
| 381 | 2025-03-10 13:43:58 | phonier | 2 | 107671 | 46 | 18.283 | 5889.1 |
| 380 | 2025-03-05 22:27:34 | phonier | 1 | 69583 | 3 | 5.203 | 13373.6 |
| 379 | 2025-02-27 02:29:01 | phonier | 1 | 69583 | 3 | 8.296 | 8387.5 |
| 378 | 2025-02-19 20:12:37 | phonier | 1 | 69583 | 3 | 4.406 | 15792.8 |
| 377 | 2025-01-27 16:00:38 | phonier | 2 | 107671 | 46 | 8.076 | 13332.2 |
| 376 | 2025-01-27 15:58:58 | phonier | 3 | 134027 | 506 | 19.800 | 6769.0 |
| 375 | 2025-01-27 15:10:12 | phonier | 3 | 134027 | 506 | 7.313 | 18327.2 |
| 374 | 2025-01-27 13:46:34 | phonier | 3 | 134027 | 506 | 36.283 | 3693.9 |
| 373 | 2025-01-27 13:46:36 | phonier | 2 | 107671 | 46 | 16.033 | 6715.6 |
| 372 | 2025-01-27 13:45:18 | phonier | 1 | 69583 | 3 | 4.763 | 14609.1 |
| 371 | 2025-01-23 15:41:30 | phonier | 1 | 69583 | 3 | 5.736 | 12130.9 |
| 370 | 2025-01-15 06:06:05 | phonier | 1 | 69583 | 3 | 3.420 | 20345.9 |
| 369 | 2024-12-28 08:56:48 | phonier | 1 | 69583 | 3 | 6.953 | 10007.6 |
| 368 | 2024-12-15 14:33:42 | phonier | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 367 | 2024-12-08 00:47:31 | phonier | 1 | 69583 | 3 | 4.330 | 16070.0 |
| 366 | 2024-11-11 05:08:45 | phonier | 2 | 107671 | 46 | 23.580 | 4566.2 |
| 365 | 2024-11-11 00:59:09 | phonier | 2 | 107671 | 46 | 15.986 | 6735.3 |
| 364 | 2024-11-10 05:30:53 | phonier | 2 | 107671 | 46 | 23.203 | 4640.4 |
| 363 | 2024-11-09 13:03:23 | phonier | 2 | 107671 | 46 | 15.140 | 7111.7 |
| 362 | 2024-11-09 06:30:53 | phonier | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 361 | 2024-10-28 13:38:06 | phonier | 1 | 69583 | 3 | 2.923 | 23805.3 |
| 360 | 2024-10-10 18:21:48 | phonier | 3 | 134027 | 506 | 25.610 | 5233.4 |
| 359 | 2024-10-08 22:21:14 | phonier | 1 | 69583 | 3 | 6.376 | 10913.3 |
| 358 | 2024-10-08 06:23:45 | phonier | 3 | 134027 | 506 | 48.080 | 2787.6 |
| 357 | 2024-10-07 08:04:15 | phonier | 1 | 69583 | 3 | 5.890 | 11813.8 |
| 356 | 2024-10-04 08:03:10 | phonier | 3 | 134027 | 506 | 50.986 | 2628.7 |
| 355 | 2024-10-03 07:46:25 | phonier | 3 | 134027 | 506 | 38.940 | 3441.9 |
| 354 | 2024-10-03 07:46:27 | phonier | 2 | 107671 | 46 | 26.063 | 4131.2 |
| 353 | 2024-09-27 10:38:36 | phonier | 1 | 69583 | 3 | 4.046 | 17198.0 |
| 352 | 2024-09-12 04:04:59 | phonier | 1 | 69583 | 3 | 13.970 | 4980.9 |
| 351 | 2024-09-07 22:35:52 | phonier | 1 | 69583 | 3 | 14.716 | 4728.4 |
| 350 | 2024-09-06 02:22:53 | phonier | 1 | 69583 | 3 | 8.250 | 8434.3 |
| 349 | 2024-08-27 07:16:16 | phonier | 1 | 69583 | 3 | 5.483 | 12690.7 |
| 348 | 2024-08-09 17:24:23 | phonier | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 347 | 2024-08-05 02:11:23 | phonier | 1 | 69583 | 3 | 5.686 | 12237.6 |
| 346 | 2024-07-31 07:16:27 | phonier | 1 | 69583 | 3 | 3.373 | 20629.4 |
| 345 | 2024-07-31 05:06:11 | phonier | 1 | 69583 | 3 | 8.686 | 8010.9 |
| 344 | 2024-07-19 11:22:23 | phonier | 1 | 69583 | 3 | 4.440 | 15671.8 |
| 343 | 2024-07-11 19:45:32 | phonier | 1 | 69583 | 3 | 2.326 | 29915.3 |
| 342 | 2024-07-11 14:11:11 | phonier | 1 | 69583 | 3 | 2.856 | 24363.8 |
| 341 | 2024-07-06 03:39:18 | phonier | 1 | 69583 | 3 | 3.423 | 20328.1 |
| 340 | 2024-07-05 17:21:12 | phonier | 1 | 69583 | 3 | 5.530 | 12582.8 |
| 339 | 2024-07-03 01:40:35 | phonier | 1 | 69583 | 3 | 6.156 | 11303.3 |
| 338 | 2024-06-22 19:30:56 | phonier | 1 | 69583 | 3 | 2.513 | 27689.2 |
| 337 | 2024-06-21 07:06:15 | phonier | 1 | 69583 | 3 | 6.390 | 10889.4 |
| 336 | 2024-06-13 02:06:43 | phonier | 1 | 69583 | 3 | 2.080 | 33453.4 |
| 335 | 2024-06-07 12:08:44 | phonier | 1 | 69583 | 3 | 5.216 | 13340.3 |
| 334 | 2024-05-05 10:04:06 | phonier | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 333 | 2024-04-30 20:29:24 | phonier | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 332 | 2024-04-27 04:56:13 | phonier | 1 | 69583 | 3 | 2.716 | 25619.7 |
| 331 | 2024-03-30 04:26:35 | phonier | 1 | 69583 | 3 | 1.376 | 50569.0 |
| 330 | 2024-03-29 07:18:01 | phonier | 1 | 69583 | 3 | 3.483 | 19977.9 |
| 329 | 2024-03-28 07:50:10 | phonier | 1 | 69583 | 3 | 2.846 | 24449.4 |
| 328 | 2024-03-17 04:17:43 | phonier | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 327 | 2024-03-03 12:20:16 | phonier | 1 | 69583 | 3 | 2.106 | 33040.4 |
| 326 | 2023-12-31 11:30:09 | phonier | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 325 | 2023-12-09 11:22:00 | phonier | 3 | 134027 | 506 | 6.406 | 20922.1 |
| 324 | 2023-12-09 11:21:58 | phonier | 2 | 107671 | 46 | 3.080 | 34958.1 |
| 323 | 2023-11-29 13:41:50 | phonier | 1 | 69583 | 3 | 2.326 | 29915.3 |
| 322 | 2023-11-26 16:29:04 | phonier | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 321 | 2023-11-15 12:41:59 | phonier | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 320 | 2023-11-11 05:40:51 | phonier | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 319 | 2023-11-03 04:42:18 | phonier | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 318 | 2023-10-30 21:47:42 | phonier | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 317 | 2023-10-27 07:29:32 | phonier | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 316 | 2023-10-21 07:26:52 | phonier | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 315 | 2023-10-07 08:16:18 | phonier | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 314 | 2023-09-25 22:39:18 | phonier | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 313 | 2023-09-22 06:02:34 | phonier | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 312 | 2023-08-16 18:29:16 | phonier | 1 | 69583 | 3 | 2.250 | 30925.8 |
| 311 | 2023-07-11 03:26:39 | phonier | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 310 | 2023-05-20 07:05:26 | phonier | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 309 | 2023-03-20 08:59:00 | phonier | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 308 | 2023-03-18 07:04:50 | phonier | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 307 | 2023-01-06 06:04:52 | phonier | 1 | 69583 | 3 | 1.046 | 66522.9 |