History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deficiency"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 321 | 2025-09-08 03:15:04 | deficiency | 2 | 108824 | 5 | 2.686 | 40515.3 |
| 320 | 2025-09-07 17:51:39 | deficiency | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 319 | 2025-09-07 13:51:51 | deficiency | 1 | 67641 | 1 | 1.220 | 55443.4 |
| 318 | 2025-08-30 14:02:40 | deficiency | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 317 | 2025-07-25 04:55:47 | deficiency | 1 | 67641 | 1 | 8.330 | 8120.2 |
| 316 | 2025-07-24 22:07:31 | deficiency | 1 | 67641 | 1 | 5.343 | 12659.7 |
| 315 | 2025-07-24 17:17:09 | deficiency | 1 | 67641 | 1 | 4.220 | 16028.7 |
| 314 | 2025-07-02 04:58:33 | deficiency | 1 | 67641 | 1 | 5.096 | 13273.4 |
| 313 | 2025-06-16 05:51:21 | deficiency | 4 | 161450 | 49 | 46.046 | 3506.3 |
| 312 | 2025-06-14 10:03:37 | deficiency | 1 | 67641 | 1 | 5.986 | 11299.9 |
| 311 | 2025-06-12 08:56:56 | deficiency | 2 | 108824 | 5 | 8.000 | 13603.0 |
| 310 | 2025-06-12 03:58:13 | deficiency | 4 | 161450 | 49 | 56.360 | 2864.6 |
| 309 | 2025-06-12 02:18:30 | deficiency | 3 | 140603 | 14 | 28.893 | 4866.3 |
| 308 | 2025-06-11 11:58:56 | deficiency | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 307 | 2025-05-14 12:20:31 | deficiency | 1 | 67641 | 1 | 3.220 | 21006.5 |
| 306 | 2025-03-29 14:25:45 | deficiency | 1 | 67641 | 1 | 4.983 | 13574.4 |
| 305 | 2025-03-23 17:12:14 | deficiency | 3 | 140603 | 14 | 23.580 | 5962.8 |
| 304 | 2025-03-16 16:08:52 | deficiency | 3 | 140603 | 14 | 41.753 | 3367.5 |
| 303 | 2025-03-15 03:18:37 | deficiency | 1 | 67641 | 1 | 5.503 | 12291.7 |
| 302 | 2025-03-10 23:36:50 | deficiency | 3 | 140603 | 14 | 36.940 | 3806.3 |
| 301 | 2025-03-01 06:26:37 | deficiency | 1 | 67641 | 1 | 2.546 | 26567.6 |
| 300 | 2025-02-23 00:53:10 | deficiency | 3 | 140603 | 14 | 41.160 | 3416.0 |
| 299 | 2025-02-22 16:13:06 | deficiency | 3 | 140603 | 14 | 26.536 | 5298.6 |
| 298 | 2025-02-22 16:12:52 | deficiency | 2 | 108824 | 5 | 13.953 | 7799.3 |
| 297 | 2025-02-22 16:08:25 | deficiency | 1 | 67641 | 1 | 6.170 | 10962.9 |
| 296 | 2025-01-31 09:15:20 | deficiency | 4 | 161450 | 49 | 44.253 | 3648.3 |
| 295 | 2025-01-30 17:51:05 | deficiency | 4 | 161450 | 49 | 60.863 | 2652.7 |
| 294 | 2025-01-29 21:23:03 | deficiency | 3 | 140603 | 14 | 27.593 | 5095.6 |
| 293 | 2025-01-22 22:11:44 | deficiency | 3 | 140603 | 14 | 30.783 | 4567.6 |
| 292 | 2025-01-22 22:06:34 | deficiency | 1 | 67641 | 1 | 2.750 | 24596.7 |
| 291 | 2025-01-18 09:05:49 | deficiency | 4 | 161450 | 49 | 47.453 | 3402.3 |
| 290 | 2025-01-18 09:05:39 | deficiency | 3 | 140603 | 14 | 31.813 | 4419.7 |
| 289 | 2025-01-18 09:05:25 | deficiency | 1 | 67641 | 1 | 4.813 | 14053.8 |
| 288 | 2025-01-17 12:18:21 | deficiency | 3 | 140603 | 14 | 23.486 | 5986.7 |
| 287 | 2025-01-16 21:23:54 | deficiency | 2 | 108824 | 5 | 16.800 | 6477.6 |
| 286 | 2025-01-12 12:28:29 | deficiency | 2 | 108824 | 5 | 14.623 | 7442.0 |
| 285 | 2025-01-03 17:37:50 | deficiency | 3 | 140603 | 14 | 24.233 | 5802.1 |
| 284 | 2025-01-03 17:37:48 | deficiency | 2 | 108824 | 5 | 21.690 | 5017.2 |
| 283 | 2025-01-02 22:38:24 | deficiency | 3 | 140603 | 14 | 32.593 | 4313.9 |
| 282 | 2025-01-02 22:38:25 | deficiency | 2 | 108824 | 5 | 9.576 | 11364.2 |
| 281 | 2025-01-02 22:37:12 | deficiency | 1 | 67641 | 1 | 5.296 | 12772.1 |
| 280 | 2025-01-01 00:58:29 | deficiency | 3 | 140603 | 14 | 31.300 | 4492.1 |
| 279 | 2024-12-30 11:41:58 | deficiency | 1 | 67641 | 1 | 5.220 | 12958.0 |
| 278 | 2024-12-30 00:25:19 | deficiency | 4 | 161450 | 49 | 57.490 | 2808.3 |
| 277 | 2024-12-28 22:30:29 | deficiency | 4 | 161450 | 49 | 45.720 | 3531.3 |
| 276 | 2024-12-23 17:36:25 | deficiency | 1 | 67641 | 1 | 5.406 | 12512.2 |
| 275 | 2024-12-20 20:36:14 | deficiency | 4 | 161450 | 49 | 47.313 | 3412.4 |
| 274 | 2024-12-19 07:26:33 | deficiency | 3 | 140603 | 14 | 29.066 | 4837.4 |
| 273 | 2024-12-13 13:15:06 | deficiency | 3 | 140603 | 14 | 31.846 | 4415.1 |
| 272 | 2024-12-02 03:30:55 | deficiency | 1 | 67641 | 1 | 5.296 | 12772.1 |
| 271 | 2024-11-30 22:55:12 | deficiency | 2 | 108824 | 5 | 11.160 | 9751.3 |
| 270 | 2024-11-30 14:22:05 | deficiency | 3 | 140603 | 14 | 29.500 | 4766.2 |
| 269 | 2024-11-29 22:34:44 | deficiency | 3 | 140603 | 14 | 47.253 | 2975.5 |
| 268 | 2024-11-29 15:46:55 | deficiency | 3 | 140603 | 14 | 39.563 | 3553.9 |
| 267 | 2024-11-29 15:46:58 | deficiency | 2 | 108824 | 5 | 15.780 | 6896.3 |
| 266 | 2024-11-28 17:33:13 | deficiency | 4 | 161450 | 49 | 78.583 | 2054.5 |
| 265 | 2024-11-25 08:37:45 | deficiency | 4 | 161450 | 49 | 54.143 | 2981.9 |
| 264 | 2024-11-23 23:07:38 | deficiency | 4 | 161450 | 49 | 49.203 | 3281.3 |
| 263 | 2024-11-23 05:37:49 | deficiency | 4 | 161450 | 49 | 56.546 | 2855.2 |
| 262 | 2024-11-17 00:29:52 | deficiency | 2 | 108824 | 5 | 19.783 | 5500.9 |
| 261 | 2024-11-16 23:13:19 | deficiency | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 260 | 2024-11-16 08:14:04 | deficiency | 3 | 140603 | 14 | 24.830 | 5662.6 |
| 259 | 2024-11-08 22:30:40 | deficiency | 1 | 67641 | 1 | 3.923 | 17242.2 |
| 258 | 2024-11-06 23:43:13 | deficiency | 3 | 140603 | 14 | 26.423 | 5321.2 |
| 257 | 2024-11-02 12:09:16 | deficiency | 2 | 108824 | 5 | 14.953 | 7277.7 |
| 256 | 2024-11-01 03:25:05 | deficiency | 1 | 67641 | 1 | 2.516 | 26884.3 |
| 255 | 2024-10-28 15:38:27 | deficiency | 4 | 161450 | 49 | 46.206 | 3494.1 |
| 254 | 2024-10-28 15:38:39 | deficiency | 2 | 108824 | 5 | 7.906 | 13764.7 |
| 253 | 2024-10-28 15:37:02 | deficiency | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 252 | 2024-10-26 14:48:39 | deficiency | 5 | 173545 | 353 | 115.633 | 1500.8 |
| 251 | 2024-10-20 00:15:25 | deficiency | 5 | 173545 | 353 | 119.536 | 1451.8 |
| 250 | 2024-10-20 00:15:07 | deficiency | 3 | 140603 | 14 | 37.656 | 3733.9 |
| 249 | 2024-10-19 17:00:39 | deficiency | 5 | 173545 | 353 | 92.333 | 1879.6 |
| 248 | 2024-10-19 11:46:23 | deficiency | 5 | 173545 | 353 | 83.456 | 2079.5 |
| 247 | 2024-10-19 02:12:53 | deficiency | 5 | 173545 | 353 | 84.360 | 2057.2 |
| 246 | 2024-10-18 18:24:58 | deficiency | 3 | 140603 | 14 | 38.846 | 3619.5 |
| 245 | 2024-10-05 20:05:38 | deficiency | 3 | 140603 | 14 | 48.253 | 2913.9 |
| 244 | 2024-10-01 14:22:18 | deficiency | 1 | 67641 | 1 | 5.830 | 11602.2 |
| 243 | 2024-09-28 02:48:08 | deficiency | 1 | 67641 | 1 | 9.623 | 7029.1 |
| 242 | 2024-09-18 12:42:18 | deficiency | 1 | 67641 | 1 | 7.203 | 9390.7 |
| 241 | 2024-09-16 13:36:11 | deficiency | 3 | 140603 | 14 | 43.410 | 3239.0 |
| 240 | 2024-09-15 12:40:50 | deficiency | 5 | 173545 | 353 | 133.130 | 1303.6 |
| 239 | 2024-09-15 12:40:54 | deficiency | 3 | 140603 | 14 | 63.533 | 2213.1 |
| 238 | 2024-09-15 12:40:57 | deficiency | 2 | 108824 | 5 | 24.610 | 4421.9 |
| 237 | 2024-09-15 12:37:24 | deficiency | 1 | 67641 | 1 | 4.110 | 16457.7 |
| 236 | 2024-08-31 12:59:55 | deficiency | 1 | 67641 | 1 | 10.453 | 6471.0 |
| 235 | 2024-08-04 01:28:22 | deficiency | 3 | 140603 | 14 | 20.690 | 6795.7 |
| 234 | 2024-08-04 01:28:16 | deficiency | 2 | 108824 | 5 | 15.500 | 7020.9 |
| 233 | 2024-08-01 08:54:52 | deficiency | 1 | 67641 | 1 | 2.546 | 26567.6 |
| 232 | 2024-07-31 05:57:45 | deficiency | 3 | 140603 | 14 | 24.156 | 5820.6 |
| 231 | 2024-07-31 05:57:30 | deficiency | 2 | 108824 | 5 | 15.343 | 7092.7 |
| 230 | 2024-07-27 17:22:14 | deficiency | 4 | 161450 | 49 | 19.343 | 8346.7 |
| 229 | 2024-07-27 17:22:03 | deficiency | 3 | 140603 | 14 | 28.893 | 4866.3 |
| 228 | 2024-07-27 09:30:32 | deficiency | 4 | 161450 | 49 | 46.143 | 3498.9 |
| 227 | 2024-07-24 05:40:12 | deficiency | 3 | 140603 | 14 | 22.360 | 6288.1 |
| 226 | 2024-07-23 11:30:40 | deficiency | 4 | 161450 | 49 | 20.826 | 7752.3 |
| 225 | 2024-07-23 07:23:29 | deficiency | 4 | 161450 | 49 | 36.126 | 4469.1 |
| 224 | 2024-07-22 22:40:18 | deficiency | 4 | 161450 | 49 | 38.050 | 4243.1 |
| 223 | 2024-07-22 22:40:35 | deficiency | 2 | 108824 | 5 | 14.936 | 7286.0 |
| 222 | 2024-07-22 22:40:28 | deficiency | 3 | 140603 | 14 | 17.436 | 8063.9 |