History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lieutenant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 339 | 2025-11-30 18:19:40 | lieutenant | 4 | 161450 | 25 | 10.203 | 15823.8 |
| 338 | 2025-11-30 16:35:48 | lieutenant | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 337 | 2025-08-01 13:25:39 | lieutenant | 1 | 67641 | 2 | 2.846 | 23767.0 |
| 336 | 2025-07-24 08:02:41 | lieutenant | 1 | 67641 | 2 | 5.263 | 12852.2 |
| 335 | 2025-07-13 13:18:15 | lieutenant | 3 | 140603 | 5 | 5.453 | 25784.5 |
| 334 | 2025-06-22 00:20:01 | lieutenant | 1 | 67641 | 2 | 5.673 | 11923.3 |
| 333 | 2025-05-27 14:12:04 | lieutenant | 1 | 67641 | 2 | 3.280 | 20622.3 |
| 332 | 2025-05-10 22:00:33 | lieutenant | 1 | 67641 | 2 | 5.453 | 12404.4 |
| 331 | 2025-04-08 12:53:13 | lieutenant | 3 | 140603 | 5 | 35.096 | 4006.2 |
| 330 | 2025-03-17 12:50:05 | lieutenant | 3 | 140603 | 5 | 31.440 | 4472.1 |
| 329 | 2025-03-17 12:49:59 | lieutenant | 2 | 108824 | 3 | 20.800 | 5231.9 |
| 328 | 2025-03-17 12:49:48 | lieutenant | 3 | 140603 | 5 | 29.833 | 4713.0 |
| 327 | 2025-03-15 12:05:06 | lieutenant | 1 | 67641 | 2 | 5.360 | 12619.6 |
| 326 | 2025-03-12 03:08:34 | lieutenant | 1 | 67641 | 2 | 5.313 | 12731.2 |
| 325 | 2025-03-11 18:25:38 | lieutenant | 1 | 67641 | 2 | 5.186 | 13043.0 |
| 324 | 2025-03-09 14:38:42 | lieutenant | 3 | 140603 | 5 | 30.813 | 4563.1 |
| 323 | 2025-03-09 14:38:54 | lieutenant | 2 | 108824 | 3 | 15.406 | 7063.7 |
| 322 | 2025-03-09 14:35:54 | lieutenant | 1 | 67641 | 2 | 4.313 | 15683.1 |
| 321 | 2025-02-23 02:30:47 | lieutenant | 3 | 140603 | 5 | 77.063 | 1824.5 |
| 320 | 2025-02-19 18:14:13 | lieutenant | 3 | 140603 | 5 | 32.393 | 4340.5 |
| 319 | 2025-02-18 17:50:17 | lieutenant | 4 | 161450 | 25 | 51.736 | 3120.7 |
| 318 | 2025-02-15 10:21:13 | lieutenant | 4 | 161450 | 25 | 45.220 | 3570.3 |
| 317 | 2025-02-14 02:18:14 | lieutenant | 3 | 140603 | 5 | 19.376 | 7256.6 |
| 316 | 2025-02-13 00:36:38 | lieutenant | 4 | 161450 | 25 | 57.476 | 2809.0 |
| 315 | 2025-02-13 00:36:47 | lieutenant | 3 | 140603 | 5 | 32.273 | 4356.7 |
| 314 | 2025-02-13 00:36:45 | lieutenant | 2 | 108824 | 3 | 14.766 | 7369.9 |
| 313 | 2025-02-13 00:33:49 | lieutenant | 1 | 67641 | 2 | 2.876 | 23519.1 |
| 312 | 2025-02-01 20:56:14 | lieutenant | 1 | 67641 | 2 | 5.296 | 12772.1 |
| 311 | 2025-01-14 07:58:28 | lieutenant | 1 | 67641 | 2 | 5.530 | 12231.6 |
| 310 | 2025-01-11 20:57:52 | lieutenant | 3 | 140603 | 5 | 16.416 | 8565.0 |
| 309 | 2025-01-02 04:14:48 | lieutenant | 3 | 140603 | 5 | 32.830 | 4282.8 |
| 308 | 2025-01-02 04:14:56 | lieutenant | 2 | 108824 | 3 | 14.203 | 7662.0 |
| 307 | 2025-01-02 04:14:23 | lieutenant | 3 | 140603 | 5 | 30.143 | 4664.5 |
| 306 | 2025-01-02 04:13:52 | lieutenant | 1 | 67641 | 2 | 4.720 | 14330.7 |
| 305 | 2025-01-02 04:12:36 | lieutenant | 3 | 140603 | 5 | 48.406 | 2904.7 |
| 304 | 2024-12-30 01:57:55 | lieutenant | 1 | 67641 | 2 | 8.253 | 8195.9 |
| 303 | 2024-12-20 11:58:46 | lieutenant | 1 | 67641 | 2 | 5.593 | 12093.9 |
| 302 | 2024-12-05 03:46:16 | lieutenant | 1 | 67641 | 2 | 4.843 | 13966.8 |
| 301 | 2024-11-29 20:56:19 | lieutenant | 3 | 140603 | 5 | 33.516 | 4195.1 |
| 300 | 2024-11-29 20:56:24 | lieutenant | 2 | 108824 | 3 | 12.610 | 8630.0 |
| 299 | 2024-11-29 20:53:08 | lieutenant | 1 | 67641 | 2 | 2.546 | 26567.6 |
| 298 | 2024-11-28 12:54:46 | lieutenant | 3 | 140603 | 5 | 24.500 | 5738.9 |
| 297 | 2024-11-28 04:49:06 | lieutenant | 4 | 161450 | 25 | 56.970 | 2833.9 |
| 296 | 2024-11-28 04:49:07 | lieutenant | 3 | 140603 | 5 | 41.456 | 3391.6 |
| 295 | 2024-11-28 04:49:10 | lieutenant | 2 | 108824 | 3 | 7.860 | 13845.3 |
| 294 | 2024-11-28 04:47:31 | lieutenant | 1 | 67641 | 2 | 2.843 | 23792.1 |
| 293 | 2024-10-22 03:26:43 | lieutenant | 3 | 140603 | 5 | 23.266 | 6043.3 |
| 292 | 2024-10-22 03:25:08 | lieutenant | 3 | 140603 | 5 | 32.766 | 4291.1 |
| 291 | 2024-10-22 03:25:06 | lieutenant | 3 | 140603 | 5 | 33.236 | 4230.4 |
| 290 | 2024-10-22 03:24:36 | lieutenant | 2 | 108824 | 3 | 14.940 | 7284.1 |
| 289 | 2024-10-22 03:24:08 | lieutenant | 1 | 67641 | 2 | 3.063 | 22083.3 |
| 288 | 2024-10-22 03:23:08 | lieutenant | 2 | 108824 | 3 | 16.376 | 6645.3 |
| 287 | 2024-10-22 03:22:56 | lieutenant | 1 | 67641 | 2 | 2.640 | 25621.6 |
| 286 | 2024-10-22 03:18:32 | lieutenant | 1 | 67641 | 2 | 7.356 | 9195.4 |
| 285 | 2024-10-22 03:18:25 | lieutenant | 1 | 67641 | 2 | 6.516 | 10380.8 |
| 284 | 2024-10-22 03:16:47 | lieutenant | 3 | 140603 | 5 | 38.986 | 3606.5 |
| 283 | 2024-10-22 03:15:03 | lieutenant | 1 | 67641 | 2 | 5.236 | 12918.4 |
| 282 | 2024-10-22 03:14:23 | lieutenant | 1 | 67641 | 2 | 2.500 | 27056.4 |
| 281 | 2024-10-22 03:11:51 | lieutenant | 3 | 140603 | 5 | 40.063 | 3509.5 |
| 280 | 2024-10-22 03:08:47 | lieutenant | 4 | 161450 | 25 | 54.096 | 2984.5 |
| 279 | 2024-10-22 03:08:58 | lieutenant | 3 | 140603 | 5 | 35.030 | 4013.8 |
| 278 | 2024-10-22 03:09:01 | lieutenant | 2 | 108824 | 3 | 14.063 | 7738.3 |
| 277 | 2024-10-22 03:07:38 | lieutenant | 1 | 67641 | 2 | 4.093 | 16526.0 |
| 276 | 2024-10-22 03:06:45 | lieutenant | 1 | 67641 | 2 | 3.360 | 20131.3 |
| 275 | 2024-10-19 14:14:45 | lieutenant | 4 | 161450 | 25 | 66.093 | 2442.8 |
| 274 | 2024-10-19 14:14:44 | lieutenant | 3 | 140603 | 5 | 22.313 | 6301.4 |
| 273 | 2024-10-19 14:14:46 | lieutenant | 2 | 108824 | 3 | 8.233 | 13218.0 |
| 272 | 2024-10-19 14:11:39 | lieutenant | 1 | 67641 | 2 | 4.826 | 14016.0 |
| 271 | 2024-10-17 10:29:41 | lieutenant | 3 | 140603 | 5 | 28.610 | 4914.5 |
| 270 | 2024-10-17 10:29:41 | lieutenant | 2 | 108824 | 3 | 15.750 | 6909.5 |
| 269 | 2024-10-17 10:28:32 | lieutenant | 3 | 140603 | 5 | 16.560 | 8490.5 |
| 268 | 2024-10-17 10:28:24 | lieutenant | 3 | 140603 | 5 | 21.046 | 6680.7 |
| 267 | 2024-10-17 10:26:17 | lieutenant | 1 | 67641 | 2 | 4.890 | 13832.5 |
| 266 | 2024-10-15 05:04:59 | lieutenant | 3 | 140603 | 5 | 31.330 | 4487.8 |
| 265 | 2024-10-15 05:04:37 | lieutenant | 3 | 140603 | 5 | 46.410 | 3029.6 |
| 264 | 2024-10-15 05:04:41 | lieutenant | 3 | 140603 | 5 | 30.876 | 4553.8 |
| 263 | 2024-10-15 05:05:01 | lieutenant | 2 | 108824 | 3 | 7.970 | 13654.2 |
| 262 | 2024-10-15 05:00:21 | lieutenant | 1 | 67641 | 2 | 4.903 | 13795.8 |
| 261 | 2024-10-14 10:13:37 | lieutenant | 3 | 140603 | 5 | 37.923 | 3707.6 |
| 260 | 2024-09-14 03:02:19 | lieutenant | 3 | 140603 | 5 | 60.926 | 2307.8 |
| 259 | 2024-09-11 15:44:41 | lieutenant | 1 | 67641 | 2 | 11.563 | 5849.8 |
| 258 | 2024-09-10 23:20:26 | lieutenant | 3 | 140603 | 5 | 73.363 | 1916.5 |
| 257 | 2024-09-09 22:41:30 | lieutenant | 1 | 67641 | 2 | 4.296 | 15745.1 |
| 256 | 2024-09-07 14:08:26 | lieutenant | 4 | 161450 | 25 | 95.536 | 1689.9 |
| 255 | 2024-09-07 14:08:29 | lieutenant | 3 | 140603 | 5 | 68.626 | 2048.8 |
| 254 | 2024-09-07 14:08:32 | lieutenant | 2 | 108824 | 3 | 20.816 | 5227.9 |
| 253 | 2024-09-07 14:02:46 | lieutenant | 1 | 67641 | 2 | 1.970 | 34335.5 |
| 252 | 2024-08-28 05:05:50 | lieutenant | 5 | 173545 | 229 | 94.316 | 1840.0 |
| 251 | 2024-08-23 16:55:25 | lieutenant | 2 | 108824 | 3 | 21.313 | 5106.0 |
| 250 | 2024-08-23 16:55:24 | lieutenant | 3 | 140603 | 5 | 23.016 | 6108.9 |
| 249 | 2024-08-23 16:35:21 | lieutenant | 1 | 67641 | 2 | 5.220 | 12958.0 |
| 248 | 2024-08-13 08:11:06 | lieutenant | 5 | 173545 | 229 | 116.710 | 1487.0 |
| 247 | 2024-08-12 01:50:16 | lieutenant | 5 | 173545 | 229 | 106.930 | 1623.0 |
| 246 | 2024-08-11 15:18:57 | lieutenant | 2 | 108824 | 3 | 11.313 | 9619.4 |
| 245 | 2024-08-11 15:18:45 | lieutenant | 4 | 161450 | 25 | 22.236 | 7260.7 |
| 244 | 2024-08-11 15:18:52 | lieutenant | 3 | 140603 | 5 | 12.203 | 11522.0 |
| 243 | 2024-08-11 15:14:57 | lieutenant | 1 | 67641 | 2 | 6.310 | 10719.7 |
| 242 | 2024-08-11 13:04:51 | lieutenant | 5 | 173545 | 229 | 80.660 | 2151.6 |
| 241 | 2024-08-11 03:38:23 | lieutenant | 5 | 173545 | 229 | 77.803 | 2230.6 |
| 240 | 2024-08-11 03:37:08 | lieutenant | 5 | 173545 | 229 | 81.566 | 2127.7 |