History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"moonfish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
271 | 2024-04-16 11:44:44 | moonfish | 2 | 121059 | 10 | 4.953 | 24441.6 |
270 | 2024-04-16 11:42:48 | moonfish | 1 | 82945 | 2 | 1.376 | 60279.8 |
269 | 2024-04-09 20:26:40 | moonfish | 2 | 121059 | 10 | 3.703 | 32692.1 |
268 | 2024-04-09 00:10:44 | moonfish | 2 | 121059 | 10 | 3.300 | 36684.5 |
267 | 2024-04-09 00:10:26 | moonfish | 3 | 146162 | 85 | 8.610 | 16975.8 |
266 | 2024-04-06 06:22:11 | moonfish | 4 | 161609 | 506 | 41.766 | 3869.4 |
265 | 2024-04-05 20:02:23 | moonfish | 3 | 146162 | 85 | 7.876 | 18557.9 |
264 | 2024-04-05 20:02:24 | moonfish | 2 | 121059 | 10 | 3.830 | 31608.1 |
263 | 2024-04-05 20:02:21 | moonfish | 1 | 82945 | 2 | 1.423 | 58288.8 |
262 | 2024-04-05 17:55:43 | moonfish | 4 | 161609 | 506 | 14.000 | 11543.5 |
261 | 2024-04-01 14:39:53 | moonfish | 1 | 82945 | 2 | 2.403 | 34517.3 |
260 | 2024-04-01 14:39:15 | moonfish | 2 | 121059 | 10 | 9.750 | 12416.3 |
259 | 2024-03-31 21:57:11 | moonfish | 4 | 161609 | 506 | 29.500 | 5478.3 |
258 | 2024-03-31 18:36:23 | moonfish | 1 | 82945 | 2 | 3.233 | 25655.7 |
257 | 2024-03-31 05:19:42 | moonfish | 4 | 161609 | 506 | 37.143 | 4351.0 |
256 | 2024-03-31 02:13:14 | moonfish | 4 | 161609 | 506 | 22.796 | 7089.4 |
255 | 2024-03-30 20:32:28 | moonfish | 4 | 161609 | 506 | 31.283 | 5166.0 |
254 | 2024-03-16 01:43:37 | moonfish | 2 | 121059 | 10 | 8.313 | 14562.6 |
253 | 2024-03-16 01:43:15 | moonfish | 1 | 82945 | 2 | 2.766 | 29987.3 |
252 | 2024-03-13 22:56:15 | moonfish | 3 | 146162 | 85 | 11.376 | 12848.3 |
251 | 2024-03-12 08:01:20 | moonfish | 4 | 161609 | 506 | 25.503 | 6336.9 |
250 | 2024-03-11 00:00:39 | moonfish | 1 | 82945 | 2 | 2.470 | 33581.0 |
249 | 2024-03-07 19:20:42 | moonfish | 3 | 146162 | 85 | 18.860 | 7749.8 |
248 | 2024-03-07 02:28:22 | moonfish | 4 | 161609 | 506 | 24.423 | 6617.1 |
247 | 2024-03-06 10:13:14 | moonfish | 3 | 146162 | 85 | 14.550 | 10045.5 |
246 | 2024-03-06 10:12:57 | moonfish | 3 | 146162 | 85 | 31.343 | 4663.3 |
245 | 2024-03-06 10:13:17 | moonfish | 2 | 121059 | 10 | 8.610 | 14060.3 |
244 | 2024-03-06 10:13:11 | moonfish | 1 | 82945 | 2 | 1.610 | 51518.6 |
243 | 2024-03-06 10:12:57 | moonfish | 2 | 121059 | 10 | 7.610 | 15907.9 |
242 | 2024-03-06 10:12:50 | moonfish | 1 | 82945 | 2 | 1.690 | 49079.9 |
241 | 2024-03-06 10:11:19 | moonfish | 4 | 161609 | 506 | 44.533 | 3629.0 |
240 | 2024-03-01 19:07:49 | moonfish | 1 | 82945 | 2 | 2.550 | 32527.5 |
239 | 2024-03-01 16:27:09 | moonfish | 4 | 161609 | 506 | 36.456 | 4433.0 |
238 | 2024-02-27 06:33:05 | moonfish | 4 | 161609 | 506 | 13.720 | 11779.1 |
237 | 2024-02-26 12:55:45 | moonfish | 4 | 161609 | 506 | 21.906 | 7377.4 |
236 | 2024-02-04 17:16:53 | moonfish | 4 | 161609 | 506 | 26.733 | 6045.3 |
235 | 2024-02-01 21:44:16 | moonfish | 1 | 82945 | 2 | 1.250 | 66356.0 |
234 | 2024-01-29 23:22:51 | moonfish | 1 | 82945 | 2 | 1.453 | 57085.3 |
233 | 2024-01-27 13:14:31 | moonfish | 4 | 161609 | 506 | 12.486 | 12943.2 |
232 | 2024-01-27 10:59:39 | moonfish | 4 | 161609 | 506 | 12.093 | 13363.8 |
231 | 2024-01-27 10:58:33 | moonfish | 4 | 161609 | 506 | 19.593 | 8248.3 |
230 | 2024-01-13 06:05:46 | moonfish | 1 | 82945 | 2 | 1.436 | 57761.1 |
229 | 2024-01-02 19:30:13 | moonfish | 4 | 161609 | 506 | 11.770 | 13730.6 |
228 | 2024-01-02 19:30:20 | moonfish | 2 | 121059 | 10 | 3.813 | 31749.0 |
227 | 2024-01-02 19:30:16 | moonfish | 3 | 146162 | 85 | 7.253 | 20151.9 |
226 | 2023-11-25 12:13:54 | moonfish | 4 | 161609 | 506 | 10.530 | 15347.5 |
225 | 2023-11-19 00:04:29 | moonfish | 1 | 82945 | 2 | 1.436 | 57761.1 |
224 | 2023-11-14 08:37:19 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
223 | 2023-11-09 11:50:54 | moonfish | 1 | 82945 | 2 | 1.296 | 64000.8 |
222 | 2023-11-03 23:16:46 | moonfish | 1 | 82945 | 2 | 1.280 | 64800.8 |
221 | 2023-10-22 21:17:13 | moonfish | 1 | 82945 | 2 | 1.796 | 46183.2 |
220 | 2023-10-19 02:36:35 | moonfish | 1 | 82945 | 2 | 1.546 | 53651.4 |
219 | 2023-10-14 05:54:16 | moonfish | 1 | 82945 | 2 | 1.393 | 59544.1 |
218 | 2023-10-10 23:41:08 | moonfish | 1 | 82945 | 2 | 1.610 | 51518.6 |
217 | 2023-09-11 04:52:14 | moonfish | 1 | 82945 | 2 | 1.283 | 64649.3 |
216 | 2023-08-29 18:06:15 | moonfish | 1 | 82945 | 2 | 1.406 | 58993.6 |
215 | 2023-08-26 14:59:09 | moonfish | 4 | 161609 | 506 | 10.470 | 15435.4 |
214 | 2023-08-12 06:55:34 | moonfish | 4 | 161609 | 506 | 12.140 | 13312.1 |
213 | 2023-06-04 06:52:14 | moonfish | 1 | 82945 | 2 | 1.346 | 61623.3 |
212 | 2023-06-01 22:30:34 | moonfish | 1 | 82945 | 2 | 1.360 | 60989.0 |
211 | 2023-05-06 12:35:28 | moonfish | 4 | 161609 | 506 | 11.796 | 13700.3 |
210 | 2023-03-25 13:51:11 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
209 | 2023-02-12 12:30:08 | moonfish | 4 | 161609 | 506 | 10.283 | 15716.1 |
208 | 2023-02-05 15:56:23 | moonfish | 4 | 161609 | 506 | 10.593 | 15256.2 |
207 | 2023-02-05 07:58:43 | moonfish | 1 | 82945 | 2 | 1.360 | 60989.0 |
206 | 2023-01-10 00:27:26 | moonfish | 1 | 82945 | 2 | 1.250 | 66356.0 |
205 | 2022-11-22 22:56:17 | moonfish | 4 | 161609 | 506 | 10.453 | 15460.5 |
204 | 2022-10-15 08:50:00 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
203 | 2022-10-07 20:25:59 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
202 | 2022-06-05 21:53:44 | moonfish | 1 | 82945 | 2 | 1.296 | 64000.8 |
201 | 2022-06-03 16:28:41 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
200 | 2022-05-30 22:46:36 | moonfish | 1 | 82945 | 2 | 1.296 | 64000.8 |
199 | 2022-05-03 17:16:23 | moonfish | 4 | 161609 | 506 | 12.156 | 13294.6 |
198 | 2022-04-30 18:06:45 | moonfish | 4 | 161609 | 506 | 10.236 | 15788.3 |
197 | 2022-02-07 01:50:10 | moonfish | 1 | 82945 | 2 | 1.406 | 58993.6 |
196 | 2022-01-26 08:44:22 | moonfish | 1 | 82945 | 2 | 2.720 | 30494.5 |
195 | 2021-12-19 17:28:08 | moonfish | 1 | 82945 | 2 | 1.453 | 57085.3 |
194 | 2021-12-17 15:07:29 | moonfish | 1 | 82945 | 2 | 1.390 | 59672.7 |
193 | 2021-11-20 06:32:04 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
192 | 2021-10-03 09:49:06 | moonfish | 1 | 82945 | 2 | 2.533 | 32745.8 |
191 | 2021-06-30 18:58:15 | moonfish | 1 | 82945 | 2 | 1.266 | 65517.4 |
190 | 2021-05-28 08:51:35 | moonfish | 4 | 161609 | 506 | 12.720 | 12705.1 |
189 | 2021-04-24 12:35:56 | moonfish | 1 | 82945 | 2 | 2.906 | 28542.7 |
188 | 2021-04-23 22:11:51 | moonfish | 4 | 161609 | 506 | 19.063 | 8477.6 |
187 | 2021-04-03 22:25:21 | moonfish | 3 | 146162 | 85 | 6.186 | 23627.9 |
186 | 2021-03-30 17:11:57 | moonfish | 1 | 82945 | 2 | 1.423 | 58288.8 |
185 | 2021-03-15 22:50:37 | moonfish | 1 | 82945 | 2 | 1.546 | 53651.4 |
184 | 2021-03-09 17:30:25 | moonfish | 4 | 161609 | 506 | 10.673 | 15141.9 |
183 | 2021-02-12 06:47:40 | moonfish | 3 | 146162 | 85 | 6.936 | 21073.0 |
182 | 2021-01-09 18:08:49 | moonfish | 1 | 82945 | 2 | 1.283 | 64649.3 |
181 | 2020-12-21 11:48:26 | moonfish | 4 | 161609 | 506 | 10.846 | 14900.3 |
180 | 2020-12-21 09:18:13 | moonfish | 4 | 161609 | 506 | 17.343 | 9318.4 |
179 | 2020-12-19 19:18:38 | moonfish | 3 | 146162 | 85 | 6.170 | 23689.1 |
178 | 2020-12-19 03:23:49 | moonfish | 1 | 82945 | 2 | 1.423 | 58288.8 |
177 | 2020-12-11 23:18:00 | moonfish | 4 | 161609 | 506 | 12.173 | 13276.0 |
176 | 2020-11-17 19:47:54 | moonfish | 1 | 82945 | 2 | 1.550 | 53512.9 |
175 | 2020-11-02 03:17:49 | moonfish | 1 | 82945 | 2 | 1.360 | 60989.0 |
174 | 2020-09-28 03:50:23 | moonfish | 1 | 82945 | 2 | 1.283 | 64649.3 |
173 | 2020-09-14 23:44:18 | moonfish | 1 | 82945 | 2 | 1.233 | 67270.9 |
172 | 2020-07-31 06:04:19 | moonfish | 1 | 82945 | 2 | 1.330 | 62364.7 |