History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"carnallite"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 310 | 2025-12-25 14:25:44 | carnallite | 1 | 67641 | 2 | 1.280 | 52844.5 |
| 309 | 2025-10-14 19:43:59 | carnallite | 1 | 67641 | 2 | 1.233 | 54858.9 |
| 308 | 2025-09-22 12:21:03 | carnallite | 1 | 67641 | 2 | 1.190 | 56841.2 |
| 307 | 2025-09-12 10:32:07 | carnallite | 3 | 140603 | 13 | 6.486 | 21677.9 |
| 306 | 2025-09-10 04:17:41 | carnallite | 1 | 67641 | 2 | 1.186 | 57032.9 |
| 305 | 2025-08-31 12:20:42 | carnallite | 1 | 67641 | 2 | 1.063 | 63632.2 |
| 304 | 2025-08-25 12:54:24 | carnallite | 4 | 161450 | 103 | 85.410 | 1890.3 |
| 303 | 2025-08-21 17:43:08 | carnallite | 4 | 161450 | 103 | 11.780 | 13705.4 |
| 302 | 2025-08-21 17:22:34 | carnallite | 4 | 161450 | 103 | 30.813 | 5239.7 |
| 301 | 2025-07-29 12:44:44 | carnallite | 3 | 140603 | 13 | 24.580 | 5720.2 |
| 300 | 2025-07-29 01:00:08 | carnallite | 2 | 108824 | 3 | 21.250 | 5121.1 |
| 299 | 2025-07-28 23:43:27 | carnallite | 3 | 140603 | 13 | 31.080 | 4523.9 |
| 298 | 2025-07-27 04:10:48 | carnallite | 1 | 67641 | 2 | 2.936 | 23038.5 |
| 297 | 2025-07-26 12:35:06 | carnallite | 1 | 67641 | 2 | 3.296 | 20522.1 |
| 296 | 2025-07-24 17:24:03 | carnallite | 1 | 67641 | 2 | 6.126 | 11041.6 |
| 295 | 2025-07-23 18:51:54 | carnallite | 1 | 67641 | 2 | 2.733 | 24749.7 |
| 294 | 2025-07-20 13:21:15 | carnallite | 3 | 140603 | 13 | 16.220 | 8668.5 |
| 293 | 2025-07-15 09:53:34 | carnallite | 2 | 108824 | 3 | 11.593 | 9387.0 |
| 292 | 2025-07-09 03:20:05 | carnallite | 1 | 67641 | 2 | 1.126 | 60071.9 |
| 291 | 2025-06-29 22:42:06 | carnallite | 1 | 67641 | 2 | 3.250 | 20812.6 |
| 290 | 2025-06-16 02:23:07 | carnallite | 1 | 67641 | 2 | 2.906 | 23276.3 |
| 289 | 2025-06-10 05:44:29 | carnallite | 1 | 67641 | 2 | 5.906 | 11452.9 |
| 288 | 2025-05-31 15:47:53 | carnallite | 2 | 108824 | 3 | 11.766 | 9249.0 |
| 287 | 2025-05-29 21:03:06 | carnallite | 1 | 67641 | 2 | 1.216 | 55625.8 |
| 286 | 2025-05-28 08:35:40 | carnallite | 1 | 67641 | 2 | 1.220 | 55443.4 |
| 285 | 2025-05-27 10:31:58 | carnallite | 1 | 67641 | 2 | 5.936 | 11395.0 |
| 283 | 2025-05-27 10:31:58 | carnallite | 1 | 67641 | 2 | 5.500 | 12298.4 |
| 282 | 2025-05-23 22:28:05 | carnallite | 1 | 67641 | 2 | 5.673 | 11923.3 |
| 281 | 2025-05-17 21:46:05 | carnallite | 1 | 67641 | 2 | 2.766 | 24454.4 |
| 280 | 2025-05-16 12:01:51 | carnallite | 1 | 67641 | 2 | 8.483 | 7973.7 |
| 279 | 2025-05-16 04:06:55 | carnallite | 1 | 67641 | 2 | 6.500 | 10406.3 |
| 278 | 2025-05-03 02:40:23 | carnallite | 1 | 67641 | 2 | 5.016 | 13485.0 |
| 277 | 2025-04-02 04:38:18 | carnallite | 1 | 67641 | 2 | 5.860 | 11542.8 |
| 276 | 2025-03-21 13:51:12 | carnallite | 1 | 67641 | 2 | 3.813 | 17739.6 |
| 275 | 2025-03-08 23:07:28 | carnallite | 1 | 67641 | 2 | 3.846 | 17587.4 |
| 274 | 2025-02-20 16:35:45 | carnallite | 3 | 140603 | 13 | 29.630 | 4745.3 |
| 273 | 2025-02-20 16:35:43 | carnallite | 2 | 108824 | 3 | 10.610 | 10256.7 |
| 272 | 2025-02-20 16:34:02 | carnallite | 1 | 67641 | 2 | 5.310 | 12738.4 |
| 271 | 2025-02-03 10:08:03 | carnallite | 3 | 140603 | 13 | 34.956 | 4022.3 |
| 270 | 2025-02-02 06:20:10 | carnallite | 2 | 108824 | 3 | 24.003 | 4533.8 |
| 269 | 2025-02-02 06:20:00 | carnallite | 3 | 140603 | 13 | 27.016 | 5204.4 |
| 268 | 2025-02-02 06:19:19 | carnallite | 1 | 67641 | 2 | 3.643 | 18567.4 |
| 267 | 2025-01-27 22:42:25 | carnallite | 1 | 67641 | 2 | 5.716 | 11833.6 |
| 266 | 2025-01-24 18:26:18 | carnallite | 1 | 67641 | 2 | 1.156 | 58513.0 |
| 265 | 2025-01-23 05:53:45 | carnallite | 3 | 140603 | 13 | 31.360 | 4483.5 |
| 264 | 2025-01-19 18:13:09 | carnallite | 3 | 140603 | 13 | 44.296 | 3174.2 |
| 263 | 2025-01-19 18:13:05 | carnallite | 3 | 140603 | 13 | 38.186 | 3682.1 |
| 262 | 2025-01-19 18:13:08 | carnallite | 2 | 108824 | 3 | 24.283 | 4481.5 |
| 261 | 2025-01-19 18:09:54 | carnallite | 1 | 67641 | 2 | 3.080 | 21961.4 |
| 260 | 2025-01-19 14:59:36 | carnallite | 1 | 67641 | 2 | 5.233 | 12925.9 |
| 259 | 2025-01-01 08:01:21 | carnallite | 3 | 140603 | 13 | 38.816 | 3622.3 |
| 258 | 2025-01-01 08:01:23 | carnallite | 2 | 108824 | 3 | 15.390 | 7071.1 |
| 257 | 2025-01-01 08:00:20 | carnallite | 3 | 140603 | 13 | 33.516 | 4195.1 |
| 256 | 2025-01-01 07:56:37 | carnallite | 1 | 67641 | 2 | 2.250 | 30062.7 |
| 255 | 2024-12-27 17:36:06 | carnallite | 1 | 67641 | 2 | 1.203 | 56226.9 |
| 254 | 2024-12-22 07:08:00 | carnallite | 2 | 108824 | 3 | 16.406 | 6633.2 |
| 253 | 2024-12-19 09:55:29 | carnallite | 3 | 140603 | 13 | 34.203 | 4110.8 |
| 252 | 2024-12-19 09:55:30 | carnallite | 2 | 108824 | 3 | 10.030 | 10849.9 |
| 251 | 2024-12-19 09:53:12 | carnallite | 1 | 67641 | 2 | 2.486 | 27208.8 |
| 250 | 2024-12-08 07:53:55 | carnallite | 1 | 67641 | 2 | 3.686 | 18350.8 |
| 249 | 2024-11-26 22:48:33 | carnallite | 3 | 140603 | 13 | 53.846 | 2611.2 |
| 248 | 2024-11-25 00:20:07 | carnallite | 4 | 161450 | 103 | 71.843 | 2247.3 |
| 247 | 2024-11-25 00:20:12 | carnallite | 3 | 140603 | 13 | 47.673 | 2949.3 |
| 246 | 2024-11-25 00:20:09 | carnallite | 2 | 108824 | 3 | 16.626 | 6545.4 |
| 245 | 2024-11-25 00:09:24 | carnallite | 1 | 67641 | 2 | 6.156 | 10987.8 |
| 244 | 2024-11-16 13:58:54 | carnallite | 3 | 140603 | 13 | 27.016 | 5204.4 |
| 243 | 2024-11-16 13:59:05 | carnallite | 2 | 108824 | 3 | 12.280 | 8861.9 |
| 242 | 2024-11-16 13:22:23 | carnallite | 1 | 67641 | 2 | 1.110 | 60937.8 |
| 241 | 2024-11-02 04:31:48 | carnallite | 2 | 108824 | 3 | 15.063 | 7224.6 |
| 240 | 2024-11-02 04:26:09 | carnallite | 1 | 67641 | 2 | 1.750 | 38652.0 |
| 239 | 2024-10-31 21:48:27 | carnallite | 2 | 108824 | 3 | 15.923 | 6834.4 |
| 238 | 2024-10-31 21:48:03 | carnallite | 1 | 67641 | 2 | 6.406 | 10559.0 |
| 237 | 2024-10-16 21:25:57 | carnallite | 3 | 140603 | 13 | 32.173 | 4370.2 |
| 236 | 2024-10-14 00:03:27 | carnallite | 3 | 140603 | 13 | 34.706 | 4051.3 |
| 235 | 2024-10-14 00:03:26 | carnallite | 3 | 140603 | 13 | 26.906 | 5225.7 |
| 234 | 2024-10-14 00:03:26 | carnallite | 2 | 108824 | 3 | 24.673 | 4410.7 |
| 233 | 2024-10-14 00:01:38 | carnallite | 1 | 67641 | 2 | 2.360 | 28661.4 |
| 232 | 2024-10-13 09:25:03 | carnallite | 3 | 140603 | 13 | 34.376 | 4090.2 |
| 231 | 2024-10-13 08:48:20 | carnallite | 3 | 140603 | 13 | 31.750 | 4428.4 |
| 230 | 2024-10-13 03:38:37 | carnallite | 3 | 140603 | 13 | 49.423 | 2844.9 |
| 229 | 2024-10-13 00:53:03 | carnallite | 4 | 161450 | 103 | 61.066 | 2643.9 |
| 228 | 2024-10-13 00:53:03 | carnallite | 3 | 140603 | 13 | 34.830 | 4036.8 |
| 227 | 2024-10-13 00:53:05 | carnallite | 2 | 108824 | 3 | 15.863 | 6860.2 |
| 226 | 2024-09-27 03:01:19 | carnallite | 1 | 67641 | 2 | 9.123 | 7414.3 |
| 225 | 2024-09-09 02:12:38 | carnallite | 1 | 67641 | 2 | 6.783 | 9972.1 |
| 224 | 2024-08-24 21:52:12 | carnallite | 1 | 67641 | 2 | 1.076 | 62863.4 |
| 223 | 2024-08-22 00:24:00 | carnallite | 1 | 67641 | 2 | 3.890 | 17388.4 |
| 222 | 2024-08-06 01:48:56 | carnallite | 2 | 108824 | 3 | 13.373 | 8137.6 |
| 221 | 2024-08-06 01:48:45 | carnallite | 3 | 140603 | 13 | 17.156 | 8195.6 |
| 220 | 2024-08-06 01:44:39 | carnallite | 1 | 67641 | 2 | 2.576 | 26258.2 |
| 219 | 2024-07-20 22:24:01 | carnallite | 4 | 161450 | 103 | 39.390 | 4098.8 |
| 218 | 2024-07-19 16:58:53 | carnallite | 2 | 108824 | 3 | 15.406 | 7063.7 |
| 217 | 2024-07-19 16:58:49 | carnallite | 3 | 140603 | 13 | 12.920 | 10882.6 |
| 216 | 2024-07-19 16:53:31 | carnallite | 1 | 67641 | 2 | 4.156 | 16275.5 |
| 215 | 2024-07-19 16:01:50 | carnallite | 3 | 140603 | 13 | 29.516 | 4763.6 |
| 214 | 2024-07-19 16:01:48 | carnallite | 2 | 108824 | 3 | 6.003 | 18128.3 |
| 213 | 2024-07-19 14:00:13 | carnallite | 4 | 161450 | 103 | 50.363 | 3205.7 |
| 212 | 2024-07-18 10:25:39 | carnallite | 4 | 161450 | 103 | 34.563 | 4671.2 |
| 211 | 2024-07-18 04:57:20 | carnallite | 4 | 161450 | 103 | 64.596 | 2499.4 |