History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"defendant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 328 | 2025-08-20 21:18:45 | defendant | 1 | 81242 | 3 | 3.343 | 24302.1 |
| 327 | 2025-08-05 07:10:43 | defendant | 1 | 81242 | 3 | 2.576 | 31538.0 |
| 326 | 2025-08-01 14:32:39 | defendant | 1 | 81242 | 3 | 6.813 | 11924.6 |
| 325 | 2025-07-25 12:37:30 | defendant | 1 | 81242 | 3 | 6.013 | 13511.1 |
| 324 | 2025-07-14 17:48:59 | defendant | 3 | 148641 | 41 | 33.970 | 4375.7 |
| 323 | 2025-07-13 01:06:23 | defendant | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 322 | 2025-07-11 20:09:01 | defendant | 3 | 148641 | 41 | 35.313 | 4209.2 |
| 321 | 2025-07-10 16:05:52 | defendant | 1 | 81242 | 3 | 5.170 | 15714.1 |
| 320 | 2025-07-06 23:59:01 | defendant | 1 | 81242 | 3 | 5.906 | 13755.8 |
| 319 | 2025-06-30 10:19:01 | defendant | 1 | 81242 | 3 | 3.626 | 22405.4 |
| 318 | 2025-06-30 10:18:37 | defendant | 1 | 81242 | 3 | 5.123 | 15858.3 |
| 317 | 2025-06-23 07:50:30 | defendant | 3 | 148641 | 41 | 19.593 | 7586.4 |
| 316 | 2025-06-21 06:21:35 | defendant | 3 | 148641 | 41 | 8.923 | 16658.2 |
| 315 | 2025-05-27 09:42:49 | defendant | 1 | 81242 | 3 | 9.656 | 8413.6 |
| 314 | 2025-05-18 23:59:54 | defendant | 2 | 121436 | 9 | 3.560 | 34111.2 |
| 313 | 2025-05-10 11:52:02 | defendant | 1 | 81242 | 3 | 2.250 | 36107.6 |
| 312 | 2025-05-07 23:12:28 | defendant | 2 | 121436 | 9 | 13.576 | 8944.9 |
| 311 | 2025-05-02 15:31:39 | defendant | 1 | 81242 | 3 | 4.860 | 16716.5 |
| 310 | 2025-04-25 22:13:46 | defendant | 2 | 121436 | 9 | 21.000 | 5782.7 |
| 309 | 2025-04-25 04:18:45 | defendant | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 308 | 2025-03-31 09:38:07 | defendant | 1 | 81242 | 3 | 6.576 | 12354.3 |
| 307 | 2025-03-24 01:32:02 | defendant | 3 | 148641 | 41 | 18.110 | 8207.7 |
| 306 | 2025-03-23 18:44:20 | defendant | 3 | 148641 | 41 | 52.256 | 2844.5 |
| 305 | 2025-03-22 04:22:51 | defendant | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 304 | 2025-03-08 16:53:12 | defendant | 1 | 81242 | 3 | 6.843 | 11872.3 |
| 303 | 2025-03-07 23:45:23 | defendant | 1 | 81242 | 3 | 9.186 | 8844.1 |
| 302 | 2025-02-25 16:38:58 | defendant | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 301 | 2025-02-06 10:45:22 | defendant | 2 | 121436 | 9 | 16.066 | 7558.6 |
| 300 | 2025-02-05 21:21:05 | defendant | 1 | 81242 | 3 | 3.733 | 21763.2 |
| 299 | 2025-02-03 19:11:04 | defendant | 3 | 148641 | 41 | 51.266 | 2899.4 |
| 298 | 2025-02-03 12:04:36 | defendant | 3 | 148641 | 41 | 40.533 | 3667.2 |
| 297 | 2025-01-30 09:49:11 | defendant | 3 | 148641 | 41 | 37.580 | 3955.3 |
| 296 | 2025-01-30 09:49:12 | defendant | 2 | 121436 | 9 | 10.096 | 12028.1 |
| 295 | 2025-01-30 09:47:40 | defendant | 1 | 81242 | 3 | 5.703 | 14245.5 |
| 294 | 2025-01-26 17:22:13 | defendant | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 293 | 2025-01-16 03:41:52 | defendant | 1 | 81242 | 3 | 6.313 | 12869.0 |
| 292 | 2025-01-05 16:11:20 | defendant | 1 | 81242 | 3 | 9.050 | 8977.0 |
| 291 | 2025-01-04 20:25:00 | defendant | 2 | 121436 | 9 | 15.156 | 8012.4 |
| 290 | 2025-01-01 19:24:52 | defendant | 3 | 148641 | 41 | 31.473 | 4722.8 |
| 289 | 2025-01-01 11:36:48 | defendant | 3 | 148641 | 41 | 34.860 | 4263.9 |
| 288 | 2024-12-30 12:44:50 | defendant | 3 | 148641 | 41 | 49.360 | 3011.4 |
| 287 | 2024-12-29 05:19:44 | defendant | 3 | 148641 | 41 | 35.580 | 4177.7 |
| 286 | 2024-12-29 05:19:39 | defendant | 3 | 148641 | 41 | 33.643 | 4418.2 |
| 285 | 2024-12-29 05:19:44 | defendant | 2 | 121436 | 9 | 16.406 | 7401.9 |
| 284 | 2024-12-27 15:26:22 | defendant | 1 | 81242 | 3 | 9.703 | 8372.9 |
| 283 | 2024-12-22 22:14:28 | defendant | 1 | 81242 | 3 | 4.250 | 19115.8 |
| 282 | 2024-12-09 19:06:37 | defendant | 1 | 81242 | 3 | 3.200 | 25388.1 |
| 281 | 2024-11-09 15:10:01 | defendant | 1 | 81242 | 3 | 3.690 | 22016.8 |
| 280 | 2024-11-08 07:26:02 | defendant | 1 | 81242 | 3 | 3.263 | 24897.9 |
| 279 | 2024-11-06 07:52:00 | defendant | 1 | 81242 | 3 | 3.410 | 23824.6 |
| 278 | 2024-11-01 06:37:17 | defendant | 1 | 81242 | 3 | 3.703 | 21939.5 |
| 277 | 2024-10-01 18:30:13 | defendant | 1 | 81242 | 3 | 8.703 | 9334.9 |
| 276 | 2024-09-25 03:46:38 | defendant | 1 | 81242 | 3 | 12.203 | 6657.5 |
| 275 | 2024-09-19 11:13:49 | defendant | 3 | 148641 | 41 | 56.190 | 2645.3 |
| 274 | 2024-09-19 11:11:53 | defendant | 1 | 81242 | 3 | 4.890 | 16613.9 |
| 273 | 2024-09-16 11:56:09 | defendant | 2 | 121436 | 9 | 24.643 | 4927.8 |
| 272 | 2024-09-16 11:55:00 | defendant | 1 | 81242 | 3 | 10.220 | 7949.3 |
| 271 | 2024-08-29 13:57:00 | defendant | 3 | 148641 | 41 | 78.723 | 1888.2 |
| 270 | 2024-08-29 13:57:00 | defendant | 3 | 148641 | 41 | 64.923 | 2289.5 |
| 269 | 2024-08-29 13:57:02 | defendant | 2 | 121436 | 9 | 33.470 | 3628.2 |
| 268 | 2024-08-29 11:28:08 | defendant | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 267 | 2024-08-03 22:58:40 | defendant | 1 | 81242 | 3 | 5.326 | 15253.8 |
| 266 | 2024-07-23 13:38:01 | defendant | 2 | 121436 | 9 | 7.156 | 16969.8 |
| 265 | 2024-07-23 13:37:18 | defendant | 1 | 81242 | 3 | 5.216 | 15575.5 |
| 264 | 2024-07-21 22:42:20 | defendant | 2 | 121436 | 9 | 6.673 | 18198.1 |
| 263 | 2024-07-21 22:39:33 | defendant | 1 | 81242 | 3 | 2.796 | 29056.5 |
| 262 | 2024-07-20 07:09:30 | defendant | 3 | 148641 | 41 | 34.473 | 4311.8 |
| 261 | 2024-07-19 19:45:22 | defendant | 4 | 165329 | 185 | 58.536 | 2824.4 |
| 260 | 2024-07-19 15:20:41 | defendant | 2 | 121436 | 9 | 19.330 | 6282.3 |
| 259 | 2024-07-19 15:19:53 | defendant | 1 | 81242 | 3 | 3.563 | 22801.6 |
| 258 | 2024-07-18 13:40:27 | defendant | 2 | 121436 | 9 | 17.250 | 7039.8 |
| 257 | 2024-07-18 13:33:41 | defendant | 1 | 81242 | 3 | 3.376 | 24064.6 |
| 256 | 2024-07-18 13:16:57 | defendant | 3 | 148641 | 41 | 28.940 | 5136.2 |
| 255 | 2024-07-18 10:32:10 | defendant | 3 | 148641 | 41 | 32.503 | 4573.1 |
| 254 | 2024-07-17 23:26:33 | defendant | 3 | 148641 | 41 | 29.643 | 5014.4 |
| 253 | 2024-07-17 11:45:24 | defendant | 4 | 165329 | 185 | 34.266 | 4824.9 |
| 252 | 2024-07-17 01:09:50 | defendant | 4 | 165329 | 185 | 51.100 | 3235.4 |
| 251 | 2024-07-16 12:41:31 | defendant | 1 | 81242 | 3 | 4.533 | 17922.3 |
| 250 | 2024-07-16 12:36:52 | defendant | 1 | 81242 | 3 | 3.140 | 25873.2 |
| 249 | 2024-07-13 11:44:55 | defendant | 4 | 165329 | 185 | 46.456 | 3558.8 |
| 248 | 2024-07-13 11:44:56 | defendant | 3 | 148641 | 41 | 14.736 | 10086.9 |
| 247 | 2024-07-08 04:17:57 | defendant | 1 | 81242 | 3 | 4.250 | 19115.8 |
| 246 | 2024-07-07 05:33:19 | defendant | 1 | 81242 | 3 | 7.360 | 11038.3 |
| 245 | 2024-07-07 04:53:50 | defendant | 3 | 148641 | 41 | 28.286 | 5254.9 |
| 244 | 2024-07-07 04:53:07 | defendant | 4 | 165329 | 185 | 56.956 | 2902.7 |
| 243 | 2024-07-07 04:47:48 | defendant | 2 | 121436 | 9 | 14.720 | 8249.7 |
| 242 | 2024-07-07 04:44:02 | defendant | 1 | 81242 | 3 | 8.780 | 9253.1 |
| 241 | 2024-07-07 04:38:04 | defendant | 1 | 81242 | 3 | 6.736 | 12060.9 |
| 240 | 2024-07-01 13:06:15 | defendant | 1 | 81242 | 3 | 2.483 | 32719.3 |
| 239 | 2024-06-21 18:29:36 | defendant | 2 | 121436 | 9 | 9.373 | 12955.9 |
| 238 | 2024-06-21 18:28:06 | defendant | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 237 | 2024-06-18 06:01:54 | defendant | 4 | 165329 | 185 | 48.503 | 3408.6 |
| 236 | 2024-06-17 21:31:34 | defendant | 4 | 165329 | 185 | 65.693 | 2516.7 |
| 235 | 2024-06-17 21:31:14 | defendant | 3 | 148641 | 41 | 29.063 | 5114.4 |
| 234 | 2024-06-17 21:30:21 | defendant | 2 | 121436 | 9 | 20.516 | 5919.1 |
| 233 | 2024-06-17 10:17:26 | defendant | 4 | 165329 | 185 | 60.283 | 2742.5 |
| 232 | 2024-06-17 10:16:26 | defendant | 3 | 148641 | 41 | 28.643 | 5189.4 |
| 231 | 2024-06-17 04:28:14 | defendant | 4 | 165329 | 185 | 86.146 | 1919.2 |
| 230 | 2024-06-16 17:27:43 | defendant | 4 | 165329 | 185 | 58.926 | 2805.7 |
| 229 | 2024-06-16 17:27:22 | defendant | 3 | 148641 | 41 | 27.673 | 5371.3 |