History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crappie"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 246 | 2024-04-28 15:26:50 | crappie | 1 | 69583 | 5 | 1.486 | 46825.7 |
| 245 | 2024-04-27 13:53:17 | crappie | 1 | 69583 | 5 | 1.423 | 48898.8 |
| 244 | 2024-03-30 20:04:22 | crappie | 1 | 69583 | 5 | 2.733 | 25460.3 |
| 243 | 2024-03-29 12:40:30 | crappie | 1 | 69583 | 5 | 2.813 | 24736.2 |
| 242 | 2024-03-18 21:20:32 | crappie | 2 | 107671 | 26 | 3.673 | 29314.2 |
| 241 | 2024-03-18 21:20:24 | crappie | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 240 | 2024-03-18 21:20:10 | crappie | 3 | 134027 | 224 | 7.110 | 18850.5 |
| 239 | 2024-03-14 14:02:47 | crappie | 3 | 134027 | 224 | 24.893 | 5384.1 |
| 238 | 2024-03-13 15:55:15 | crappie | 3 | 134027 | 224 | 15.326 | 8745.1 |
| 237 | 2024-03-12 07:51:44 | crappie | 3 | 134027 | 224 | 13.906 | 9638.1 |
| 236 | 2024-02-29 08:33:23 | crappie | 1 | 69583 | 5 | 1.796 | 38743.3 |
| 235 | 2024-02-19 15:08:42 | crappie | 1 | 69583 | 5 | 2.546 | 27330.3 |
| 234 | 2024-01-11 08:40:48 | crappie | 3 | 134027 | 224 | 6.046 | 22167.9 |
| 233 | 2024-01-11 08:40:43 | crappie | 2 | 107671 | 26 | 3.186 | 33795.0 |
| 232 | 2024-01-07 21:01:50 | crappie | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 231 | 2023-12-13 17:31:54 | crappie | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 230 | 2023-11-25 23:21:10 | crappie | 3 | 134027 | 224 | 6.656 | 20136.3 |
| 229 | 2023-11-23 02:36:09 | crappie | 1 | 69583 | 5 | 2.436 | 28564.4 |
| 228 | 2023-11-17 00:22:10 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 227 | 2023-11-02 01:56:05 | crappie | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 226 | 2023-10-15 13:40:28 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 225 | 2023-10-06 21:24:53 | crappie | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 224 | 2023-10-04 04:41:29 | crappie | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 223 | 2023-10-01 00:09:47 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 222 | 2023-09-23 11:06:23 | crappie | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 221 | 2023-09-15 23:44:41 | crappie | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 220 | 2023-08-25 02:29:40 | crappie | 3 | 134027 | 224 | 13.283 | 10090.1 |
| 219 | 2023-08-24 18:24:25 | crappie | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 218 | 2023-08-18 11:36:35 | crappie | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 217 | 2023-07-25 12:31:13 | crappie | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 216 | 2023-07-25 12:26:03 | crappie | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 215 | 2023-06-11 20:13:58 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 214 | 2023-06-10 17:24:08 | crappie | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 213 | 2023-05-29 05:10:19 | crappie | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 212 | 2023-05-11 08:29:17 | crappie | 3 | 134027 | 224 | 5.876 | 22809.2 |
| 211 | 2023-03-25 12:45:30 | crappie | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 210 | 2023-02-22 15:58:21 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 209 | 2023-02-16 07:01:21 | crappie | 3 | 134027 | 224 | 5.736 | 23365.9 |
| 208 | 2023-01-09 07:02:33 | crappie | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 207 | 2022-11-27 01:10:27 | crappie | 3 | 134027 | 224 | 5.860 | 22871.5 |
| 206 | 2022-11-02 05:36:47 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 205 | 2022-10-17 03:21:05 | crappie | 1 | 69583 | 5 | 1.656 | 42018.7 |
| 204 | 2022-07-16 04:13:01 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 203 | 2022-06-07 09:42:28 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 202 | 2022-06-07 00:42:42 | crappie | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 201 | 2022-05-06 17:02:20 | crappie | 3 | 134027 | 224 | 7.266 | 18445.8 |
| 200 | 2022-03-29 04:51:59 | crappie | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 199 | 2022-02-19 02:21:04 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 198 | 2021-12-11 15:50:06 | crappie | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 197 | 2021-12-10 08:44:30 | crappie | 1 | 69583 | 5 | 2.186 | 31831.2 |
| 196 | 2021-10-19 16:52:12 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 195 | 2021-09-20 10:08:51 | crappie | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 194 | 2021-09-07 14:25:26 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 193 | 2021-07-19 13:57:06 | crappie | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 192 | 2021-06-06 16:45:03 | crappie | 1 | 69583 | 5 | 2.266 | 30707.4 |
| 191 | 2021-06-03 12:22:24 | crappie | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 190 | 2021-05-13 06:55:02 | crappie | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 189 | 2021-04-12 02:49:41 | crappie | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 188 | 2021-03-01 01:53:43 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 187 | 2021-02-19 01:11:33 | crappie | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 186 | 2020-11-29 08:35:18 | crappie | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 185 | 2020-10-31 14:03:18 | crappie | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 184 | 2020-10-27 00:04:01 | crappie | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 183 | 2020-08-25 23:22:53 | crappie | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 182 | 2020-08-22 19:23:19 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 181 | 2020-05-21 11:58:34 | crappie | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 180 | 2020-03-30 03:25:48 | crappie | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 179 | 2020-03-28 12:15:44 | crappie | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 178 | 2020-03-25 03:52:29 | crappie | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 177 | 2020-03-23 06:09:52 | crappie | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 176 | 2020-02-28 14:51:19 | crappie | 1 | 69583 | 5 | 2.593 | 26834.9 |
| 175 | 2020-02-22 20:03:58 | crappie | 1 | 69583 | 5 | 2.216 | 31400.3 |
| 174 | 2020-02-22 11:15:22 | crappie | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 173 | 2020-02-21 01:57:45 | crappie | 1 | 69583 | 5 | 1.423 | 48898.8 |
| 172 | 2020-02-18 10:06:53 | crappie | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 171 | 2020-02-13 15:29:51 | crappie | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 170 | 2020-02-02 05:13:28 | crappie | 1 | 69583 | 5 | 3.296 | 21111.3 |
| 169 | 2020-02-02 00:57:22 | crappie | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 168 | 2020-01-22 17:22:37 | crappie | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 167 | 2020-01-22 03:54:50 | crappie | 1 | 69583 | 5 | 3.170 | 21950.5 |
| 166 | 2020-01-22 02:34:42 | crappie | 1 | 69583 | 5 | 2.060 | 33778.2 |
| 165 | 2020-01-20 16:35:49 | crappie | 1 | 69583 | 5 | 3.906 | 17814.4 |
| 164 | 2020-01-16 06:23:09 | crappie | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 163 | 2020-01-11 15:36:40 | crappie | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 162 | 2020-01-09 21:16:53 | crappie | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 161 | 2019-12-31 07:08:56 | crappie | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 160 | 2019-12-30 01:37:32 | crappie | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 159 | 2019-11-19 00:54:54 | crappie | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 158 | 2019-10-19 08:57:48 | crappie | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 157 | 2019-08-17 09:18:00 | crappie | 1 | 69583 | 5 | 1.193 | 58326.1 |
| 156 | 2019-05-17 15:30:03 | crappie | 1 | 69583 | 5 | 1.240 | 56115.3 |
| 155 | 2019-02-27 00:28:29 | crappie | 1 | 69583 | 5 | 1.176 | 59169.2 |
| 154 | 2019-02-05 02:45:38 | crappie | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 153 | 2019-01-24 16:35:19 | crappie | 1 | 69583 | 5 | 1.070 | 65030.8 |
| 152 | 2019-01-24 15:29:34 | crappie | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 151 | 2019-01-17 06:15:28 | crappie | 1 | 69583 | 5 | 1.070 | 65030.8 |
| 150 | 2018-11-02 02:13:19 | crappie | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 149 | 2018-10-20 05:49:27 | crappie | 1 | 69583 | 5 | 1.036 | 67165.1 |
| 148 | 2018-10-01 03:08:45 | crappie | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 147 | 2018-09-30 04:48:12 | crappie | 1 | 69583 | 5 | 2.196 | 31686.2 |