History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fantasia"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
283 | 2024-04-26 05:06:14 | fantasia | 2 | 121059 | 17 | 8.753 | 13830.6 |
282 | 2024-04-26 04:57:09 | fantasia | 3 | 146162 | 64 | 8.376 | 17450.1 |
281 | 2024-04-25 17:53:08 | fantasia | 1 | 82945 | 3 | 1.610 | 51518.6 |
280 | 2024-04-25 17:49:40 | fantasia | 4 | 161609 | 488 | 20.266 | 7974.4 |
279 | 2024-04-25 17:49:04 | fantasia | 2 | 121059 | 17 | 7.436 | 16280.1 |
278 | 2024-04-25 17:48:56 | fantasia | 1 | 82945 | 3 | 3.110 | 26670.4 |
277 | 2024-04-25 17:48:40 | fantasia | 2 | 121059 | 17 | 6.220 | 19462.9 |
276 | 2024-04-25 17:48:20 | fantasia | 3 | 146162 | 64 | 8.936 | 16356.5 |
275 | 2024-04-25 17:48:08 | fantasia | 3 | 146162 | 64 | 13.110 | 11148.9 |
274 | 2024-04-25 17:35:36 | fantasia | 4 | 161609 | 488 | 23.736 | 6808.6 |
273 | 2024-04-25 17:20:21 | fantasia | 4 | 161609 | 488 | 17.220 | 9385.0 |
272 | 2024-04-25 05:08:17 | fantasia | 4 | 161609 | 488 | 28.173 | 5736.3 |
271 | 2024-04-25 05:08:15 | fantasia | 3 | 146162 | 64 | 20.170 | 7246.5 |
270 | 2024-04-25 00:13:42 | fantasia | 4 | 161609 | 488 | 26.330 | 6137.8 |
269 | 2024-04-25 00:13:42 | fantasia | 3 | 146162 | 64 | 19.376 | 7543.5 |
268 | 2024-04-25 00:13:42 | fantasia | 2 | 121059 | 17 | 9.343 | 12957.2 |
267 | 2024-04-24 22:25:59 | fantasia | 1 | 82945 | 3 | 1.533 | 54106.3 |
266 | 2024-04-13 04:57:33 | fantasia | 2 | 121059 | 17 | 8.203 | 14757.9 |
265 | 2024-04-13 04:57:37 | fantasia | 1 | 82945 | 3 | 1.796 | 46183.2 |
264 | 2024-04-10 03:04:13 | fantasia | 1 | 82945 | 3 | 1.643 | 50483.9 |
263 | 2024-03-26 17:42:09 | fantasia | 2 | 121059 | 17 | 3.390 | 35710.6 |
262 | 2024-03-26 17:41:09 | fantasia | 3 | 146162 | 64 | 6.750 | 21653.6 |
261 | 2024-03-25 07:00:33 | fantasia | 1 | 82945 | 3 | 3.046 | 27230.8 |
260 | 2024-03-25 07:00:09 | fantasia | 2 | 121059 | 17 | 3.750 | 32282.4 |
259 | 2024-03-25 06:26:33 | fantasia | 3 | 146162 | 64 | 7.780 | 18786.9 |
258 | 2024-03-23 02:33:21 | fantasia | 4 | 161609 | 488 | 18.190 | 8884.5 |
257 | 2024-03-22 11:06:15 | fantasia | 2 | 121059 | 17 | 5.033 | 24053.0 |
256 | 2024-03-22 11:05:53 | fantasia | 3 | 146162 | 64 | 7.563 | 19325.9 |
255 | 2024-03-22 10:30:40 | fantasia | 4 | 161609 | 488 | 14.936 | 10820.1 |
254 | 2024-03-22 09:09:40 | fantasia | 3 | 146162 | 64 | 18.126 | 8063.7 |
253 | 2024-03-21 14:07:24 | fantasia | 4 | 161609 | 488 | 35.156 | 4596.9 |
252 | 2024-03-21 14:07:01 | fantasia | 3 | 146162 | 64 | 29.316 | 4985.7 |
251 | 2024-03-21 14:07:00 | fantasia | 2 | 121059 | 17 | 16.656 | 7268.2 |
250 | 2024-03-21 04:42:25 | fantasia | 4 | 161609 | 488 | 30.270 | 5338.9 |
249 | 2024-03-20 18:22:45 | fantasia | 4 | 161609 | 488 | 19.126 | 8449.7 |
248 | 2024-03-19 21:51:03 | fantasia | 4 | 161609 | 488 | 28.953 | 5581.8 |
247 | 2024-03-19 21:51:06 | fantasia | 3 | 146162 | 64 | 11.080 | 13191.5 |
246 | 2024-03-19 21:51:03 | fantasia | 2 | 121059 | 17 | 13.626 | 8884.4 |
245 | 2024-03-19 20:41:14 | fantasia | 1 | 82945 | 3 | 1.406 | 58993.6 |
244 | 2024-03-08 00:55:03 | fantasia | 1 | 82945 | 3 | 3.000 | 27648.3 |
243 | 2024-03-02 10:56:36 | fantasia | 1 | 82945 | 3 | 2.280 | 36379.4 |
242 | 2024-02-27 14:02:34 | fantasia | 1 | 82945 | 3 | 1.420 | 58412.0 |
241 | 2024-02-05 14:01:34 | fantasia | 3 | 146162 | 64 | 7.123 | 20519.7 |
240 | 2024-02-04 07:41:58 | fantasia | 4 | 161609 | 488 | 40.156 | 4024.5 |
239 | 2024-02-01 12:05:16 | fantasia | 1 | 82945 | 3 | 1.250 | 66356.0 |
238 | 2024-01-30 20:52:55 | fantasia | 2 | 121059 | 17 | 4.470 | 27082.6 |
237 | 2024-01-29 18:36:07 | fantasia | 2 | 121059 | 17 | 3.436 | 35232.5 |
236 | 2024-01-29 18:35:37 | fantasia | 3 | 146162 | 64 | 7.516 | 19446.8 |
235 | 2024-01-29 18:34:19 | fantasia | 2 | 121059 | 17 | 3.796 | 31891.2 |
234 | 2024-01-29 18:34:15 | fantasia | 3 | 146162 | 64 | 7.266 | 20115.9 |
233 | 2024-01-29 18:34:11 | fantasia | 1 | 82945 | 3 | 1.640 | 50576.2 |
232 | 2024-01-29 11:41:16 | fantasia | 4 | 161609 | 488 | 23.843 | 6778.0 |
231 | 2024-01-29 11:29:03 | fantasia | 4 | 161609 | 488 | 16.156 | 10003.0 |
230 | 2024-01-29 10:58:09 | fantasia | 4 | 161609 | 488 | 15.706 | 10289.6 |
229 | 2024-01-18 23:02:29 | fantasia | 1 | 82945 | 3 | 1.343 | 61761.0 |
228 | 2024-01-15 00:07:48 | fantasia | 1 | 82945 | 3 | 1.266 | 65517.4 |
227 | 2023-12-05 15:16:08 | fantasia | 1 | 82945 | 3 | 1.470 | 56425.2 |
226 | 2023-12-02 21:08:23 | fantasia | 1 | 82945 | 3 | 1.500 | 55296.7 |
225 | 2023-11-30 01:06:17 | fantasia | 1 | 82945 | 3 | 1.393 | 59544.1 |
224 | 2023-11-13 19:11:15 | fantasia | 1 | 82945 | 3 | 1.250 | 66356.0 |
223 | 2023-10-07 18:31:26 | fantasia | 1 | 82945 | 3 | 1.903 | 43586.4 |
222 | 2023-09-15 03:23:04 | fantasia | 1 | 82945 | 3 | 1.296 | 64000.8 |
221 | 2023-09-02 04:42:43 | fantasia | 1 | 82945 | 3 | 1.283 | 64649.3 |
220 | 2023-09-01 12:57:58 | fantasia | 1 | 82945 | 3 | 2.530 | 32784.6 |
219 | 2023-08-29 05:43:51 | fantasia | 1 | 82945 | 3 | 1.343 | 61761.0 |
218 | 2023-06-07 23:45:38 | fantasia | 1 | 82945 | 3 | 1.420 | 58412.0 |
217 | 2023-05-04 20:05:28 | fantasia | 1 | 82945 | 3 | 1.470 | 56425.2 |
216 | 2023-03-29 16:31:53 | fantasia | 1 | 82945 | 3 | 1.250 | 66356.0 |
215 | 2023-01-12 08:39:07 | fantasia | 1 | 82945 | 3 | 1.263 | 65673.0 |
214 | 2023-01-07 15:23:27 | fantasia | 1 | 82945 | 3 | 1.296 | 64000.8 |
213 | 2022-10-31 19:36:43 | fantasia | 1 | 82945 | 3 | 1.313 | 63172.1 |
212 | 2022-08-30 10:01:20 | fantasia | 1 | 82945 | 3 | 1.280 | 64800.8 |
211 | 2022-07-11 12:12:36 | fantasia | 1 | 82945 | 3 | 1.330 | 62364.7 |
210 | 2022-06-21 09:40:25 | fantasia | 1 | 82945 | 3 | 1.390 | 59672.7 |
209 | 2022-06-19 04:19:47 | fantasia | 1 | 82945 | 3 | 1.436 | 57761.1 |
208 | 2022-04-12 12:11:48 | fantasia | 1 | 82945 | 3 | 1.310 | 63316.8 |
207 | 2022-02-22 08:02:02 | fantasia | 1 | 82945 | 3 | 1.356 | 61168.9 |
206 | 2022-02-20 03:42:16 | fantasia | 1 | 82945 | 3 | 1.406 | 58993.6 |
205 | 2021-12-18 11:32:34 | fantasia | 1 | 82945 | 3 | 1.516 | 54713.1 |
204 | 2021-12-13 13:20:22 | fantasia | 1 | 82945 | 3 | 1.296 | 64000.8 |
203 | 2021-12-11 11:26:34 | fantasia | 1 | 82945 | 3 | 1.580 | 52496.8 |
202 | 2021-11-04 01:48:11 | fantasia | 1 | 82945 | 3 | 1.360 | 60989.0 |
201 | 2021-09-01 11:09:05 | fantasia | 1 | 82945 | 3 | 1.453 | 57085.3 |
200 | 2021-06-15 08:47:56 | fantasia | 4 | 161609 | 488 | 10.813 | 14945.8 |
199 | 2021-05-28 10:41:42 | fantasia | 1 | 82945 | 3 | 1.390 | 59672.7 |
198 | 2021-05-25 00:57:59 | fantasia | 1 | 82945 | 3 | 1.440 | 57600.7 |
197 | 2021-05-13 12:52:10 | fantasia | 1 | 82945 | 3 | 1.453 | 57085.3 |
196 | 2021-05-05 23:51:06 | fantasia | 4 | 161609 | 488 | 12.250 | 13192.6 |
195 | 2021-05-03 10:13:03 | fantasia | 4 | 161609 | 488 | 14.093 | 11467.3 |
194 | 2021-04-12 11:59:55 | fantasia | 1 | 82945 | 3 | 1.250 | 66356.0 |
193 | 2021-04-07 06:46:39 | fantasia | 4 | 161609 | 488 | 12.796 | 12629.6 |
192 | 2021-04-01 20:34:53 | fantasia | 4 | 161609 | 488 | 12.453 | 12977.5 |
191 | 2021-02-19 12:31:39 | fantasia | 1 | 82945 | 3 | 1.280 | 64800.8 |
190 | 2021-01-26 10:00:33 | fantasia | 1 | 82945 | 3 | 1.280 | 64800.8 |
189 | 2020-11-15 19:54:50 | fantasia | 1 | 82945 | 3 | 1.263 | 65673.0 |
188 | 2020-11-02 14:25:22 | fantasia | 1 | 82945 | 3 | 1.610 | 51518.6 |
187 | 2020-10-30 03:09:36 | fantasia | 1 | 82945 | 3 | 1.300 | 63803.8 |
186 | 2020-10-17 20:56:29 | fantasia | 1 | 82945 | 3 | 1.486 | 55817.6 |
185 | 2020-10-16 21:17:49 | fantasia | 1 | 82945 | 3 | 1.296 | 64000.8 |
184 | 2020-10-12 22:11:33 | fantasia | 1 | 82945 | 3 | 1.313 | 63172.1 |