History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crayfish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
256 | 2024-05-01 08:57:08 | crayfish | 4 | 161609 | 505 | 29.846 | 5414.8 |
255 | 2024-04-29 01:39:05 | crayfish | 4 | 161609 | 505 | 13.250 | 12196.9 |
254 | 2024-04-28 10:50:13 | crayfish | 3 | 146162 | 75 | 11.220 | 13026.9 |
253 | 2024-04-28 06:48:06 | crayfish | 4 | 161609 | 505 | 25.296 | 6388.7 |
252 | 2024-04-27 10:31:12 | crayfish | 4 | 161609 | 505 | 40.643 | 3976.3 |
251 | 2024-04-27 09:44:01 | crayfish | 3 | 146162 | 75 | 9.470 | 15434.2 |
250 | 2024-04-26 07:49:45 | crayfish | 4 | 161609 | 505 | 16.936 | 9542.3 |
249 | 2024-04-08 05:32:54 | crayfish | 1 | 82945 | 3 | 5.846 | 14188.3 |
248 | 2024-04-08 04:24:17 | crayfish | 1 | 82945 | 3 | 3.516 | 23590.7 |
247 | 2024-04-08 04:22:04 | crayfish | 2 | 121059 | 13 | 4.470 | 27082.6 |
246 | 2024-04-08 04:21:44 | crayfish | 3 | 146162 | 75 | 10.970 | 13323.8 |
245 | 2024-04-06 15:12:10 | crayfish | 2 | 121059 | 13 | 8.440 | 14343.5 |
244 | 2024-04-06 15:12:08 | crayfish | 3 | 146162 | 75 | 10.750 | 13596.5 |
243 | 2024-04-05 03:23:33 | crayfish | 2 | 121059 | 13 | 13.280 | 9115.9 |
242 | 2024-04-05 03:23:33 | crayfish | 3 | 146162 | 75 | 11.826 | 12359.4 |
241 | 2024-04-05 03:23:25 | crayfish | 1 | 82945 | 3 | 3.156 | 26281.7 |
240 | 2024-03-31 22:30:26 | crayfish | 4 | 161609 | 505 | 15.656 | 10322.5 |
239 | 2024-03-30 12:44:02 | crayfish | 1 | 82945 | 3 | 1.766 | 46967.7 |
238 | 2024-03-30 06:24:15 | crayfish | 3 | 146162 | 75 | 18.326 | 7975.7 |
237 | 2024-03-30 05:44:13 | crayfish | 3 | 146162 | 75 | 11.626 | 12572.0 |
236 | 2024-03-29 11:47:48 | crayfish | 4 | 161609 | 505 | 29.436 | 5490.2 |
235 | 2024-03-29 04:57:31 | crayfish | 4 | 161609 | 505 | 19.686 | 8209.3 |
234 | 2024-03-29 04:09:26 | crayfish | 4 | 161609 | 505 | 28.423 | 5685.9 |
233 | 2024-03-29 04:09:31 | crayfish | 2 | 121059 | 13 | 15.236 | 7945.6 |
232 | 2024-03-29 04:09:24 | crayfish | 3 | 146162 | 75 | 19.110 | 7648.5 |
231 | 2024-03-29 04:09:00 | crayfish | 1 | 82945 | 3 | 3.360 | 24686.0 |
230 | 2024-03-06 23:01:34 | crayfish | 1 | 82945 | 3 | 1.766 | 46967.7 |
229 | 2024-03-05 13:11:52 | crayfish | 2 | 121059 | 13 | 3.643 | 33230.6 |
228 | 2024-03-02 01:42:01 | crayfish | 2 | 121059 | 13 | 4.780 | 25326.2 |
227 | 2024-03-02 01:42:01 | crayfish | 1 | 82945 | 3 | 1.780 | 46598.3 |
226 | 2024-03-01 17:10:04 | crayfish | 4 | 161609 | 505 | 24.910 | 6487.7 |
225 | 2024-03-01 01:24:10 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
224 | 2024-02-29 02:44:59 | crayfish | 3 | 146162 | 75 | 7.686 | 19016.7 |
223 | 2024-02-28 00:43:49 | crayfish | 4 | 161609 | 505 | 22.190 | 7283.0 |
222 | 2024-02-28 00:43:47 | crayfish | 3 | 146162 | 75 | 7.796 | 18748.3 |
221 | 2024-02-28 00:43:46 | crayfish | 2 | 121059 | 13 | 4.060 | 29817.5 |
220 | 2024-02-28 00:43:46 | crayfish | 1 | 82945 | 3 | 2.623 | 31622.2 |
219 | 2024-02-09 20:34:35 | crayfish | 4 | 161609 | 505 | 13.953 | 11582.4 |
218 | 2024-02-09 20:33:37 | crayfish | 3 | 146162 | 75 | 8.063 | 18127.5 |
217 | 2024-02-09 20:32:51 | crayfish | 2 | 121059 | 13 | 4.016 | 30144.2 |
216 | 2024-02-06 12:33:25 | crayfish | 2 | 121059 | 13 | 7.720 | 15681.2 |
215 | 2024-02-03 03:11:21 | crayfish | 2 | 121059 | 13 | 3.550 | 34101.1 |
214 | 2024-01-29 16:04:03 | crayfish | 2 | 121059 | 13 | 3.830 | 31608.1 |
213 | 2024-01-27 16:28:27 | crayfish | 2 | 121059 | 13 | 3.953 | 30624.6 |
212 | 2024-01-27 16:27:31 | crayfish | 3 | 146162 | 75 | 7.906 | 18487.5 |
211 | 2024-01-23 04:36:53 | crayfish | 4 | 161609 | 505 | 14.596 | 11072.1 |
210 | 2024-01-22 18:24:51 | crayfish | 4 | 161609 | 505 | 13.450 | 12015.5 |
209 | 2024-01-19 06:55:36 | crayfish | 4 | 161609 | 505 | 11.123 | 14529.3 |
208 | 2024-01-01 21:56:30 | crayfish | 3 | 146162 | 75 | 7.423 | 19690.4 |
207 | 2023-12-18 17:08:51 | crayfish | 4 | 161609 | 505 | 13.016 | 12416.2 |
206 | 2023-12-12 07:57:24 | crayfish | 4 | 161609 | 505 | 13.253 | 12194.1 |
205 | 2023-12-09 10:41:40 | crayfish | 1 | 82945 | 3 | 1.280 | 64800.8 |
204 | 2023-12-01 19:57:49 | crayfish | 4 | 161609 | 505 | 11.093 | 14568.6 |
203 | 2023-11-26 03:49:44 | crayfish | 1 | 82945 | 3 | 1.343 | 61761.0 |
202 | 2023-11-19 07:32:04 | crayfish | 2 | 121059 | 13 | 3.233 | 37444.8 |
201 | 2023-11-19 07:31:54 | crayfish | 3 | 146162 | 75 | 8.110 | 18022.4 |
200 | 2023-11-19 04:39:22 | crayfish | 4 | 161609 | 505 | 15.140 | 10674.3 |
199 | 2023-11-08 17:49:27 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
198 | 2023-11-08 09:37:28 | crayfish | 1 | 82945 | 3 | 2.796 | 29665.6 |
197 | 2023-11-05 07:04:28 | crayfish | 1 | 82945 | 3 | 1.373 | 60411.5 |
196 | 2023-11-04 12:37:08 | crayfish | 1 | 82945 | 3 | 1.376 | 60279.8 |
195 | 2023-11-01 21:23:38 | crayfish | 1 | 82945 | 3 | 1.563 | 53067.8 |
194 | 2023-10-28 06:26:55 | crayfish | 4 | 161609 | 505 | 12.670 | 12755.2 |
193 | 2023-10-28 06:27:00 | crayfish | 3 | 146162 | 75 | 7.703 | 18974.7 |
192 | 2023-10-28 06:26:58 | crayfish | 2 | 121059 | 13 | 3.876 | 31233.0 |
191 | 2023-10-21 01:36:30 | crayfish | 1 | 82945 | 3 | 1.330 | 62364.7 |
190 | 2023-10-15 12:06:26 | crayfish | 1 | 82945 | 3 | 1.440 | 57600.7 |
189 | 2023-10-07 23:00:57 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
188 | 2023-10-06 09:11:01 | crayfish | 3 | 146162 | 75 | 6.376 | 22923.8 |
187 | 2023-09-28 17:16:56 | crayfish | 4 | 161609 | 505 | 14.013 | 11532.8 |
186 | 2023-09-23 10:38:49 | crayfish | 3 | 146162 | 75 | 10.440 | 14000.2 |
185 | 2023-09-23 10:38:33 | crayfish | 4 | 161609 | 505 | 12.560 | 12867.0 |
184 | 2023-09-23 10:38:38 | crayfish | 2 | 121059 | 13 | 3.720 | 32542.7 |
183 | 2023-09-23 03:20:36 | crayfish | 1 | 82945 | 3 | 1.470 | 56425.2 |
182 | 2023-09-21 14:35:09 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
181 | 2023-09-20 07:05:43 | crayfish | 1 | 82945 | 3 | 1.466 | 56579.1 |
180 | 2023-09-18 22:41:32 | crayfish | 1 | 82945 | 3 | 1.500 | 55296.7 |
179 | 2023-09-18 11:13:05 | crayfish | 1 | 82945 | 3 | 1.500 | 55296.7 |
178 | 2023-09-17 23:08:32 | crayfish | 4 | 161609 | 505 | 11.206 | 14421.6 |
177 | 2023-09-09 07:45:04 | crayfish | 1 | 82945 | 3 | 1.296 | 64000.8 |
176 | 2023-09-07 18:37:29 | crayfish | 1 | 82945 | 3 | 1.483 | 55930.5 |
175 | 2023-08-27 17:35:26 | crayfish | 4 | 161609 | 505 | 12.626 | 12799.7 |
174 | 2023-08-10 07:53:01 | crayfish | 4 | 161609 | 505 | 11.610 | 13919.8 |
173 | 2023-08-09 08:44:24 | crayfish | 4 | 161609 | 505 | 10.500 | 15391.3 |
172 | 2023-08-05 23:02:11 | crayfish | 1 | 82945 | 3 | 1.266 | 65517.4 |
171 | 2023-08-04 02:55:31 | crayfish | 1 | 82945 | 3 | 1.326 | 62552.8 |
170 | 2023-08-02 18:45:18 | crayfish | 1 | 82945 | 3 | 1.326 | 62552.8 |
169 | 2023-08-01 18:29:03 | crayfish | 1 | 82945 | 3 | 1.440 | 57600.7 |
168 | 2023-07-19 03:09:02 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
167 | 2023-07-17 12:08:19 | crayfish | 3 | 146162 | 75 | 7.440 | 19645.4 |
166 | 2023-07-05 21:08:33 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
165 | 2023-06-21 05:57:00 | crayfish | 4 | 161609 | 505 | 11.410 | 14163.8 |
164 | 2023-06-09 10:24:48 | crayfish | 1 | 82945 | 3 | 1.310 | 63316.8 |
163 | 2023-06-08 17:15:27 | crayfish | 1 | 82945 | 3 | 1.313 | 63172.1 |
162 | 2023-05-01 14:04:23 | crayfish | 4 | 161609 | 505 | 10.516 | 15367.9 |
161 | 2023-04-18 11:58:12 | crayfish | 1 | 82945 | 3 | 1.266 | 65517.4 |
160 | 2023-04-02 04:57:50 | crayfish | 4 | 161609 | 505 | 13.063 | 12371.5 |
159 | 2023-04-01 03:38:44 | crayfish | 3 | 146162 | 75 | 6.870 | 21275.4 |
158 | 2023-03-18 15:09:27 | crayfish | 4 | 161609 | 505 | 12.313 | 13125.1 |
157 | 2023-03-11 02:01:57 | crayfish | 4 | 161609 | 505 | 10.373 | 15579.8 |