History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"squalene"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
264 | 2024-05-05 02:33:31 | squalene | 1 | 82945 | 2 | 1.326 | 62552.8 |
263 | 2024-05-03 20:43:41 | squalene | 2 | 121059 | 3 | 4.203 | 28803.0 |
262 | 2024-05-03 19:05:33 | squalene | 3 | 146162 | 54 | 7.173 | 20376.7 |
261 | 2024-05-03 19:03:21 | squalene | 2 | 121059 | 3 | 7.783 | 15554.3 |
260 | 2024-05-03 14:52:51 | squalene | 3 | 146162 | 54 | 6.876 | 21256.8 |
259 | 2024-05-01 22:50:38 | squalene | 3 | 146162 | 54 | 15.080 | 9692.4 |
258 | 2024-05-01 08:49:49 | squalene | 3 | 146162 | 54 | 19.486 | 7500.9 |
257 | 2024-05-01 08:49:48 | squalene | 2 | 121059 | 3 | 10.470 | 11562.5 |
256 | 2024-04-30 23:32:02 | squalene | 1 | 82945 | 2 | 1.483 | 55930.5 |
255 | 2024-04-16 15:35:02 | squalene | 4 | 161609 | 473 | 30.720 | 5260.7 |
254 | 2024-04-13 18:13:12 | squalene | 4 | 161609 | 473 | 29.343 | 5507.6 |
253 | 2024-04-13 14:10:21 | squalene | 4 | 161609 | 473 | 14.423 | 11205.0 |
252 | 2024-04-12 22:02:09 | squalene | 4 | 161609 | 473 | 13.486 | 11983.5 |
251 | 2024-04-12 21:37:01 | squalene | 3 | 146162 | 54 | 19.363 | 7548.5 |
250 | 2024-04-12 21:36:54 | squalene | 4 | 161609 | 473 | 21.173 | 7632.8 |
249 | 2024-04-12 21:37:09 | squalene | 1 | 82945 | 2 | 1.546 | 53651.4 |
248 | 2024-04-12 21:37:05 | squalene | 1 | 82945 | 2 | 1.576 | 52630.1 |
247 | 2024-04-12 21:36:57 | squalene | 2 | 121059 | 3 | 4.720 | 25648.1 |
246 | 2024-03-31 23:11:07 | squalene | 3 | 146162 | 54 | 14.563 | 10036.5 |
245 | 2024-03-31 22:10:46 | squalene | 3 | 146162 | 54 | 7.720 | 18932.9 |
244 | 2024-03-31 22:10:42 | squalene | 2 | 121059 | 3 | 5.250 | 23058.9 |
243 | 2024-03-31 22:10:40 | squalene | 1 | 82945 | 2 | 1.610 | 51518.6 |
242 | 2024-03-20 07:19:20 | squalene | 1 | 82945 | 2 | 2.640 | 31418.6 |
241 | 2024-03-14 09:49:44 | squalene | 4 | 161609 | 473 | 12.483 | 12946.3 |
240 | 2024-03-12 03:56:55 | squalene | 3 | 146162 | 54 | 26.266 | 5564.7 |
239 | 2024-03-11 16:02:30 | squalene | 3 | 146162 | 54 | 12.783 | 11434.1 |
238 | 2024-03-10 17:49:31 | squalene | 4 | 161609 | 473 | 13.236 | 12209.8 |
237 | 2024-03-10 15:21:46 | squalene | 4 | 161609 | 473 | 29.550 | 5469.0 |
236 | 2024-03-09 19:30:07 | squalene | 4 | 161609 | 473 | 15.876 | 10179.5 |
235 | 2024-03-08 23:06:35 | squalene | 1 | 82945 | 2 | 1.533 | 54106.3 |
234 | 2024-03-08 23:06:18 | squalene | 4 | 161609 | 473 | 13.626 | 11860.3 |
233 | 2024-03-08 23:06:13 | squalene | 3 | 146162 | 54 | 7.766 | 18820.8 |
232 | 2024-03-08 23:06:15 | squalene | 2 | 121059 | 3 | 3.860 | 31362.4 |
231 | 2024-03-08 23:06:06 | squalene | 1 | 82945 | 2 | 3.076 | 26965.2 |
230 | 2024-03-07 04:17:47 | squalene | 1 | 82945 | 2 | 4.796 | 17294.6 |
229 | 2024-02-29 20:27:49 | squalene | 1 | 82945 | 2 | 1.546 | 53651.4 |
228 | 2024-02-26 14:20:55 | squalene | 1 | 82945 | 2 | 1.530 | 54212.4 |
227 | 2024-02-05 14:40:20 | squalene | 1 | 82945 | 2 | 1.533 | 54106.3 |
226 | 2024-02-04 09:46:18 | squalene | 4 | 161609 | 473 | 13.000 | 12431.5 |
225 | 2024-01-31 21:08:24 | squalene | 2 | 121059 | 3 | 3.580 | 33815.4 |
224 | 2024-01-31 21:07:08 | squalene | 3 | 146162 | 54 | 7.250 | 20160.3 |
223 | 2024-01-30 17:50:47 | squalene | 2 | 121059 | 3 | 3.546 | 34139.6 |
222 | 2024-01-30 17:50:27 | squalene | 3 | 146162 | 54 | 6.750 | 21653.6 |
221 | 2024-01-29 20:32:19 | squalene | 4 | 161609 | 473 | 20.236 | 7986.2 |
220 | 2024-01-29 17:44:12 | squalene | 3 | 146162 | 54 | 6.733 | 21708.3 |
219 | 2024-01-29 17:43:51 | squalene | 4 | 161609 | 473 | 11.860 | 13626.4 |
218 | 2024-01-29 17:43:47 | squalene | 2 | 121059 | 3 | 3.563 | 33976.7 |
217 | 2024-01-05 15:49:49 | squalene | 1 | 82945 | 2 | 1.390 | 59672.7 |
216 | 2023-12-28 13:06:30 | squalene | 2 | 121059 | 3 | 3.173 | 38152.9 |
215 | 2023-12-18 11:40:26 | squalene | 1 | 82945 | 2 | 1.283 | 64649.3 |
214 | 2023-12-12 09:34:00 | squalene | 1 | 82945 | 2 | 1.313 | 63172.1 |
213 | 2023-12-02 10:08:49 | squalene | 1 | 82945 | 2 | 1.453 | 57085.3 |
212 | 2023-10-17 18:45:11 | squalene | 1 | 82945 | 2 | 1.440 | 57600.7 |
211 | 2023-09-30 15:27:12 | squalene | 2 | 121059 | 3 | 3.436 | 35232.5 |
210 | 2023-09-15 11:06:06 | squalene | 1 | 82945 | 2 | 1.280 | 64800.8 |
209 | 2023-09-14 05:58:09 | squalene | 1 | 82945 | 2 | 1.283 | 64649.3 |
208 | 2023-08-30 09:17:41 | squalene | 1 | 82945 | 2 | 1.406 | 58993.6 |
207 | 2023-07-29 05:37:32 | squalene | 1 | 82945 | 2 | 1.420 | 58412.0 |
206 | 2023-07-11 06:13:41 | squalene | 2 | 121059 | 3 | 3.186 | 37997.2 |
205 | 2023-06-25 05:23:07 | squalene | 1 | 82945 | 2 | 1.376 | 60279.8 |
204 | 2023-03-30 11:11:46 | squalene | 2 | 121059 | 3 | 7.000 | 17294.1 |
203 | 2023-03-29 04:16:56 | squalene | 1 | 82945 | 2 | 1.250 | 66356.0 |
202 | 2023-01-12 11:30:49 | squalene | 1 | 82945 | 2 | 1.236 | 67107.6 |
201 | 2022-12-27 21:35:58 | squalene | 2 | 121059 | 3 | 3.063 | 39523.0 |
200 | 2022-10-29 11:33:52 | squalene | 1 | 82945 | 2 | 1.250 | 66356.0 |
199 | 2022-08-27 08:10:55 | squalene | 2 | 121059 | 3 | 3.046 | 39743.6 |
198 | 2022-07-19 06:58:07 | squalene | 1 | 82945 | 2 | 1.266 | 65517.4 |
197 | 2022-07-14 14:29:51 | squalene | 1 | 82945 | 2 | 1.266 | 65517.4 |
196 | 2021-12-09 15:00:55 | squalene | 4 | 161609 | 473 | 11.673 | 13844.7 |
195 | 2021-11-22 10:54:53 | squalene | 4 | 161609 | 473 | 13.206 | 12237.5 |
194 | 2021-10-26 03:37:22 | squalene | 4 | 161609 | 473 | 10.343 | 15625.0 |
193 | 2021-10-09 02:31:55 | squalene | 4 | 161609 | 473 | 10.546 | 15324.2 |
192 | 2021-10-01 07:47:33 | squalene | 4 | 161609 | 473 | 10.623 | 15213.1 |
191 | 2021-09-08 06:22:52 | squalene | 4 | 161609 | 473 | 10.860 | 14881.1 |
190 | 2021-08-29 12:52:29 | squalene | 4 | 161609 | 473 | 10.673 | 15141.9 |
189 | 2021-08-18 22:53:08 | squalene | 4 | 161609 | 473 | 10.486 | 15411.9 |
188 | 2021-08-11 07:33:19 | squalene | 4 | 161609 | 473 | 10.440 | 15479.8 |
187 | 2021-07-04 18:57:35 | squalene | 4 | 161609 | 473 | 10.313 | 15670.4 |
186 | 2021-06-16 15:49:03 | squalene | 1 | 82945 | 2 | 1.500 | 55296.7 |
185 | 2021-06-06 10:40:08 | squalene | 4 | 161609 | 473 | 12.313 | 13125.1 |
184 | 2021-05-19 03:48:45 | squalene | 1 | 82945 | 2 | 1.486 | 55817.6 |
183 | 2021-04-27 03:05:51 | squalene | 1 | 82945 | 2 | 1.360 | 60989.0 |
182 | 2021-01-31 05:13:27 | squalene | 4 | 161609 | 473 | 11.470 | 14089.7 |
181 | 2021-01-10 14:51:08 | squalene | 1 | 82945 | 2 | 1.283 | 64649.3 |
180 | 2020-11-10 07:10:14 | squalene | 1 | 82945 | 2 | 1.313 | 63172.1 |
179 | 2020-09-28 18:59:04 | squalene | 1 | 82945 | 2 | 1.250 | 66356.0 |
178 | 2020-04-04 03:51:52 | squalene | 1 | 82945 | 2 | 1.296 | 64000.8 |
177 | 2020-03-28 15:53:25 | squalene | 1 | 82945 | 2 | 2.940 | 28212.6 |
176 | 2020-03-24 01:41:09 | squalene | 1 | 82945 | 2 | 1.576 | 52630.1 |
175 | 2020-02-29 17:55:57 | squalene | 1 | 82945 | 2 | 3.140 | 26415.6 |
174 | 2020-02-28 01:22:28 | squalene | 1 | 82945 | 2 | 4.920 | 16858.7 |
173 | 2020-02-17 11:13:43 | squalene | 1 | 82945 | 2 | 3.123 | 26559.4 |
172 | 2020-02-04 14:58:55 | squalene | 1 | 82945 | 2 | 1.623 | 51106.0 |
171 | 2020-01-30 19:15:55 | squalene | 1 | 82945 | 2 | 3.266 | 25396.5 |
170 | 2020-01-30 07:59:27 | squalene | 1 | 82945 | 2 | 2.453 | 33813.7 |
169 | 2020-01-27 05:46:47 | squalene | 1 | 82945 | 2 | 1.326 | 62552.8 |
168 | 2020-01-20 21:19:41 | squalene | 1 | 82945 | 2 | 2.766 | 29987.3 |
167 | 2020-01-15 20:20:21 | squalene | 1 | 82945 | 2 | 1.453 | 57085.3 |
166 | 2020-01-03 11:14:53 | squalene | 1 | 82945 | 2 | 2.686 | 30880.5 |
165 | 2020-01-02 00:21:10 | squalene | 1 | 82945 | 2 | 1.360 | 60989.0 |