History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"officer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 331 | 2025-08-28 04:32:15 | officer | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 330 | 2025-08-26 03:41:27 | officer | 1 | 69583 | 4 | 5.550 | 12537.5 |
| 329 | 2025-08-06 07:05:19 | officer | 3 | 134027 | 123 | 27.313 | 4907.1 |
| 328 | 2025-08-03 12:02:25 | officer | 3 | 134027 | 123 | 34.766 | 3855.1 |
| 327 | 2025-08-01 07:27:41 | officer | 1 | 69583 | 4 | 3.300 | 21085.8 |
| 326 | 2025-07-28 14:56:19 | officer | 3 | 134027 | 123 | 15.093 | 8880.1 |
| 325 | 2025-07-26 13:10:03 | officer | 1 | 69583 | 4 | 2.406 | 28920.6 |
| 324 | 2025-07-24 02:27:32 | officer | 1 | 69583 | 4 | 4.313 | 16133.3 |
| 323 | 2025-07-23 01:38:10 | officer | 1 | 69583 | 4 | 6.690 | 10401.0 |
| 322 | 2025-07-22 15:06:29 | officer | 1 | 69583 | 4 | 5.466 | 12730.2 |
| 321 | 2025-07-07 03:17:23 | officer | 1 | 69583 | 4 | 9.783 | 7112.6 |
| 320 | 2025-07-06 22:53:00 | officer | 1 | 69583 | 4 | 5.923 | 11747.9 |
| 319 | 2025-07-04 06:46:31 | officer | 1 | 69583 | 4 | 5.706 | 12194.7 |
| 318 | 2025-07-02 06:45:10 | officer | 1 | 69583 | 4 | 6.216 | 11194.2 |
| 317 | 2025-06-26 10:01:02 | officer | 1 | 69583 | 4 | 5.920 | 11753.9 |
| 316 | 2025-06-08 06:21:32 | officer | 2 | 107671 | 11 | 10.216 | 10539.4 |
| 315 | 2025-06-06 10:29:10 | officer | 1 | 69583 | 4 | 8.060 | 8633.1 |
| 314 | 2025-06-02 02:38:26 | officer | 1 | 69583 | 4 | 6.686 | 10407.3 |
| 313 | 2025-05-20 13:12:58 | officer | 1 | 69583 | 4 | 7.046 | 9875.5 |
| 312 | 2025-05-16 05:21:20 | officer | 1 | 69583 | 4 | 5.826 | 11943.5 |
| 311 | 2025-05-13 12:36:55 | officer | 1 | 69583 | 4 | 5.576 | 12479.0 |
| 310 | 2025-04-29 23:38:03 | officer | 3 | 134027 | 123 | 33.016 | 4059.5 |
| 309 | 2025-04-29 09:01:30 | officer | 2 | 107671 | 11 | 5.893 | 18271.0 |
| 308 | 2025-04-27 09:00:58 | officer | 2 | 107671 | 11 | 2.796 | 38508.9 |
| 307 | 2025-04-19 11:50:53 | officer | 1 | 69583 | 4 | 1.200 | 57985.8 |
| 306 | 2025-04-16 08:27:16 | officer | 1 | 69583 | 4 | 4.250 | 16372.5 |
| 305 | 2025-04-16 01:57:29 | officer | 1 | 69583 | 4 | 6.720 | 10354.6 |
| 304 | 2025-04-04 06:02:39 | officer | 1 | 69583 | 4 | 3.313 | 21003.0 |
| 303 | 2025-03-21 05:07:24 | officer | 3 | 134027 | 123 | 28.123 | 4765.7 |
| 302 | 2025-03-19 14:06:47 | officer | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 301 | 2025-03-15 06:23:19 | officer | 1 | 69583 | 4 | 4.860 | 14317.5 |
| 300 | 2025-03-10 21:26:56 | officer | 1 | 69583 | 4 | 6.300 | 11044.9 |
| 299 | 2025-03-07 01:20:08 | officer | 3 | 134027 | 123 | 23.250 | 5764.6 |
| 298 | 2025-03-06 16:28:19 | officer | 3 | 134027 | 123 | 48.486 | 2764.2 |
| 297 | 2025-03-04 02:48:20 | officer | 3 | 134027 | 123 | 43.970 | 3048.1 |
| 296 | 2025-03-04 02:48:02 | officer | 2 | 107671 | 11 | 15.576 | 6912.6 |
| 295 | 2025-03-04 02:47:50 | officer | 1 | 69583 | 4 | 8.263 | 8421.0 |
| 294 | 2025-03-01 02:41:42 | officer | 3 | 134027 | 123 | 29.316 | 4571.8 |
| 293 | 2025-02-17 22:45:02 | officer | 1 | 69583 | 4 | 1.423 | 48898.8 |
| 292 | 2025-02-06 13:23:16 | officer | 3 | 134027 | 123 | 26.096 | 5135.9 |
| 291 | 2025-02-05 04:41:28 | officer | 1 | 69583 | 4 | 5.830 | 11935.3 |
| 290 | 2025-02-04 14:28:04 | officer | 1 | 69583 | 4 | 6.810 | 10217.8 |
| 289 | 2025-02-04 01:51:24 | officer | 3 | 134027 | 123 | 13.940 | 9614.6 |
| 288 | 2025-02-01 23:15:24 | officer | 3 | 134027 | 123 | 32.406 | 4135.9 |
| 287 | 2025-02-01 20:34:02 | officer | 3 | 134027 | 123 | 25.296 | 5298.3 |
| 286 | 2025-02-01 20:34:03 | officer | 2 | 107671 | 11 | 15.280 | 7046.5 |
| 285 | 2025-02-01 20:32:20 | officer | 1 | 69583 | 4 | 5.000 | 13916.6 |
| 284 | 2025-01-26 20:17:46 | officer | 1 | 69583 | 4 | 5.780 | 12038.6 |
| 283 | 2024-12-27 09:12:14 | officer | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 282 | 2024-12-17 01:11:14 | officer | 1 | 69583 | 4 | 3.626 | 19190.0 |
| 281 | 2024-12-15 16:44:34 | officer | 2 | 107671 | 11 | 3.640 | 29579.9 |
| 280 | 2024-12-05 00:49:52 | officer | 1 | 69583 | 4 | 5.720 | 12164.9 |
| 279 | 2024-12-04 16:29:00 | officer | 1 | 69583 | 4 | 5.873 | 11847.9 |
| 278 | 2024-12-03 21:04:24 | officer | 2 | 107671 | 11 | 16.233 | 6632.8 |
| 277 | 2024-11-18 09:34:16 | officer | 2 | 107671 | 11 | 16.983 | 6339.9 |
| 276 | 2024-11-18 07:34:47 | officer | 1 | 69583 | 4 | 6.533 | 10651.0 |
| 275 | 2024-11-16 13:26:11 | officer | 3 | 134027 | 123 | 33.376 | 4015.7 |
| 274 | 2024-11-16 09:34:34 | officer | 3 | 134027 | 123 | 16.456 | 8144.6 |
| 273 | 2024-11-11 15:25:34 | officer | 3 | 134027 | 123 | 30.233 | 4433.1 |
| 272 | 2024-11-11 15:25:39 | officer | 2 | 107671 | 11 | 19.296 | 5580.0 |
| 271 | 2024-11-11 05:14:41 | officer | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 270 | 2024-11-03 19:55:56 | officer | 1 | 69583 | 4 | 8.423 | 8261.1 |
| 269 | 2024-10-18 05:09:03 | officer | 1 | 69583 | 4 | 5.643 | 12330.9 |
| 268 | 2024-10-11 06:03:07 | officer | 1 | 69583 | 4 | 5.906 | 11781.7 |
| 267 | 2024-10-02 16:45:51 | officer | 1 | 69583 | 4 | 7.563 | 9200.4 |
| 266 | 2024-09-04 03:21:22 | officer | 1 | 69583 | 4 | 12.343 | 5637.4 |
| 265 | 2024-08-28 14:17:35 | officer | 1 | 69583 | 4 | 19.936 | 3490.3 |
| 264 | 2024-08-21 19:49:55 | officer | 1 | 69583 | 4 | 9.186 | 7574.9 |
| 263 | 2024-08-12 07:44:53 | officer | 1 | 69583 | 4 | 7.046 | 9875.5 |
| 262 | 2024-08-08 19:47:27 | officer | 1 | 69583 | 4 | 3.970 | 17527.2 |
| 261 | 2024-08-04 20:02:10 | officer | 1 | 69583 | 4 | 2.203 | 31585.6 |
| 260 | 2024-08-02 00:40:22 | officer | 1 | 69583 | 4 | 2.923 | 23805.3 |
| 259 | 2024-07-14 22:56:36 | officer | 1 | 69583 | 4 | 2.516 | 27656.2 |
| 258 | 2024-07-13 17:07:59 | officer | 1 | 69583 | 4 | 4.500 | 15462.9 |
| 257 | 2024-07-13 09:48:04 | officer | 1 | 69583 | 4 | 4.000 | 17395.8 |
| 256 | 2024-07-06 07:52:01 | officer | 1 | 69583 | 4 | 3.436 | 20251.2 |
| 255 | 2024-07-03 08:49:49 | officer | 1 | 69583 | 4 | 1.783 | 39025.8 |
| 254 | 2024-07-01 19:11:58 | officer | 1 | 69583 | 4 | 5.876 | 11841.9 |
| 253 | 2024-06-30 20:13:49 | officer | 1 | 69583 | 4 | 2.233 | 31161.2 |
| 252 | 2024-06-17 16:10:25 | officer | 1 | 69583 | 4 | 4.850 | 14347.0 |
| 251 | 2024-06-03 00:18:53 | officer | 1 | 69583 | 4 | 6.140 | 11332.7 |
| 250 | 2024-05-19 12:52:24 | officer | 3 | 134027 | 123 | 17.610 | 7610.8 |
| 249 | 2024-05-17 12:36:05 | officer | 3 | 134027 | 123 | 13.360 | 10032.0 |
| 248 | 2024-05-16 06:30:05 | officer | 3 | 134027 | 123 | 7.030 | 19065.0 |
| 247 | 2024-04-27 23:01:08 | officer | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 246 | 2024-03-31 02:31:28 | officer | 1 | 69583 | 4 | 1.560 | 44604.5 |
| 245 | 2024-03-30 06:25:33 | officer | 1 | 69583 | 4 | 3.000 | 23194.3 |
| 244 | 2024-03-29 05:51:43 | officer | 2 | 107671 | 11 | 9.610 | 11204.1 |
| 243 | 2024-03-29 05:51:25 | officer | 3 | 134027 | 123 | 8.763 | 15294.6 |
| 242 | 2024-03-29 04:47:28 | officer | 2 | 107671 | 11 | 5.796 | 18576.8 |
| 241 | 2024-03-27 16:42:01 | officer | 2 | 107671 | 11 | 3.483 | 30913.3 |
| 240 | 2024-03-27 16:41:01 | officer | 3 | 134027 | 123 | 7.343 | 18252.3 |
| 239 | 2024-03-25 09:31:41 | officer | 3 | 134027 | 123 | 5.533 | 24223.2 |
| 238 | 2024-03-25 09:31:37 | officer | 2 | 107671 | 11 | 2.720 | 39584.9 |
| 237 | 2024-03-22 10:19:12 | officer | 3 | 134027 | 123 | 11.440 | 11715.6 |
| 236 | 2024-03-20 19:42:42 | officer | 3 | 134027 | 123 | 6.966 | 19240.2 |
| 235 | 2024-03-20 19:42:42 | officer | 2 | 107671 | 11 | 3.503 | 30736.8 |
| 234 | 2024-03-20 19:42:15 | officer | 1 | 69583 | 4 | 2.516 | 27656.2 |
| 233 | 2024-03-20 19:42:03 | officer | 3 | 134027 | 123 | 7.606 | 17621.2 |
| 232 | 2024-03-20 19:41:50 | officer | 2 | 107671 | 11 | 4.796 | 22450.2 |