History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoplifted"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 335 | 2025-11-17 21:23:23 | shoplifted | 4 | 161450 | 82 | 13.936 | 11585.1 |
| 334 | 2025-11-03 11:10:21 | shoplifted | 1 | 67641 | 2 | 1.206 | 56087.1 |
| 333 | 2025-11-01 15:04:30 | shoplifted | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 332 | 2025-10-31 15:35:11 | shoplifted | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 331 | 2025-10-18 15:45:30 | shoplifted | 4 | 161450 | 82 | 10.826 | 14913.2 |
| 330 | 2025-10-16 17:01:36 | shoplifted | 4 | 161450 | 82 | 10.440 | 15464.6 |
| 329 | 2025-10-15 03:27:51 | shoplifted | 3 | 140603 | 16 | 5.623 | 25005.0 |
| 328 | 2025-09-27 08:23:24 | shoplifted | 4 | 161450 | 82 | 10.520 | 15347.0 |
| 327 | 2025-09-20 04:42:57 | shoplifted | 4 | 161450 | 82 | 11.936 | 13526.3 |
| 326 | 2025-09-11 23:29:23 | shoplifted | 4 | 161450 | 82 | 9.830 | 16424.2 |
| 325 | 2025-08-31 22:52:12 | shoplifted | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 324 | 2025-08-29 07:57:44 | shoplifted | 4 | 161450 | 82 | 18.296 | 8824.3 |
| 323 | 2025-08-28 23:06:50 | shoplifted | 3 | 140603 | 16 | 6.423 | 21890.5 |
| 322 | 2025-08-17 03:33:40 | shoplifted | 3 | 140603 | 16 | 14.846 | 9470.8 |
| 321 | 2025-08-14 22:04:08 | shoplifted | 4 | 161450 | 82 | 45.830 | 3522.8 |
| 320 | 2025-08-12 05:49:12 | shoplifted | 1 | 67641 | 2 | 4.750 | 14240.2 |
| 319 | 2025-08-11 00:08:16 | shoplifted | 4 | 161450 | 82 | 54.580 | 2958.0 |
| 318 | 2025-08-10 10:33:39 | shoplifted | 4 | 161450 | 82 | 32.533 | 4962.7 |
| 317 | 2025-08-09 23:02:43 | shoplifted | 3 | 140603 | 16 | 14.346 | 9800.9 |
| 316 | 2025-08-09 00:29:52 | shoplifted | 4 | 161450 | 82 | 46.473 | 3474.1 |
| 315 | 2025-08-08 22:00:09 | shoplifted | 1 | 67641 | 2 | 1.153 | 58665.2 |
| 314 | 2025-08-08 02:55:24 | shoplifted | 3 | 140603 | 16 | 6.593 | 21326.1 |
| 313 | 2025-08-07 17:52:51 | shoplifted | 4 | 161450 | 82 | 26.033 | 6201.7 |
| 312 | 2025-08-01 20:50:08 | shoplifted | 4 | 161450 | 82 | 75.363 | 2142.3 |
| 311 | 2025-08-01 20:24:40 | shoplifted | 2 | 108824 | 5 | 15.046 | 7232.8 |
| 310 | 2025-08-01 10:28:11 | shoplifted | 1 | 67641 | 2 | 5.016 | 13485.0 |
| 309 | 2025-07-31 01:09:49 | shoplifted | 1 | 67641 | 2 | 2.483 | 27241.6 |
| 308 | 2025-07-19 02:38:10 | shoplifted | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 307 | 2025-07-10 04:55:27 | shoplifted | 1 | 67641 | 2 | 4.703 | 14382.5 |
| 306 | 2025-07-09 22:08:58 | shoplifted | 2 | 108824 | 5 | 23.753 | 4581.5 |
| 305 | 2025-07-03 21:31:04 | shoplifted | 1 | 67641 | 2 | 8.640 | 7828.8 |
| 304 | 2025-06-30 00:34:13 | shoplifted | 1 | 67641 | 2 | 3.090 | 21890.3 |
| 303 | 2025-06-28 00:41:26 | shoplifted | 1 | 67641 | 2 | 4.876 | 13872.2 |
| 302 | 2025-06-21 11:16:20 | shoplifted | 1 | 67641 | 2 | 2.826 | 23935.2 |
| 301 | 2025-06-14 16:15:54 | shoplifted | 3 | 140603 | 16 | 28.580 | 4919.6 |
| 300 | 2025-06-14 13:46:37 | shoplifted | 2 | 108824 | 5 | 12.436 | 8750.7 |
| 299 | 2025-06-12 07:36:41 | shoplifted | 2 | 108824 | 5 | 13.233 | 8223.7 |
| 298 | 2025-06-10 01:09:40 | shoplifted | 1 | 67641 | 2 | 7.140 | 9473.5 |
| 297 | 2025-06-09 14:38:41 | shoplifted | 3 | 140603 | 16 | 5.610 | 25062.9 |
| 296 | 2025-06-06 21:18:14 | shoplifted | 3 | 140603 | 16 | 11.346 | 12392.3 |
| 295 | 2025-05-20 21:27:46 | shoplifted | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 294 | 2025-05-12 00:03:21 | shoplifted | 3 | 140603 | 16 | 37.843 | 3715.4 |
| 293 | 2025-05-10 22:46:55 | shoplifted | 1 | 67641 | 2 | 3.406 | 19859.4 |
| 292 | 2025-05-04 02:01:41 | shoplifted | 3 | 140603 | 16 | 41.660 | 3375.0 |
| 291 | 2025-04-26 09:08:29 | shoplifted | 2 | 108824 | 5 | 21.346 | 5098.1 |
| 290 | 2025-04-16 10:31:22 | shoplifted | 1 | 67641 | 2 | 2.750 | 24596.7 |
| 289 | 2025-04-14 23:25:53 | shoplifted | 3 | 140603 | 16 | 7.580 | 18549.2 |
| 288 | 2025-03-26 23:06:18 | shoplifted | 1 | 67641 | 2 | 5.360 | 12619.6 |
| 287 | 2025-03-24 12:37:01 | shoplifted | 1 | 67641 | 2 | 5.530 | 12231.6 |
| 286 | 2025-03-15 18:55:57 | shoplifted | 3 | 140603 | 16 | 33.390 | 4210.9 |
| 285 | 2025-03-13 06:45:30 | shoplifted | 2 | 108824 | 5 | 14.253 | 7635.2 |
| 284 | 2025-03-13 04:06:19 | shoplifted | 3 | 140603 | 16 | 40.470 | 3474.3 |
| 283 | 2025-03-13 04:06:12 | shoplifted | 3 | 140603 | 16 | 35.656 | 3943.3 |
| 282 | 2025-03-13 04:06:09 | shoplifted | 2 | 108824 | 5 | 21.593 | 5039.8 |
| 281 | 2025-03-13 04:06:12 | shoplifted | 3 | 140603 | 16 | 16.250 | 8652.5 |
| 280 | 2025-03-13 04:04:06 | shoplifted | 1 | 67641 | 2 | 7.906 | 8555.7 |
| 279 | 2025-03-08 15:51:45 | shoplifted | 3 | 140603 | 16 | 31.003 | 4535.1 |
| 278 | 2025-02-28 23:22:48 | shoplifted | 3 | 140603 | 16 | 28.123 | 4999.6 |
| 277 | 2025-02-28 23:22:42 | shoplifted | 2 | 108824 | 5 | 14.313 | 7603.2 |
| 276 | 2025-02-28 23:20:07 | shoplifted | 1 | 67641 | 2 | 4.483 | 15088.3 |
| 275 | 2025-02-01 13:37:20 | shoplifted | 1 | 67641 | 2 | 4.860 | 13917.9 |
| 274 | 2025-01-24 12:14:17 | shoplifted | 1 | 67641 | 2 | 5.110 | 13237.0 |
| 273 | 2025-01-19 19:56:47 | shoplifted | 2 | 108824 | 5 | 13.533 | 8041.4 |
| 272 | 2025-01-19 19:54:39 | shoplifted | 3 | 140603 | 16 | 31.816 | 4419.3 |
| 271 | 2025-01-19 19:54:23 | shoplifted | 3 | 140603 | 16 | 34.640 | 4059.0 |
| 270 | 2025-01-19 19:51:36 | shoplifted | 1 | 67641 | 2 | 3.016 | 22427.4 |
| 269 | 2025-01-17 00:30:02 | shoplifted | 3 | 140603 | 16 | 31.313 | 4490.2 |
| 268 | 2025-01-17 00:30:06 | shoplifted | 2 | 108824 | 5 | 14.970 | 7269.5 |
| 267 | 2025-01-17 00:28:57 | shoplifted | 3 | 140603 | 16 | 28.690 | 4900.8 |
| 266 | 2025-01-17 00:28:47 | shoplifted | 3 | 140603 | 16 | 30.046 | 4679.6 |
| 265 | 2025-01-17 00:26:23 | shoplifted | 1 | 67641 | 2 | 4.516 | 14978.1 |
| 264 | 2024-12-29 23:53:00 | shoplifted | 3 | 140603 | 16 | 39.846 | 3528.7 |
| 263 | 2024-12-29 23:52:53 | shoplifted | 3 | 140603 | 16 | 34.596 | 4064.1 |
| 262 | 2024-12-29 23:52:52 | shoplifted | 3 | 140603 | 16 | 25.970 | 5414.1 |
| 261 | 2024-12-29 23:52:55 | shoplifted | 2 | 108824 | 5 | 15.646 | 6955.4 |
| 260 | 2024-12-29 23:52:48 | shoplifted | 1 | 67641 | 2 | 4.516 | 14978.1 |
| 259 | 2024-12-23 04:24:47 | shoplifted | 3 | 140603 | 16 | 31.673 | 4439.2 |
| 258 | 2024-12-23 04:24:44 | shoplifted | 2 | 108824 | 5 | 15.766 | 6902.4 |
| 257 | 2024-12-23 04:24:11 | shoplifted | 1 | 67641 | 2 | 5.763 | 11737.1 |
| 256 | 2024-12-11 07:26:55 | shoplifted | 3 | 140603 | 16 | 32.856 | 4279.4 |
| 255 | 2024-12-11 07:27:04 | shoplifted | 2 | 108824 | 5 | 18.766 | 5799.0 |
| 254 | 2024-12-11 07:27:01 | shoplifted | 3 | 140603 | 16 | 21.173 | 6640.7 |
| 253 | 2024-12-11 07:23:42 | shoplifted | 1 | 67641 | 2 | 8.046 | 8406.8 |
| 252 | 2024-11-30 16:58:30 | shoplifted | 2 | 108824 | 5 | 15.423 | 7056.0 |
| 251 | 2024-11-30 16:58:03 | shoplifted | 3 | 140603 | 16 | 32.906 | 4272.9 |
| 250 | 2024-11-29 08:09:13 | shoplifted | 1 | 67641 | 2 | 2.796 | 24192.1 |
| 249 | 2024-11-25 19:39:47 | shoplifted | 4 | 161450 | 82 | 48.750 | 3311.8 |
| 248 | 2024-11-25 19:39:48 | shoplifted | 3 | 140603 | 16 | 44.186 | 3182.1 |
| 247 | 2024-11-25 19:39:58 | shoplifted | 2 | 108824 | 5 | 15.700 | 6931.5 |
| 246 | 2024-11-25 19:37:23 | shoplifted | 1 | 67641 | 2 | 5.953 | 11362.5 |
| 245 | 2024-11-23 03:37:06 | shoplifted | 1 | 67641 | 2 | 5.203 | 13000.4 |
| 244 | 2024-11-14 21:13:50 | shoplifted | 3 | 140603 | 16 | 28.186 | 4988.4 |
| 243 | 2024-11-14 21:13:42 | shoplifted | 2 | 108824 | 5 | 15.220 | 7150.1 |
| 242 | 2024-11-05 08:35:34 | shoplifted | 3 | 140603 | 16 | 32.206 | 4365.7 |
| 241 | 2024-11-05 08:35:22 | shoplifted | 1 | 67641 | 2 | 5.450 | 12411.2 |
| 240 | 2024-11-05 08:35:13 | shoplifted | 2 | 108824 | 5 | 3.500 | 31092.6 |
| 239 | 2024-11-02 14:46:34 | shoplifted | 3 | 140603 | 16 | 37.330 | 3766.5 |
| 238 | 2024-10-29 05:43:01 | shoplifted | 2 | 108824 | 5 | 18.203 | 5978.4 |
| 237 | 2024-10-29 05:41:21 | shoplifted | 1 | 67641 | 2 | 2.610 | 25916.1 |
| 236 | 2024-10-25 07:58:44 | shoplifted | 3 | 140603 | 16 | 29.253 | 4806.4 |