History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gatehouses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 398 | 2025-12-26 07:22:00 | gatehouses | 1 | 67641 | 2 | 1.593 | 42461.4 |
| 397 | 2025-12-25 11:18:55 | gatehouses | 1 | 67641 | 2 | 2.826 | 23935.2 |
| 396 | 2025-12-23 20:14:02 | gatehouses | 1 | 67641 | 2 | 1.796 | 37662.0 |
| 395 | 2025-12-20 19:18:07 | gatehouses | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 394 | 2025-12-19 04:48:59 | gatehouses | 1 | 67641 | 2 | 4.406 | 15352.0 |
| 393 | 2025-12-18 18:31:35 | gatehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 392 | 2025-12-18 18:27:54 | gatehouses | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 391 | 2025-12-12 23:48:14 | gatehouses | 1 | 67641 | 2 | 1.153 | 58665.2 |
| 390 | 2025-12-04 15:10:47 | gatehouses | 1 | 67641 | 2 | 2.063 | 32787.7 |
| 389 | 2025-11-21 19:04:10 | gatehouses | 1 | 67641 | 2 | 1.250 | 54112.8 |
| 388 | 2025-10-20 01:12:14 | gatehouses | 1 | 67641 | 2 | 2.156 | 31373.4 |
| 387 | 2025-10-12 18:27:51 | gatehouses | 1 | 67641 | 2 | 1.016 | 66575.8 |
| 386 | 2025-10-02 20:25:45 | gatehouses | 2 | 108824 | 9 | 3.546 | 30689.2 |
| 385 | 2025-09-30 19:21:01 | gatehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 384 | 2025-09-26 20:21:52 | gatehouses | 1 | 67641 | 2 | 1.170 | 57812.8 |
| 383 | 2025-09-24 18:55:04 | gatehouses | 3 | 140603 | 47 | 6.373 | 22062.3 |
| 382 | 2025-09-18 06:02:02 | gatehouses | 1 | 67641 | 2 | 1.153 | 58665.2 |
| 381 | 2025-09-15 19:20:35 | gatehouses | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 380 | 2025-08-28 01:48:56 | gatehouses | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 379 | 2025-08-09 04:37:31 | gatehouses | 1 | 67641 | 2 | 2.910 | 23244.3 |
| 378 | 2025-08-06 00:57:05 | gatehouses | 4 | 161450 | 178 | 40.656 | 3971.1 |
| 377 | 2025-08-04 06:42:36 | gatehouses | 4 | 161450 | 178 | 58.346 | 2767.1 |
| 376 | 2025-08-02 03:01:00 | gatehouses | 4 | 161450 | 178 | 37.660 | 4287.0 |
| 375 | 2025-08-01 02:22:42 | gatehouses | 3 | 140603 | 47 | 25.486 | 5516.9 |
| 374 | 2025-07-30 21:54:00 | gatehouses | 4 | 161450 | 178 | 15.283 | 10564.0 |
| 373 | 2025-07-24 07:12:36 | gatehouses | 1 | 67641 | 2 | 5.580 | 12122.0 |
| 372 | 2025-07-22 16:39:29 | gatehouses | 1 | 67641 | 2 | 3.686 | 18350.8 |
| 371 | 2025-07-16 08:39:32 | gatehouses | 1 | 67641 | 2 | 2.360 | 28661.4 |
| 370 | 2025-07-16 00:32:58 | gatehouses | 1 | 67641 | 2 | 3.403 | 19876.9 |
| 369 | 2025-07-14 04:04:12 | gatehouses | 1 | 67641 | 2 | 4.703 | 14382.5 |
| 368 | 2025-06-28 01:58:27 | gatehouses | 1 | 67641 | 2 | 5.513 | 12269.4 |
| 367 | 2025-06-26 15:35:20 | gatehouses | 4 | 161450 | 178 | 39.253 | 4113.1 |
| 366 | 2025-06-25 19:48:27 | gatehouses | 4 | 161450 | 178 | 16.470 | 9802.7 |
| 365 | 2025-06-20 04:14:17 | gatehouses | 4 | 161450 | 178 | 63.143 | 2556.9 |
| 364 | 2025-06-20 01:10:17 | gatehouses | 2 | 108824 | 9 | 10.953 | 9935.5 |
| 363 | 2025-06-19 21:33:38 | gatehouses | 1 | 67641 | 2 | 5.923 | 11420.1 |
| 362 | 2025-06-19 12:11:40 | gatehouses | 3 | 140603 | 47 | 6.656 | 21124.2 |
| 361 | 2025-06-19 08:55:14 | gatehouses | 1 | 67641 | 2 | 2.033 | 33271.5 |
| 360 | 2025-06-16 06:35:09 | gatehouses | 3 | 140603 | 47 | 34.210 | 4110.0 |
| 359 | 2025-06-14 12:14:17 | gatehouses | 2 | 108824 | 9 | 16.516 | 6589.0 |
| 358 | 2025-06-14 04:08:38 | gatehouses | 3 | 140603 | 47 | 19.890 | 7069.0 |
| 357 | 2025-06-11 13:28:31 | gatehouses | 3 | 140603 | 47 | 21.750 | 6464.5 |
| 356 | 2025-06-11 05:00:25 | gatehouses | 2 | 108824 | 9 | 14.766 | 7369.9 |
| 355 | 2025-06-10 21:27:09 | gatehouses | 3 | 140603 | 47 | 30.250 | 4648.0 |
| 354 | 2025-06-10 01:13:43 | gatehouses | 1 | 67641 | 2 | 3.233 | 20922.1 |
| 353 | 2025-05-31 04:03:41 | gatehouses | 1 | 67641 | 2 | 4.156 | 16275.5 |
| 352 | 2025-05-24 21:50:41 | gatehouses | 1 | 67641 | 2 | 5.440 | 12434.0 |
| 351 | 2025-05-14 08:58:55 | gatehouses | 1 | 67641 | 2 | 3.330 | 20312.6 |
| 350 | 2025-05-06 05:58:06 | gatehouses | 1 | 67641 | 2 | 7.250 | 9329.8 |
| 349 | 2025-04-28 00:42:54 | gatehouses | 1 | 67641 | 2 | 3.220 | 21006.5 |
| 348 | 2025-04-22 18:46:17 | gatehouses | 1 | 67641 | 2 | 2.313 | 29243.8 |
| 347 | 2025-04-20 21:07:17 | gatehouses | 1 | 67641 | 2 | 5.720 | 11825.3 |
| 346 | 2025-04-18 13:01:04 | gatehouses | 3 | 140603 | 47 | 22.876 | 6146.3 |
| 345 | 2025-04-17 21:20:51 | gatehouses | 3 | 140603 | 47 | 31.126 | 4517.2 |
| 344 | 2025-04-17 01:42:43 | gatehouses | 1 | 67641 | 2 | 5.420 | 12479.9 |
| 343 | 2025-04-03 22:08:49 | gatehouses | 3 | 140603 | 47 | 21.873 | 6428.2 |
| 342 | 2025-03-27 03:25:29 | gatehouses | 3 | 140603 | 47 | 30.940 | 4544.4 |
| 341 | 2025-03-27 03:03:09 | gatehouses | 1 | 67641 | 2 | 2.623 | 25787.6 |
| 340 | 2025-03-25 09:57:38 | gatehouses | 4 | 161450 | 178 | 57.083 | 2828.3 |
| 339 | 2025-03-24 13:25:33 | gatehouses | 2 | 108824 | 9 | 15.373 | 7078.9 |
| 338 | 2025-03-24 10:50:51 | gatehouses | 3 | 140603 | 47 | 24.596 | 5716.5 |
| 337 | 2025-03-22 01:14:51 | gatehouses | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 336 | 2025-03-14 09:17:24 | gatehouses | 1 | 67641 | 2 | 2.796 | 24192.1 |
| 335 | 2025-03-11 10:21:01 | gatehouses | 3 | 140603 | 47 | 28.253 | 4976.6 |
| 334 | 2025-03-08 14:30:05 | gatehouses | 2 | 108824 | 9 | 15.360 | 7084.9 |
| 333 | 2025-03-08 14:25:57 | gatehouses | 1 | 67641 | 2 | 4.923 | 13739.8 |
| 332 | 2025-03-08 14:20:58 | gatehouses | 3 | 140603 | 47 | 30.236 | 4650.2 |
| 331 | 2025-03-08 10:47:51 | gatehouses | 2 | 108824 | 9 | 15.436 | 7050.0 |
| 330 | 2025-03-08 00:22:49 | gatehouses | 3 | 140603 | 47 | 36.063 | 3898.8 |
| 329 | 2025-03-03 10:21:00 | gatehouses | 4 | 161450 | 178 | 47.156 | 3423.7 |
| 328 | 2025-03-02 23:36:25 | gatehouses | 4 | 161450 | 178 | 56.503 | 2857.4 |
| 327 | 2025-03-02 23:36:23 | gatehouses | 2 | 108824 | 9 | 29.706 | 3663.4 |
| 326 | 2025-03-02 22:17:32 | gatehouses | 1 | 67641 | 2 | 1.063 | 63632.2 |
| 325 | 2025-02-23 11:19:58 | gatehouses | 3 | 140603 | 47 | 28.940 | 4858.4 |
| 324 | 2025-02-23 02:57:05 | gatehouses | 3 | 140603 | 47 | 33.130 | 4244.0 |
| 323 | 2025-02-23 02:57:00 | gatehouses | 3 | 140603 | 47 | 32.923 | 4270.7 |
| 322 | 2025-02-23 02:57:00 | gatehouses | 2 | 108824 | 9 | 15.423 | 7056.0 |
| 321 | 2025-02-23 02:53:53 | gatehouses | 1 | 67641 | 2 | 8.233 | 8215.8 |
| 320 | 2025-01-27 00:47:23 | gatehouses | 1 | 67641 | 2 | 5.660 | 11950.7 |
| 319 | 2025-01-25 18:49:44 | gatehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 318 | 2025-01-24 05:08:08 | gatehouses | 3 | 140603 | 47 | 47.316 | 2971.6 |
| 317 | 2025-01-24 05:08:23 | gatehouses | 2 | 108824 | 9 | 10.376 | 10488.0 |
| 316 | 2025-01-24 05:04:26 | gatehouses | 1 | 67641 | 2 | 7.606 | 8893.1 |
| 315 | 2025-01-24 05:02:48 | gatehouses | 3 | 140603 | 47 | 32.953 | 4266.8 |
| 314 | 2025-01-22 20:14:25 | gatehouses | 3 | 140603 | 47 | 39.786 | 3534.0 |
| 313 | 2025-01-21 22:50:51 | gatehouses | 3 | 140603 | 47 | 43.673 | 3219.4 |
| 312 | 2025-01-18 23:14:33 | gatehouses | 1 | 67641 | 2 | 5.406 | 12512.2 |
| 311 | 2024-12-26 15:37:46 | gatehouses | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 310 | 2024-12-25 00:17:34 | gatehouses | 1 | 67641 | 2 | 7.626 | 8869.8 |
| 309 | 2024-12-24 09:26:29 | gatehouses | 3 | 140603 | 47 | 16.623 | 8458.3 |
| 308 | 2024-12-19 14:41:44 | gatehouses | 3 | 140603 | 47 | 38.720 | 3631.3 |
| 307 | 2024-12-19 14:41:38 | gatehouses | 2 | 108824 | 9 | 19.486 | 5584.7 |
| 306 | 2024-12-19 07:01:07 | gatehouses | 3 | 140603 | 47 | 28.843 | 4874.8 |
| 305 | 2024-12-17 13:34:54 | gatehouses | 3 | 140603 | 47 | 48.673 | 2888.7 |
| 304 | 2024-12-17 13:34:52 | gatehouses | 3 | 140603 | 47 | 25.063 | 5610.0 |
| 303 | 2024-12-17 13:34:49 | gatehouses | 2 | 108824 | 9 | 15.640 | 6958.1 |
| 302 | 2024-12-17 13:32:26 | gatehouses | 1 | 67641 | 2 | 5.280 | 12810.8 |
| 301 | 2024-12-16 21:15:56 | gatehouses | 1 | 67641 | 2 | 5.890 | 11484.0 |
| 300 | 2024-12-11 10:11:46 | gatehouses | 3 | 140603 | 47 | 41.423 | 3394.3 |
| 299 | 2024-11-24 09:08:32 | gatehouses | 1 | 67641 | 2 | 1.096 | 61716.2 |