History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upfront"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 274 | 2025-10-25 23:50:56 | upfront | 4 | 151207 | 711 | 11.376 | 13291.8 |
| 273 | 2025-10-25 02:32:05 | upfront | 4 | 151207 | 711 | 10.640 | 14211.2 |
| 272 | 2025-10-20 10:17:53 | upfront | 4 | 151207 | 711 | 68.690 | 2201.3 |
| 271 | 2025-10-16 08:01:04 | upfront | 2 | 107671 | 5 | 3.003 | 35854.5 |
| 270 | 2025-10-14 19:42:28 | upfront | 4 | 151207 | 711 | 10.236 | 14772.1 |
| 269 | 2025-10-14 19:28:06 | upfront | 4 | 151207 | 711 | 10.906 | 13864.6 |
| 268 | 2025-10-09 22:31:23 | upfront | 4 | 151207 | 711 | 10.266 | 14728.9 |
| 267 | 2025-10-09 18:19:38 | upfront | 4 | 151207 | 711 | 10.110 | 14956.2 |
| 266 | 2025-10-06 08:00:27 | upfront | 4 | 151207 | 711 | 11.110 | 13610.0 |
| 265 | 2025-10-02 06:13:22 | upfront | 4 | 151207 | 711 | 10.860 | 13923.3 |
| 264 | 2025-09-29 16:38:17 | upfront | 4 | 151207 | 711 | 12.283 | 12310.3 |
| 263 | 2025-09-17 04:01:27 | upfront | 4 | 151207 | 711 | 11.703 | 12920.4 |
| 262 | 2025-09-10 17:03:00 | upfront | 2 | 107671 | 5 | 3.263 | 32997.5 |
| 261 | 2025-09-10 15:46:32 | upfront | 4 | 151207 | 711 | 11.640 | 12990.3 |
| 260 | 2025-09-07 15:32:11 | upfront | 4 | 151207 | 711 | 13.390 | 11292.5 |
| 259 | 2025-09-05 00:46:32 | upfront | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 258 | 2025-08-28 23:23:49 | upfront | 4 | 151207 | 711 | 9.953 | 15192.1 |
| 257 | 2025-07-28 08:14:34 | upfront | 4 | 151207 | 711 | 32.250 | 4688.6 |
| 256 | 2025-07-27 19:23:35 | upfront | 2 | 107671 | 5 | 6.906 | 15590.9 |
| 255 | 2025-07-27 00:12:32 | upfront | 1 | 69583 | 1 | 2.533 | 27470.6 |
| 254 | 2025-07-26 07:16:38 | upfront | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 253 | 2025-07-26 03:10:40 | upfront | 4 | 151207 | 711 | 21.470 | 7042.7 |
| 252 | 2025-07-25 01:37:19 | upfront | 4 | 151207 | 711 | 50.126 | 3016.5 |
| 251 | 2025-07-24 20:54:57 | upfront | 1 | 69583 | 1 | 4.516 | 15408.1 |
| 250 | 2025-07-24 15:43:34 | upfront | 1 | 69583 | 1 | 7.266 | 9576.5 |
| 249 | 2025-07-22 19:19:45 | upfront | 4 | 151207 | 711 | 54.503 | 2774.3 |
| 248 | 2025-07-19 20:25:24 | upfront | 4 | 151207 | 711 | 10.720 | 14105.1 |
| 247 | 2025-07-18 11:58:04 | upfront | 4 | 151207 | 711 | 55.156 | 2741.4 |
| 246 | 2025-07-17 15:19:36 | upfront | 2 | 107671 | 5 | 12.910 | 8340.1 |
| 245 | 2025-07-17 09:55:12 | upfront | 4 | 151207 | 711 | 58.033 | 2605.5 |
| 244 | 2025-07-16 13:20:49 | upfront | 1 | 69583 | 1 | 2.593 | 26834.9 |
| 243 | 2025-06-29 19:35:53 | upfront | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 242 | 2025-06-24 23:04:15 | upfront | 4 | 151207 | 711 | 12.203 | 12391.0 |
| 241 | 2025-06-22 11:08:10 | upfront | 1 | 69583 | 1 | 5.376 | 12943.3 |
| 240 | 2025-06-19 13:04:02 | upfront | 1 | 69583 | 1 | 5.766 | 12067.8 |
| 239 | 2025-06-14 14:31:19 | upfront | 2 | 107671 | 5 | 21.296 | 5055.9 |
| 238 | 2025-06-14 12:22:50 | upfront | 4 | 151207 | 711 | 58.060 | 2604.3 |
| 237 | 2025-06-12 23:10:45 | upfront | 1 | 69583 | 1 | 5.046 | 13789.7 |
| 236 | 2025-06-12 10:20:26 | upfront | 4 | 151207 | 711 | 78.920 | 1916.0 |
| 235 | 2025-06-11 23:38:44 | upfront | 4 | 151207 | 711 | 59.813 | 2528.0 |
| 234 | 2025-06-10 09:11:30 | upfront | 4 | 151207 | 711 | 43.240 | 3496.9 |
| 233 | 2025-06-09 21:13:12 | upfront | 3 | 134027 | 62 | 27.296 | 4910.1 |
| 232 | 2025-06-09 04:02:51 | upfront | 3 | 134027 | 62 | 6.546 | 20474.6 |
| 231 | 2025-06-06 18:49:12 | upfront | 3 | 134027 | 62 | 6.046 | 22167.9 |
| 230 | 2025-06-06 10:26:28 | upfront | 1 | 69583 | 1 | 4.856 | 14329.3 |
| 229 | 2025-06-06 07:54:36 | upfront | 1 | 69583 | 1 | 6.576 | 10581.4 |
| 228 | 2025-06-05 08:40:31 | upfront | 1 | 69583 | 1 | 3.000 | 23194.3 |
| 227 | 2025-06-04 07:00:14 | upfront | 1 | 69583 | 1 | 6.466 | 10761.4 |
| 226 | 2025-05-22 11:43:29 | upfront | 1 | 69583 | 1 | 9.766 | 7125.0 |
| 225 | 2025-05-16 13:21:28 | upfront | 1 | 69583 | 1 | 2.983 | 23326.5 |
| 224 | 2025-05-15 11:38:13 | upfront | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 223 | 2025-05-10 23:55:06 | upfront | 1 | 69583 | 1 | 5.423 | 12831.1 |
| 222 | 2025-05-06 11:44:41 | upfront | 2 | 107671 | 5 | 16.160 | 6662.8 |
| 221 | 2025-04-27 14:41:13 | upfront | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 220 | 2025-04-20 10:34:16 | upfront | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 219 | 2025-04-18 07:22:00 | upfront | 1 | 69583 | 1 | 8.580 | 8109.9 |
| 218 | 2025-04-14 07:33:20 | upfront | 1 | 69583 | 1 | 5.423 | 12831.1 |
| 217 | 2025-04-11 20:52:48 | upfront | 1 | 69583 | 1 | 5.656 | 12302.5 |
| 216 | 2025-04-11 13:30:53 | upfront | 1 | 69583 | 1 | 6.156 | 11303.3 |
| 215 | 2025-04-10 23:09:48 | upfront | 1 | 69583 | 1 | 4.900 | 14200.6 |
| 214 | 2025-04-09 06:54:57 | upfront | 1 | 69583 | 1 | 5.670 | 12272.1 |
| 213 | 2025-04-06 09:48:08 | upfront | 1 | 69583 | 1 | 2.830 | 24587.6 |
| 212 | 2025-03-31 02:14:34 | upfront | 3 | 134027 | 62 | 31.910 | 4200.2 |
| 211 | 2025-03-27 01:23:35 | upfront | 3 | 134027 | 62 | 40.283 | 3327.1 |
| 210 | 2025-03-26 22:41:43 | upfront | 3 | 134027 | 62 | 16.926 | 7918.4 |
| 209 | 2025-03-22 17:48:50 | upfront | 3 | 134027 | 62 | 15.033 | 8915.5 |
| 208 | 2025-03-22 16:11:39 | upfront | 2 | 107671 | 5 | 3.423 | 31455.2 |
| 207 | 2025-03-22 15:49:45 | upfront | 3 | 134027 | 62 | 31.390 | 4269.7 |
| 206 | 2025-03-20 13:33:01 | upfront | 1 | 69583 | 1 | 6.093 | 11420.2 |
| 205 | 2025-03-13 23:18:13 | upfront | 1 | 69583 | 1 | 5.016 | 13872.2 |
| 204 | 2025-03-13 14:02:37 | upfront | 1 | 69583 | 1 | 3.716 | 18725.2 |
| 203 | 2025-03-08 17:59:05 | upfront | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 202 | 2025-03-06 19:15:41 | upfront | 1 | 69583 | 1 | 8.533 | 8154.6 |
| 201 | 2025-03-01 21:14:08 | upfront | 1 | 69583 | 1 | 2.986 | 23303.1 |
| 200 | 2025-01-27 20:43:56 | upfront | 3 | 134027 | 62 | 6.623 | 20236.6 |
| 199 | 2025-01-27 09:45:39 | upfront | 3 | 134027 | 62 | 32.113 | 4173.6 |
| 198 | 2025-01-26 23:38:53 | upfront | 3 | 134027 | 62 | 6.673 | 20085.0 |
| 197 | 2025-01-26 20:17:14 | upfront | 4 | 151207 | 711 | 58.800 | 2571.5 |
| 196 | 2025-01-26 19:44:36 | upfront | 4 | 151207 | 711 | 62.923 | 2403.0 |
| 195 | 2025-01-26 19:34:21 | upfront | 3 | 134027 | 62 | 23.390 | 5730.1 |
| 194 | 2025-01-26 18:56:16 | upfront | 4 | 151207 | 711 | 56.846 | 2659.9 |
| 193 | 2025-01-26 18:56:16 | upfront | 3 | 134027 | 62 | 42.766 | 3134.0 |
| 192 | 2025-01-26 18:56:17 | upfront | 2 | 107671 | 5 | 19.813 | 5434.4 |
| 191 | 2025-01-26 18:13:15 | upfront | 1 | 69583 | 1 | 2.720 | 25582.0 |
| 190 | 2024-12-14 17:54:08 | upfront | 1 | 69583 | 1 | 4.656 | 14944.8 |
| 189 | 2024-11-20 04:14:04 | upfront | 1 | 69583 | 1 | 5.110 | 13617.0 |
| 188 | 2024-11-07 07:46:12 | upfront | 1 | 69583 | 1 | 5.326 | 13064.8 |
| 187 | 2024-10-22 09:22:24 | upfront | 1 | 69583 | 1 | 4.720 | 14742.2 |
| 186 | 2024-08-23 11:07:47 | upfront | 1 | 69583 | 1 | 10.703 | 6501.3 |
| 185 | 2024-08-22 17:39:16 | upfront | 1 | 69583 | 1 | 14.360 | 4845.6 |
| 184 | 2024-08-15 10:08:52 | upfront | 1 | 69583 | 1 | 5.203 | 13373.6 |
| 183 | 2024-08-12 19:14:27 | upfront | 1 | 69583 | 1 | 7.750 | 8978.5 |
| 182 | 2024-07-31 10:19:03 | upfront | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 181 | 2024-07-30 02:36:28 | upfront | 1 | 69583 | 1 | 4.093 | 17000.5 |
| 180 | 2024-07-22 01:11:27 | upfront | 1 | 69583 | 1 | 4.390 | 15850.3 |
| 179 | 2024-07-17 19:33:13 | upfront | 1 | 69583 | 1 | 4.906 | 14183.2 |
| 178 | 2024-07-15 09:02:00 | upfront | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 177 | 2024-06-29 15:49:51 | upfront | 1 | 69583 | 1 | 4.263 | 16322.5 |
| 176 | 2024-06-20 20:36:11 | upfront | 1 | 69583 | 1 | 2.330 | 29863.9 |
| 175 | 2024-06-14 03:45:27 | upfront | 1 | 69583 | 1 | 2.140 | 32515.4 |