History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chrysolite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
261 | 2024-04-01 15:58:10 | chrysolite | 2 | 108824 | 4 | 12.440 | 8747.9 |
260 | 2024-04-01 11:02:12 | chrysolite | 1 | 67641 | 2 | 3.186 | 21230.7 |
259 | 2024-03-30 22:41:29 | chrysolite | 1 | 67641 | 2 | 1.186 | 57032.9 |
258 | 2024-03-25 11:43:35 | chrysolite | 1 | 67641 | 2 | 1.093 | 61885.6 |
257 | 2024-03-24 13:23:58 | chrysolite | 4 | 161450 | 63 | 15.220 | 10607.8 |
256 | 2024-03-23 11:11:21 | chrysolite | 4 | 161450 | 63 | 27.373 | 5898.1 |
255 | 2024-03-22 08:28:27 | chrysolite | 4 | 161450 | 63 | 41.236 | 3915.3 |
254 | 2024-03-22 08:28:32 | chrysolite | 3 | 140603 | 15 | 23.343 | 6023.3 |
253 | 2024-03-21 23:58:33 | chrysolite | 4 | 161450 | 63 | 36.066 | 4476.5 |
252 | 2024-03-21 23:58:46 | chrysolite | 3 | 140603 | 15 | 7.686 | 18293.4 |
251 | 2024-03-21 23:58:37 | chrysolite | 2 | 108824 | 4 | 10.643 | 10224.9 |
250 | 2024-03-21 22:39:35 | chrysolite | 1 | 67641 | 2 | 2.406 | 28113.5 |
249 | 2024-03-19 10:54:43 | chrysolite | 3 | 140603 | 15 | 24.343 | 5775.9 |
248 | 2024-03-17 15:40:55 | chrysolite | 3 | 140603 | 15 | 5.283 | 26614.2 |
247 | 2024-03-14 22:46:58 | chrysolite | 5 | 173545 | 442 | 52.533 | 3303.5 |
246 | 2024-03-11 21:23:50 | chrysolite | 5 | 173545 | 442 | 60.146 | 2885.4 |
245 | 2024-03-11 19:09:32 | chrysolite | 5 | 173545 | 442 | 35.753 | 4854.0 |
244 | 2024-02-28 11:12:00 | chrysolite | 1 | 67641 | 2 | 0.986 | 68601.4 |
243 | 2024-02-09 17:10:04 | chrysolite | 1 | 67641 | 2 | 1.016 | 66575.8 |
242 | 2024-01-30 05:58:19 | chrysolite | 4 | 161450 | 63 | 11.720 | 13775.6 |
241 | 2024-01-29 03:34:19 | chrysolite | 1 | 67641 | 2 | 1.063 | 63632.2 |
240 | 2024-01-19 09:11:12 | chrysolite | 1 | 67641 | 2 | 1.143 | 59178.5 |
239 | 2024-01-08 15:35:03 | chrysolite | 5 | 173545 | 442 | 17.610 | 9854.9 |
238 | 2024-01-06 00:44:17 | chrysolite | 2 | 108824 | 4 | 3.046 | 35726.9 |
237 | 2024-01-04 20:45:30 | chrysolite | 2 | 108824 | 4 | 2.966 | 36690.5 |
236 | 2024-01-04 20:45:27 | chrysolite | 3 | 140603 | 15 | 5.873 | 23940.6 |
235 | 2024-01-02 21:36:53 | chrysolite | 1 | 67641 | 2 | 1.140 | 59334.2 |
234 | 2023-12-07 15:01:50 | chrysolite | 4 | 161450 | 63 | 11.236 | 14369.0 |
233 | 2023-12-04 19:33:14 | chrysolite | 2 | 108824 | 4 | 3.016 | 36082.2 |
232 | 2023-12-01 22:15:16 | chrysolite | 3 | 140603 | 15 | 5.486 | 25629.4 |
231 | 2023-11-15 10:12:02 | chrysolite | 1 | 67641 | 2 | 1.060 | 63812.3 |
230 | 2023-11-15 02:31:53 | chrysolite | 1 | 67641 | 2 | 1.013 | 66773.0 |
229 | 2023-11-15 01:57:39 | chrysolite | 5 | 173545 | 442 | 39.233 | 4423.4 |
228 | 2023-11-15 01:57:15 | chrysolite | 4 | 161450 | 63 | 13.406 | 12043.1 |
227 | 2023-11-08 14:39:40 | chrysolite | 4 | 161450 | 63 | 9.330 | 17304.4 |
226 | 2023-11-08 14:39:29 | chrysolite | 4 | 161450 | 63 | 9.033 | 17873.4 |
225 | 2023-11-07 10:52:17 | chrysolite | 4 | 161450 | 63 | 37.690 | 4283.6 |
224 | 2023-11-07 10:51:59 | chrysolite | 4 | 161450 | 63 | 30.203 | 5345.5 |
223 | 2023-11-06 19:06:06 | chrysolite | 4 | 161450 | 63 | 9.906 | 16298.2 |
222 | 2023-10-31 00:44:46 | chrysolite | 1 | 67641 | 2 | 1.030 | 65670.9 |
221 | 2023-09-12 03:51:21 | chrysolite | 5 | 173545 | 442 | 22.266 | 7794.2 |
220 | 2023-09-03 07:41:05 | chrysolite | 1 | 67641 | 2 | 1.060 | 63812.3 |
219 | 2023-09-02 00:50:53 | chrysolite | 2 | 108824 | 4 | 2.970 | 36641.1 |
218 | 2023-08-31 16:10:11 | chrysolite | 3 | 140603 | 15 | 5.266 | 26700.2 |
217 | 2023-08-13 22:44:50 | chrysolite | 4 | 161450 | 63 | 10.173 | 15870.4 |
216 | 2023-08-12 23:08:55 | chrysolite | 5 | 173545 | 442 | 16.343 | 10618.9 |
215 | 2023-05-20 05:56:35 | chrysolite | 2 | 108824 | 4 | 2.546 | 42743.1 |
214 | 2023-05-16 23:00:36 | chrysolite | 3 | 140603 | 15 | 5.940 | 23670.5 |
213 | 2023-04-23 12:14:07 | chrysolite | 5 | 173545 | 442 | 14.373 | 12074.4 |
212 | 2023-04-20 08:37:12 | chrysolite | 4 | 161450 | 63 | 9.093 | 17755.4 |
211 | 2023-03-01 04:44:54 | chrysolite | 2 | 108824 | 4 | 5.686 | 19138.9 |
210 | 2023-02-25 08:42:04 | chrysolite | 1 | 67641 | 2 | 0.986 | 68601.4 |
209 | 2023-02-24 20:02:23 | chrysolite | 3 | 140603 | 15 | 5.170 | 27195.9 |
208 | 2023-01-26 22:36:42 | chrysolite | 5 | 173545 | 442 | 16.160 | 10739.2 |
207 | 2023-01-22 15:30:55 | chrysolite | 4 | 161450 | 63 | 9.063 | 17814.2 |
206 | 2022-12-25 00:56:37 | chrysolite | 1 | 67641 | 2 | 0.970 | 69733.0 |
205 | 2022-12-13 17:34:43 | chrysolite | 5 | 173545 | 442 | 19.546 | 8878.8 |
204 | 2022-12-09 08:46:40 | chrysolite | 2 | 108824 | 4 | 2.563 | 42459.6 |
203 | 2022-12-08 16:33:08 | chrysolite | 3 | 140603 | 15 | 5.280 | 26629.4 |
202 | 2022-11-07 23:19:07 | chrysolite | 5 | 173545 | 442 | 14.360 | 12085.3 |
201 | 2022-11-03 10:35:44 | chrysolite | 4 | 161450 | 63 | 9.296 | 17367.7 |
200 | 2022-09-10 16:18:21 | chrysolite | 1 | 67641 | 2 | 1.000 | 67641.0 |
199 | 2022-07-22 20:38:55 | chrysolite | 3 | 140603 | 15 | 5.296 | 26548.9 |
198 | 2022-07-16 18:40:04 | chrysolite | 2 | 108824 | 4 | 2.596 | 41919.9 |
197 | 2022-05-20 05:01:56 | chrysolite | 5 | 173545 | 442 | 15.923 | 10899.0 |
196 | 2022-05-15 09:48:36 | chrysolite | 4 | 161450 | 63 | 10.093 | 15996.2 |
195 | 2022-04-26 08:53:18 | chrysolite | 1 | 67641 | 2 | 1.203 | 56226.9 |
194 | 2022-04-24 03:14:46 | chrysolite | 1 | 67641 | 2 | 1.140 | 59334.2 |
193 | 2022-03-20 01:13:41 | chrysolite | 3 | 140603 | 15 | 5.360 | 26231.9 |
192 | 2022-03-09 23:58:00 | chrysolite | 2 | 108824 | 4 | 3.063 | 35528.6 |
191 | 2022-01-15 11:56:30 | chrysolite | 1 | 67641 | 2 | 2.436 | 27767.2 |
190 | 2022-01-13 08:34:26 | chrysolite | 1 | 67641 | 2 | 1.000 | 67641.0 |
189 | 2021-11-21 15:40:10 | chrysolite | 1 | 67641 | 2 | 1.153 | 58665.2 |
188 | 2021-05-08 10:13:18 | chrysolite | 1 | 67641 | 2 | 1.313 | 51516.4 |
187 | 2021-04-06 21:13:21 | chrysolite | 1 | 67641 | 2 | 1.093 | 61885.6 |
186 | 2021-02-14 18:56:33 | chrysolite | 1 | 67641 | 2 | 1.013 | 66773.0 |
185 | 2020-10-31 06:10:38 | chrysolite | 1 | 67641 | 2 | 1.156 | 58513.0 |
184 | 2020-03-26 01:23:06 | chrysolite | 1 | 67641 | 2 | 1.406 | 48108.8 |
183 | 2020-03-16 14:43:08 | chrysolite | 1 | 67641 | 2 | 1.000 | 67641.0 |
182 | 2020-03-13 19:37:40 | chrysolite | 1 | 67641 | 2 | 1.033 | 65480.2 |
181 | 2020-03-01 04:55:54 | chrysolite | 1 | 67641 | 2 | 1.143 | 59178.5 |
180 | 2020-02-27 16:46:40 | chrysolite | 5 | 173545 | 442 | 46.876 | 3702.2 |
179 | 2020-02-24 12:55:10 | chrysolite | 1 | 67641 | 2 | 1.156 | 58513.0 |
178 | 2020-02-17 23:55:07 | chrysolite | 1 | 67641 | 2 | 1.953 | 34634.4 |
177 | 2020-02-12 10:16:56 | chrysolite | 5 | 173545 | 442 | 34.393 | 5045.9 |
176 | 2020-02-12 10:00:33 | chrysolite | 5 | 173545 | 442 | 33.423 | 5192.4 |
175 | 2020-02-12 00:29:24 | chrysolite | 5 | 173545 | 442 | 21.580 | 8041.9 |
174 | 2020-02-11 21:35:39 | chrysolite | 5 | 173545 | 442 | 20.830 | 8331.5 |
173 | 2020-02-11 13:24:24 | chrysolite | 5 | 173545 | 442 | 37.723 | 4600.5 |
172 | 2020-02-11 02:31:39 | chrysolite | 1 | 67641 | 2 | 1.643 | 41169.2 |
171 | 2020-02-09 23:17:33 | chrysolite | 1 | 67641 | 2 | 1.220 | 55443.4 |
170 | 2020-01-25 03:28:51 | chrysolite | 1 | 67641 | 2 | 1.186 | 57032.9 |
169 | 2020-01-18 06:39:06 | chrysolite | 1 | 67641 | 2 | 2.686 | 25182.8 |
168 | 2020-01-15 09:50:04 | chrysolite | 5 | 173545 | 442 | 19.923 | 8710.8 |
167 | 2020-01-15 08:31:25 | chrysolite | 5 | 173545 | 442 | 17.110 | 10142.9 |
166 | 2020-01-15 02:24:16 | chrysolite | 5 | 173545 | 442 | 21.566 | 8047.2 |
165 | 2020-01-11 19:11:48 | chrysolite | 1 | 67641 | 2 | 1.110 | 60937.8 |
164 | 2020-01-02 13:38:14 | chrysolite | 1 | 67641 | 2 | 1.156 | 58513.0 |
163 | 2019-11-29 07:49:15 | chrysolite | 1 | 67641 | 2 | 1.013 | 66773.0 |
162 | 2019-11-26 07:53:22 | chrysolite | 5 | 173545 | 442 | 15.846 | 10952.0 |