History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yesteryear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
243 | 2025-10-01 14:21:03 | yesteryear | 1 | 67641 | 2 | 1.016 | 66575.8 |
242 | 2025-09-10 01:05:46 | yesteryear | 1 | 67641 | 2 | 1.093 | 61885.6 |
241 | 2025-08-05 06:45:28 | yesteryear | 1 | 67641 | 2 | 2.576 | 26258.2 |
240 | 2025-07-25 04:39:11 | yesteryear | 1 | 67641 | 2 | 2.843 | 23792.1 |
239 | 2025-07-25 03:55:11 | yesteryear | 1 | 67641 | 2 | 2.236 | 30250.9 |
238 | 2025-07-24 19:52:07 | yesteryear | 1 | 67641 | 2 | 2.406 | 28113.5 |
237 | 2025-07-19 12:28:30 | yesteryear | 1 | 67641 | 2 | 1.093 | 61885.6 |
236 | 2025-05-31 19:47:37 | yesteryear | 1 | 67641 | 2 | 5.733 | 11798.5 |
235 | 2025-05-15 01:38:57 | yesteryear | 1 | 67641 | 2 | 1.123 | 60232.4 |
234 | 2025-05-11 01:39:30 | yesteryear | 1 | 67641 | 2 | 2.936 | 23038.5 |
233 | 2025-05-10 04:37:49 | yesteryear | 1 | 67641 | 2 | 5.436 | 12443.2 |
232 | 2025-03-14 05:58:33 | yesteryear | 3 | 140603 | 6 | 34.860 | 4033.4 |
231 | 2025-02-24 05:55:47 | yesteryear | 3 | 140603 | 6 | 39.786 | 3534.0 |
230 | 2025-02-21 14:58:28 | yesteryear | 4 | 161450 | 42 | 53.583 | 3013.1 |
229 | 2025-02-21 14:58:06 | yesteryear | 4 | 161450 | 42 | 66.893 | 2413.6 |
228 | 2025-02-21 14:58:17 | yesteryear | 2 | 108824 | 2 | 13.783 | 7895.5 |
227 | 2025-02-21 14:52:41 | yesteryear | 1 | 67641 | 2 | 6.140 | 11016.4 |
226 | 2025-02-15 13:44:39 | yesteryear | 3 | 140603 | 6 | 28.173 | 4990.7 |
225 | 2025-02-15 13:44:34 | yesteryear | 3 | 140603 | 6 | 24.863 | 5655.1 |
224 | 2025-02-15 13:44:28 | yesteryear | 2 | 108824 | 2 | 11.750 | 9261.6 |
223 | 2025-02-15 13:43:57 | yesteryear | 1 | 67641 | 2 | 5.720 | 11825.3 |
222 | 2025-02-02 08:55:14 | yesteryear | 2 | 108824 | 2 | 15.263 | 7129.9 |
221 | 2025-02-02 08:54:37 | yesteryear | 3 | 140603 | 6 | 30.733 | 4575.0 |
220 | 2025-02-02 08:53:54 | yesteryear | 3 | 140603 | 6 | 43.446 | 3236.3 |
219 | 2025-02-02 08:52:18 | yesteryear | 1 | 67641 | 2 | 4.966 | 13620.8 |
218 | 2025-01-31 00:14:46 | yesteryear | 3 | 140603 | 6 | 40.283 | 3490.4 |
217 | 2025-01-22 16:40:45 | yesteryear | 3 | 140603 | 6 | 22.343 | 6292.9 |
216 | 2025-01-19 06:17:53 | yesteryear | 3 | 140603 | 6 | 44.716 | 3144.4 |
215 | 2025-01-19 06:17:55 | yesteryear | 2 | 108824 | 2 | 14.313 | 7603.2 |
214 | 2025-01-19 06:15:51 | yesteryear | 1 | 67641 | 2 | 3.843 | 17601.1 |
213 | 2025-01-09 07:29:42 | yesteryear | 1 | 67641 | 2 | 7.890 | 8573.0 |
212 | 2024-12-26 07:10:08 | yesteryear | 1 | 67641 | 2 | 0.983 | 68810.8 |
211 | 2024-12-12 03:01:57 | yesteryear | 3 | 140603 | 6 | 35.330 | 3979.7 |
210 | 2024-12-12 03:02:11 | yesteryear | 2 | 108824 | 2 | 15.796 | 6889.3 |
209 | 2024-12-12 03:01:49 | yesteryear | 3 | 140603 | 6 | 32.816 | 4284.6 |
208 | 2024-12-12 02:56:51 | yesteryear | 1 | 67641 | 2 | 6.436 | 10509.8 |
207 | 2024-11-30 23:02:52 | yesteryear | 2 | 108824 | 2 | 15.190 | 7164.2 |
206 | 2024-11-30 23:01:00 | yesteryear | 1 | 67641 | 2 | 1.126 | 60071.9 |
205 | 2024-11-18 22:12:45 | yesteryear | 3 | 140603 | 6 | 31.970 | 4398.0 |
204 | 2024-11-16 16:08:10 | yesteryear | 3 | 140603 | 6 | 45.126 | 3115.8 |
203 | 2024-11-16 16:08:14 | yesteryear | 3 | 140603 | 6 | 30.016 | 4684.3 |
202 | 2024-11-16 16:08:16 | yesteryear | 2 | 108824 | 2 | 14.500 | 7505.1 |
201 | 2024-11-16 16:08:06 | yesteryear | 3 | 140603 | 6 | 19.500 | 7210.4 |
200 | 2024-11-15 10:09:02 | yesteryear | 3 | 140603 | 6 | 29.500 | 4766.2 |
199 | 2024-11-14 08:44:50 | yesteryear | 1 | 67641 | 2 | 2.830 | 23901.4 |
198 | 2024-11-09 21:28:00 | yesteryear | 3 | 140603 | 6 | 25.113 | 5598.8 |
197 | 2024-11-08 06:47:24 | yesteryear | 1 | 67641 | 2 | 7.093 | 9536.3 |
196 | 2024-11-03 12:35:47 | yesteryear | 3 | 140603 | 6 | 35.483 | 3962.5 |
195 | 2024-11-03 07:49:25 | yesteryear | 3 | 140603 | 6 | 49.076 | 2865.0 |
194 | 2024-11-03 07:49:25 | yesteryear | 2 | 108824 | 2 | 22.343 | 4870.6 |
193 | 2024-11-03 07:47:57 | yesteryear | 1 | 67641 | 2 | 5.500 | 12298.4 |
192 | 2024-10-26 11:36:00 | yesteryear | 2 | 108824 | 2 | 23.233 | 4684.0 |
191 | 2024-10-26 11:32:12 | yesteryear | 1 | 67641 | 2 | 3.516 | 19238.1 |
190 | 2024-10-26 00:00:20 | yesteryear | 1 | 67641 | 2 | 4.466 | 15145.8 |
189 | 2024-10-22 07:46:03 | yesteryear | 3 | 140603 | 6 | 36.486 | 3853.6 |
188 | 2024-10-22 07:45:38 | yesteryear | 3 | 140603 | 6 | 35.876 | 3919.1 |
187 | 2024-10-13 15:47:26 | yesteryear | 3 | 140603 | 6 | 31.126 | 4517.2 |
186 | 2024-10-13 07:08:07 | yesteryear | 3 | 140603 | 6 | 41.640 | 3376.6 |
185 | 2024-10-08 08:02:03 | yesteryear | 3 | 140603 | 6 | 37.396 | 3759.8 |
184 | 2024-10-03 04:42:22 | yesteryear | 1 | 67641 | 2 | 10.156 | 6660.2 |
183 | 2024-10-02 17:01:40 | yesteryear | 3 | 140603 | 6 | 50.236 | 2798.8 |
182 | 2024-10-02 10:32:18 | yesteryear | 3 | 140603 | 6 | 50.143 | 2804.0 |
181 | 2024-10-02 00:14:31 | yesteryear | 2 | 108824 | 2 | 24.376 | 4464.4 |
180 | 2024-10-01 22:19:27 | yesteryear | 2 | 108824 | 2 | 34.733 | 3133.2 |
179 | 2024-10-01 22:03:20 | yesteryear | 5 | 173545 | 439 | 100.740 | 1722.7 |
178 | 2024-10-01 22:03:20 | yesteryear | 4 | 161450 | 42 | 87.240 | 1850.6 |
177 | 2024-10-01 22:03:28 | yesteryear | 3 | 140603 | 6 | 49.406 | 2845.9 |
176 | 2024-10-01 22:03:29 | yesteryear | 2 | 108824 | 2 | 29.673 | 3667.4 |
175 | 2024-10-01 21:58:37 | yesteryear | 1 | 67641 | 2 | 4.160 | 16259.9 |
174 | 2024-09-12 10:42:14 | yesteryear | 3 | 140603 | 6 | 70.693 | 1988.9 |
173 | 2024-09-09 22:30:09 | yesteryear | 1 | 67641 | 2 | 7.546 | 8963.8 |
172 | 2024-08-15 02:24:17 | yesteryear | 3 | 140603 | 6 | 71.610 | 1963.5 |
171 | 2024-08-15 00:43:01 | yesteryear | 1 | 67641 | 2 | 10.733 | 6302.2 |
170 | 2024-08-11 15:37:18 | yesteryear | 4 | 161450 | 42 | 28.566 | 5651.8 |
169 | 2024-08-09 19:14:33 | yesteryear | 4 | 161450 | 42 | 52.410 | 3080.5 |
168 | 2024-08-09 19:14:25 | yesteryear | 4 | 161450 | 42 | 55.733 | 2896.8 |
167 | 2024-08-09 19:14:29 | yesteryear | 3 | 140603 | 6 | 29.146 | 4824.1 |
166 | 2024-08-09 19:14:26 | yesteryear | 2 | 108824 | 2 | 5.953 | 18280.5 |
165 | 2024-08-09 19:11:42 | yesteryear | 1 | 67641 | 2 | 4.626 | 14621.9 |
164 | 2024-07-30 04:20:58 | yesteryear | 1 | 67641 | 2 | 7.156 | 9452.3 |
163 | 2024-07-19 16:51:41 | yesteryear | 4 | 161450 | 42 | 55.566 | 2905.6 |
162 | 2024-07-19 00:31:00 | yesteryear | 4 | 161450 | 42 | 60.300 | 2677.4 |
161 | 2024-07-17 16:04:33 | yesteryear | 1 | 67641 | 2 | 2.000 | 33820.5 |
160 | 2024-07-17 08:16:56 | yesteryear | 4 | 161450 | 42 | 48.220 | 3348.2 |
159 | 2024-07-14 18:45:24 | yesteryear | 4 | 161450 | 42 | 79.270 | 2036.7 |
158 | 2024-07-10 06:07:32 | yesteryear | 1 | 67641 | 2 | 7.500 | 9018.8 |
157 | 2024-07-06 01:00:04 | yesteryear | 4 | 161450 | 42 | 62.113 | 2599.3 |
156 | 2024-07-04 23:22:33 | yesteryear | 3 | 140603 | 6 | 25.593 | 5493.8 |
155 | 2024-07-04 23:22:38 | yesteryear | 2 | 108824 | 2 | 15.483 | 7028.6 |
154 | 2024-07-04 23:22:12 | yesteryear | 4 | 161450 | 42 | 27.750 | 5818.0 |
153 | 2024-07-04 23:20:57 | yesteryear | 1 | 67641 | 2 | 2.296 | 29460.4 |
152 | 2024-06-13 12:31:58 | yesteryear | 1 | 67641 | 2 | 2.173 | 31127.9 |
151 | 2024-06-09 23:59:18 | yesteryear | 1 | 67641 | 2 | 2.063 | 32787.7 |
150 | 2024-05-25 22:32:38 | yesteryear | 3 | 140603 | 6 | 19.613 | 7168.9 |
149 | 2024-05-25 22:32:45 | yesteryear | 2 | 108824 | 2 | 6.203 | 17543.8 |
148 | 2024-05-25 22:30:48 | yesteryear | 1 | 67641 | 2 | 4.080 | 16578.7 |
147 | 2024-05-24 19:00:44 | yesteryear | 4 | 161450 | 42 | 35.130 | 4595.8 |
146 | 2024-05-22 12:41:38 | yesteryear | 4 | 161450 | 42 | 34.393 | 4694.3 |
145 | 2024-05-19 17:11:41 | yesteryear | 3 | 140603 | 6 | 22.470 | 6257.4 |
144 | 2024-05-19 17:11:44 | yesteryear | 2 | 108824 | 2 | 7.906 | 13764.7 |