History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yesterdays"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 284 | 2025-12-27 14:29:25 | yesterdays | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 283 | 2025-12-21 17:36:54 | yesterdays | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 282 | 2025-12-16 11:33:25 | yesterdays | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 281 | 2025-12-10 23:23:46 | yesterdays | 1 | 67641 | 2 | 1.030 | 65670.9 |
| 280 | 2025-11-26 09:16:17 | yesterdays | 1 | 67641 | 2 | 5.420 | 12479.9 |
| 279 | 2025-11-24 06:41:31 | yesterdays | 1 | 67641 | 2 | 1.140 | 59334.2 |
| 278 | 2025-10-20 15:40:51 | yesterdays | 1 | 67641 | 2 | 2.843 | 23792.1 |
| 277 | 2025-10-18 12:10:22 | yesterdays | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 276 | 2025-10-14 15:06:03 | yesterdays | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 275 | 2025-10-05 20:08:33 | yesterdays | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 274 | 2025-10-04 10:03:07 | yesterdays | 4 | 161450 | 55 | 12.343 | 13080.3 |
| 273 | 2025-10-01 09:50:06 | yesterdays | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 272 | 2025-09-28 18:30:22 | yesterdays | 1 | 67641 | 2 | 1.170 | 57812.8 |
| 271 | 2025-09-21 21:32:47 | yesterdays | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 270 | 2025-09-14 19:09:01 | yesterdays | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 269 | 2025-08-30 02:21:11 | yesterdays | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 268 | 2025-08-23 10:52:30 | yesterdays | 1 | 67641 | 2 | 5.436 | 12443.2 |
| 267 | 2025-08-19 15:38:09 | yesterdays | 4 | 161450 | 55 | 79.986 | 2018.5 |
| 266 | 2025-08-15 22:33:13 | yesterdays | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 265 | 2025-08-14 11:09:18 | yesterdays | 1 | 67641 | 2 | 1.046 | 64666.3 |
| 264 | 2025-08-10 05:33:43 | yesterdays | 3 | 140603 | 5 | 16.080 | 8744.0 |
| 263 | 2025-08-10 02:53:13 | yesterdays | 4 | 161450 | 55 | 49.876 | 3237.0 |
| 262 | 2025-08-09 22:36:24 | yesterdays | 2 | 108824 | 2 | 7.796 | 13959.0 |
| 261 | 2025-08-08 22:02:59 | yesterdays | 1 | 67641 | 2 | 1.143 | 59178.5 |
| 260 | 2025-08-06 19:08:10 | yesterdays | 1 | 67641 | 2 | 2.720 | 24868.0 |
| 259 | 2025-07-29 02:21:03 | yesterdays | 3 | 140603 | 5 | 23.906 | 5881.5 |
| 258 | 2025-07-29 01:51:08 | yesterdays | 2 | 108824 | 2 | 7.346 | 14814.0 |
| 257 | 2025-07-27 18:29:31 | yesterdays | 1 | 67641 | 2 | 5.050 | 13394.3 |
| 256 | 2025-07-25 19:59:01 | yesterdays | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 255 | 2025-07-21 02:12:33 | yesterdays | 1 | 67641 | 2 | 1.123 | 60232.4 |
| 254 | 2025-07-15 13:51:00 | yesterdays | 1 | 67641 | 2 | 2.656 | 25467.2 |
| 253 | 2025-05-22 09:48:00 | yesterdays | 1 | 67641 | 2 | 5.376 | 12582.0 |
| 252 | 2025-05-20 01:10:36 | yesterdays | 1 | 67641 | 2 | 2.906 | 23276.3 |
| 251 | 2025-05-11 12:02:05 | yesterdays | 1 | 67641 | 2 | 1.096 | 61716.2 |
| 250 | 2025-04-02 01:12:31 | yesterdays | 1 | 67641 | 2 | 9.190 | 7360.3 |
| 249 | 2025-03-31 08:44:34 | yesterdays | 3 | 140603 | 5 | 30.970 | 4540.0 |
| 248 | 2025-03-31 03:15:39 | yesterdays | 2 | 108824 | 2 | 15.703 | 6930.1 |
| 247 | 2025-03-30 06:51:46 | yesterdays | 1 | 67641 | 2 | 1.093 | 61885.6 |
| 246 | 2025-03-29 03:47:53 | yesterdays | 1 | 67641 | 2 | 5.313 | 12731.2 |
| 245 | 2025-03-13 00:46:28 | yesterdays | 1 | 67641 | 2 | 3.000 | 22547.0 |
| 244 | 2025-03-10 15:10:02 | yesterdays | 1 | 67641 | 2 | 6.983 | 9686.5 |
| 243 | 2025-03-02 12:29:45 | yesterdays | 1 | 67641 | 2 | 5.126 | 13195.7 |
| 242 | 2025-02-24 05:55:50 | yesterdays | 3 | 140603 | 5 | 33.063 | 4252.6 |
| 241 | 2025-02-24 05:55:49 | yesterdays | 2 | 108824 | 2 | 13.190 | 8250.5 |
| 240 | 2025-02-24 05:55:03 | yesterdays | 1 | 67641 | 2 | 2.906 | 23276.3 |
| 239 | 2025-02-15 13:44:07 | yesterdays | 3 | 140603 | 5 | 35.063 | 4010.0 |
| 238 | 2025-02-12 02:43:51 | yesterdays | 1 | 67641 | 2 | 5.233 | 12925.9 |
| 237 | 2025-02-08 00:37:35 | yesterdays | 3 | 140603 | 5 | 36.236 | 3880.2 |
| 236 | 2025-02-01 09:55:46 | yesterdays | 3 | 140603 | 5 | 45.626 | 3081.6 |
| 235 | 2025-01-31 00:16:23 | yesterdays | 4 | 161450 | 55 | 60.410 | 2672.6 |
| 234 | 2025-01-31 00:16:34 | yesterdays | 3 | 140603 | 5 | 34.096 | 4123.7 |
| 233 | 2025-01-31 00:16:38 | yesterdays | 2 | 108824 | 2 | 15.486 | 7027.3 |
| 232 | 2025-01-31 00:15:01 | yesterdays | 4 | 161450 | 55 | 62.003 | 2603.9 |
| 231 | 2025-01-31 00:08:55 | yesterdays | 1 | 67641 | 2 | 2.860 | 23650.7 |
| 230 | 2025-01-12 02:04:19 | yesterdays | 1 | 67641 | 2 | 5.173 | 13075.8 |
| 229 | 2025-01-05 06:37:05 | yesterdays | 3 | 140603 | 5 | 26.580 | 5289.8 |
| 228 | 2025-01-05 06:37:09 | yesterdays | 2 | 108824 | 2 | 15.470 | 7034.5 |
| 227 | 2025-01-05 06:36:03 | yesterdays | 1 | 67641 | 2 | 3.813 | 17739.6 |
| 226 | 2024-12-19 04:42:35 | yesterdays | 1 | 67641 | 2 | 5.873 | 11517.3 |
| 225 | 2024-12-15 08:06:57 | yesterdays | 4 | 161450 | 55 | 84.346 | 1914.1 |
| 224 | 2024-12-13 23:32:39 | yesterdays | 4 | 161450 | 55 | 63.300 | 2550.6 |
| 223 | 2024-12-12 15:57:39 | yesterdays | 4 | 161450 | 55 | 54.406 | 2967.5 |
| 222 | 2024-12-12 15:12:11 | yesterdays | 4 | 161450 | 55 | 34.213 | 4719.0 |
| 221 | 2024-12-12 15:12:14 | yesterdays | 3 | 140603 | 5 | 25.320 | 5553.0 |
| 220 | 2024-12-12 15:12:14 | yesterdays | 2 | 108824 | 2 | 18.420 | 5907.9 |
| 219 | 2024-12-12 15:10:51 | yesterdays | 1 | 67641 | 2 | 5.340 | 12666.9 |
| 218 | 2024-11-29 17:03:11 | yesterdays | 3 | 140603 | 5 | 28.240 | 4978.9 |
| 217 | 2024-11-29 17:03:13 | yesterdays | 2 | 108824 | 2 | 19.816 | 5491.7 |
| 216 | 2024-11-29 17:02:14 | yesterdays | 1 | 67641 | 2 | 7.780 | 8694.2 |
| 215 | 2024-11-16 16:08:01 | yesterdays | 3 | 140603 | 5 | 51.456 | 2732.5 |
| 214 | 2024-11-15 10:08:39 | yesterdays | 3 | 140603 | 5 | 24.910 | 5644.4 |
| 213 | 2024-11-03 07:49:15 | yesterdays | 3 | 140603 | 5 | 32.466 | 4330.8 |
| 212 | 2024-10-31 14:11:55 | yesterdays | 2 | 108824 | 2 | 7.640 | 14244.0 |
| 211 | 2024-10-31 14:10:56 | yesterdays | 1 | 67641 | 2 | 2.576 | 26258.2 |
| 210 | 2024-10-22 17:20:03 | yesterdays | 3 | 140603 | 5 | 32.453 | 4332.5 |
| 209 | 2024-10-22 17:20:04 | yesterdays | 2 | 108824 | 2 | 7.923 | 13735.2 |
| 208 | 2024-10-22 17:19:27 | yesterdays | 3 | 140603 | 5 | 38.346 | 3666.7 |
| 207 | 2024-10-22 17:19:18 | yesterdays | 3 | 140603 | 5 | 18.970 | 7411.9 |
| 206 | 2024-10-22 17:14:25 | yesterdays | 1 | 67641 | 2 | 4.533 | 14921.9 |
| 205 | 2024-10-22 07:46:26 | yesterdays | 3 | 140603 | 5 | 30.960 | 4541.4 |
| 204 | 2024-10-22 07:46:32 | yesterdays | 2 | 108824 | 2 | 16.096 | 6760.9 |
| 203 | 2024-10-22 07:45:50 | yesterdays | 3 | 140603 | 5 | 34.423 | 4084.6 |
| 202 | 2024-10-22 07:45:38 | yesterdays | 3 | 140603 | 5 | 17.750 | 7921.3 |
| 201 | 2024-10-22 07:39:10 | yesterdays | 1 | 67641 | 2 | 5.606 | 12065.8 |
| 200 | 2024-10-13 15:47:19 | yesterdays | 3 | 140603 | 5 | 30.876 | 4553.8 |
| 199 | 2024-10-07 00:54:48 | yesterdays | 1 | 67641 | 2 | 4.516 | 14978.1 |
| 198 | 2024-10-01 22:02:34 | yesterdays | 3 | 140603 | 5 | 52.740 | 2666.0 |
| 197 | 2024-10-01 22:02:38 | yesterdays | 3 | 140603 | 5 | 41.283 | 3405.8 |
| 196 | 2024-10-01 22:02:29 | yesterdays | 3 | 140603 | 5 | 42.236 | 3329.0 |
| 195 | 2024-09-26 06:31:39 | yesterdays | 1 | 67641 | 2 | 10.220 | 6618.5 |
| 194 | 2024-09-17 16:51:14 | yesterdays | 3 | 140603 | 5 | 60.763 | 2314.0 |
| 193 | 2024-09-12 10:42:07 | yesterdays | 3 | 140603 | 5 | 72.286 | 1945.1 |
| 192 | 2024-09-12 10:42:07 | yesterdays | 2 | 108824 | 2 | 14.936 | 7286.0 |
| 191 | 2024-08-29 02:14:00 | yesterdays | 1 | 67641 | 2 | 1.000 | 67641.0 |
| 190 | 2024-08-25 04:20:55 | yesterdays | 1 | 67641 | 2 | 7.046 | 9599.9 |
| 189 | 2024-08-25 04:06:47 | yesterdays | 4 | 161450 | 55 | 95.816 | 1685.0 |
| 188 | 2024-08-25 01:00:57 | yesterdays | 4 | 161450 | 55 | 117.023 | 1379.6 |
| 187 | 2024-08-25 00:03:51 | yesterdays | 4 | 161450 | 55 | 117.896 | 1369.4 |
| 186 | 2024-08-24 23:52:54 | yesterdays | 4 | 161450 | 55 | 95.956 | 1682.5 |
| 185 | 2024-08-22 07:47:22 | yesterdays | 4 | 161450 | 55 | 74.460 | 2168.3 |