History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"discounting"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 308 | 2024-06-03 14:23:32 | discounting | 3 | 121633 | 54 | 5.203 | 23377.5 |
| 307 | 2024-06-02 05:14:12 | discounting | 2 | 86808 | 7 | 8.893 | 9761.4 |
| 306 | 2024-05-30 01:14:33 | discounting | 2 | 86808 | 7 | 8.876 | 9780.1 |
| 305 | 2024-05-30 00:37:56 | discounting | 1 | 49908 | 3 | 0.876 | 56972.6 |
| 304 | 2024-05-25 10:29:25 | discounting | 3 | 121633 | 54 | 14.503 | 8386.7 |
| 303 | 2024-05-23 21:06:27 | discounting | 2 | 86808 | 7 | 10.970 | 7913.2 |
| 302 | 2024-05-23 21:06:16 | discounting | 3 | 121633 | 54 | 6.736 | 18057.2 |
| 301 | 2024-05-23 21:04:10 | discounting | 1 | 49908 | 3 | 0.966 | 51664.6 |
| 300 | 2024-05-22 15:35:17 | discounting | 1 | 49908 | 3 | 2.063 | 24192.0 |
| 299 | 2024-05-22 15:34:30 | discounting | 4 | 148819 | 221 | 12.313 | 12086.3 |
| 298 | 2024-05-22 15:34:22 | discounting | 3 | 121633 | 54 | 12.576 | 9671.8 |
| 297 | 2024-05-22 15:34:18 | discounting | 2 | 86808 | 7 | 2.873 | 30215.1 |
| 296 | 2024-05-21 23:31:50 | discounting | 4 | 148819 | 221 | 22.516 | 6609.5 |
| 295 | 2024-05-21 07:10:05 | discounting | 4 | 148819 | 221 | 28.610 | 5201.6 |
| 294 | 2024-05-21 03:34:08 | discounting | 4 | 148819 | 221 | 35.296 | 4216.3 |
| 293 | 2024-05-21 03:34:14 | discounting | 3 | 121633 | 54 | 15.686 | 7754.2 |
| 292 | 2024-05-21 03:34:19 | discounting | 2 | 86808 | 7 | 8.326 | 10426.1 |
| 291 | 2024-05-21 03:27:33 | discounting | 1 | 49908 | 3 | 1.063 | 46950.1 |
| 290 | 2024-05-02 07:05:08 | discounting | 1 | 49908 | 3 | 2.843 | 17554.7 |
| 289 | 2024-05-02 02:29:17 | discounting | 1 | 49908 | 3 | 0.890 | 56076.4 |
| 288 | 2024-04-29 02:14:29 | discounting | 1 | 49908 | 3 | 0.876 | 56972.6 |
| 287 | 2024-04-20 07:51:57 | discounting | 2 | 86808 | 7 | 8.186 | 10604.4 |
| 286 | 2024-04-20 07:45:32 | discounting | 1 | 49908 | 3 | 0.936 | 53320.5 |
| 285 | 2024-04-15 16:31:49 | discounting | 3 | 121633 | 54 | 15.173 | 8016.4 |
| 284 | 2024-04-15 00:31:35 | discounting | 2 | 86808 | 7 | 8.346 | 10401.2 |
| 283 | 2024-04-15 00:31:23 | discounting | 1 | 49908 | 3 | 3.060 | 16309.8 |
| 282 | 2024-04-12 07:58:50 | discounting | 3 | 121633 | 54 | 15.593 | 7800.5 |
| 281 | 2024-04-10 16:24:42 | discounting | 4 | 148819 | 221 | 31.983 | 4653.1 |
| 280 | 2024-04-01 04:40:42 | discounting | 2 | 86808 | 7 | 8.500 | 10212.7 |
| 279 | 2024-03-30 01:05:44 | discounting | 2 | 86808 | 7 | 4.156 | 20887.4 |
| 278 | 2024-03-30 01:03:30 | discounting | 1 | 49908 | 3 | 0.966 | 51664.6 |
| 277 | 2024-03-29 13:36:59 | discounting | 4 | 148819 | 221 | 35.456 | 4197.3 |
| 276 | 2024-03-29 13:36:59 | discounting | 3 | 121633 | 54 | 12.876 | 9446.5 |
| 275 | 2024-03-29 13:37:00 | discounting | 2 | 86808 | 7 | 9.843 | 8819.3 |
| 274 | 2024-03-29 13:33:58 | discounting | 1 | 49908 | 3 | 0.923 | 54071.5 |
| 273 | 2024-03-24 05:17:29 | discounting | 1 | 49908 | 3 | 0.733 | 68087.3 |
| 272 | 2024-03-17 21:34:52 | discounting | 1 | 49908 | 3 | 1.000 | 49908.0 |
| 271 | 2024-03-08 12:43:48 | discounting | 1 | 49908 | 3 | 1.593 | 31329.6 |
| 270 | 2024-02-26 19:03:27 | discounting | 2 | 86808 | 7 | 2.750 | 31566.5 |
| 269 | 2024-02-26 19:00:36 | discounting | 1 | 49908 | 3 | 1.000 | 49908.0 |
| 268 | 2024-02-24 00:52:32 | discounting | 4 | 148819 | 221 | 9.190 | 16193.6 |
| 267 | 2024-02-24 00:52:31 | discounting | 3 | 121633 | 54 | 4.936 | 24642.0 |
| 266 | 2024-02-16 03:12:38 | discounting | 1 | 49908 | 3 | 2.860 | 17450.3 |
| 265 | 2024-02-11 11:05:33 | discounting | 2 | 86808 | 7 | 5.516 | 15737.5 |
| 264 | 2024-02-05 11:42:16 | discounting | 2 | 86808 | 7 | 2.670 | 32512.4 |
| 263 | 2024-02-05 10:30:41 | discounting | 1 | 49908 | 3 | 0.923 | 54071.5 |
| 262 | 2024-02-04 00:25:18 | discounting | 1 | 49908 | 3 | 0.843 | 59202.8 |
| 261 | 2024-02-03 01:56:30 | discounting | 1 | 49908 | 3 | 0.893 | 55888.0 |
| 260 | 2024-01-22 03:19:52 | discounting | 4 | 148819 | 221 | 9.690 | 15358.0 |
| 259 | 2024-01-20 21:02:01 | discounting | 4 | 148819 | 221 | 9.003 | 16529.9 |
| 258 | 2024-01-13 14:46:35 | discounting | 3 | 121633 | 54 | 4.436 | 27419.5 |
| 257 | 2024-01-12 00:56:13 | discounting | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 256 | 2023-12-19 12:43:49 | discounting | 1 | 49908 | 3 | 0.903 | 55269.1 |
| 255 | 2023-12-11 02:43:33 | discounting | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 254 | 2023-12-09 07:55:55 | discounting | 1 | 49908 | 3 | 0.733 | 68087.3 |
| 253 | 2023-12-05 19:15:56 | discounting | 1 | 49908 | 3 | 0.860 | 58032.6 |
| 252 | 2023-12-03 11:19:14 | discounting | 1 | 49908 | 3 | 0.763 | 65410.2 |
| 251 | 2023-11-11 16:17:45 | discounting | 1 | 49908 | 3 | 0.733 | 68087.3 |
| 250 | 2023-11-09 06:50:05 | discounting | 1 | 49908 | 3 | 0.780 | 63984.6 |
| 249 | 2023-11-05 04:15:00 | discounting | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 248 | 2023-11-01 11:48:09 | discounting | 4 | 148819 | 221 | 13.673 | 10884.2 |
| 247 | 2023-10-24 14:15:05 | discounting | 3 | 121633 | 54 | 4.453 | 27314.8 |
| 246 | 2023-08-29 05:29:10 | discounting | 1 | 49908 | 3 | 0.763 | 65410.2 |
| 245 | 2023-08-08 19:11:52 | discounting | 4 | 148819 | 221 | 7.920 | 18790.3 |
| 244 | 2023-08-03 13:48:25 | discounting | 3 | 121633 | 54 | 4.406 | 27606.2 |
| 243 | 2023-07-29 14:41:50 | discounting | 1 | 49908 | 3 | 0.813 | 61387.5 |
| 242 | 2023-06-03 20:12:45 | discounting | 1 | 49908 | 3 | 0.810 | 61614.8 |
| 241 | 2023-04-20 20:39:08 | discounting | 4 | 148819 | 221 | 9.640 | 15437.7 |
| 240 | 2023-04-13 12:42:20 | discounting | 3 | 121633 | 54 | 4.280 | 28418.9 |
| 239 | 2023-03-28 05:35:03 | discounting | 1 | 49908 | 3 | 0.780 | 63984.6 |
| 238 | 2023-01-26 11:53:26 | discounting | 4 | 148819 | 221 | 7.910 | 18814.0 |
| 237 | 2023-01-19 18:00:31 | discounting | 3 | 121633 | 54 | 4.373 | 27814.5 |
| 236 | 2023-01-11 06:03:27 | discounting | 1 | 49908 | 3 | 0.856 | 58303.7 |
| 235 | 2023-01-05 03:07:36 | discounting | 1 | 49908 | 3 | 0.826 | 60421.3 |
| 234 | 2022-11-07 20:28:08 | discounting | 4 | 148819 | 221 | 8.376 | 17767.3 |
| 233 | 2022-10-29 23:37:01 | discounting | 3 | 121633 | 54 | 4.326 | 28116.7 |
| 232 | 2022-10-16 18:18:59 | discounting | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 231 | 2022-08-31 22:18:11 | discounting | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 230 | 2022-08-24 18:55:35 | discounting | 1 | 49908 | 3 | 0.763 | 65410.2 |
| 229 | 2022-06-06 16:55:10 | discounting | 1 | 49908 | 3 | 0.766 | 65154.0 |
| 228 | 2022-06-04 12:19:31 | discounting | 1 | 49908 | 3 | 0.750 | 66544.0 |
| 227 | 2022-05-25 01:17:23 | discounting | 3 | 121633 | 54 | 4.393 | 27687.9 |
| 226 | 2022-05-05 19:28:16 | discounting | 4 | 148819 | 221 | 9.733 | 15290.1 |
| 225 | 2022-04-20 14:17:11 | discounting | 1 | 49908 | 3 | 1.126 | 44323.3 |
| 224 | 2022-02-27 09:03:19 | discounting | 1 | 49908 | 3 | 0.780 | 63984.6 |
| 223 | 2021-12-31 22:31:44 | discounting | 3 | 121633 | 54 | 6.156 | 19758.4 |
| 222 | 2021-12-31 13:13:27 | discounting | 3 | 121633 | 54 | 5.296 | 22967.0 |
| 221 | 2021-12-30 21:55:24 | discounting | 3 | 121633 | 54 | 5.203 | 23377.5 |
| 220 | 2021-12-30 05:39:55 | discounting | 3 | 121633 | 54 | 5.266 | 23097.8 |
| 219 | 2021-12-29 21:04:07 | discounting | 3 | 121633 | 54 | 5.123 | 23742.5 |
| 218 | 2021-12-29 14:00:55 | discounting | 3 | 121633 | 54 | 4.440 | 27394.8 |
| 217 | 2021-12-29 03:22:00 | discounting | 1 | 49908 | 3 | 0.766 | 65154.0 |
| 216 | 2021-12-28 19:25:00 | discounting | 3 | 121633 | 54 | 5.890 | 20650.8 |
| 215 | 2021-12-28 03:57:14 | discounting | 3 | 121633 | 54 | 4.986 | 24394.9 |
| 214 | 2021-12-27 18:58:41 | discounting | 3 | 121633 | 54 | 4.953 | 24557.4 |
| 213 | 2021-12-27 10:10:54 | discounting | 3 | 121633 | 54 | 5.030 | 24181.5 |
| 212 | 2021-12-26 18:27:07 | discounting | 3 | 121633 | 54 | 5.390 | 22566.4 |
| 211 | 2021-12-26 07:26:31 | discounting | 3 | 121633 | 54 | 5.453 | 22305.7 |
| 210 | 2021-12-25 19:25:59 | discounting | 3 | 121633 | 54 | 4.530 | 26850.6 |
| 209 | 2021-12-25 09:28:53 | discounting | 3 | 121633 | 54 | 5.156 | 23590.6 |