History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spinose"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 268 | 2024-04-11 07:44:12 | spinose | 2 | 107671 | 21 | 3.250 | 33129.5 |
| 267 | 2024-04-11 02:56:20 | spinose | 3 | 134027 | 260 | 10.983 | 12203.1 |
| 266 | 2024-04-09 03:37:11 | spinose | 3 | 134027 | 260 | 18.123 | 7395.4 |
| 265 | 2024-04-08 05:38:09 | spinose | 2 | 107671 | 21 | 7.703 | 13977.8 |
| 264 | 2024-04-08 05:36:53 | spinose | 3 | 134027 | 260 | 7.236 | 18522.2 |
| 263 | 2024-04-07 15:55:55 | spinose | 3 | 134027 | 260 | 13.596 | 9857.8 |
| 262 | 2024-04-07 15:55:47 | spinose | 2 | 107671 | 21 | 7.890 | 13646.5 |
| 261 | 2024-04-07 15:54:46 | spinose | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 260 | 2024-03-25 20:10:25 | spinose | 1 | 69583 | 1 | 3.716 | 18725.2 |
| 259 | 2024-03-08 04:12:06 | spinose | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 258 | 2024-03-05 00:58:59 | spinose | 1 | 69583 | 1 | 1.576 | 44151.6 |
| 257 | 2024-01-16 08:17:36 | spinose | 3 | 134027 | 260 | 6.563 | 20421.6 |
| 256 | 2024-01-16 08:17:35 | spinose | 2 | 107671 | 21 | 3.313 | 32499.5 |
| 255 | 2023-12-31 23:14:30 | spinose | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 254 | 2023-12-18 15:19:49 | spinose | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 253 | 2023-12-16 16:33:12 | spinose | 3 | 134027 | 260 | 6.453 | 20769.7 |
| 252 | 2023-12-16 16:33:11 | spinose | 2 | 107671 | 21 | 3.063 | 35152.1 |
| 251 | 2023-11-17 18:33:26 | spinose | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 250 | 2023-11-11 11:29:45 | spinose | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 249 | 2023-11-04 14:43:24 | spinose | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 248 | 2023-10-17 22:32:27 | spinose | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 247 | 2023-10-11 21:16:09 | spinose | 1 | 69583 | 1 | 1.300 | 53525.4 |
| 246 | 2023-10-05 00:51:02 | spinose | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 245 | 2023-09-29 09:26:49 | spinose | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 244 | 2023-09-24 14:33:10 | spinose | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 243 | 2023-06-01 18:26:27 | spinose | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 242 | 2023-04-27 11:05:45 | spinose | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 241 | 2023-03-18 01:37:43 | spinose | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 240 | 2023-01-26 18:14:55 | spinose | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 239 | 2022-12-26 11:18:27 | spinose | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 238 | 2022-09-17 04:56:54 | spinose | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 237 | 2022-09-12 03:43:09 | spinose | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 236 | 2022-04-23 08:52:45 | spinose | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 235 | 2022-04-19 22:07:16 | spinose | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 234 | 2021-12-15 17:52:00 | spinose | 1 | 69583 | 1 | 2.140 | 32515.4 |
| 233 | 2021-08-26 09:17:13 | spinose | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 232 | 2021-05-31 13:21:31 | spinose | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 231 | 2021-05-15 15:38:18 | spinose | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 230 | 2021-04-04 13:02:02 | spinose | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 229 | 2021-03-29 23:39:39 | spinose | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 228 | 2021-03-08 21:59:49 | spinose | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 227 | 2021-02-23 07:22:45 | spinose | 1 | 69583 | 1 | 1.153 | 60349.5 |
| 226 | 2021-01-23 18:22:51 | spinose | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 225 | 2020-11-10 19:01:44 | spinose | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 224 | 2020-11-07 11:35:45 | spinose | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 223 | 2020-10-25 02:51:29 | spinose | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 222 | 2020-10-11 13:10:49 | spinose | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 221 | 2020-10-05 06:04:08 | spinose | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 220 | 2020-06-12 10:32:13 | spinose | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 219 | 2020-03-30 00:54:24 | spinose | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 218 | 2020-03-28 03:55:56 | spinose | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 217 | 2020-03-26 09:46:43 | spinose | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 216 | 2020-03-26 01:47:37 | spinose | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 215 | 2020-03-21 05:29:23 | spinose | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 214 | 2020-02-29 01:16:22 | spinose | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 213 | 2020-02-28 23:50:50 | spinose | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 212 | 2020-02-26 13:31:29 | spinose | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 211 | 2020-02-25 03:20:09 | spinose | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 210 | 2020-02-11 05:09:44 | spinose | 1 | 69583 | 1 | 2.296 | 30306.2 |
| 209 | 2020-02-10 02:13:50 | spinose | 1 | 69583 | 1 | 1.376 | 50569.0 |
| 208 | 2020-02-06 18:49:28 | spinose | 1 | 69583 | 1 | 2.673 | 26031.8 |
| 207 | 2020-02-05 13:46:04 | spinose | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 206 | 2020-01-31 11:47:09 | spinose | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 205 | 2020-01-31 08:51:18 | spinose | 1 | 69583 | 1 | 1.483 | 46920.4 |
| 204 | 2020-01-18 03:12:47 | spinose | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 203 | 2020-01-17 02:44:06 | spinose | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 202 | 2020-01-13 20:51:53 | spinose | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 201 | 2020-01-08 20:54:24 | spinose | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 200 | 2019-12-31 11:37:25 | spinose | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 199 | 2019-12-27 22:23:05 | spinose | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 198 | 2019-12-27 15:47:14 | spinose | 1 | 69583 | 1 | 2.813 | 24736.2 |
| 197 | 2019-12-27 13:23:48 | spinose | 1 | 69583 | 1 | 2.440 | 28517.6 |
| 196 | 2019-12-14 21:00:53 | spinose | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 195 | 2019-11-23 08:06:33 | spinose | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 194 | 2019-08-27 16:27:15 | spinose | 1 | 69583 | 1 | 1.016 | 68487.2 |
| 193 | 2019-08-24 11:12:02 | spinose | 1 | 69583 | 1 | 1.136 | 61252.6 |
| 192 | 2019-06-04 04:11:53 | spinose | 1 | 69583 | 1 | 1.230 | 56571.5 |
| 191 | 2019-05-12 04:59:15 | spinose | 1 | 69583 | 1 | 1.253 | 55533.1 |
| 190 | 2019-03-13 06:20:24 | spinose | 1 | 69583 | 1 | 1.073 | 64849.0 |
| 189 | 2019-02-25 22:01:53 | spinose | 1 | 69583 | 1 | 1.083 | 64250.2 |
| 188 | 2019-02-24 01:11:38 | spinose | 1 | 69583 | 1 | 1.083 | 64250.2 |
| 187 | 2019-02-22 09:30:12 | spinose | 1 | 69583 | 1 | 1.090 | 63837.6 |
| 186 | 2019-02-13 23:55:50 | spinose | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 185 | 2019-02-10 12:57:59 | spinose | 1 | 69583 | 1 | 1.040 | 66906.7 |
| 184 | 2019-01-31 00:36:09 | spinose | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 183 | 2019-01-30 22:22:44 | spinose | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 182 | 2019-01-27 13:45:59 | spinose | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 181 | 2019-01-25 23:41:05 | spinose | 1 | 69583 | 1 | 1.160 | 59985.3 |
| 180 | 2019-01-21 01:57:33 | spinose | 1 | 69583 | 1 | 1.176 | 59169.2 |
| 179 | 2019-01-03 02:00:17 | spinose | 1 | 69583 | 1 | 1.050 | 66269.5 |
| 178 | 2018-12-27 15:56:17 | spinose | 1 | 69583 | 1 | 1.200 | 57985.8 |
| 177 | 2018-11-22 11:31:58 | spinose | 1 | 69583 | 1 | 1.020 | 68218.6 |
| 176 | 2018-11-18 14:34:11 | spinose | 1 | 69583 | 1 | 1.040 | 66906.7 |
| 175 | 2018-09-25 15:35:34 | spinose | 1 | 69583 | 1 | 1.346 | 51696.1 |
| 174 | 2018-09-24 10:17:46 | spinose | 1 | 69583 | 1 | 1.213 | 57364.4 |
| 173 | 2018-09-22 05:37:00 | spinose | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 172 | 2018-09-18 17:15:26 | spinose | 1 | 69583 | 1 | 1.133 | 61414.8 |
| 171 | 2018-09-14 21:52:14 | spinose | 1 | 69583 | 1 | 1.193 | 58326.1 |
| 170 | 2018-09-13 05:16:36 | spinose | 1 | 69583 | 1 | 1.043 | 66714.3 |
| 169 | 2018-09-04 19:10:14 | spinose | 1 | 69583 | 1 | 1.066 | 65274.9 |