History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prevention"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 432 | 2025-10-10 16:05:01 | prevention | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 431 | 2025-10-06 19:27:23 | prevention | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 430 | 2025-10-01 15:27:22 | prevention | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 429 | 2025-09-08 23:13:31 | prevention | 4 | 161450 | 271 | 11.313 | 14271.2 |
| 428 | 2025-09-04 12:54:32 | prevention | 4 | 161450 | 271 | 11.923 | 13541.1 |
| 427 | 2025-09-03 02:16:31 | prevention | 3 | 140603 | 64 | 5.890 | 23871.5 |
| 426 | 2025-08-23 06:50:33 | prevention | 1 | 67641 | 2 | 8.436 | 8018.1 |
| 425 | 2025-08-22 01:10:14 | prevention | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 424 | 2025-08-21 16:35:54 | prevention | 1 | 67641 | 2 | 2.563 | 26391.3 |
| 423 | 2025-08-21 14:09:11 | prevention | 3 | 140603 | 64 | 16.970 | 8285.4 |
| 422 | 2025-08-20 05:36:48 | prevention | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 421 | 2025-08-19 14:12:50 | prevention | 3 | 140603 | 64 | 18.516 | 7593.6 |
| 420 | 2025-08-18 20:45:30 | prevention | 2 | 108824 | 8 | 8.970 | 12132.0 |
| 419 | 2025-08-18 12:22:50 | prevention | 1 | 67641 | 2 | 1.080 | 62630.6 |
| 418 | 2025-08-09 10:57:00 | prevention | 1 | 67641 | 2 | 2.923 | 23141.0 |
| 417 | 2025-08-05 11:50:15 | prevention | 1 | 67641 | 2 | 4.453 | 15190.0 |
| 416 | 2025-07-27 09:03:11 | prevention | 1 | 67641 | 2 | 4.810 | 14062.6 |
| 415 | 2025-07-24 20:14:25 | prevention | 1 | 67641 | 2 | 4.076 | 16594.9 |
| 414 | 2025-07-23 20:59:26 | prevention | 1 | 67641 | 2 | 5.220 | 12958.0 |
| 413 | 2025-07-22 16:39:05 | prevention | 1 | 67641 | 2 | 2.780 | 24331.3 |
| 412 | 2025-07-19 13:44:38 | prevention | 1 | 67641 | 2 | 1.300 | 52031.5 |
| 411 | 2025-07-14 16:36:01 | prevention | 3 | 140603 | 64 | 44.423 | 3165.1 |
| 410 | 2025-07-12 23:11:28 | prevention | 1 | 67641 | 2 | 1.280 | 52844.5 |
| 409 | 2025-07-11 14:19:37 | prevention | 3 | 140603 | 64 | 35.423 | 3969.3 |
| 408 | 2025-07-06 10:02:38 | prevention | 1 | 67641 | 2 | 1.173 | 57665.0 |
| 407 | 2025-07-05 11:31:32 | prevention | 3 | 140603 | 64 | 46.580 | 3018.5 |
| 406 | 2025-07-04 10:12:59 | prevention | 1 | 67641 | 2 | 2.343 | 28869.4 |
| 405 | 2025-07-03 09:54:44 | prevention | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 404 | 2025-07-03 08:02:44 | prevention | 1 | 67641 | 2 | 5.906 | 11452.9 |
| 403 | 2025-06-26 08:55:47 | prevention | 1 | 67641 | 2 | 6.203 | 10904.6 |
| 402 | 2025-06-19 23:24:37 | prevention | 2 | 108824 | 8 | 9.720 | 11195.9 |
| 401 | 2025-06-19 20:25:49 | prevention | 3 | 140603 | 64 | 34.316 | 4097.3 |
| 400 | 2025-06-19 14:42:21 | prevention | 1 | 67641 | 2 | 1.266 | 53428.9 |
| 399 | 2025-06-14 17:19:13 | prevention | 1 | 67641 | 2 | 5.576 | 12130.7 |
| 398 | 2025-06-04 14:40:43 | prevention | 2 | 108824 | 8 | 17.800 | 6113.7 |
| 397 | 2025-06-04 07:53:27 | prevention | 3 | 140603 | 64 | 32.156 | 4372.5 |
| 396 | 2025-06-03 08:36:41 | prevention | 1 | 67641 | 2 | 2.250 | 30062.7 |
| 395 | 2025-06-03 06:57:32 | prevention | 1 | 67641 | 2 | 3.093 | 21869.1 |
| 394 | 2025-05-27 08:27:38 | prevention | 1 | 67641 | 2 | 6.703 | 10091.2 |
| 393 | 2025-05-24 13:22:04 | prevention | 3 | 140603 | 64 | 35.393 | 3972.6 |
| 392 | 2025-05-22 10:52:38 | prevention | 3 | 140603 | 64 | 26.256 | 5355.1 |
| 391 | 2025-05-22 03:20:35 | prevention | 3 | 140603 | 64 | 40.720 | 3452.9 |
| 390 | 2025-05-20 10:51:00 | prevention | 1 | 67641 | 2 | 3.986 | 16969.6 |
| 389 | 2025-05-19 23:21:01 | prevention | 2 | 108824 | 8 | 13.123 | 8292.6 |
| 388 | 2025-05-19 20:01:42 | prevention | 3 | 140603 | 64 | 28.766 | 4887.8 |
| 387 | 2025-05-19 14:35:56 | prevention | 1 | 67641 | 2 | 1.266 | 53428.9 |
| 386 | 2025-05-14 17:00:46 | prevention | 1 | 67641 | 2 | 6.030 | 11217.4 |
| 385 | 2025-05-13 09:43:13 | prevention | 1 | 67641 | 2 | 1.296 | 52192.1 |
| 384 | 2025-05-12 12:54:30 | prevention | 1 | 67641 | 2 | 8.733 | 7745.4 |
| 383 | 2025-05-09 12:33:02 | prevention | 1 | 67641 | 2 | 5.546 | 12196.4 |
| 382 | 2025-04-26 08:39:47 | prevention | 1 | 67641 | 2 | 3.096 | 21847.9 |
| 381 | 2025-04-23 14:42:29 | prevention | 1 | 67641 | 2 | 1.300 | 52031.5 |
| 380 | 2025-04-20 08:44:40 | prevention | 1 | 67641 | 2 | 5.750 | 11763.7 |
| 379 | 2025-04-16 14:13:48 | prevention | 1 | 67641 | 2 | 4.903 | 13795.8 |
| 378 | 2025-04-11 17:57:34 | prevention | 1 | 67641 | 2 | 5.860 | 11542.8 |
| 377 | 2025-04-02 08:17:52 | prevention | 1 | 67641 | 2 | 2.546 | 26567.6 |
| 376 | 2025-03-29 09:02:45 | prevention | 1 | 67641 | 2 | 4.190 | 16143.4 |
| 375 | 2025-03-28 21:27:51 | prevention | 3 | 140603 | 64 | 33.266 | 4226.6 |
| 374 | 2025-03-27 09:34:44 | prevention | 3 | 140603 | 64 | 17.303 | 8125.9 |
| 373 | 2025-03-26 16:39:35 | prevention | 3 | 140603 | 64 | 19.330 | 7273.8 |
| 372 | 2025-03-25 12:01:53 | prevention | 3 | 140603 | 64 | 36.343 | 3868.8 |
| 371 | 2025-03-24 15:09:52 | prevention | 3 | 140603 | 64 | 6.940 | 20259.8 |
| 370 | 2025-03-24 06:04:32 | prevention | 3 | 140603 | 64 | 43.970 | 3197.7 |
| 369 | 2025-03-24 04:52:41 | prevention | 2 | 108824 | 8 | 17.503 | 6217.4 |
| 368 | 2025-03-22 10:10:10 | prevention | 1 | 67641 | 2 | 4.420 | 15303.4 |
| 367 | 2025-03-13 03:40:30 | prevention | 1 | 67641 | 2 | 5.386 | 12558.7 |
| 366 | 2025-03-07 18:04:44 | prevention | 1 | 67641 | 2 | 5.890 | 11484.0 |
| 365 | 2025-03-07 08:20:19 | prevention | 1 | 67641 | 2 | 5.910 | 11445.2 |
| 364 | 2025-02-23 15:59:06 | prevention | 1 | 67641 | 2 | 5.516 | 12262.7 |
| 363 | 2025-02-16 07:02:07 | prevention | 3 | 140603 | 64 | 32.143 | 4374.3 |
| 362 | 2025-02-16 07:01:42 | prevention | 1 | 67641 | 2 | 2.750 | 24596.7 |
| 361 | 2025-02-12 21:03:03 | prevention | 3 | 140603 | 64 | 32.846 | 4280.7 |
| 360 | 2025-02-12 21:02:54 | prevention | 2 | 108824 | 8 | 17.643 | 6168.1 |
| 359 | 2025-02-10 18:42:02 | prevention | 2 | 108824 | 8 | 19.093 | 5699.7 |
| 358 | 2025-02-10 12:23:45 | prevention | 3 | 140603 | 64 | 33.846 | 4154.2 |
| 357 | 2025-02-10 02:33:44 | prevention | 1 | 67641 | 2 | 5.123 | 13203.4 |
| 356 | 2025-02-09 19:53:00 | prevention | 3 | 140603 | 64 | 50.036 | 2810.0 |
| 355 | 2025-02-09 08:47:35 | prevention | 3 | 140603 | 64 | 33.236 | 4230.4 |
| 354 | 2025-02-09 08:47:32 | prevention | 2 | 108824 | 8 | 16.170 | 6730.0 |
| 353 | 2025-02-09 08:47:03 | prevention | 3 | 140603 | 64 | 31.673 | 4439.2 |
| 352 | 2025-02-09 08:44:39 | prevention | 1 | 67641 | 2 | 5.986 | 11299.9 |
| 351 | 2025-01-17 09:19:28 | prevention | 3 | 140603 | 64 | 43.830 | 3207.9 |
| 350 | 2025-01-17 09:19:33 | prevention | 2 | 108824 | 8 | 19.093 | 5699.7 |
| 349 | 2025-01-17 09:17:22 | prevention | 1 | 67641 | 2 | 1.220 | 55443.4 |
| 348 | 2025-01-11 06:04:41 | prevention | 2 | 108824 | 8 | 16.140 | 6742.5 |
| 347 | 2025-01-10 03:14:08 | prevention | 2 | 108824 | 8 | 3.343 | 32552.8 |
| 346 | 2025-01-10 03:13:59 | prevention | 1 | 67641 | 2 | 1.190 | 56841.2 |
| 345 | 2025-01-09 09:33:23 | prevention | 3 | 140603 | 64 | 33.813 | 4158.3 |
| 344 | 2025-01-09 09:33:22 | prevention | 3 | 140603 | 64 | 30.673 | 4583.9 |
| 343 | 2025-01-09 08:39:57 | prevention | 4 | 161450 | 271 | 59.300 | 2722.6 |
| 342 | 2025-01-09 08:39:57 | prevention | 3 | 140603 | 64 | 30.063 | 4676.9 |
| 341 | 2025-01-09 08:39:57 | prevention | 2 | 108824 | 8 | 15.733 | 6916.9 |
| 340 | 2025-01-09 08:38:25 | prevention | 1 | 67641 | 2 | 5.516 | 12262.7 |
| 339 | 2024-12-23 22:42:58 | prevention | 1 | 67641 | 2 | 3.170 | 21337.9 |
| 338 | 2024-12-16 09:21:26 | prevention | 3 | 140603 | 64 | 25.330 | 5550.8 |
| 337 | 2024-12-14 07:27:41 | prevention | 1 | 67641 | 2 | 5.403 | 12519.2 |
| 336 | 2024-12-11 06:29:40 | prevention | 2 | 108824 | 8 | 16.516 | 6589.0 |
| 335 | 2024-12-04 11:59:39 | prevention | 3 | 140603 | 64 | 31.156 | 4512.9 |
| 334 | 2024-12-03 16:14:56 | prevention | 2 | 108824 | 8 | 23.813 | 4569.9 |
| 333 | 2024-12-03 16:14:16 | prevention | 3 | 140603 | 64 | 33.423 | 4206.8 |