History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subtone"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 275 | 2024-04-01 13:16:41 | subtone | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 274 | 2024-03-29 22:52:34 | subtone | 1 | 69583 | 3 | 4.253 | 16360.9 |
| 273 | 2024-02-27 20:16:03 | subtone | 1 | 69583 | 3 | 4.203 | 16555.6 |
| 272 | 2024-02-11 02:49:04 | subtone | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 271 | 2024-01-20 00:58:43 | subtone | 2 | 107671 | 17 | 3.436 | 31336.1 |
| 270 | 2024-01-12 03:39:43 | subtone | 3 | 134027 | 188 | 5.766 | 23244.4 |
| 269 | 2023-12-24 06:23:33 | subtone | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 268 | 2023-11-21 17:59:56 | subtone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 267 | 2023-11-06 11:23:37 | subtone | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 266 | 2023-10-30 21:52:25 | subtone | 2 | 107671 | 17 | 2.873 | 37476.9 |
| 265 | 2023-10-24 13:13:36 | subtone | 3 | 134027 | 188 | 5.873 | 22820.9 |
| 264 | 2023-10-18 07:21:28 | subtone | 3 | 134027 | 188 | 6.546 | 20474.6 |
| 263 | 2023-10-11 20:15:12 | subtone | 1 | 69583 | 3 | 2.156 | 32274.1 |
| 262 | 2023-09-29 22:12:16 | subtone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 261 | 2023-09-25 19:11:35 | subtone | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 260 | 2023-08-07 18:09:22 | subtone | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 259 | 2023-08-06 21:55:52 | subtone | 2 | 107671 | 17 | 3.390 | 31761.4 |
| 258 | 2023-07-30 15:27:05 | subtone | 3 | 134027 | 188 | 5.750 | 23309.0 |
| 257 | 2023-05-19 23:40:41 | subtone | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 256 | 2023-05-07 13:15:18 | subtone | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 255 | 2023-04-19 11:18:17 | subtone | 2 | 107671 | 17 | 3.203 | 33615.7 |
| 254 | 2023-04-08 15:31:32 | subtone | 3 | 134027 | 188 | 6.673 | 20085.0 |
| 253 | 2023-03-01 18:51:51 | subtone | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 252 | 2023-01-19 19:20:31 | subtone | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 251 | 2023-01-18 10:29:39 | subtone | 2 | 107671 | 17 | 3.343 | 32207.9 |
| 250 | 2023-01-14 11:03:04 | subtone | 3 | 134027 | 188 | 6.030 | 22226.7 |
| 249 | 2022-12-26 20:05:29 | subtone | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 248 | 2022-10-28 18:57:15 | subtone | 2 | 107671 | 17 | 2.766 | 38926.6 |
| 247 | 2022-10-17 01:13:55 | subtone | 3 | 134027 | 188 | 5.563 | 24092.6 |
| 246 | 2022-09-13 18:44:52 | subtone | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 245 | 2022-09-10 11:19:19 | subtone | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 244 | 2022-07-18 06:54:05 | subtone | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 243 | 2022-07-15 22:44:41 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 242 | 2022-07-04 08:10:57 | subtone | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 241 | 2022-05-23 23:46:15 | subtone | 2 | 107671 | 17 | 3.016 | 35699.9 |
| 240 | 2022-05-18 10:49:36 | subtone | 3 | 134027 | 188 | 5.860 | 22871.5 |
| 239 | 2022-04-27 12:11:23 | subtone | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 238 | 2022-03-26 12:53:05 | subtone | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 237 | 2021-12-28 21:58:39 | subtone | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 236 | 2021-09-08 21:52:33 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 235 | 2021-07-14 05:55:24 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 234 | 2021-06-23 11:23:36 | subtone | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 233 | 2021-05-31 21:52:44 | subtone | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 232 | 2021-05-29 09:14:09 | subtone | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 231 | 2021-05-26 12:05:47 | subtone | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 230 | 2021-04-30 15:17:23 | subtone | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 229 | 2021-04-20 17:12:36 | subtone | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 228 | 2021-02-26 13:34:35 | subtone | 1 | 69583 | 3 | 2.440 | 28517.6 |
| 227 | 2021-02-17 04:52:40 | subtone | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 226 | 2021-01-13 13:58:41 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 225 | 2020-12-14 19:51:28 | subtone | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 224 | 2020-11-26 15:19:59 | subtone | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 223 | 2020-11-04 14:24:58 | subtone | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 222 | 2020-10-30 06:05:34 | subtone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 221 | 2020-10-22 22:40:06 | subtone | 1 | 69583 | 3 | 2.283 | 30478.8 |
| 220 | 2020-10-12 00:27:55 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 219 | 2020-09-09 14:16:46 | subtone | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 218 | 2020-08-28 09:20:10 | subtone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 217 | 2020-08-24 01:38:39 | subtone | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 216 | 2020-08-01 17:00:34 | subtone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 215 | 2020-07-24 03:31:57 | subtone | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 214 | 2020-05-13 09:52:36 | subtone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 213 | 2020-03-29 22:12:31 | subtone | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 212 | 2020-03-25 22:52:01 | subtone | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 211 | 2020-03-24 14:30:26 | subtone | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 210 | 2020-03-21 06:00:52 | subtone | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 209 | 2020-02-29 16:43:42 | subtone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 208 | 2020-02-28 22:50:50 | subtone | 1 | 69583 | 3 | 2.690 | 25867.3 |
| 207 | 2020-02-25 11:43:15 | subtone | 1 | 69583 | 3 | 2.296 | 30306.2 |
| 206 | 2020-02-11 02:03:50 | subtone | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 205 | 2020-02-10 17:55:25 | subtone | 1 | 69583 | 3 | 2.923 | 23805.3 |
| 204 | 2020-02-07 20:30:24 | subtone | 1 | 69583 | 3 | 1.500 | 46388.7 |
| 203 | 2020-02-07 17:30:32 | subtone | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 202 | 2020-02-05 15:09:04 | subtone | 1 | 69583 | 3 | 3.483 | 19977.9 |
| 201 | 2020-02-03 18:45:52 | subtone | 1 | 69583 | 3 | 2.580 | 26970.2 |
| 200 | 2020-02-01 08:50:13 | subtone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 199 | 2020-01-31 08:14:06 | subtone | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 198 | 2020-01-18 03:26:13 | subtone | 1 | 69583 | 3 | 2.750 | 25302.9 |
| 197 | 2020-01-16 13:36:08 | subtone | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 196 | 2020-01-13 13:41:44 | subtone | 1 | 69583 | 3 | 2.720 | 25582.0 |
| 195 | 2020-01-08 15:30:09 | subtone | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 194 | 2020-01-02 13:53:54 | subtone | 1 | 69583 | 3 | 3.203 | 21724.3 |
| 193 | 2019-12-29 05:52:10 | subtone | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 192 | 2019-12-27 22:57:02 | subtone | 1 | 69583 | 3 | 2.283 | 30478.8 |
| 191 | 2019-12-26 18:46:55 | subtone | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 190 | 2019-11-07 08:36:59 | subtone | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 189 | 2019-08-06 03:43:47 | subtone | 1 | 69583 | 3 | 1.166 | 59676.7 |
| 188 | 2019-04-29 22:20:44 | subtone | 1 | 69583 | 3 | 1.320 | 52714.4 |
| 187 | 2019-01-17 02:26:51 | subtone | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 186 | 2019-01-13 08:51:13 | subtone | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 185 | 2019-01-09 20:00:21 | subtone | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 184 | 2019-01-07 03:10:55 | subtone | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 183 | 2019-01-03 19:45:27 | subtone | 1 | 69583 | 3 | 1.180 | 58968.6 |
| 182 | 2018-12-31 11:57:54 | subtone | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 181 | 2018-12-29 02:26:26 | subtone | 1 | 69583 | 3 | 1.083 | 64250.2 |
| 180 | 2018-12-27 05:18:47 | subtone | 1 | 69583 | 3 | 1.130 | 61577.9 |
| 179 | 2018-11-25 06:41:56 | subtone | 1 | 69583 | 3 | 1.240 | 56115.3 |
| 178 | 2018-11-05 20:43:46 | subtone | 1 | 69583 | 3 | 1.070 | 65030.8 |
| 177 | 2018-10-30 22:02:59 | subtone | 1 | 69583 | 3 | 2.406 | 28920.6 |
| 176 | 2018-09-16 16:29:52 | subtone | 1 | 69583 | 3 | 1.246 | 55845.1 |