History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yachts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
290 | 2024-04-28 00:32:01 | yachts | 3 | 112716 | 469 | 18.220 | 6186.4 |
289 | 2024-04-27 22:49:05 | yachts | 3 | 112716 | 469 | 7.186 | 15685.5 |
288 | 2024-04-19 08:42:44 | yachts | 1 | 48755 | 2 | 0.826 | 59025.4 |
287 | 2024-04-10 07:44:47 | yachts | 1 | 48755 | 2 | 3.220 | 15141.3 |
286 | 2024-04-06 00:12:23 | yachts | 3 | 112716 | 469 | 11.110 | 10145.5 |
285 | 2024-04-05 21:17:55 | yachts | 2 | 82551 | 34 | 2.950 | 27983.4 |
284 | 2024-04-05 21:13:04 | yachts | 3 | 112716 | 469 | 7.156 | 15751.3 |
283 | 2024-03-31 05:54:24 | yachts | 3 | 112716 | 469 | 15.140 | 7444.9 |
282 | 2024-03-31 03:45:02 | yachts | 2 | 82551 | 34 | 2.453 | 33653.1 |
281 | 2024-03-31 03:44:41 | yachts | 3 | 112716 | 469 | 8.123 | 13876.2 |
280 | 2024-03-28 16:00:43 | yachts | 1 | 48755 | 2 | 0.873 | 55847.7 |
279 | 2024-03-28 16:00:33 | yachts | 3 | 112716 | 469 | 5.733 | 19660.9 |
278 | 2024-03-28 16:00:34 | yachts | 2 | 82551 | 34 | 2.560 | 32246.5 |
277 | 2024-03-28 16:00:33 | yachts | 1 | 48755 | 2 | 0.876 | 55656.4 |
276 | 2024-02-22 05:24:08 | yachts | 1 | 48755 | 2 | 0.890 | 54780.9 |
275 | 2024-02-09 02:31:43 | yachts | 2 | 82551 | 34 | 2.203 | 37472.1 |
274 | 2024-02-05 10:47:35 | yachts | 3 | 112716 | 469 | 11.533 | 9773.3 |
273 | 2024-01-30 18:13:46 | yachts | 2 | 82551 | 34 | 2.513 | 32849.6 |
272 | 2024-01-29 21:05:26 | yachts | 2 | 82551 | 34 | 2.533 | 32590.2 |
271 | 2024-01-29 21:04:54 | yachts | 3 | 112716 | 469 | 4.716 | 23900.8 |
270 | 2024-01-27 01:13:33 | yachts | 3 | 112716 | 469 | 10.766 | 10469.6 |
269 | 2024-01-20 07:51:02 | yachts | 3 | 112716 | 469 | 4.656 | 24208.8 |
268 | 2023-12-30 03:56:07 | yachts | 2 | 82551 | 34 | 2.390 | 34540.2 |
267 | 2023-12-25 07:28:17 | yachts | 2 | 82551 | 34 | 2.313 | 35690.0 |
266 | 2023-12-23 06:24:17 | yachts | 3 | 112716 | 469 | 4.580 | 24610.5 |
265 | 2023-12-06 11:22:37 | yachts | 1 | 48755 | 2 | 0.826 | 59025.4 |
264 | 2023-12-03 10:24:28 | yachts | 1 | 48755 | 2 | 0.720 | 67715.3 |
263 | 2023-12-03 10:24:27 | yachts | 1 | 48755 | 2 | 0.720 | 67715.3 |
262 | 2023-11-29 17:45:30 | yachts | 1 | 48755 | 2 | 0.830 | 58741.0 |
261 | 2023-11-27 07:55:48 | yachts | 1 | 48755 | 2 | 0.876 | 55656.4 |
260 | 2023-11-17 21:55:38 | yachts | 1 | 48755 | 2 | 1.800 | 27086.1 |
259 | 2023-11-13 03:23:56 | yachts | 2 | 82551 | 34 | 2.373 | 34787.6 |
258 | 2023-11-05 00:39:07 | yachts | 1 | 48755 | 2 | 0.780 | 62506.4 |
257 | 2023-10-23 10:39:40 | yachts | 1 | 48755 | 2 | 0.856 | 56956.8 |
256 | 2023-10-13 15:47:27 | yachts | 1 | 48755 | 2 | 0.813 | 59969.2 |
255 | 2023-10-07 09:57:25 | yachts | 1 | 48755 | 2 | 0.813 | 59969.2 |
254 | 2023-09-29 23:05:02 | yachts | 3 | 112716 | 469 | 5.966 | 18893.1 |
253 | 2023-09-29 16:38:34 | yachts | 1 | 48755 | 2 | 0.876 | 55656.4 |
252 | 2023-09-24 14:43:47 | yachts | 1 | 48755 | 2 | 0.736 | 66243.2 |
251 | 2023-09-24 08:58:16 | yachts | 3 | 112716 | 469 | 5.343 | 21096.0 |
250 | 2023-09-22 10:08:27 | yachts | 1 | 48755 | 2 | 0.800 | 60943.8 |
249 | 2023-08-15 19:16:28 | yachts | 2 | 82551 | 34 | 2.060 | 40073.3 |
248 | 2023-07-19 11:12:49 | yachts | 1 | 48755 | 2 | 0.813 | 59969.2 |
247 | 2023-07-05 14:57:23 | yachts | 3 | 112716 | 469 | 4.563 | 24702.2 |
246 | 2023-07-05 04:42:49 | yachts | 3 | 112716 | 469 | 4.610 | 24450.3 |
245 | 2023-04-30 06:48:50 | yachts | 2 | 82551 | 34 | 2.060 | 40073.3 |
244 | 2023-04-22 11:37:44 | yachts | 1 | 48755 | 2 | 0.750 | 65006.7 |
243 | 2023-03-27 14:44:38 | yachts | 3 | 112716 | 469 | 4.843 | 23274.0 |
242 | 2023-02-15 03:54:54 | yachts | 1 | 48755 | 2 | 1.623 | 30040.0 |
241 | 2023-02-02 03:55:51 | yachts | 2 | 82551 | 34 | 2.080 | 39688.0 |
240 | 2023-01-15 22:11:09 | yachts | 3 | 112716 | 469 | 4.563 | 24702.2 |
239 | 2022-12-25 06:55:39 | yachts | 3 | 112716 | 469 | 10.470 | 10765.6 |
238 | 2022-12-23 20:56:57 | yachts | 3 | 112716 | 469 | 5.563 | 20261.7 |
237 | 2022-12-13 12:52:34 | yachts | 1 | 48755 | 2 | 0.813 | 59969.2 |
236 | 2022-11-18 17:19:17 | yachts | 3 | 112716 | 469 | 6.046 | 18643.1 |
235 | 2022-11-14 06:17:18 | yachts | 2 | 82551 | 34 | 2.326 | 35490.5 |
234 | 2022-11-07 01:54:11 | yachts | 3 | 112716 | 469 | 4.576 | 24632.0 |
233 | 2022-11-05 19:40:46 | yachts | 3 | 112716 | 469 | 4.500 | 25048.0 |
232 | 2022-10-13 05:47:16 | yachts | 3 | 112716 | 469 | 4.546 | 24794.5 |
231 | 2022-09-25 16:00:30 | yachts | 3 | 112716 | 469 | 5.250 | 21469.7 |
230 | 2022-09-12 04:41:26 | yachts | 1 | 48755 | 2 | 0.843 | 57835.1 |
229 | 2022-08-26 06:40:07 | yachts | 3 | 112716 | 469 | 4.750 | 23729.7 |
228 | 2022-08-22 09:19:44 | yachts | 1 | 48755 | 2 | 0.783 | 62266.9 |
227 | 2022-08-06 21:39:27 | yachts | 1 | 48755 | 2 | 0.736 | 66243.2 |
226 | 2022-07-17 21:41:18 | yachts | 1 | 48755 | 2 | 0.796 | 61250.0 |
225 | 2022-07-02 21:24:55 | yachts | 1 | 48755 | 2 | 0.716 | 68093.6 |
224 | 2022-06-17 21:42:27 | yachts | 2 | 82551 | 34 | 2.143 | 38521.2 |
223 | 2022-04-20 15:17:01 | yachts | 1 | 48755 | 2 | 0.923 | 52822.3 |
222 | 2022-01-14 04:20:46 | yachts | 1 | 48755 | 2 | 0.766 | 63648.8 |
221 | 2021-11-12 03:58:22 | yachts | 1 | 48755 | 2 | 0.733 | 66514.3 |
220 | 2021-09-27 16:27:33 | yachts | 1 | 48755 | 2 | 0.766 | 63648.8 |
219 | 2021-08-23 22:49:16 | yachts | 1 | 48755 | 2 | 0.736 | 66243.2 |
218 | 2021-08-21 18:10:12 | yachts | 1 | 48755 | 2 | 0.736 | 66243.2 |
217 | 2021-05-15 02:56:45 | yachts | 3 | 112716 | 469 | 5.406 | 20850.2 |
216 | 2021-04-29 15:26:33 | yachts | 1 | 48755 | 2 | 0.876 | 55656.4 |
215 | 2021-03-29 04:03:28 | yachts | 1 | 48755 | 2 | 0.830 | 58741.0 |
214 | 2021-02-20 19:48:38 | yachts | 3 | 112716 | 469 | 4.580 | 24610.5 |
213 | 2021-01-27 20:28:33 | yachts | 3 | 112716 | 469 | 5.533 | 20371.6 |
212 | 2021-01-12 22:33:29 | yachts | 1 | 48755 | 2 | 0.750 | 65006.7 |
211 | 2020-11-17 21:56:11 | yachts | 3 | 112716 | 469 | 4.830 | 23336.6 |
210 | 2020-11-12 05:05:46 | yachts | 1 | 48755 | 2 | 0.733 | 66514.3 |
209 | 2020-10-31 03:02:28 | yachts | 1 | 48755 | 2 | 1.126 | 43299.3 |
208 | 2020-10-04 21:36:46 | yachts | 1 | 48755 | 2 | 0.766 | 63648.8 |
207 | 2020-09-30 11:09:07 | yachts | 1 | 48755 | 2 | 0.750 | 65006.7 |
206 | 2020-08-06 15:05:07 | yachts | 1 | 48755 | 2 | 0.766 | 63648.8 |
205 | 2020-08-04 05:58:01 | yachts | 1 | 48755 | 2 | 0.813 | 59969.2 |
204 | 2020-08-03 08:08:48 | yachts | 1 | 48755 | 2 | 0.766 | 63648.8 |
203 | 2020-07-29 08:34:10 | yachts | 1 | 48755 | 2 | 0.876 | 55656.4 |
202 | 2020-05-11 20:22:43 | yachts | 1 | 48755 | 2 | 0.733 | 66514.3 |
201 | 2020-03-28 01:33:18 | yachts | 1 | 48755 | 2 | 0.860 | 56691.9 |
200 | 2020-03-26 20:17:01 | yachts | 1 | 48755 | 2 | 0.873 | 55847.7 |
199 | 2020-03-26 17:06:41 | yachts | 1 | 48755 | 2 | 0.733 | 66514.3 |
198 | 2020-03-24 11:45:46 | yachts | 1 | 48755 | 2 | 1.046 | 46610.9 |
197 | 2020-03-23 10:59:06 | yachts | 1 | 48755 | 2 | 0.750 | 65006.7 |
196 | 2020-03-22 09:10:20 | yachts | 1 | 48755 | 2 | 0.920 | 52994.6 |
195 | 2020-03-18 17:15:57 | yachts | 1 | 48755 | 2 | 0.843 | 57835.1 |
194 | 2020-02-24 21:46:12 | yachts | 1 | 48755 | 2 | 0.856 | 56956.8 |
193 | 2020-02-14 20:42:37 | yachts | 1 | 48755 | 2 | 1.860 | 26212.4 |
192 | 2020-02-11 03:49:09 | yachts | 1 | 48755 | 2 | 0.873 | 55847.7 |
191 | 2020-02-09 13:31:11 | yachts | 1 | 48755 | 2 | 1.860 | 26212.4 |