History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whisker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
296 | 2024-03-31 00:44:44 | whisker | 1 | 69583 | 7 | 2.373 | 29322.8 |
295 | 2024-03-30 09:25:28 | whisker | 3 | 134027 | 364 | 19.530 | 6862.6 |
294 | 2024-03-30 05:51:11 | whisker | 3 | 134027 | 364 | 12.656 | 10590.0 |
293 | 2024-03-18 08:00:42 | whisker | 3 | 134027 | 364 | 7.313 | 18327.2 |
292 | 2024-03-18 04:36:04 | whisker | 2 | 107671 | 50 | 3.356 | 32083.1 |
291 | 2024-03-15 13:39:17 | whisker | 3 | 134027 | 364 | 15.390 | 8708.7 |
290 | 2024-03-15 13:38:57 | whisker | 2 | 107671 | 50 | 3.670 | 29338.1 |
289 | 2024-03-14 17:56:07 | whisker | 2 | 107671 | 50 | 5.170 | 20826.1 |
288 | 2024-01-20 08:01:20 | whisker | 1 | 69583 | 7 | 1.296 | 53690.6 |
287 | 2024-01-13 06:28:23 | whisker | 3 | 134027 | 364 | 6.126 | 21878.4 |
286 | 2024-01-13 06:28:22 | whisker | 2 | 107671 | 50 | 3.110 | 34620.9 |
285 | 2023-12-05 08:31:15 | whisker | 3 | 134027 | 364 | 5.690 | 23554.8 |
284 | 2023-11-27 05:58:28 | whisker | 2 | 107671 | 50 | 2.610 | 41253.3 |
283 | 2023-11-19 19:22:59 | whisker | 1 | 69583 | 7 | 1.016 | 68487.2 |
282 | 2023-11-16 10:04:24 | whisker | 1 | 69583 | 7 | 1.030 | 67556.3 |
281 | 2023-11-15 20:53:14 | whisker | 1 | 69583 | 7 | 1.263 | 55093.4 |
280 | 2023-10-31 17:48:09 | whisker | 1 | 69583 | 7 | 1.236 | 56296.9 |
279 | 2023-10-25 13:33:41 | whisker | 1 | 69583 | 7 | 1.126 | 61796.6 |
278 | 2023-10-06 17:44:26 | whisker | 1 | 69583 | 7 | 1.046 | 66522.9 |
277 | 2023-09-26 02:32:56 | whisker | 1 | 69583 | 7 | 1.080 | 64428.7 |
276 | 2023-09-14 12:39:36 | whisker | 1 | 69583 | 7 | 1.063 | 65459.1 |
275 | 2023-09-03 08:51:55 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
274 | 2023-09-02 22:08:57 | whisker | 3 | 134027 | 364 | 5.483 | 24444.1 |
273 | 2023-08-27 17:17:41 | whisker | 2 | 107671 | 50 | 2.656 | 40538.8 |
272 | 2023-07-03 16:44:21 | whisker | 1 | 69583 | 7 | 1.216 | 57222.9 |
271 | 2023-06-13 16:40:38 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
270 | 2023-05-20 19:50:36 | whisker | 3 | 134027 | 364 | 5.406 | 24792.3 |
269 | 2023-05-13 17:04:51 | whisker | 2 | 107671 | 50 | 2.673 | 40281.0 |
268 | 2023-03-03 07:52:48 | whisker | 1 | 69583 | 7 | 1.000 | 69583.0 |
267 | 2023-02-27 13:03:51 | whisker | 3 | 134027 | 364 | 5.310 | 25240.5 |
266 | 2023-02-18 03:07:03 | whisker | 2 | 107671 | 50 | 2.656 | 40538.8 |
265 | 2023-02-01 10:45:44 | whisker | 1 | 69583 | 7 | 1.156 | 60192.9 |
264 | 2022-12-26 01:13:43 | whisker | 1 | 69583 | 7 | 1.013 | 68690.0 |
263 | 2022-12-08 00:37:32 | whisker | 3 | 134027 | 364 | 5.296 | 25307.2 |
262 | 2022-11-30 23:15:34 | whisker | 2 | 107671 | 50 | 3.000 | 35890.3 |
261 | 2022-11-25 05:45:50 | whisker | 2 | 107671 | 50 | 3.156 | 34116.3 |
260 | 2022-10-26 20:31:53 | whisker | 2 | 107671 | 50 | 2.703 | 39833.9 |
259 | 2022-09-19 10:27:11 | whisker | 1 | 69583 | 7 | 1.016 | 68487.2 |
258 | 2022-09-17 10:35:49 | whisker | 2 | 107671 | 50 | 2.643 | 40738.2 |
257 | 2022-09-14 09:54:37 | whisker | 1 | 69583 | 7 | 1.063 | 65459.1 |
256 | 2022-08-03 09:27:47 | whisker | 2 | 107671 | 50 | 2.736 | 39353.4 |
255 | 2022-07-21 14:13:54 | whisker | 3 | 134027 | 364 | 5.640 | 23763.7 |
254 | 2022-07-16 21:18:09 | whisker | 1 | 69583 | 7 | 1.063 | 65459.1 |
253 | 2022-07-08 15:08:49 | whisker | 2 | 107671 | 50 | 2.716 | 39643.2 |
252 | 2022-04-22 01:34:45 | whisker | 1 | 69583 | 7 | 1.420 | 49002.1 |
251 | 2022-03-16 15:02:10 | whisker | 1 | 69583 | 7 | 1.373 | 50679.5 |
250 | 2022-03-14 11:20:59 | whisker | 1 | 69583 | 7 | 1.516 | 45899.1 |
249 | 2022-03-01 15:40:18 | whisker | 3 | 134027 | 364 | 6.126 | 21878.4 |
248 | 2022-02-27 11:01:26 | whisker | 3 | 134027 | 364 | 6.453 | 20769.7 |
247 | 2021-12-22 15:11:20 | whisker | 1 | 69583 | 7 | 1.263 | 55093.4 |
246 | 2021-12-20 23:07:23 | whisker | 1 | 69583 | 7 | 1.046 | 66522.9 |
245 | 2021-11-21 09:29:43 | whisker | 3 | 134027 | 364 | 6.046 | 22167.9 |
244 | 2021-11-01 16:48:08 | whisker | 1 | 69583 | 7 | 1.173 | 59320.5 |
243 | 2021-10-31 20:36:26 | whisker | 1 | 69583 | 7 | 1.173 | 59320.5 |
242 | 2021-10-25 12:47:15 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
241 | 2021-10-22 02:32:10 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
240 | 2021-10-21 10:01:04 | whisker | 1 | 69583 | 7 | 2.190 | 31773.1 |
239 | 2021-10-21 00:28:50 | whisker | 1 | 69583 | 7 | 1.030 | 67556.3 |
238 | 2021-09-20 03:47:59 | whisker | 3 | 134027 | 364 | 6.046 | 22167.9 |
237 | 2021-09-18 18:38:57 | whisker | 1 | 69583 | 7 | 1.140 | 61037.7 |
236 | 2021-09-17 22:26:21 | whisker | 1 | 69583 | 7 | 1.186 | 58670.3 |
235 | 2021-09-15 18:45:13 | whisker | 1 | 69583 | 7 | 1.123 | 61961.7 |
234 | 2021-09-13 15:23:35 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
233 | 2021-09-11 10:24:22 | whisker | 1 | 69583 | 7 | 1.153 | 60349.5 |
232 | 2021-08-21 16:50:02 | whisker | 1 | 69583 | 7 | 1.033 | 67360.1 |
231 | 2021-05-16 11:18:59 | whisker | 1 | 69583 | 7 | 1.153 | 60349.5 |
230 | 2021-05-04 04:24:58 | whisker | 1 | 69583 | 7 | 1.236 | 56296.9 |
229 | 2021-04-30 14:13:33 | whisker | 1 | 69583 | 7 | 1.156 | 60192.9 |
228 | 2021-04-05 04:47:07 | whisker | 1 | 69583 | 7 | 1.250 | 55666.4 |
227 | 2021-03-09 13:52:11 | whisker | 1 | 69583 | 7 | 1.090 | 63837.6 |
226 | 2021-02-13 19:52:21 | whisker | 1 | 69583 | 7 | 1.046 | 66522.9 |
225 | 2021-02-13 08:18:28 | whisker | 1 | 69583 | 7 | 2.063 | 33729.0 |
224 | 2021-01-20 11:26:20 | whisker | 1 | 69583 | 7 | 1.063 | 65459.1 |
223 | 2021-01-14 18:21:55 | whisker | 1 | 69583 | 7 | 1.030 | 67556.3 |
222 | 2020-12-21 03:55:58 | whisker | 1 | 69583 | 7 | 1.080 | 64428.7 |
221 | 2020-11-08 06:29:13 | whisker | 1 | 69583 | 7 | 1.266 | 54962.9 |
220 | 2020-11-02 07:59:22 | whisker | 3 | 134027 | 364 | 6.470 | 20715.1 |
219 | 2020-10-30 22:05:42 | whisker | 1 | 69583 | 7 | 1.093 | 63662.4 |
218 | 2020-10-30 11:39:07 | whisker | 2 | 107671 | 50 | 3.296 | 32667.2 |
217 | 2020-10-04 18:07:20 | whisker | 1 | 69583 | 7 | 1.046 | 66522.9 |
216 | 2020-09-14 07:55:00 | whisker | 1 | 69583 | 7 | 1.216 | 57222.9 |
215 | 2020-08-14 03:53:32 | whisker | 1 | 69583 | 7 | 1.126 | 61796.6 |
214 | 2020-06-17 07:23:15 | whisker | 1 | 69583 | 7 | 1.123 | 61961.7 |
213 | 2020-05-14 20:38:27 | whisker | 1 | 69583 | 7 | 1.063 | 65459.1 |
212 | 2020-03-23 12:33:20 | whisker | 1 | 69583 | 7 | 1.250 | 55666.4 |
211 | 2020-03-06 02:15:13 | whisker | 1 | 69583 | 7 | 1.170 | 59472.6 |
210 | 2020-03-05 23:00:19 | whisker | 1 | 69583 | 7 | 1.266 | 54962.9 |
209 | 2020-03-03 22:15:23 | whisker | 1 | 69583 | 7 | 1.143 | 60877.5 |
208 | 2020-03-01 00:53:20 | whisker | 1 | 69583 | 7 | 1.203 | 57841.2 |
207 | 2020-02-17 12:17:21 | whisker | 1 | 69583 | 7 | 2.640 | 26357.2 |
206 | 2020-02-13 21:21:17 | whisker | 1 | 69583 | 7 | 2.466 | 28217.0 |
205 | 2020-02-10 15:04:14 | whisker | 1 | 69583 | 7 | 2.563 | 27149.0 |
204 | 2020-02-07 22:22:39 | whisker | 1 | 69583 | 7 | 1.203 | 57841.2 |
203 | 2020-02-01 13:38:06 | whisker | 1 | 69583 | 7 | 2.580 | 26970.2 |
202 | 2020-01-29 01:25:46 | whisker | 1 | 69583 | 7 | 1.720 | 40455.2 |
201 | 2020-01-22 12:33:57 | whisker | 1 | 69583 | 7 | 1.330 | 52318.0 |
200 | 2020-01-20 00:41:30 | whisker | 1 | 69583 | 7 | 1.186 | 58670.3 |
199 | 2020-01-15 06:15:16 | whisker | 1 | 69583 | 7 | 3.610 | 19275.1 |
198 | 2020-01-07 13:23:22 | whisker | 1 | 69583 | 7 | 1.300 | 53525.4 |
197 | 2020-01-06 20:54:41 | whisker | 1 | 69583 | 7 | 2.533 | 27470.6 |