History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smithsonite"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 253 | 2025-11-18 23:07:12 | smithsonite | 3 | 121633 | 2 | 6.110 | 19907.2 |
| 252 | 2025-11-16 23:58:03 | smithsonite | 1 | 49908 | 2 | 3.720 | 13416.1 |
| 251 | 2025-09-10 11:41:33 | smithsonite | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 250 | 2025-09-10 10:57:18 | smithsonite | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 249 | 2025-08-28 03:07:25 | smithsonite | 1 | 49908 | 2 | 1.763 | 28308.6 |
| 248 | 2025-07-25 02:55:53 | smithsonite | 1 | 49908 | 2 | 4.123 | 12104.8 |
| 247 | 2025-07-24 05:14:25 | smithsonite | 1 | 49908 | 2 | 4.000 | 12477.0 |
| 246 | 2025-07-24 03:13:08 | smithsonite | 1 | 49908 | 2 | 2.860 | 17450.3 |
| 245 | 2025-03-21 05:15:14 | smithsonite | 1 | 49908 | 2 | 5.796 | 8610.8 |
| 244 | 2025-03-15 19:18:00 | smithsonite | 3 | 121633 | 2 | 27.113 | 4486.2 |
| 243 | 2025-03-15 19:18:01 | smithsonite | 3 | 121633 | 2 | 25.656 | 4740.9 |
| 242 | 2025-03-15 19:17:14 | smithsonite | 3 | 121633 | 2 | 35.563 | 3420.2 |
| 241 | 2025-03-15 19:17:13 | smithsonite | 2 | 86808 | 2 | 10.623 | 8171.7 |
| 240 | 2025-03-15 19:16:46 | smithsonite | 1 | 49908 | 2 | 3.876 | 12876.2 |
| 239 | 2025-03-08 11:30:12 | smithsonite | 4 | 148819 | 4 | 48.900 | 3043.3 |
| 238 | 2025-03-08 11:30:09 | smithsonite | 4 | 148819 | 4 | 47.656 | 3122.8 |
| 237 | 2025-03-08 11:30:05 | smithsonite | 3 | 121633 | 2 | 41.173 | 2954.2 |
| 236 | 2025-03-08 11:30:01 | smithsonite | 2 | 86808 | 2 | 10.540 | 8236.1 |
| 235 | 2025-03-04 18:49:52 | smithsonite | 1 | 49908 | 2 | 2.593 | 19247.2 |
| 234 | 2025-02-19 14:37:14 | smithsonite | 1 | 49908 | 2 | 3.673 | 13587.8 |
| 233 | 2025-02-16 16:44:11 | smithsonite | 3 | 121633 | 2 | 25.860 | 4703.5 |
| 232 | 2025-02-16 16:44:11 | smithsonite | 3 | 121633 | 2 | 25.393 | 4790.0 |
| 231 | 2025-02-16 16:44:02 | smithsonite | 2 | 86808 | 2 | 13.376 | 6489.8 |
| 230 | 2025-02-16 16:42:35 | smithsonite | 1 | 49908 | 2 | 4.313 | 11571.5 |
| 229 | 2025-01-30 13:43:17 | smithsonite | 3 | 121633 | 2 | 29.720 | 4092.6 |
| 228 | 2025-01-30 13:43:03 | smithsonite | 4 | 148819 | 4 | 35.640 | 4175.6 |
| 227 | 2025-01-30 13:42:46 | smithsonite | 4 | 148819 | 4 | 46.173 | 3223.1 |
| 226 | 2025-01-30 13:43:15 | smithsonite | 2 | 86808 | 2 | 11.720 | 7406.8 |
| 225 | 2025-01-18 05:22:30 | smithsonite | 3 | 121633 | 2 | 17.830 | 6821.8 |
| 224 | 2025-01-18 05:22:23 | smithsonite | 2 | 86808 | 2 | 10.033 | 8652.2 |
| 223 | 2025-01-17 02:55:55 | smithsonite | 1 | 49908 | 2 | 3.763 | 13262.8 |
| 222 | 2025-01-16 17:45:50 | smithsonite | 1 | 49908 | 2 | 4.140 | 12055.1 |
| 221 | 2025-01-12 14:32:32 | smithsonite | 4 | 148819 | 4 | 45.393 | 3278.5 |
| 220 | 2025-01-12 14:32:24 | smithsonite | 3 | 121633 | 2 | 24.190 | 5028.2 |
| 219 | 2025-01-12 14:32:15 | smithsonite | 2 | 86808 | 2 | 12.830 | 6766.0 |
| 218 | 2025-01-12 14:31:45 | smithsonite | 1 | 49908 | 2 | 4.000 | 12477.0 |
| 217 | 2025-01-06 09:24:13 | smithsonite | 4 | 148819 | 4 | 41.110 | 3620.0 |
| 216 | 2025-01-02 01:00:18 | smithsonite | 4 | 148819 | 4 | 59.470 | 2502.4 |
| 215 | 2025-01-02 01:00:06 | smithsonite | 4 | 148819 | 4 | 53.456 | 2784.0 |
| 214 | 2025-01-02 01:00:18 | smithsonite | 3 | 121633 | 2 | 26.123 | 4656.2 |
| 213 | 2025-01-02 01:00:11 | smithsonite | 2 | 86808 | 2 | 6.486 | 13383.9 |
| 212 | 2024-12-31 03:27:46 | smithsonite | 1 | 49908 | 2 | 3.656 | 13651.0 |
| 211 | 2024-12-17 10:54:04 | smithsonite | 4 | 148819 | 4 | 45.300 | 3285.2 |
| 210 | 2024-12-17 10:54:05 | smithsonite | 3 | 121633 | 2 | 21.076 | 5771.2 |
| 209 | 2024-12-17 10:54:09 | smithsonite | 2 | 86808 | 2 | 10.296 | 8431.2 |
| 208 | 2024-12-17 10:51:17 | smithsonite | 1 | 49908 | 2 | 4.126 | 12096.0 |
| 207 | 2024-12-05 02:28:17 | smithsonite | 3 | 121633 | 2 | 23.953 | 5078.0 |
| 206 | 2024-12-05 02:28:08 | smithsonite | 3 | 121633 | 2 | 21.126 | 5757.5 |
| 205 | 2024-12-05 02:28:12 | smithsonite | 2 | 86808 | 2 | 11.326 | 7664.5 |
| 204 | 2024-12-05 02:25:37 | smithsonite | 1 | 49908 | 2 | 2.390 | 20882.0 |
| 203 | 2024-11-24 03:40:08 | smithsonite | 1 | 49908 | 2 | 3.910 | 12764.2 |
| 202 | 2024-11-16 07:41:33 | smithsonite | 1 | 49908 | 2 | 5.953 | 8383.7 |
| 201 | 2024-11-05 12:24:13 | smithsonite | 1 | 49908 | 2 | 4.516 | 11051.4 |
| 200 | 2024-10-26 06:54:52 | smithsonite | 1 | 49908 | 2 | 3.986 | 12520.8 |
| 199 | 2024-10-25 03:30:09 | smithsonite | 1 | 49908 | 2 | 1.970 | 25334.0 |
| 198 | 2024-09-26 02:57:33 | smithsonite | 3 | 121633 | 2 | 59.003 | 2061.5 |
| 197 | 2024-09-26 02:57:11 | smithsonite | 3 | 121633 | 2 | 52.846 | 2301.7 |
| 196 | 2024-09-26 02:57:07 | smithsonite | 3 | 121633 | 2 | 47.490 | 2561.2 |
| 195 | 2024-09-26 02:56:40 | smithsonite | 3 | 121633 | 2 | 35.360 | 3439.8 |
| 194 | 2024-09-26 02:56:42 | smithsonite | 2 | 86808 | 2 | 20.533 | 4227.7 |
| 193 | 2024-09-26 02:56:19 | smithsonite | 1 | 49908 | 2 | 7.610 | 6558.2 |
| 192 | 2024-09-13 17:01:50 | smithsonite | 1 | 49908 | 2 | 10.953 | 4556.6 |
| 191 | 2024-09-13 03:06:35 | smithsonite | 4 | 148819 | 4 | 64.300 | 2314.4 |
| 190 | 2024-09-13 03:06:08 | smithsonite | 4 | 148819 | 4 | 64.270 | 2315.5 |
| 189 | 2024-09-13 03:06:09 | smithsonite | 3 | 121633 | 2 | 39.830 | 3053.8 |
| 188 | 2024-09-13 03:06:09 | smithsonite | 2 | 86808 | 2 | 8.656 | 10028.7 |
| 187 | 2024-09-13 03:05:42 | smithsonite | 1 | 49908 | 2 | 8.360 | 5969.9 |
| 186 | 2024-09-09 16:02:46 | smithsonite | 1 | 49908 | 2 | 4.453 | 11207.7 |
| 185 | 2024-08-11 00:30:14 | smithsonite | 4 | 148819 | 4 | 52.770 | 2820.1 |
| 184 | 2024-07-26 19:43:43 | smithsonite | 1 | 49908 | 2 | 5.656 | 8823.9 |
| 183 | 2024-07-21 10:01:25 | smithsonite | 4 | 148819 | 4 | 44.453 | 3347.8 |
| 182 | 2024-07-21 03:05:13 | smithsonite | 4 | 148819 | 4 | 41.486 | 3587.2 |
| 181 | 2024-07-20 20:33:33 | smithsonite | 4 | 148819 | 4 | 33.140 | 4490.6 |
| 180 | 2024-07-20 05:59:55 | smithsonite | 5 | 164607 | 64 | 50.613 | 3252.3 |
| 179 | 2024-07-20 05:59:51 | smithsonite | 4 | 148819 | 4 | 35.253 | 4221.5 |
| 178 | 2024-07-20 06:00:01 | smithsonite | 2 | 86808 | 2 | 9.423 | 9212.4 |
| 177 | 2024-07-20 05:59:58 | smithsonite | 3 | 121633 | 2 | 12.220 | 9953.6 |
| 176 | 2024-07-20 05:52:41 | smithsonite | 1 | 49908 | 2 | 1.623 | 30750.5 |
| 175 | 2024-07-17 20:11:42 | smithsonite | 1 | 49908 | 2 | 4.233 | 11790.2 |
| 174 | 2024-07-16 19:42:16 | smithsonite | 1 | 49908 | 2 | 3.936 | 12679.9 |
| 173 | 2024-07-16 19:39:26 | smithsonite | 1 | 49908 | 2 | 1.780 | 28038.2 |
| 172 | 2024-07-07 03:23:52 | smithsonite | 1 | 49908 | 2 | 4.533 | 11009.9 |
| 171 | 2024-07-03 18:08:25 | smithsonite | 3 | 121633 | 2 | 30.250 | 4020.9 |
| 170 | 2024-07-03 18:08:29 | smithsonite | 2 | 86808 | 2 | 11.046 | 7858.8 |
| 169 | 2024-07-03 18:08:21 | smithsonite | 4 | 148819 | 4 | 16.813 | 8851.4 |
| 168 | 2024-07-03 18:01:38 | smithsonite | 1 | 49908 | 2 | 3.800 | 13133.7 |
| 167 | 2024-06-25 17:50:26 | smithsonite | 1 | 49908 | 2 | 4.013 | 12436.6 |
| 166 | 2024-06-14 15:05:02 | smithsonite | 4 | 148819 | 4 | 53.846 | 2763.8 |
| 165 | 2024-06-13 11:04:42 | smithsonite | 1 | 49908 | 2 | 3.983 | 12530.3 |
| 164 | 2024-06-13 08:37:24 | smithsonite | 3 | 121633 | 2 | 21.110 | 5761.9 |
| 163 | 2024-06-12 14:42:41 | smithsonite | 4 | 148819 | 4 | 58.473 | 2545.1 |
| 162 | 2024-06-12 14:42:51 | smithsonite | 4 | 148819 | 4 | 44.470 | 3346.5 |
| 161 | 2024-06-12 14:42:46 | smithsonite | 3 | 121633 | 2 | 31.813 | 3823.4 |
| 160 | 2024-06-12 14:42:47 | smithsonite | 4 | 148819 | 4 | 30.313 | 4909.4 |
| 159 | 2024-06-12 14:42:45 | smithsonite | 2 | 86808 | 2 | 18.596 | 4668.1 |
| 158 | 2024-06-12 14:40:54 | smithsonite | 1 | 49908 | 2 | 6.500 | 7678.2 |
| 157 | 2024-06-12 04:18:27 | smithsonite | 5 | 164607 | 64 | 72.833 | 2260.1 |
| 156 | 2024-06-12 04:17:55 | smithsonite | 5 | 164607 | 64 | 79.616 | 2067.5 |
| 155 | 2024-06-12 04:18:29 | smithsonite | 4 | 148819 | 4 | 39.503 | 3767.3 |
| 154 | 2024-06-12 04:18:29 | smithsonite | 3 | 121633 | 2 | 28.813 | 4221.5 |