History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"condoms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 434 | 2024-04-27 06:36:07 | condoms | 1 | 69583 | 5 | 4.890 | 14229.7 |
| 433 | 2024-04-20 22:06:06 | condoms | 3 | 134027 | 328 | 26.783 | 5004.2 |
| 432 | 2024-04-20 15:09:49 | condoms | 3 | 134027 | 328 | 18.190 | 7368.2 |
| 431 | 2024-04-19 14:09:22 | condoms | 2 | 107671 | 36 | 3.640 | 29579.9 |
| 430 | 2024-04-19 14:00:04 | condoms | 3 | 134027 | 328 | 10.000 | 13402.7 |
| 429 | 2024-04-19 13:56:59 | condoms | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 428 | 2024-04-19 13:56:04 | condoms | 3 | 134027 | 328 | 9.390 | 14273.4 |
| 427 | 2024-04-19 13:54:09 | condoms | 2 | 107671 | 36 | 3.843 | 28017.4 |
| 426 | 2024-04-19 13:47:22 | condoms | 1 | 69583 | 5 | 1.736 | 40082.4 |
| 425 | 2024-04-12 22:05:37 | condoms | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 424 | 2024-04-10 01:53:27 | condoms | 3 | 134027 | 328 | 16.423 | 8160.9 |
| 423 | 2024-04-09 11:00:42 | condoms | 3 | 134027 | 328 | 28.550 | 4694.5 |
| 422 | 2024-04-09 11:00:42 | condoms | 2 | 107671 | 36 | 8.346 | 12900.9 |
| 421 | 2024-04-09 03:30:44 | condoms | 3 | 134027 | 328 | 18.673 | 7177.6 |
| 420 | 2024-04-09 03:30:44 | condoms | 2 | 107671 | 36 | 9.326 | 11545.2 |
| 419 | 2024-04-09 00:26:29 | condoms | 1 | 69583 | 5 | 1.486 | 46825.7 |
| 418 | 2024-03-30 01:57:20 | condoms | 1 | 69583 | 5 | 2.266 | 30707.4 |
| 417 | 2024-03-10 19:50:05 | condoms | 3 | 134027 | 328 | 21.456 | 6246.6 |
| 416 | 2024-03-10 08:18:14 | condoms | 3 | 134027 | 328 | 16.390 | 8177.4 |
| 415 | 2024-03-09 16:00:41 | condoms | 3 | 134027 | 328 | 24.143 | 5551.4 |
| 414 | 2024-03-08 23:58:13 | condoms | 3 | 134027 | 328 | 19.703 | 6802.4 |
| 413 | 2024-03-08 23:58:21 | condoms | 2 | 107671 | 36 | 4.140 | 26007.5 |
| 412 | 2024-03-08 23:04:28 | condoms | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 411 | 2024-02-10 21:11:17 | condoms | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 410 | 2024-02-07 01:41:34 | condoms | 3 | 134027 | 328 | 13.173 | 10174.4 |
| 409 | 2024-02-06 02:27:42 | condoms | 2 | 107671 | 36 | 3.763 | 28613.1 |
| 408 | 2024-02-06 02:27:38 | condoms | 3 | 134027 | 328 | 7.050 | 19010.9 |
| 407 | 2024-02-06 02:24:47 | condoms | 1 | 69583 | 5 | 2.563 | 27149.0 |
| 406 | 2024-01-06 13:21:04 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 405 | 2023-12-29 11:21:59 | condoms | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 404 | 2023-12-25 18:03:42 | condoms | 2 | 107671 | 36 | 3.203 | 33615.7 |
| 403 | 2023-12-02 03:29:06 | condoms | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 402 | 2023-11-21 03:08:38 | condoms | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 401 | 2023-11-10 16:32:08 | condoms | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 400 | 2023-11-01 20:42:47 | condoms | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 399 | 2023-10-28 05:26:00 | condoms | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 398 | 2023-10-23 00:13:31 | condoms | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 397 | 2023-10-18 22:30:14 | condoms | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 396 | 2023-10-11 12:04:03 | condoms | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 395 | 2023-09-30 10:25:14 | condoms | 3 | 134027 | 328 | 5.783 | 23176.0 |
| 394 | 2023-09-30 10:25:08 | condoms | 2 | 107671 | 36 | 3.220 | 33438.2 |
| 393 | 2023-09-26 14:08:30 | condoms | 2 | 107671 | 36 | 3.420 | 31482.7 |
| 392 | 2023-09-24 21:59:16 | condoms | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 391 | 2023-09-17 02:54:35 | condoms | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 390 | 2023-08-15 05:17:26 | condoms | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 389 | 2023-07-13 16:45:20 | condoms | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 388 | 2023-07-06 19:20:07 | condoms | 2 | 107671 | 36 | 2.860 | 37647.2 |
| 387 | 2023-05-16 20:46:33 | condoms | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 386 | 2023-04-02 09:13:37 | condoms | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 385 | 2023-03-24 02:26:54 | condoms | 2 | 107671 | 36 | 2.953 | 36461.6 |
| 384 | 2023-03-12 17:28:15 | condoms | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 383 | 2022-12-31 16:11:19 | condoms | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 382 | 2022-12-28 04:34:12 | condoms | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 381 | 2022-12-23 12:06:16 | condoms | 2 | 107671 | 36 | 2.936 | 36672.7 |
| 380 | 2022-09-19 23:25:38 | condoms | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 379 | 2022-09-13 19:26:18 | condoms | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 378 | 2022-09-10 22:39:22 | condoms | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 377 | 2022-09-01 16:57:00 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 376 | 2022-08-24 05:46:59 | condoms | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 375 | 2022-08-20 23:58:55 | condoms | 2 | 107671 | 36 | 2.936 | 36672.7 |
| 374 | 2022-08-16 04:08:47 | condoms | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 373 | 2022-07-18 20:35:11 | condoms | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 372 | 2022-07-18 10:02:10 | condoms | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 371 | 2022-07-10 12:40:48 | condoms | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 370 | 2022-06-25 17:49:40 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 369 | 2022-06-15 04:48:08 | condoms | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 368 | 2022-05-28 16:47:27 | condoms | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 367 | 2022-05-25 20:25:08 | condoms | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 366 | 2022-05-03 02:46:34 | condoms | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 365 | 2022-04-02 18:46:02 | condoms | 2 | 107671 | 36 | 3.203 | 33615.7 |
| 364 | 2022-02-13 20:38:26 | condoms | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 363 | 2022-01-22 01:35:49 | condoms | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 362 | 2021-11-19 17:24:07 | condoms | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 361 | 2021-11-06 00:54:36 | condoms | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 360 | 2021-10-03 08:42:40 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 359 | 2021-10-01 05:54:01 | condoms | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 358 | 2021-08-25 09:35:48 | condoms | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 357 | 2021-08-23 05:19:55 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 356 | 2021-08-06 07:58:22 | condoms | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 355 | 2021-08-02 20:03:11 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 354 | 2021-05-26 06:20:45 | condoms | 3 | 134027 | 328 | 7.250 | 18486.5 |
| 353 | 2021-05-14 18:17:39 | condoms | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 352 | 2021-04-24 20:57:40 | condoms | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 351 | 2021-04-24 11:06:08 | condoms | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 350 | 2021-04-15 11:44:26 | condoms | 3 | 134027 | 328 | 6.440 | 20811.6 |
| 349 | 2021-03-26 09:20:26 | condoms | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 348 | 2021-02-21 14:05:23 | condoms | 3 | 134027 | 328 | 5.953 | 22514.2 |
| 347 | 2021-01-30 13:04:59 | condoms | 3 | 134027 | 328 | 5.970 | 22450.1 |
| 346 | 2021-01-20 05:26:29 | condoms | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 345 | 2021-01-18 04:45:42 | condoms | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 344 | 2021-01-09 15:28:13 | condoms | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 343 | 2021-01-03 13:19:04 | condoms | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 342 | 2020-12-31 04:37:33 | condoms | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 341 | 2020-11-11 07:33:33 | condoms | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 340 | 2020-10-20 21:08:03 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 339 | 2020-10-17 01:37:26 | condoms | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 338 | 2020-10-12 12:07:35 | condoms | 3 | 134027 | 328 | 6.063 | 22105.7 |
| 337 | 2020-09-27 22:25:41 | condoms | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 336 | 2020-09-02 07:38:52 | condoms | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 335 | 2020-08-02 07:55:33 | condoms | 1 | 69583 | 5 | 1.140 | 61037.7 |