History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spearer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
335 | 2024-04-09 06:48:20 | spearer | 1 | 69583 | 9 | 1.216 | 57222.9 |
334 | 2024-03-28 11:32:40 | spearer | 1 | 69583 | 9 | 2.593 | 26834.9 |
333 | 2024-03-25 21:00:11 | spearer | 1 | 69583 | 9 | 1.470 | 47335.4 |
332 | 2024-03-08 22:27:26 | spearer | 1 | 69583 | 9 | 1.313 | 52995.4 |
331 | 2024-01-03 13:52:38 | spearer | 1 | 69583 | 9 | 1.313 | 52995.4 |
330 | 2024-01-02 00:10:37 | spearer | 2 | 107671 | 74 | 3.216 | 33479.8 |
329 | 2023-12-13 06:51:44 | spearer | 1 | 69583 | 9 | 1.076 | 64668.2 |
328 | 2023-12-12 18:05:05 | spearer | 1 | 69583 | 9 | 1.096 | 63488.1 |
327 | 2023-12-08 03:40:31 | spearer | 1 | 69583 | 9 | 1.076 | 64668.2 |
326 | 2023-12-08 03:40:29 | spearer | 1 | 69583 | 9 | 1.140 | 61037.7 |
325 | 2023-12-02 11:40:36 | spearer | 1 | 69583 | 9 | 1.250 | 55666.4 |
324 | 2023-11-22 02:21:09 | spearer | 1 | 69583 | 9 | 1.266 | 54962.9 |
323 | 2023-11-18 07:19:06 | spearer | 1 | 69583 | 9 | 1.190 | 58473.1 |
322 | 2023-10-07 01:15:38 | spearer | 2 | 107671 | 74 | 3.296 | 32667.2 |
321 | 2023-09-29 05:57:50 | spearer | 1 | 69583 | 9 | 1.173 | 59320.5 |
320 | 2023-09-26 21:41:21 | spearer | 1 | 69583 | 9 | 1.283 | 54234.6 |
319 | 2023-09-23 17:56:19 | spearer | 1 | 69583 | 9 | 1.266 | 54962.9 |
318 | 2023-08-28 22:48:13 | spearer | 1 | 69583 | 9 | 1.170 | 59472.6 |
317 | 2023-07-27 13:23:49 | spearer | 1 | 69583 | 9 | 1.090 | 63837.6 |
316 | 2023-07-18 12:32:34 | spearer | 2 | 107671 | 74 | 2.860 | 37647.2 |
315 | 2023-05-11 17:00:23 | spearer | 1 | 69583 | 9 | 1.186 | 58670.3 |
314 | 2023-04-25 00:19:57 | spearer | 1 | 69583 | 9 | 1.063 | 65459.1 |
313 | 2023-04-01 22:04:49 | spearer | 2 | 107671 | 74 | 5.576 | 19309.7 |
312 | 2023-01-22 06:36:51 | spearer | 1 | 69583 | 9 | 1.063 | 65459.1 |
311 | 2022-12-27 08:46:45 | spearer | 2 | 107671 | 74 | 3.143 | 34257.4 |
310 | 2022-09-27 04:14:06 | spearer | 1 | 69583 | 9 | 1.220 | 57035.2 |
309 | 2022-08-25 22:37:00 | spearer | 2 | 107671 | 74 | 4.173 | 25801.8 |
308 | 2022-06-13 03:16:30 | spearer | 1 | 69583 | 9 | 1.173 | 59320.5 |
307 | 2022-06-10 23:27:49 | spearer | 1 | 69583 | 9 | 1.126 | 61796.6 |
306 | 2022-05-27 19:00:12 | spearer | 1 | 69583 | 9 | 1.093 | 63662.4 |
305 | 2022-02-18 14:39:41 | spearer | 1 | 69583 | 9 | 1.280 | 54361.7 |
304 | 2022-02-16 09:33:04 | spearer | 1 | 69583 | 9 | 1.140 | 61037.7 |
303 | 2022-01-29 20:16:12 | spearer | 1 | 69583 | 9 | 1.123 | 61961.7 |
302 | 2021-12-03 15:23:53 | spearer | 1 | 69583 | 9 | 1.266 | 54962.9 |
301 | 2021-10-11 01:54:22 | spearer | 1 | 69583 | 9 | 1.076 | 64668.2 |
300 | 2021-10-09 20:09:36 | spearer | 1 | 69583 | 9 | 1.186 | 58670.3 |
299 | 2021-09-19 22:09:32 | spearer | 1 | 69583 | 9 | 1.093 | 63662.4 |
298 | 2021-08-01 10:21:56 | spearer | 1 | 69583 | 9 | 1.060 | 65644.3 |
297 | 2021-07-07 22:08:07 | spearer | 1 | 69583 | 9 | 1.093 | 63662.4 |
296 | 2021-05-20 01:17:44 | spearer | 1 | 69583 | 9 | 1.250 | 55666.4 |
295 | 2021-04-20 03:17:33 | spearer | 1 | 69583 | 9 | 1.093 | 63662.4 |
294 | 2021-04-13 12:40:38 | spearer | 2 | 107671 | 74 | 6.720 | 16022.5 |
293 | 2021-04-08 02:45:55 | spearer | 1 | 69583 | 9 | 1.170 | 59472.6 |
292 | 2021-04-03 22:59:17 | spearer | 1 | 69583 | 9 | 1.203 | 57841.2 |
291 | 2021-03-22 22:32:50 | spearer | 1 | 69583 | 9 | 1.110 | 62687.4 |
290 | 2021-03-18 07:54:32 | spearer | 3 | 134027 | 621 | 6.733 | 19906.0 |
289 | 2021-02-26 05:05:19 | spearer | 1 | 69583 | 9 | 1.080 | 64428.7 |
288 | 2021-01-28 04:06:22 | spearer | 3 | 134027 | 621 | 6.173 | 21711.8 |
287 | 2021-01-27 05:56:24 | spearer | 2 | 107671 | 74 | 3.016 | 35699.9 |
286 | 2021-01-04 19:58:42 | spearer | 1 | 69583 | 9 | 2.250 | 30925.8 |
285 | 2020-12-30 11:23:47 | spearer | 3 | 134027 | 621 | 6.016 | 22278.4 |
284 | 2020-12-29 22:35:39 | spearer | 1 | 69583 | 9 | 1.236 | 56296.9 |
283 | 2020-12-07 16:28:31 | spearer | 1 | 69583 | 9 | 1.076 | 64668.2 |
282 | 2020-11-19 08:47:31 | spearer | 2 | 107671 | 74 | 3.280 | 32826.5 |
281 | 2020-11-07 23:26:53 | spearer | 1 | 69583 | 9 | 1.593 | 43680.5 |
280 | 2020-10-28 18:27:12 | spearer | 1 | 69583 | 9 | 1.203 | 57841.2 |
279 | 2020-10-27 20:46:13 | spearer | 1 | 69583 | 9 | 1.076 | 64668.2 |
278 | 2020-10-22 21:12:35 | spearer | 1 | 69583 | 9 | 1.106 | 62914.1 |
277 | 2020-10-16 03:42:28 | spearer | 3 | 134027 | 621 | 6.173 | 21711.8 |
276 | 2020-10-15 08:52:15 | spearer | 2 | 107671 | 74 | 2.860 | 37647.2 |
275 | 2020-10-02 10:45:54 | spearer | 1 | 69583 | 9 | 1.156 | 60192.9 |
274 | 2020-09-26 15:18:34 | spearer | 1 | 69583 | 9 | 1.220 | 57035.2 |
273 | 2020-09-26 06:09:14 | spearer | 1 | 69583 | 9 | 1.063 | 65459.1 |
272 | 2020-08-30 12:40:33 | spearer | 1 | 69583 | 9 | 1.203 | 57841.2 |
271 | 2020-07-24 11:36:45 | spearer | 1 | 69583 | 9 | 1.126 | 61796.6 |
270 | 2020-06-21 00:16:43 | spearer | 1 | 69583 | 9 | 1.220 | 57035.2 |
269 | 2020-06-17 20:19:05 | spearer | 1 | 69583 | 9 | 1.110 | 62687.4 |
268 | 2020-06-03 21:07:00 | spearer | 1 | 69583 | 9 | 1.390 | 50059.7 |
267 | 2020-03-29 20:04:23 | spearer | 1 | 69583 | 9 | 1.280 | 54361.7 |
266 | 2020-03-28 09:19:18 | spearer | 1 | 69583 | 9 | 2.703 | 25742.9 |
265 | 2020-03-26 12:20:07 | spearer | 1 | 69583 | 9 | 1.283 | 54234.6 |
264 | 2020-03-23 15:29:48 | spearer | 1 | 69583 | 9 | 1.203 | 57841.2 |
263 | 2020-03-19 23:07:35 | spearer | 1 | 69583 | 9 | 1.126 | 61796.6 |
262 | 2020-03-07 05:43:52 | spearer | 1 | 69583 | 9 | 1.110 | 62687.4 |
261 | 2020-02-24 11:46:04 | spearer | 1 | 69583 | 9 | 1.280 | 54361.7 |
260 | 2020-02-23 22:55:42 | spearer | 1 | 69583 | 9 | 2.640 | 26357.2 |
259 | 2020-02-17 06:00:50 | spearer | 1 | 69583 | 9 | 1.403 | 49595.9 |
258 | 2020-02-10 01:59:33 | spearer | 1 | 69583 | 9 | 1.356 | 51314.9 |
257 | 2020-02-05 21:51:51 | spearer | 1 | 69583 | 9 | 2.563 | 27149.0 |
256 | 2020-02-04 11:30:10 | spearer | 1 | 69583 | 9 | 1.330 | 52318.0 |
255 | 2020-01-31 14:56:46 | spearer | 1 | 69583 | 9 | 1.343 | 51811.6 |
254 | 2020-01-29 02:55:05 | spearer | 1 | 69583 | 9 | 1.420 | 49002.1 |
253 | 2020-01-24 06:28:23 | spearer | 1 | 69583 | 9 | 2.873 | 24219.6 |
252 | 2020-01-17 15:25:36 | spearer | 1 | 69583 | 9 | 1.080 | 64428.7 |
251 | 2020-01-15 09:04:35 | spearer | 1 | 69583 | 9 | 1.313 | 52995.4 |
250 | 2020-01-11 20:43:31 | spearer | 1 | 69583 | 9 | 1.263 | 55093.4 |
249 | 2020-01-07 22:51:34 | spearer | 1 | 69583 | 9 | 2.873 | 24219.6 |
248 | 2019-12-29 15:50:05 | spearer | 1 | 69583 | 9 | 1.216 | 57222.9 |
247 | 2019-12-27 02:46:32 | spearer | 1 | 69583 | 9 | 1.266 | 54962.9 |
246 | 2019-12-26 22:29:54 | spearer | 1 | 69583 | 9 | 3.063 | 22717.3 |
245 | 2019-12-26 12:10:23 | spearer | 1 | 69583 | 9 | 1.233 | 56433.9 |
244 | 2019-12-04 06:48:19 | spearer | 1 | 69583 | 9 | 1.190 | 58473.1 |
243 | 2019-09-02 01:00:43 | spearer | 1 | 69583 | 9 | 1.970 | 35321.3 |
242 | 2019-06-18 22:19:22 | spearer | 1 | 69583 | 9 | 1.130 | 61577.9 |
241 | 2019-06-02 13:20:06 | spearer | 1 | 69583 | 9 | 1.140 | 61037.7 |
240 | 2019-06-02 09:16:31 | spearer | 1 | 69583 | 9 | 1.183 | 58819.1 |
239 | 2019-05-30 07:09:05 | spearer | 1 | 69583 | 9 | 1.260 | 55224.6 |
238 | 2019-05-30 04:27:47 | spearer | 1 | 69583 | 9 | 1.110 | 62687.4 |
237 | 2019-03-14 15:57:05 | spearer | 1 | 69583 | 9 | 1.073 | 64849.0 |
236 | 2019-03-01 10:07:28 | spearer | 1 | 69583 | 9 | 1.180 | 58968.6 |