History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occasional"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 334 | 2025-07-24 04:13:50 | occasional | 1 | 67641 | 1 | 3.096 | 21847.9 |
| 333 | 2025-07-23 17:37:08 | occasional | 1 | 67641 | 1 | 6.360 | 10635.4 |
| 332 | 2025-07-23 04:33:23 | occasional | 1 | 67641 | 1 | 3.406 | 19859.4 |
| 331 | 2025-07-17 18:21:56 | occasional | 3 | 140603 | 15 | 15.906 | 8839.6 |
| 330 | 2025-07-15 06:22:37 | occasional | 1 | 67641 | 1 | 3.923 | 17242.2 |
| 329 | 2025-07-13 03:30:58 | occasional | 3 | 140603 | 15 | 6.110 | 23011.9 |
| 328 | 2025-07-11 15:12:08 | occasional | 3 | 140603 | 15 | 36.796 | 3821.1 |
| 327 | 2025-07-04 06:55:07 | occasional | 1 | 67641 | 1 | 8.576 | 7887.2 |
| 326 | 2025-07-02 10:16:19 | occasional | 1 | 67641 | 1 | 6.923 | 9770.5 |
| 325 | 2025-06-27 18:17:22 | occasional | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 324 | 2025-06-21 12:02:01 | occasional | 1 | 67641 | 1 | 8.470 | 7986.0 |
| 323 | 2025-06-20 15:53:58 | occasional | 3 | 140603 | 15 | 26.486 | 5308.6 |
| 322 | 2025-06-18 01:59:08 | occasional | 1 | 67641 | 1 | 2.470 | 27385.0 |
| 321 | 2025-06-14 19:23:37 | occasional | 3 | 140603 | 15 | 31.920 | 4404.9 |
| 320 | 2025-06-14 17:15:37 | occasional | 3 | 140603 | 15 | 33.000 | 4260.7 |
| 319 | 2025-06-13 23:00:08 | occasional | 2 | 108824 | 5 | 27.080 | 4018.6 |
| 318 | 2025-06-13 05:35:00 | occasional | 1 | 67641 | 1 | 1.060 | 63812.3 |
| 317 | 2025-06-04 09:26:36 | occasional | 1 | 67641 | 1 | 2.860 | 23650.7 |
| 316 | 2025-05-16 12:22:25 | occasional | 1 | 67641 | 1 | 6.373 | 10613.7 |
| 315 | 2025-05-09 18:47:43 | occasional | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 314 | 2025-05-02 01:26:10 | occasional | 1 | 67641 | 1 | 5.640 | 11993.1 |
| 313 | 2025-04-29 18:06:11 | occasional | 1 | 67641 | 1 | 1.080 | 62630.6 |
| 312 | 2025-04-21 13:44:55 | occasional | 3 | 140603 | 15 | 23.470 | 5990.8 |
| 311 | 2025-04-13 20:58:35 | occasional | 3 | 140603 | 15 | 24.080 | 5839.0 |
| 310 | 2025-04-04 21:00:43 | occasional | 3 | 140603 | 15 | 36.516 | 3850.4 |
| 309 | 2025-04-04 20:08:31 | occasional | 3 | 140603 | 15 | 33.346 | 4216.5 |
| 308 | 2025-04-04 18:18:44 | occasional | 2 | 108824 | 5 | 10.376 | 10488.0 |
| 307 | 2025-04-03 21:42:48 | occasional | 3 | 140603 | 15 | 31.706 | 4434.6 |
| 306 | 2025-04-03 08:48:00 | occasional | 1 | 67641 | 1 | 5.423 | 12473.0 |
| 305 | 2025-03-29 13:29:24 | occasional | 1 | 67641 | 1 | 4.440 | 15234.5 |
| 304 | 2025-03-20 07:20:04 | occasional | 1 | 67641 | 1 | 9.126 | 7411.9 |
| 303 | 2025-03-10 20:34:12 | occasional | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 302 | 2025-02-16 15:54:39 | occasional | 1 | 67641 | 1 | 5.673 | 11923.3 |
| 301 | 2025-02-07 22:49:27 | occasional | 3 | 140603 | 15 | 35.643 | 3944.8 |
| 300 | 2025-02-07 22:49:27 | occasional | 3 | 140603 | 15 | 28.016 | 5018.7 |
| 299 | 2025-02-07 22:49:30 | occasional | 3 | 140603 | 15 | 22.263 | 6315.5 |
| 298 | 2025-02-07 22:49:22 | occasional | 2 | 108824 | 5 | 7.670 | 14188.3 |
| 297 | 2025-02-06 04:55:59 | occasional | 3 | 140603 | 15 | 31.403 | 4477.4 |
| 296 | 2025-02-06 04:56:07 | occasional | 2 | 108824 | 5 | 15.793 | 6890.6 |
| 295 | 2025-02-06 04:22:18 | occasional | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 294 | 2025-02-02 00:42:46 | occasional | 1 | 67641 | 1 | 6.000 | 11273.5 |
| 293 | 2025-01-30 22:06:01 | occasional | 3 | 140603 | 15 | 31.520 | 4460.8 |
| 292 | 2025-01-29 23:11:06 | occasional | 3 | 140603 | 15 | 35.750 | 3933.0 |
| 291 | 2025-01-29 23:11:05 | occasional | 3 | 140603 | 15 | 36.313 | 3872.0 |
| 290 | 2025-01-29 23:11:04 | occasional | 3 | 140603 | 15 | 29.893 | 4703.5 |
| 289 | 2025-01-29 23:11:05 | occasional | 2 | 108824 | 5 | 12.533 | 8683.0 |
| 288 | 2025-01-24 00:34:19 | occasional | 3 | 140603 | 15 | 30.313 | 4638.4 |
| 286 | 2025-01-24 00:34:16 | occasional | 3 | 140603 | 15 | 32.756 | 4292.4 |
| 285 | 2025-01-24 00:34:02 | occasional | 2 | 108824 | 5 | 11.076 | 9825.2 |
| 284 | 2025-01-24 00:33:41 | occasional | 1 | 67641 | 1 | 5.266 | 12844.9 |
| 283 | 2025-01-08 22:30:27 | occasional | 1 | 67641 | 1 | 5.546 | 12196.4 |
| 282 | 2024-12-24 15:38:30 | occasional | 3 | 140603 | 15 | 42.760 | 3288.2 |
| 281 | 2024-12-24 15:38:34 | occasional | 2 | 108824 | 5 | 15.043 | 7234.2 |
| 280 | 2024-12-24 15:37:29 | occasional | 3 | 140603 | 15 | 26.320 | 5342.1 |
| 279 | 2024-12-24 15:37:21 | occasional | 3 | 140603 | 15 | 31.286 | 4494.1 |
| 278 | 2024-12-24 15:36:26 | occasional | 1 | 67641 | 1 | 1.436 | 47103.8 |
| 277 | 2024-12-23 02:58:39 | occasional | 1 | 67641 | 1 | 5.623 | 12029.3 |
| 276 | 2024-11-25 19:48:36 | occasional | 3 | 140603 | 15 | 37.140 | 3785.8 |
| 275 | 2024-11-25 19:48:35 | occasional | 2 | 108824 | 5 | 12.156 | 8952.3 |
| 274 | 2024-11-25 19:46:52 | occasional | 1 | 67641 | 1 | 4.660 | 14515.2 |
| 273 | 2024-11-20 16:55:51 | occasional | 1 | 67641 | 1 | 2.483 | 27241.6 |
| 272 | 2024-11-20 03:58:12 | occasional | 3 | 140603 | 15 | 32.376 | 4342.8 |
| 271 | 2024-11-13 08:14:05 | occasional | 3 | 140603 | 15 | 62.643 | 2244.5 |
| 270 | 2024-11-13 08:14:37 | occasional | 3 | 140603 | 15 | 30.533 | 4605.0 |
| 269 | 2024-11-13 08:14:41 | occasional | 2 | 108824 | 5 | 7.686 | 14158.7 |
| 268 | 2024-11-13 08:14:01 | occasional | 3 | 140603 | 15 | 32.843 | 4281.1 |
| 267 | 2024-11-13 08:11:02 | occasional | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 266 | 2024-11-05 09:09:35 | occasional | 3 | 140603 | 15 | 32.300 | 4353.0 |
| 265 | 2024-11-05 09:09:34 | occasional | 3 | 140603 | 15 | 32.033 | 4389.3 |
| 264 | 2024-11-05 09:09:37 | occasional | 3 | 140603 | 15 | 21.596 | 6510.6 |
| 263 | 2024-11-05 09:09:36 | occasional | 2 | 108824 | 5 | 14.596 | 7455.7 |
| 262 | 2024-11-05 09:09:08 | occasional | 1 | 67641 | 1 | 2.033 | 33271.5 |
| 261 | 2024-10-25 14:48:16 | occasional | 1 | 67641 | 1 | 4.470 | 15132.2 |
| 260 | 2024-10-07 21:13:11 | occasional | 1 | 67641 | 1 | 12.516 | 5404.4 |
| 259 | 2024-09-16 03:26:30 | occasional | 1 | 67641 | 1 | 10.500 | 6442.0 |
| 258 | 2024-09-07 19:28:08 | occasional | 1 | 67641 | 1 | 6.893 | 9813.0 |
| 257 | 2024-08-15 23:57:51 | occasional | 3 | 140603 | 15 | 70.596 | 1991.7 |
| 256 | 2024-08-15 23:56:52 | occasional | 1 | 67641 | 1 | 7.860 | 8605.7 |
| 255 | 2024-08-09 04:40:32 | occasional | 2 | 108824 | 5 | 6.623 | 16431.2 |
| 254 | 2024-08-06 07:36:23 | occasional | 4 | 161450 | 80 | 34.770 | 4643.4 |
| 253 | 2024-08-06 06:05:13 | occasional | 4 | 161450 | 80 | 48.753 | 3311.6 |
| 252 | 2024-08-06 04:39:11 | occasional | 2 | 108824 | 5 | 9.940 | 10948.1 |
| 251 | 2024-08-04 15:17:55 | occasional | 4 | 161450 | 80 | 56.503 | 2857.4 |
| 250 | 2024-08-04 15:17:58 | occasional | 3 | 140603 | 15 | 27.486 | 5115.4 |
| 249 | 2024-08-01 04:25:39 | occasional | 1 | 67641 | 1 | 10.000 | 6764.1 |
| 248 | 2024-07-31 13:49:05 | occasional | 3 | 140603 | 15 | 24.940 | 5637.7 |
| 247 | 2024-07-31 06:21:24 | occasional | 3 | 140603 | 15 | 33.720 | 4169.7 |
| 246 | 2024-07-28 20:39:20 | occasional | 3 | 140603 | 15 | 22.346 | 6292.1 |
| 245 | 2024-07-28 20:39:20 | occasional | 2 | 108824 | 5 | 5.546 | 19622.1 |
| 244 | 2024-07-28 20:37:13 | occasional | 4 | 161450 | 80 | 38.680 | 4174.0 |
| 243 | 2024-07-28 20:28:52 | occasional | 1 | 67641 | 1 | 1.703 | 39718.7 |
| 242 | 2024-07-23 20:04:11 | occasional | 1 | 67641 | 1 | 3.830 | 17660.8 |
| 241 | 2024-07-23 19:59:32 | occasional | 1 | 67641 | 1 | 3.420 | 19778.1 |
| 240 | 2024-07-12 23:07:02 | occasional | 3 | 140603 | 15 | 27.173 | 5174.4 |
| 239 | 2024-07-11 16:06:00 | occasional | 4 | 161450 | 80 | 40.046 | 4031.6 |
| 238 | 2024-07-09 15:30:21 | occasional | 1 | 67641 | 1 | 2.313 | 29243.8 |
| 237 | 2024-07-09 03:22:24 | occasional | 4 | 161450 | 80 | 57.363 | 2814.5 |
| 236 | 2024-07-09 03:22:36 | occasional | 3 | 140603 | 15 | 28.203 | 4985.4 |
| 235 | 2024-07-09 03:22:41 | occasional | 2 | 108824 | 5 | 10.360 | 10504.2 |