History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"supplies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 290 | 2024-04-27 08:20:23 | supplies | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 289 | 2024-04-23 16:00:11 | supplies | 3 | 146162 | 160 | 22.563 | 6478.0 |
| 288 | 2024-04-23 15:57:07 | supplies | 3 | 146162 | 160 | 20.890 | 6996.7 |
| 287 | 2024-04-23 15:57:05 | supplies | 2 | 121059 | 21 | 11.626 | 10412.8 |
| 286 | 2024-04-23 15:44:15 | supplies | 1 | 82945 | 5 | 4.843 | 17126.8 |
| 285 | 2024-04-13 06:51:37 | supplies | 2 | 121059 | 21 | 4.033 | 30017.1 |
| 284 | 2024-04-10 19:33:29 | supplies | 3 | 146162 | 160 | 11.423 | 12795.4 |
| 283 | 2024-04-09 17:23:20 | supplies | 2 | 121059 | 21 | 14.093 | 8590.0 |
| 282 | 2024-04-09 17:23:21 | supplies | 1 | 82945 | 5 | 1.920 | 43200.5 |
| 281 | 2024-04-09 17:13:04 | supplies | 3 | 146162 | 160 | 9.470 | 15434.2 |
| 280 | 2024-04-09 10:35:48 | supplies | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 279 | 2024-04-09 05:34:54 | supplies | 3 | 146162 | 160 | 27.423 | 5329.9 |
| 278 | 2024-04-09 05:34:53 | supplies | 2 | 121059 | 21 | 15.393 | 7864.5 |
| 277 | 2024-04-09 01:10:05 | supplies | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 276 | 2024-04-09 01:09:54 | supplies | 3 | 146162 | 160 | 7.876 | 18557.9 |
| 275 | 2024-04-09 01:09:55 | supplies | 2 | 121059 | 21 | 3.970 | 30493.5 |
| 274 | 2024-04-09 01:09:52 | supplies | 1 | 82945 | 5 | 1.626 | 51011.7 |
| 273 | 2024-04-05 03:12:18 | supplies | 2 | 121059 | 21 | 9.203 | 13154.3 |
| 272 | 2024-04-05 03:12:20 | supplies | 1 | 82945 | 5 | 3.266 | 25396.5 |
| 271 | 2024-03-30 02:52:19 | supplies | 3 | 146162 | 160 | 7.266 | 20115.9 |
| 270 | 2024-03-30 02:52:19 | supplies | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 269 | 2024-03-10 06:44:51 | supplies | 3 | 146162 | 160 | 23.830 | 6133.5 |
| 268 | 2024-03-09 20:57:40 | supplies | 3 | 146162 | 160 | 10.453 | 13982.8 |
| 267 | 2024-03-09 20:57:30 | supplies | 2 | 121059 | 21 | 8.893 | 13612.8 |
| 266 | 2024-03-09 01:36:27 | supplies | 3 | 146162 | 160 | 32.423 | 4508.0 |
| 265 | 2024-03-09 01:36:13 | supplies | 2 | 121059 | 21 | 4.373 | 27683.3 |
| 264 | 2024-03-08 21:13:09 | supplies | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 263 | 2024-03-08 18:57:29 | supplies | 3 | 146162 | 160 | 10.486 | 13938.8 |
| 262 | 2024-03-08 18:57:30 | supplies | 2 | 121059 | 21 | 4.390 | 27576.1 |
| 261 | 2024-03-08 18:57:27 | supplies | 1 | 82945 | 5 | 1.750 | 47397.1 |
| 260 | 2024-03-05 14:21:28 | supplies | 2 | 121059 | 21 | 5.466 | 22147.6 |
| 259 | 2024-03-03 08:07:32 | supplies | 1 | 82945 | 5 | 1.810 | 45826.0 |
| 258 | 2024-02-29 14:45:37 | supplies | 2 | 121059 | 21 | 4.000 | 30264.8 |
| 257 | 2024-02-14 19:28:47 | supplies | 1 | 82945 | 5 | 1.813 | 45750.1 |
| 256 | 2024-02-08 07:24:02 | supplies | 3 | 146162 | 160 | 7.783 | 18779.6 |
| 255 | 2024-02-08 07:24:02 | supplies | 2 | 121059 | 21 | 7.736 | 15648.8 |
| 254 | 2024-02-06 20:01:34 | supplies | 3 | 146162 | 160 | 7.580 | 19282.6 |
| 253 | 2024-02-06 17:40:47 | supplies | 3 | 146162 | 160 | 10.686 | 13677.9 |
| 252 | 2024-02-05 19:23:18 | supplies | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 251 | 2024-02-05 19:22:54 | supplies | 3 | 146162 | 160 | 6.970 | 20970.2 |
| 250 | 2024-02-05 19:22:50 | supplies | 2 | 121059 | 21 | 3.906 | 30993.1 |
| 249 | 2024-01-31 10:46:32 | supplies | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 248 | 2024-01-29 10:28:57 | supplies | 1 | 82945 | 5 | 1.450 | 57203.4 |
| 247 | 2024-01-25 16:54:31 | supplies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 246 | 2024-01-05 22:02:18 | supplies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 245 | 2023-12-26 00:14:04 | supplies | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 244 | 2023-12-03 02:28:03 | supplies | 1 | 82945 | 5 | 1.300 | 63803.8 |
| 243 | 2023-11-29 01:21:13 | supplies | 1 | 82945 | 5 | 1.346 | 61623.3 |
| 242 | 2023-11-21 05:23:31 | supplies | 2 | 121059 | 21 | 3.686 | 32842.9 |
| 241 | 2023-11-07 00:33:57 | supplies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 240 | 2023-10-17 16:03:41 | supplies | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 239 | 2023-09-18 08:58:17 | supplies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 238 | 2023-09-07 23:49:40 | supplies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 237 | 2023-08-22 02:23:00 | supplies | 2 | 121059 | 21 | 3.250 | 37248.9 |
| 236 | 2023-07-10 12:29:20 | supplies | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 235 | 2023-05-25 03:03:37 | supplies | 1 | 82945 | 5 | 1.450 | 57203.4 |
| 234 | 2023-05-08 03:06:25 | supplies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 233 | 2023-05-07 10:20:06 | supplies | 2 | 121059 | 21 | 3.640 | 33258.0 |
| 232 | 2023-04-17 17:25:30 | supplies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 231 | 2023-03-24 02:21:54 | supplies | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 230 | 2023-02-11 10:25:34 | supplies | 2 | 121059 | 21 | 3.110 | 38925.7 |
| 229 | 2023-02-09 15:14:33 | supplies | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 228 | 2023-01-10 20:30:20 | supplies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 227 | 2022-12-07 10:18:52 | supplies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 226 | 2022-11-23 18:23:00 | supplies | 2 | 121059 | 21 | 3.203 | 37795.5 |
| 225 | 2022-09-05 11:24:19 | supplies | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 224 | 2022-08-10 17:22:09 | supplies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 223 | 2022-08-04 12:20:00 | supplies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 222 | 2022-08-03 01:07:20 | supplies | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 221 | 2022-08-02 03:38:48 | supplies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 220 | 2022-07-29 04:02:31 | supplies | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 219 | 2022-07-25 07:25:29 | supplies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 218 | 2022-07-15 23:42:11 | supplies | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 217 | 2022-06-17 05:14:50 | supplies | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 216 | 2022-06-04 04:46:02 | supplies | 1 | 82945 | 5 | 1.576 | 52630.1 |
| 215 | 2022-05-03 06:42:26 | supplies | 1 | 82945 | 5 | 1.300 | 63803.8 |
| 214 | 2022-04-27 15:07:45 | supplies | 2 | 121059 | 21 | 4.390 | 27576.1 |
| 213 | 2022-03-31 17:56:35 | supplies | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 212 | 2022-03-29 14:48:24 | supplies | 1 | 82945 | 5 | 2.076 | 39954.2 |
| 211 | 2022-01-02 23:37:44 | supplies | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 210 | 2021-12-31 05:08:57 | supplies | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 209 | 2021-12-30 18:19:42 | supplies | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 208 | 2021-11-15 04:05:49 | supplies | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 207 | 2021-09-22 11:10:02 | supplies | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 206 | 2021-09-21 10:16:10 | supplies | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 205 | 2021-09-17 07:00:28 | supplies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 204 | 2021-09-15 05:46:14 | supplies | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 203 | 2021-06-25 12:17:47 | supplies | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 202 | 2021-06-06 16:55:48 | supplies | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 201 | 2021-06-03 12:33:58 | supplies | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 200 | 2021-04-06 18:51:59 | supplies | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 199 | 2021-03-01 01:56:27 | supplies | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 198 | 2021-02-14 15:30:19 | supplies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 197 | 2020-11-24 16:55:52 | supplies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 196 | 2020-10-20 19:36:04 | supplies | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 195 | 2020-08-13 08:23:00 | supplies | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 194 | 2020-07-29 07:53:25 | supplies | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 193 | 2020-05-12 06:29:31 | supplies | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 192 | 2020-05-01 18:20:27 | supplies | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 191 | 2020-03-23 13:50:22 | supplies | 1 | 82945 | 5 | 1.843 | 45005.4 |