History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparling"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
301 | 2024-04-29 01:19:27 | sparling | 1 | 82945 | 11 | 1.533 | 54106.3 |
300 | 2024-04-29 00:17:22 | sparling | 1 | 82945 | 11 | 1.503 | 55186.3 |
299 | 2024-04-25 00:32:30 | sparling | 1 | 82945 | 11 | 1.733 | 47862.1 |
298 | 2024-04-02 13:13:49 | sparling | 2 | 121059 | 97 | 10.050 | 12045.7 |
297 | 2024-03-31 17:56:18 | sparling | 1 | 82945 | 11 | 2.500 | 33178.0 |
296 | 2024-03-29 20:15:09 | sparling | 1 | 82945 | 11 | 1.580 | 52496.8 |
295 | 2024-02-29 05:35:49 | sparling | 3 | 146162 | 692 | 12.453 | 11737.1 |
294 | 2024-02-29 03:31:59 | sparling | 1 | 82945 | 11 | 1.593 | 52068.4 |
293 | 2024-02-28 12:06:40 | sparling | 1 | 82945 | 11 | 1.453 | 57085.3 |
292 | 2024-02-28 09:32:00 | sparling | 2 | 121059 | 97 | 7.610 | 15907.9 |
291 | 2024-02-27 05:32:06 | sparling | 2 | 121059 | 97 | 6.453 | 18760.1 |
290 | 2024-02-27 04:34:22 | sparling | 3 | 146162 | 692 | 22.860 | 6393.8 |
289 | 2024-02-26 18:09:28 | sparling | 3 | 146162 | 692 | 10.360 | 14108.3 |
288 | 2024-02-26 15:36:54 | sparling | 3 | 146162 | 692 | 7.953 | 18378.2 |
287 | 2024-02-26 15:36:52 | sparling | 2 | 121059 | 97 | 3.796 | 31891.2 |
286 | 2024-02-26 15:36:51 | sparling | 1 | 82945 | 11 | 1.406 | 58993.6 |
285 | 2024-01-06 13:25:14 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
284 | 2023-12-24 10:05:01 | sparling | 1 | 82945 | 11 | 1.330 | 62364.7 |
283 | 2023-12-21 02:01:41 | sparling | 3 | 146162 | 692 | 7.156 | 20425.1 |
282 | 2023-12-21 02:01:10 | sparling | 2 | 121059 | 97 | 3.440 | 35191.6 |
281 | 2023-12-11 20:51:18 | sparling | 3 | 146162 | 692 | 7.550 | 19359.2 |
280 | 2023-12-11 20:51:16 | sparling | 2 | 121059 | 97 | 3.453 | 35059.1 |
279 | 2023-12-06 09:04:00 | sparling | 2 | 121059 | 97 | 4.156 | 29128.7 |
278 | 2023-11-14 01:07:33 | sparling | 1 | 82945 | 11 | 1.423 | 58288.8 |
277 | 2023-11-11 03:42:17 | sparling | 1 | 82945 | 11 | 1.403 | 59119.7 |
276 | 2023-11-03 05:04:54 | sparling | 1 | 82945 | 11 | 1.470 | 56425.2 |
275 | 2023-10-30 04:49:45 | sparling | 1 | 82945 | 11 | 1.330 | 62364.7 |
274 | 2023-10-29 15:18:39 | sparling | 1 | 82945 | 11 | 3.263 | 25419.9 |
273 | 2023-10-23 09:46:27 | sparling | 1 | 82945 | 11 | 1.533 | 54106.3 |
272 | 2023-10-11 23:20:26 | sparling | 1 | 82945 | 11 | 1.423 | 58288.8 |
271 | 2023-10-01 21:21:41 | sparling | 1 | 82945 | 11 | 2.593 | 31988.0 |
270 | 2023-09-11 14:10:03 | sparling | 1 | 82945 | 11 | 1.390 | 59672.7 |
269 | 2023-09-04 21:07:18 | sparling | 2 | 121059 | 97 | 6.403 | 18906.6 |
268 | 2023-08-23 05:18:34 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
267 | 2023-07-15 23:40:47 | sparling | 1 | 82945 | 11 | 1.263 | 65673.0 |
266 | 2023-05-24 04:50:32 | sparling | 1 | 82945 | 11 | 1.360 | 60989.0 |
265 | 2023-03-28 02:46:06 | sparling | 1 | 82945 | 11 | 1.266 | 65517.4 |
264 | 2023-03-16 19:32:58 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
263 | 2023-02-14 12:02:14 | sparling | 2 | 121059 | 97 | 3.173 | 38152.9 |
262 | 2023-01-17 08:31:42 | sparling | 1 | 82945 | 11 | 1.486 | 55817.6 |
261 | 2023-01-04 23:45:56 | sparling | 1 | 82945 | 11 | 1.266 | 65517.4 |
260 | 2022-12-03 01:12:37 | sparling | 1 | 82945 | 11 | 1.440 | 57600.7 |
259 | 2022-11-25 18:48:14 | sparling | 2 | 121059 | 97 | 3.623 | 33414.0 |
258 | 2022-09-27 11:24:36 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
257 | 2022-07-30 08:59:27 | sparling | 1 | 82945 | 11 | 1.373 | 60411.5 |
256 | 2022-07-04 04:28:21 | sparling | 1 | 82945 | 11 | 1.280 | 64800.8 |
255 | 2022-06-25 00:03:28 | sparling | 1 | 82945 | 11 | 1.263 | 65673.0 |
254 | 2022-05-18 13:27:40 | sparling | 1 | 82945 | 11 | 1.436 | 57761.1 |
253 | 2022-05-14 05:49:51 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
252 | 2022-05-07 15:18:17 | sparling | 1 | 82945 | 11 | 1.410 | 58826.2 |
251 | 2022-04-18 19:00:15 | sparling | 2 | 121059 | 97 | 3.593 | 33693.0 |
250 | 2022-04-01 09:17:15 | sparling | 1 | 82945 | 11 | 1.283 | 64649.3 |
249 | 2022-02-06 12:58:05 | sparling | 1 | 82945 | 11 | 1.310 | 63316.8 |
248 | 2021-12-14 15:00:18 | sparling | 1 | 82945 | 11 | 1.343 | 61761.0 |
247 | 2021-11-30 09:37:55 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
246 | 2021-10-30 08:32:00 | sparling | 1 | 82945 | 11 | 1.466 | 56579.1 |
245 | 2021-09-07 08:09:34 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
244 | 2021-06-06 10:00:55 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
243 | 2021-04-17 00:21:45 | sparling | 1 | 82945 | 11 | 1.283 | 64649.3 |
242 | 2021-02-24 13:41:08 | sparling | 1 | 82945 | 11 | 1.516 | 54713.1 |
241 | 2021-02-22 12:08:54 | sparling | 1 | 82945 | 11 | 1.703 | 48705.2 |
240 | 2021-02-22 06:13:41 | sparling | 1 | 82945 | 11 | 1.406 | 58993.6 |
239 | 2021-02-20 18:25:42 | sparling | 1 | 82945 | 11 | 1.330 | 62364.7 |
238 | 2021-02-02 20:37:29 | sparling | 1 | 82945 | 11 | 1.580 | 52496.8 |
237 | 2021-01-29 15:26:12 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
236 | 2021-01-07 04:16:53 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
235 | 2021-01-01 05:37:32 | sparling | 1 | 82945 | 11 | 1.486 | 55817.6 |
234 | 2020-11-19 11:34:41 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
233 | 2020-11-08 05:15:48 | sparling | 1 | 82945 | 11 | 1.436 | 57761.1 |
232 | 2020-11-01 09:21:40 | sparling | 1 | 82945 | 11 | 1.423 | 58288.8 |
231 | 2020-09-01 17:03:51 | sparling | 1 | 82945 | 11 | 1.313 | 63172.1 |
230 | 2020-08-16 05:18:21 | sparling | 1 | 82945 | 11 | 1.280 | 64800.8 |
229 | 2020-07-21 11:58:23 | sparling | 1 | 82945 | 11 | 1.393 | 59544.1 |
228 | 2020-07-12 04:25:06 | sparling | 1 | 82945 | 11 | 1.393 | 59544.1 |
227 | 2020-05-14 22:29:58 | sparling | 1 | 82945 | 11 | 1.343 | 61761.0 |
226 | 2020-04-10 08:09:23 | sparling | 1 | 82945 | 11 | 1.360 | 60989.0 |
225 | 2020-03-30 03:19:52 | sparling | 1 | 82945 | 11 | 1.466 | 56579.1 |
224 | 2020-03-21 02:07:44 | sparling | 1 | 82945 | 11 | 1.593 | 52068.4 |
223 | 2020-02-25 08:11:41 | sparling | 1 | 82945 | 11 | 3.233 | 25655.7 |
222 | 2020-02-20 02:30:18 | sparling | 1 | 82945 | 11 | 1.503 | 55186.3 |
221 | 2020-02-12 07:25:00 | sparling | 1 | 82945 | 11 | 1.530 | 54212.4 |
220 | 2020-02-11 08:44:32 | sparling | 1 | 82945 | 11 | 1.640 | 50576.2 |
219 | 2020-02-09 23:05:42 | sparling | 1 | 82945 | 11 | 1.486 | 55817.6 |
218 | 2020-02-04 14:36:21 | sparling | 1 | 82945 | 11 | 1.623 | 51106.0 |
217 | 2020-01-30 14:09:18 | sparling | 1 | 82945 | 11 | 1.780 | 46598.3 |
216 | 2020-01-30 08:06:25 | sparling | 1 | 82945 | 11 | 5.033 | 16480.2 |
215 | 2020-01-26 11:08:19 | sparling | 1 | 82945 | 11 | 1.673 | 49578.6 |
214 | 2020-01-20 23:45:54 | sparling | 1 | 82945 | 11 | 3.313 | 25036.2 |
213 | 2020-01-18 13:52:39 | sparling | 1 | 82945 | 11 | 1.783 | 46519.9 |
212 | 2020-01-15 00:55:04 | sparling | 1 | 82945 | 11 | 2.813 | 29486.3 |
211 | 2020-01-11 03:57:50 | sparling | 1 | 82945 | 11 | 2.190 | 37874.4 |
210 | 2020-01-01 11:41:18 | sparling | 1 | 82945 | 11 | 1.500 | 55296.7 |
209 | 2019-12-28 06:58:31 | sparling | 1 | 82945 | 11 | 1.610 | 51518.6 |
208 | 2019-12-26 09:48:48 | sparling | 1 | 82945 | 11 | 1.580 | 52496.8 |
207 | 2019-12-25 20:01:37 | sparling | 1 | 82945 | 11 | 1.296 | 64000.8 |
206 | 2019-11-12 04:31:14 | sparling | 1 | 82945 | 11 | 1.406 | 58993.6 |
205 | 2019-08-10 20:58:14 | sparling | 1 | 82945 | 11 | 1.370 | 60543.8 |
204 | 2019-05-11 01:17:43 | sparling | 1 | 82945 | 11 | 1.446 | 57361.7 |
203 | 2019-04-23 06:28:20 | sparling | 1 | 82945 | 11 | 1.316 | 63028.1 |
202 | 2019-04-16 23:15:41 | sparling | 1 | 82945 | 11 | 1.286 | 64498.4 |