History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gurnard"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
312 | 2024-05-06 06:15:48 | gurnard | 4 | 151207 | 1276 | 13.236 | 11423.9 |
311 | 2024-05-04 10:54:27 | gurnard | 4 | 151207 | 1276 | 22.343 | 6767.5 |
310 | 2024-05-04 07:27:08 | gurnard | 2 | 107671 | 4 | 3.220 | 33438.2 |
309 | 2024-05-04 06:42:07 | gurnard | 4 | 151207 | 1276 | 14.596 | 10359.5 |
308 | 2024-05-04 06:41:56 | gurnard | 3 | 134027 | 96 | 6.623 | 20236.6 |
307 | 2024-05-04 00:49:12 | gurnard | 3 | 134027 | 96 | 7.950 | 16858.7 |
306 | 2024-04-24 23:46:31 | gurnard | 1 | 69583 | 2 | 1.233 | 56433.9 |
305 | 2024-04-07 13:23:09 | gurnard | 1 | 69583 | 2 | 2.516 | 27656.2 |
304 | 2024-04-04 05:52:54 | gurnard | 1 | 69583 | 2 | 2.953 | 23563.5 |
303 | 2024-03-30 02:01:23 | gurnard | 3 | 134027 | 96 | 29.160 | 4596.3 |
302 | 2024-03-30 02:01:22 | gurnard | 2 | 107671 | 4 | 11.330 | 9503.2 |
301 | 2024-03-30 02:00:46 | gurnard | 1 | 69583 | 2 | 2.280 | 30518.9 |
300 | 2024-03-29 05:40:59 | gurnard | 1 | 69583 | 2 | 2.390 | 29114.2 |
299 | 2024-03-06 21:42:14 | gurnard | 4 | 151207 | 1276 | 14.656 | 10317.1 |
298 | 2024-03-05 20:00:01 | gurnard | 4 | 151207 | 1276 | 12.766 | 11844.5 |
297 | 2024-03-05 18:03:13 | gurnard | 4 | 151207 | 1276 | 24.830 | 6089.7 |
296 | 2024-03-05 17:59:31 | gurnard | 3 | 134027 | 96 | 15.796 | 8484.9 |
295 | 2024-03-05 17:46:14 | gurnard | 4 | 151207 | 1276 | 28.640 | 5279.6 |
294 | 2024-03-05 03:42:45 | gurnard | 4 | 151207 | 1276 | 21.953 | 6887.8 |
293 | 2024-03-05 03:42:40 | gurnard | 3 | 134027 | 96 | 21.656 | 6188.9 |
292 | 2024-03-05 03:42:40 | gurnard | 2 | 107671 | 4 | 9.186 | 11721.2 |
291 | 2024-03-05 03:42:07 | gurnard | 1 | 69583 | 2 | 1.373 | 50679.5 |
290 | 2024-02-27 23:04:27 | gurnard | 1 | 69583 | 2 | 2.580 | 26970.2 |
289 | 2024-02-11 15:04:23 | gurnard | 1 | 69583 | 2 | 1.266 | 54962.9 |
288 | 2024-02-08 04:49:43 | gurnard | 1 | 69583 | 2 | 1.030 | 67556.3 |
287 | 2023-11-29 06:47:00 | gurnard | 1 | 69583 | 2 | 1.063 | 65459.1 |
286 | 2023-11-29 01:34:30 | gurnard | 1 | 69583 | 2 | 1.060 | 65644.3 |
285 | 2023-11-20 19:00:39 | gurnard | 1 | 69583 | 2 | 1.063 | 65459.1 |
284 | 2023-11-05 05:21:05 | gurnard | 1 | 69583 | 2 | 1.063 | 65459.1 |
283 | 2023-10-29 23:47:21 | gurnard | 1 | 69583 | 2 | 1.123 | 61961.7 |
282 | 2023-10-01 03:16:05 | gurnard | 1 | 69583 | 2 | 1.203 | 57841.2 |
281 | 2023-09-26 06:43:27 | gurnard | 1 | 69583 | 2 | 1.140 | 61037.7 |
280 | 2023-09-22 09:58:54 | gurnard | 1 | 69583 | 2 | 1.156 | 60192.9 |
279 | 2023-09-14 01:25:18 | gurnard | 1 | 69583 | 2 | 1.233 | 56433.9 |
278 | 2023-07-03 09:18:27 | gurnard | 1 | 69583 | 2 | 1.156 | 60192.9 |
277 | 2023-05-27 03:25:58 | gurnard | 1 | 69583 | 2 | 1.060 | 65644.3 |
276 | 2023-04-12 16:20:13 | gurnard | 1 | 69583 | 2 | 1.016 | 68487.2 |
275 | 2023-02-05 15:29:07 | gurnard | 1 | 69583 | 2 | 1.156 | 60192.9 |
274 | 2023-01-31 06:08:59 | gurnard | 1 | 69583 | 2 | 1.123 | 61961.7 |
273 | 2023-01-27 17:26:50 | gurnard | 1 | 69583 | 2 | 1.156 | 60192.9 |
272 | 2022-12-04 17:57:19 | gurnard | 1 | 69583 | 2 | 1.186 | 58670.3 |
271 | 2022-09-28 23:27:31 | gurnard | 1 | 69583 | 2 | 1.046 | 66522.9 |
270 | 2022-07-31 05:18:44 | gurnard | 1 | 69583 | 2 | 1.063 | 65459.1 |
269 | 2022-05-29 08:57:13 | gurnard | 1 | 69583 | 2 | 1.153 | 60349.5 |
268 | 2022-01-24 16:32:00 | gurnard | 1 | 69583 | 2 | 1.046 | 66522.9 |
267 | 2021-10-01 20:19:15 | gurnard | 1 | 69583 | 2 | 1.170 | 59472.6 |
266 | 2021-09-13 19:17:57 | gurnard | 1 | 69583 | 2 | 1.076 | 64668.2 |
265 | 2021-07-25 17:57:05 | gurnard | 4 | 151207 | 1276 | 10.360 | 14595.3 |
264 | 2021-07-24 04:46:34 | gurnard | 4 | 151207 | 1276 | 10.076 | 15006.6 |
263 | 2021-06-22 04:20:13 | gurnard | 4 | 151207 | 1276 | 17.126 | 8829.1 |
262 | 2021-06-01 04:28:05 | gurnard | 4 | 151207 | 1276 | 12.313 | 12280.3 |
261 | 2021-05-14 05:49:39 | gurnard | 4 | 151207 | 1276 | 11.030 | 13708.7 |
260 | 2021-05-04 19:16:46 | gurnard | 1 | 69583 | 2 | 1.233 | 56433.9 |
259 | 2021-04-13 06:41:28 | gurnard | 4 | 151207 | 1276 | 12.250 | 12343.4 |
258 | 2021-03-07 10:43:38 | gurnard | 1 | 69583 | 2 | 1.186 | 58670.3 |
257 | 2021-03-01 23:48:04 | gurnard | 4 | 151207 | 1276 | 9.673 | 15631.9 |
256 | 2021-02-23 14:34:31 | gurnard | 4 | 151207 | 1276 | 9.796 | 15435.6 |
255 | 2021-02-21 19:06:30 | gurnard | 1 | 69583 | 2 | 1.203 | 57841.2 |
254 | 2021-02-19 23:44:27 | gurnard | 4 | 151207 | 1276 | 12.563 | 12035.9 |
253 | 2020-12-18 16:08:26 | gurnard | 1 | 69583 | 2 | 1.156 | 60192.9 |
252 | 2020-11-26 00:40:33 | gurnard | 4 | 151207 | 1276 | 10.110 | 14956.2 |
251 | 2020-11-10 04:53:59 | gurnard | 1 | 69583 | 2 | 1.153 | 60349.5 |
250 | 2020-11-01 10:37:06 | gurnard | 1 | 69583 | 2 | 1.203 | 57841.2 |
249 | 2020-10-18 10:53:36 | gurnard | 1 | 69583 | 2 | 1.143 | 60877.5 |
248 | 2020-10-09 06:12:48 | gurnard | 1 | 69583 | 2 | 1.096 | 63488.1 |
247 | 2020-03-29 05:53:02 | gurnard | 1 | 69583 | 2 | 1.250 | 55666.4 |
246 | 2020-03-28 20:52:20 | gurnard | 1 | 69583 | 2 | 1.263 | 55093.4 |
245 | 2020-03-28 05:04:29 | gurnard | 1 | 69583 | 2 | 1.186 | 58670.3 |
244 | 2020-03-25 14:05:16 | gurnard | 1 | 69583 | 2 | 1.313 | 52995.4 |
243 | 2020-03-24 21:55:44 | gurnard | 1 | 69583 | 2 | 1.220 | 57035.2 |
242 | 2020-03-24 18:29:39 | gurnard | 1 | 69583 | 2 | 1.313 | 52995.4 |
241 | 2020-03-22 18:57:08 | gurnard | 1 | 69583 | 2 | 2.406 | 28920.6 |
240 | 2020-03-20 21:20:01 | gurnard | 1 | 69583 | 2 | 1.250 | 55666.4 |
239 | 2020-02-25 20:42:20 | gurnard | 1 | 69583 | 2 | 2.140 | 32515.4 |
238 | 2020-02-25 11:02:26 | gurnard | 1 | 69583 | 2 | 1.470 | 47335.4 |
237 | 2020-02-24 20:30:39 | gurnard | 1 | 69583 | 2 | 1.313 | 52995.4 |
236 | 2020-02-15 13:31:17 | gurnard | 1 | 69583 | 2 | 1.360 | 51164.0 |
235 | 2020-02-13 07:34:31 | gurnard | 4 | 151207 | 1276 | 11.736 | 12884.0 |
234 | 2020-02-12 15:07:17 | gurnard | 3 | 134027 | 96 | 16.033 | 8359.4 |
233 | 2020-02-11 17:37:58 | gurnard | 3 | 134027 | 96 | 6.720 | 19944.5 |
232 | 2020-02-10 19:41:22 | gurnard | 4 | 151207 | 1276 | 11.936 | 12668.1 |
231 | 2020-02-07 20:50:19 | gurnard | 3 | 134027 | 96 | 8.190 | 16364.7 |
230 | 2020-02-03 02:49:17 | gurnard | 3 | 134027 | 96 | 10.296 | 13017.4 |
229 | 2020-02-02 11:34:06 | gurnard | 3 | 134027 | 96 | 7.453 | 17983.0 |
228 | 2020-02-01 03:37:56 | gurnard | 1 | 69583 | 2 | 1.203 | 57841.2 |
227 | 2020-01-30 13:03:22 | gurnard | 1 | 69583 | 2 | 1.440 | 48321.5 |
226 | 2020-01-30 07:50:06 | gurnard | 1 | 69583 | 2 | 1.406 | 49490.0 |
225 | 2020-01-26 13:20:39 | gurnard | 1 | 69583 | 2 | 1.310 | 53116.8 |
224 | 2020-01-22 20:32:55 | gurnard | 1 | 69583 | 2 | 2.140 | 32515.4 |
223 | 2020-01-21 23:26:20 | gurnard | 1 | 69583 | 2 | 2.643 | 26327.3 |
222 | 2020-01-21 06:24:57 | gurnard | 4 | 151207 | 1276 | 27.533 | 5491.8 |
221 | 2020-01-20 23:41:49 | gurnard | 4 | 151207 | 1276 | 22.360 | 6762.4 |
220 | 2020-01-20 21:36:43 | gurnard | 4 | 151207 | 1276 | 37.910 | 3988.6 |
219 | 2020-01-20 21:30:39 | gurnard | 4 | 151207 | 1276 | 13.470 | 11225.5 |
218 | 2020-01-20 21:28:21 | gurnard | 2 | 107671 | 4 | 9.796 | 10991.3 |
217 | 2020-01-20 21:11:43 | gurnard | 4 | 151207 | 1276 | 25.686 | 5886.7 |
216 | 2020-01-20 17:48:09 | gurnard | 4 | 151207 | 1276 | 30.096 | 5024.2 |
215 | 2020-01-20 17:48:04 | gurnard | 3 | 134027 | 96 | 10.470 | 12801.1 |
214 | 2020-01-20 12:55:09 | gurnard | 1 | 69583 | 2 | 2.016 | 34515.4 |
213 | 2020-01-11 22:36:25 | gurnard | 1 | 69583 | 2 | 1.560 | 44604.5 |