History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"teapot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-04-07 11:57:01 | teapot | 2 | 82551 | 22 | 6.783 | 12170.3 |
305 | 2024-04-06 22:51:14 | teapot | 3 | 112716 | 311 | 17.343 | 6499.2 |
304 | 2024-04-06 12:40:38 | teapot | 3 | 112716 | 311 | 12.720 | 8861.3 |
303 | 2024-04-06 12:40:36 | teapot | 2 | 82551 | 22 | 6.046 | 13653.8 |
302 | 2024-04-06 12:40:35 | teapot | 1 | 48755 | 3 | 2.156 | 22613.6 |
301 | 2024-03-30 09:22:37 | teapot | 1 | 48755 | 3 | 1.610 | 30282.6 |
300 | 2024-03-30 04:31:54 | teapot | 3 | 112716 | 311 | 10.860 | 10379.0 |
299 | 2024-03-28 23:48:49 | teapot | 3 | 112716 | 311 | 12.686 | 8885.1 |
298 | 2024-03-28 12:46:38 | teapot | 1 | 48755 | 3 | 0.893 | 54596.9 |
297 | 2024-03-28 12:46:21 | teapot | 3 | 112716 | 311 | 5.360 | 21029.1 |
296 | 2024-03-28 12:46:24 | teapot | 2 | 82551 | 22 | 2.550 | 32372.9 |
295 | 2024-03-28 12:46:19 | teapot | 1 | 48755 | 3 | 0.876 | 55656.4 |
294 | 2024-03-16 02:22:55 | teapot | 1 | 48755 | 3 | 2.266 | 21515.9 |
293 | 2024-03-16 02:22:45 | teapot | 1 | 48755 | 3 | 1.080 | 45143.5 |
292 | 2024-02-28 10:50:58 | teapot | 2 | 82551 | 22 | 4.203 | 19641.0 |
291 | 2024-02-28 10:50:44 | teapot | 3 | 112716 | 311 | 5.236 | 21527.1 |
290 | 2024-02-27 09:17:39 | teapot | 2 | 82551 | 22 | 2.860 | 28864.0 |
289 | 2024-02-27 09:17:34 | teapot | 3 | 112716 | 311 | 6.856 | 16440.5 |
288 | 2024-02-27 09:17:35 | teapot | 1 | 48755 | 3 | 0.983 | 49598.2 |
287 | 2024-02-20 22:03:10 | teapot | 1 | 48755 | 3 | 0.906 | 53813.5 |
286 | 2024-01-23 14:51:06 | teapot | 3 | 112716 | 311 | 11.266 | 10005.0 |
285 | 2024-01-22 09:43:03 | teapot | 3 | 112716 | 311 | 5.563 | 20261.7 |
284 | 2023-12-16 16:58:34 | teapot | 1 | 48755 | 3 | 0.843 | 57835.1 |
283 | 2023-12-12 20:33:59 | teapot | 1 | 48755 | 3 | 0.783 | 62266.9 |
282 | 2023-11-18 06:44:50 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
281 | 2023-10-23 09:23:28 | teapot | 1 | 48755 | 3 | 1.890 | 25796.3 |
280 | 2023-10-20 03:03:08 | teapot | 1 | 48755 | 3 | 0.763 | 63899.1 |
279 | 2023-10-14 02:45:18 | teapot | 1 | 48755 | 3 | 0.780 | 62506.4 |
278 | 2023-10-05 11:13:28 | teapot | 1 | 48755 | 3 | 0.810 | 60191.4 |
277 | 2023-09-24 23:39:24 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
276 | 2023-09-14 08:33:58 | teapot | 1 | 48755 | 3 | 0.830 | 58741.0 |
275 | 2023-06-02 03:00:59 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
274 | 2023-02-03 02:43:17 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
273 | 2023-01-30 17:29:29 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
272 | 2022-09-24 18:45:19 | teapot | 1 | 48755 | 3 | 0.766 | 63648.8 |
271 | 2022-09-21 04:11:35 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
270 | 2022-09-20 14:50:03 | teapot | 1 | 48755 | 3 | 0.733 | 66514.3 |
269 | 2022-05-04 16:37:13 | teapot | 1 | 48755 | 3 | 0.906 | 53813.5 |
268 | 2022-04-30 15:02:04 | teapot | 1 | 48755 | 3 | 0.796 | 61250.0 |
267 | 2022-01-17 12:01:49 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
266 | 2022-01-15 08:26:47 | teapot | 1 | 48755 | 3 | 1.000 | 48755.0 |
265 | 2022-01-07 11:41:29 | teapot | 1 | 48755 | 3 | 0.763 | 63899.1 |
264 | 2021-11-25 17:04:05 | teapot | 1 | 48755 | 3 | 0.923 | 52822.3 |
263 | 2021-09-21 18:24:12 | teapot | 1 | 48755 | 3 | 0.923 | 52822.3 |
262 | 2021-07-25 05:35:28 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
261 | 2021-06-18 17:19:14 | teapot | 1 | 48755 | 3 | 0.906 | 53813.5 |
260 | 2021-05-15 10:24:00 | teapot | 1 | 48755 | 3 | 0.843 | 57835.1 |
259 | 2021-04-14 14:36:39 | teapot | 1 | 48755 | 3 | 0.890 | 54780.9 |
258 | 2021-03-19 13:35:53 | teapot | 1 | 48755 | 3 | 0.826 | 59025.4 |
257 | 2021-01-28 03:08:46 | teapot | 1 | 48755 | 3 | 0.826 | 59025.4 |
256 | 2020-12-30 09:43:25 | teapot | 1 | 48755 | 3 | 0.843 | 57835.1 |
255 | 2020-12-16 16:23:38 | teapot | 1 | 48755 | 3 | 0.766 | 63648.8 |
254 | 2020-11-02 04:42:22 | teapot | 1 | 48755 | 3 | 1.796 | 27146.4 |
253 | 2020-10-31 02:01:47 | teapot | 1 | 48755 | 3 | 0.733 | 66514.3 |
252 | 2020-10-30 20:40:47 | teapot | 1 | 48755 | 3 | 0.826 | 59025.4 |
251 | 2020-10-22 00:29:03 | teapot | 1 | 48755 | 3 | 0.796 | 61250.0 |
250 | 2020-09-06 05:53:12 | teapot | 1 | 48755 | 3 | 0.826 | 59025.4 |
249 | 2020-08-14 01:58:37 | teapot | 1 | 48755 | 3 | 0.796 | 61250.0 |
248 | 2020-08-08 08:20:00 | teapot | 1 | 48755 | 3 | 0.766 | 63648.8 |
247 | 2020-07-18 10:40:16 | teapot | 1 | 48755 | 3 | 0.810 | 60191.4 |
246 | 2020-05-22 16:29:30 | teapot | 1 | 48755 | 3 | 0.763 | 63899.1 |
245 | 2020-05-08 07:04:47 | teapot | 1 | 48755 | 3 | 0.813 | 59969.2 |
244 | 2020-04-01 06:02:17 | teapot | 1 | 48755 | 3 | 0.890 | 54780.9 |
243 | 2020-03-27 16:20:19 | teapot | 1 | 48755 | 3 | 0.733 | 66514.3 |
242 | 2020-03-25 19:16:38 | teapot | 1 | 48755 | 3 | 0.830 | 58741.0 |
241 | 2020-03-23 04:08:28 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
240 | 2020-03-22 03:07:54 | teapot | 1 | 48755 | 3 | 0.830 | 58741.0 |
239 | 2020-03-18 17:58:56 | teapot | 1 | 48755 | 3 | 0.810 | 60191.4 |
238 | 2020-02-27 02:48:40 | teapot | 1 | 48755 | 3 | 1.733 | 28133.3 |
237 | 2020-02-21 10:16:38 | teapot | 1 | 48755 | 3 | 1.033 | 47197.5 |
236 | 2020-02-14 19:15:13 | teapot | 1 | 48755 | 3 | 0.986 | 49447.3 |
235 | 2020-02-10 18:33:14 | teapot | 1 | 48755 | 3 | 1.000 | 48755.0 |
234 | 2020-02-04 14:17:18 | teapot | 1 | 48755 | 3 | 0.923 | 52822.3 |
233 | 2020-02-03 01:24:32 | teapot | 1 | 48755 | 3 | 0.936 | 52088.7 |
232 | 2020-02-01 12:40:16 | teapot | 1 | 48755 | 3 | 1.126 | 43299.3 |
231 | 2020-01-30 22:26:55 | teapot | 1 | 48755 | 3 | 0.936 | 52088.7 |
230 | 2020-01-26 18:58:40 | teapot | 1 | 48755 | 3 | 1.920 | 25393.2 |
229 | 2020-01-22 17:10:20 | teapot | 1 | 48755 | 3 | 0.936 | 52088.7 |
228 | 2020-01-13 21:50:22 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
227 | 2020-01-13 19:57:08 | teapot | 1 | 48755 | 3 | 0.983 | 49598.2 |
226 | 2020-01-10 16:06:13 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
225 | 2020-01-05 04:02:17 | teapot | 1 | 48755 | 3 | 0.736 | 66243.2 |
224 | 2019-12-26 09:49:12 | teapot | 1 | 48755 | 3 | 0.890 | 54780.9 |
223 | 2019-12-26 06:23:41 | teapot | 1 | 48755 | 3 | 0.846 | 57630.0 |
222 | 2019-12-24 15:20:53 | teapot | 1 | 48755 | 3 | 0.830 | 58741.0 |
221 | 2019-12-24 10:28:16 | teapot | 1 | 48755 | 3 | 0.873 | 55847.7 |
220 | 2019-11-10 12:22:28 | teapot | 1 | 48755 | 3 | 0.860 | 56691.9 |
219 | 2019-08-09 05:36:57 | teapot | 1 | 48755 | 3 | 0.800 | 60943.8 |
218 | 2019-06-18 10:56:09 | teapot | 1 | 48755 | 3 | 1.676 | 29090.1 |
217 | 2019-06-16 19:26:52 | teapot | 1 | 48755 | 3 | 0.770 | 63318.2 |
216 | 2019-06-12 00:22:34 | teapot | 1 | 48755 | 3 | 0.743 | 65619.1 |
215 | 2019-05-30 03:49:03 | teapot | 1 | 48755 | 3 | 0.753 | 64747.7 |
214 | 2019-04-29 21:37:57 | teapot | 1 | 48755 | 3 | 0.753 | 64747.7 |
213 | 2019-02-01 23:58:25 | teapot | 1 | 48755 | 3 | 0.770 | 63318.2 |
212 | 2019-01-27 21:42:12 | teapot | 1 | 48755 | 3 | 0.750 | 65006.7 |
211 | 2019-01-11 07:01:30 | teapot | 1 | 48755 | 3 | 0.743 | 65619.1 |
210 | 2019-01-09 09:50:53 | teapot | 1 | 48755 | 3 | 0.810 | 60191.4 |
209 | 2019-01-09 09:46:46 | teapot | 1 | 48755 | 3 | 0.786 | 62029.3 |
208 | 2019-01-07 11:34:22 | teapot | 1 | 48755 | 3 | 0.730 | 66787.7 |
207 | 2019-01-07 10:50:25 | teapot | 1 | 48755 | 3 | 1.663 | 29317.5 |