History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fantasts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 246 | 2024-04-13 11:45:16 | fantasts | 1 | 82945 | 3 | 1.610 | 51518.6 |
| 245 | 2024-04-10 22:16:42 | fantasts | 1 | 82945 | 3 | 3.156 | 26281.7 |
| 244 | 2024-03-31 00:26:01 | fantasts | 4 | 161609 | 1056 | 46.783 | 3454.4 |
| 243 | 2024-03-30 10:27:26 | fantasts | 4 | 161609 | 1056 | 18.766 | 8611.8 |
| 242 | 2024-03-30 08:56:29 | fantasts | 1 | 82945 | 3 | 4.626 | 17930.2 |
| 241 | 2024-03-29 16:32:47 | fantasts | 2 | 121059 | 16 | 3.796 | 31891.2 |
| 240 | 2024-03-29 16:32:26 | fantasts | 4 | 161609 | 1056 | 14.156 | 11416.3 |
| 239 | 2024-03-29 16:32:27 | fantasts | 3 | 146162 | 98 | 8.500 | 17195.5 |
| 238 | 2024-03-28 22:32:55 | fantasts | 4 | 161609 | 1056 | 15.936 | 10141.1 |
| 237 | 2024-03-28 22:27:11 | fantasts | 4 | 161609 | 1056 | 45.033 | 3588.7 |
| 236 | 2024-03-28 22:27:13 | fantasts | 3 | 146162 | 98 | 12.686 | 11521.5 |
| 235 | 2024-03-28 22:27:12 | fantasts | 2 | 121059 | 16 | 8.033 | 15070.2 |
| 234 | 2024-03-28 22:27:05 | fantasts | 1 | 82945 | 3 | 3.170 | 26165.6 |
| 233 | 2024-03-18 21:05:07 | fantasts | 3 | 146162 | 98 | 13.516 | 10814.0 |
| 232 | 2024-03-17 04:20:08 | fantasts | 3 | 146162 | 98 | 15.346 | 9524.4 |
| 231 | 2024-03-06 16:37:59 | fantasts | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 230 | 2024-02-29 18:31:56 | fantasts | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 229 | 2024-02-28 10:30:35 | fantasts | 1 | 82945 | 3 | 4.716 | 17588.0 |
| 228 | 2024-01-18 09:41:30 | fantasts | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 227 | 2023-12-17 06:33:25 | fantasts | 2 | 121059 | 16 | 3.516 | 34430.9 |
| 226 | 2023-12-05 15:15:58 | fantasts | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 225 | 2023-12-03 18:29:34 | fantasts | 4 | 161609 | 1056 | 12.343 | 13093.2 |
| 224 | 2023-12-03 18:29:31 | fantasts | 3 | 146162 | 98 | 11.220 | 13026.9 |
| 223 | 2023-12-03 18:29:33 | fantasts | 2 | 121059 | 16 | 7.593 | 15943.5 |
| 222 | 2023-11-29 15:06:35 | fantasts | 3 | 146162 | 98 | 10.220 | 14301.6 |
| 221 | 2023-11-25 20:18:28 | fantasts | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 220 | 2023-11-12 20:33:25 | fantasts | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 219 | 2023-11-10 15:11:16 | fantasts | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 218 | 2023-11-10 03:56:55 | fantasts | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 217 | 2023-11-01 03:50:37 | fantasts | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 216 | 2023-10-27 13:32:02 | fantasts | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 215 | 2023-09-18 05:41:40 | fantasts | 2 | 121059 | 16 | 3.983 | 30393.9 |
| 214 | 2023-09-02 04:32:31 | fantasts | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 213 | 2023-08-28 20:11:45 | fantasts | 3 | 146162 | 98 | 6.953 | 21021.4 |
| 212 | 2023-07-11 02:23:23 | fantasts | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 211 | 2023-06-25 07:06:31 | fantasts | 2 | 121059 | 16 | 3.186 | 37997.2 |
| 210 | 2023-06-07 11:06:17 | fantasts | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 209 | 2023-05-15 08:35:40 | fantasts | 3 | 146162 | 98 | 6.186 | 23627.9 |
| 208 | 2023-03-29 07:41:45 | fantasts | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 207 | 2023-03-21 05:33:55 | fantasts | 2 | 121059 | 16 | 3.593 | 33693.0 |
| 206 | 2023-03-17 00:56:37 | fantasts | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 205 | 2023-03-13 18:11:39 | fantasts | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 204 | 2023-02-21 10:33:31 | fantasts | 3 | 146162 | 98 | 6.533 | 22372.9 |
| 203 | 2023-01-12 03:37:28 | fantasts | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 202 | 2023-01-02 13:18:56 | fantasts | 3 | 146162 | 98 | 6.280 | 23274.2 |
| 201 | 2022-12-19 21:10:04 | fantasts | 2 | 121059 | 16 | 3.126 | 38726.5 |
| 200 | 2022-12-02 04:33:55 | fantasts | 3 | 146162 | 98 | 6.170 | 23689.1 |
| 199 | 2022-11-18 17:03:26 | fantasts | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 198 | 2022-11-18 13:14:59 | fantasts | 3 | 146162 | 98 | 7.156 | 20425.1 |
| 197 | 2022-11-15 18:52:55 | fantasts | 3 | 146162 | 98 | 6.310 | 23163.5 |
| 196 | 2022-10-30 04:03:16 | fantasts | 1 | 82945 | 3 | 2.513 | 33006.4 |
| 195 | 2022-10-03 00:46:39 | fantasts | 3 | 146162 | 98 | 7.266 | 20115.9 |
| 194 | 2022-09-24 07:47:15 | fantasts | 3 | 146162 | 98 | 6.123 | 23871.0 |
| 193 | 2022-08-22 05:09:45 | fantasts | 3 | 146162 | 98 | 6.360 | 22981.4 |
| 192 | 2022-08-17 14:47:41 | fantasts | 2 | 121059 | 16 | 3.156 | 38358.4 |
| 191 | 2022-07-29 08:56:27 | fantasts | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 190 | 2022-07-25 22:54:22 | fantasts | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 189 | 2022-07-10 18:58:44 | fantasts | 3 | 146162 | 98 | 6.436 | 22710.1 |
| 188 | 2022-06-19 10:08:59 | fantasts | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 187 | 2022-04-03 22:14:24 | fantasts | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 186 | 2022-02-26 21:00:10 | fantasts | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 185 | 2022-02-24 17:18:22 | fantasts | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 184 | 2022-01-27 15:10:39 | fantasts | 3 | 146162 | 98 | 7.703 | 18974.7 |
| 183 | 2021-12-26 08:28:46 | fantasts | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 182 | 2021-12-21 21:12:08 | fantasts | 3 | 146162 | 98 | 8.360 | 17483.5 |
| 181 | 2021-12-20 04:28:28 | fantasts | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 180 | 2021-11-25 07:38:02 | fantasts | 3 | 146162 | 98 | 6.686 | 21860.9 |
| 179 | 2021-11-21 10:24:52 | fantasts | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 178 | 2021-11-17 05:45:54 | fantasts | 3 | 146162 | 98 | 6.483 | 22545.4 |
| 177 | 2021-11-10 05:18:52 | fantasts | 3 | 146162 | 98 | 8.253 | 17710.2 |
| 176 | 2021-10-06 02:45:02 | fantasts | 3 | 146162 | 98 | 6.610 | 22112.3 |
| 175 | 2021-09-09 17:21:59 | fantasts | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 174 | 2021-06-08 18:29:59 | fantasts | 1 | 82945 | 3 | 1.656 | 50087.6 |
| 173 | 2021-05-21 23:51:34 | fantasts | 3 | 146162 | 98 | 7.186 | 20339.8 |
| 172 | 2021-05-01 17:42:44 | fantasts | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 171 | 2021-03-31 00:42:37 | fantasts | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 170 | 2021-03-06 12:25:08 | fantasts | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 169 | 2021-03-03 07:22:39 | fantasts | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 168 | 2021-02-23 15:07:58 | fantasts | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 167 | 2021-01-23 02:13:46 | fantasts | 3 | 146162 | 98 | 6.390 | 22873.6 |
| 166 | 2021-01-07 20:04:35 | fantasts | 3 | 146162 | 98 | 7.703 | 18974.7 |
| 165 | 2020-11-27 17:46:53 | fantasts | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 164 | 2020-11-15 01:15:28 | fantasts | 3 | 146162 | 98 | 6.453 | 22650.2 |
| 163 | 2020-10-25 19:45:31 | fantasts | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 162 | 2020-10-25 00:19:19 | fantasts | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 161 | 2020-10-12 22:35:42 | fantasts | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 160 | 2020-08-28 00:56:49 | fantasts | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 159 | 2020-07-28 08:15:15 | fantasts | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 158 | 2020-05-26 11:30:31 | fantasts | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 157 | 2020-04-18 21:48:54 | fantasts | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 156 | 2020-03-28 16:14:59 | fantasts | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 155 | 2020-03-22 16:30:11 | fantasts | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 154 | 2020-02-28 01:50:32 | fantasts | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 153 | 2020-02-24 22:48:41 | fantasts | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 152 | 2020-02-23 06:17:51 | fantasts | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 151 | 2020-02-13 02:28:00 | fantasts | 1 | 82945 | 3 | 1.830 | 45325.1 |
| 150 | 2020-02-08 05:35:54 | fantasts | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 149 | 2020-02-06 12:15:58 | fantasts | 1 | 82945 | 3 | 3.283 | 25265.0 |
| 148 | 2020-02-01 09:48:26 | fantasts | 1 | 82945 | 3 | 2.016 | 41143.4 |
| 147 | 2020-02-01 08:08:35 | fantasts | 1 | 82945 | 3 | 1.643 | 50483.9 |