History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"petroleum"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
229 | 2024-04-15 19:55:52 | petroleum | 4 | 165329 | 96 | 46.690 | 3541.0 |
228 | 2024-04-10 17:22:04 | petroleum | 4 | 165329 | 96 | 47.396 | 3488.2 |
227 | 2024-04-10 13:52:04 | petroleum | 4 | 165329 | 96 | 32.063 | 5156.4 |
226 | 2024-04-07 07:03:03 | petroleum | 4 | 165329 | 96 | 40.143 | 4118.5 |
225 | 2024-04-05 17:39:01 | petroleum | 1 | 81242 | 2 | 4.423 | 18368.1 |
224 | 2024-04-03 18:58:16 | petroleum | 2 | 121436 | 3 | 9.140 | 13286.2 |
223 | 2024-04-03 18:54:53 | petroleum | 1 | 81242 | 2 | 1.560 | 52078.2 |
222 | 2024-04-03 18:46:14 | petroleum | 5 | 174418 | 1181 | 54.300 | 3212.1 |
221 | 2024-04-03 18:46:05 | petroleum | 4 | 165329 | 96 | 36.910 | 4479.2 |
220 | 2024-04-03 18:46:05 | petroleum | 3 | 148641 | 19 | 9.450 | 15729.2 |
219 | 2024-04-02 18:04:15 | petroleum | 5 | 174418 | 1181 | 60.316 | 2891.7 |
218 | 2024-04-02 07:54:37 | petroleum | 4 | 165329 | 96 | 28.203 | 5862.1 |
217 | 2024-04-01 23:07:27 | petroleum | 5 | 174418 | 1181 | 61.173 | 2851.2 |
216 | 2024-04-01 23:07:32 | petroleum | 4 | 165329 | 96 | 33.266 | 4969.9 |
215 | 2024-04-01 23:07:35 | petroleum | 3 | 148641 | 19 | 18.440 | 8060.8 |
214 | 2024-04-01 23:07:33 | petroleum | 2 | 121436 | 3 | 7.593 | 15993.2 |
213 | 2024-04-01 22:53:52 | petroleum | 1 | 81242 | 2 | 1.623 | 50056.7 |
212 | 2024-03-10 09:33:37 | petroleum | 3 | 148641 | 19 | 14.063 | 10569.7 |
211 | 2024-03-10 09:33:35 | petroleum | 2 | 121436 | 3 | 13.470 | 9015.3 |
210 | 2024-03-03 06:35:48 | petroleum | 3 | 148641 | 19 | 20.250 | 7340.3 |
209 | 2024-03-03 06:35:02 | petroleum | 2 | 121436 | 3 | 5.376 | 22588.5 |
208 | 2024-03-03 06:34:26 | petroleum | 4 | 165329 | 96 | 28.953 | 5710.3 |
207 | 2024-03-02 18:35:40 | petroleum | 5 | 174418 | 1181 | 42.130 | 4140.0 |
206 | 2024-03-02 12:11:38 | petroleum | 1 | 81242 | 2 | 1.406 | 57782.4 |
205 | 2024-03-01 19:17:01 | petroleum | 5 | 174418 | 1181 | 49.050 | 3555.9 |
204 | 2024-03-01 19:17:04 | petroleum | 3 | 148641 | 19 | 21.766 | 6829.0 |
203 | 2024-03-01 19:16:58 | petroleum | 4 | 165329 | 96 | 24.936 | 6630.1 |
202 | 2024-03-01 19:16:59 | petroleum | 2 | 121436 | 3 | 8.453 | 14366.0 |
201 | 2024-02-29 05:12:42 | petroleum | 1 | 81242 | 2 | 1.546 | 52549.8 |
200 | 2024-01-30 08:06:50 | petroleum | 1 | 81242 | 2 | 1.436 | 56575.2 |
199 | 2024-01-29 18:31:59 | petroleum | 1 | 81242 | 2 | 1.500 | 54161.3 |
198 | 2024-01-08 06:54:51 | petroleum | 1 | 81242 | 2 | 1.280 | 63470.3 |
197 | 2024-01-04 04:27:31 | petroleum | 1 | 81242 | 2 | 1.483 | 54782.2 |
196 | 2023-12-09 23:54:53 | petroleum | 1 | 81242 | 2 | 1.310 | 62016.8 |
195 | 2023-10-27 12:22:31 | petroleum | 1 | 81242 | 2 | 1.470 | 55266.7 |
194 | 2023-09-14 19:28:08 | petroleum | 1 | 81242 | 2 | 1.546 | 52549.8 |
193 | 2023-08-22 00:07:32 | petroleum | 1 | 81242 | 2 | 1.360 | 59736.8 |
192 | 2023-05-25 07:18:22 | petroleum | 1 | 81242 | 2 | 1.296 | 62686.7 |
191 | 2023-03-20 06:02:18 | petroleum | 1 | 81242 | 2 | 1.313 | 61875.1 |
190 | 2023-01-06 00:08:40 | petroleum | 1 | 81242 | 2 | 1.250 | 64993.6 |
189 | 2022-10-04 17:13:12 | petroleum | 1 | 81242 | 2 | 1.406 | 57782.4 |
188 | 2022-05-23 01:15:35 | petroleum | 1 | 81242 | 2 | 1.296 | 62686.7 |
187 | 2022-05-20 20:19:04 | petroleum | 1 | 81242 | 2 | 1.373 | 59171.2 |
186 | 2022-05-18 16:03:25 | petroleum | 1 | 81242 | 2 | 1.406 | 57782.4 |
185 | 2021-05-01 13:52:45 | petroleum | 1 | 81242 | 2 | 1.593 | 50999.4 |
184 | 2021-03-22 07:02:38 | petroleum | 1 | 81242 | 2 | 1.420 | 57212.7 |
183 | 2021-02-24 19:43:47 | petroleum | 1 | 81242 | 2 | 1.390 | 58447.5 |
182 | 2021-02-01 22:19:34 | petroleum | 1 | 81242 | 2 | 1.313 | 61875.1 |
181 | 2020-10-20 19:05:22 | petroleum | 1 | 81242 | 2 | 1.280 | 63470.3 |
180 | 2020-10-05 18:46:07 | petroleum | 1 | 81242 | 2 | 1.250 | 64993.6 |
179 | 2020-03-23 11:07:44 | petroleum | 1 | 81242 | 2 | 1.550 | 52414.2 |
178 | 2020-03-15 10:33:17 | petroleum | 1 | 81242 | 2 | 1.266 | 64172.2 |
177 | 2020-02-18 16:15:20 | petroleum | 1 | 81242 | 2 | 1.453 | 55913.3 |
176 | 2020-02-12 14:17:18 | petroleum | 1 | 81242 | 2 | 3.203 | 25364.3 |
175 | 2020-02-09 12:32:17 | petroleum | 1 | 81242 | 2 | 1.593 | 50999.4 |
174 | 2020-02-03 19:38:27 | petroleum | 1 | 81242 | 2 | 2.970 | 27354.2 |
173 | 2020-01-30 06:56:40 | petroleum | 1 | 81242 | 2 | 1.563 | 51978.2 |
172 | 2020-01-24 17:47:10 | petroleum | 1 | 81242 | 2 | 1.796 | 45235.0 |
171 | 2020-01-16 07:42:33 | petroleum | 1 | 81242 | 2 | 1.360 | 59736.8 |
170 | 2020-01-02 16:11:50 | petroleum | 1 | 81242 | 2 | 1.483 | 54782.2 |
169 | 2020-01-01 20:23:23 | petroleum | 1 | 81242 | 2 | 4.063 | 19995.6 |
168 | 2019-11-28 02:28:21 | petroleum | 1 | 81242 | 2 | 1.470 | 55266.7 |
167 | 2019-08-26 10:57:17 | petroleum | 1 | 81242 | 2 | 1.203 | 67532.8 |
166 | 2019-05-11 01:19:39 | petroleum | 1 | 81242 | 2 | 1.400 | 58030.0 |
165 | 2019-01-05 13:08:34 | petroleum | 1 | 81242 | 2 | 1.273 | 63819.3 |
164 | 2019-01-02 05:07:35 | petroleum | 1 | 81242 | 2 | 1.410 | 57618.4 |
163 | 2018-08-15 05:51:56 | petroleum | 1 | 81242 | 2 | 1.323 | 61407.4 |
162 | 2018-06-27 10:19:26 | petroleum | 1 | 81242 | 2 | 1.283 | 63321.9 |
161 | 2018-06-25 12:17:00 | petroleum | 1 | 81242 | 2 | 1.806 | 44984.5 |
160 | 2018-06-25 10:18:29 | petroleum | 1 | 81242 | 2 | 1.603 | 50681.2 |
159 | 2018-06-25 08:31:12 | petroleum | 1 | 81242 | 2 | 1.423 | 57092.1 |
158 | 2018-06-05 00:21:04 | petroleum | 1 | 81242 | 2 | 1.366 | 59474.4 |
157 | 2017-11-11 06:31:33 | petroleum | 1 | 81242 | 2 | 1.786 | 45488.2 |
156 | 2017-09-25 03:08:23 | petroleum | 1 | 81242 | 2 | 1.650 | 49237.6 |
155 | 2017-06-29 03:30:41 | petroleum | 1 | 81242 | 2 | 1.680 | 48358.3 |
154 | 2017-06-10 13:00:34 | petroleum | 1 | 81242 | 2 | 1.716 | 47343.8 |
153 | 2017-04-08 23:14:29 | petroleum | 1 | 81242 | 2 | 1.743 | 46610.4 |
152 | 2017-04-06 00:02:26 | petroleum | 1 | 81242 | 2 | 1.893 | 42917.1 |
151 | 2017-04-01 20:08:45 | petroleum | 1 | 81242 | 2 | 2.073 | 39190.5 |
150 | 2017-02-19 06:14:04 | petroleum | 1 | 81242 | 2 | 1.663 | 48852.7 |
149 | 2017-02-19 05:41:25 | petroleum | 1 | 81242 | 2 | 1.813 | 44810.8 |
148 | 2016-12-05 12:03:44 | petroleum | 1 | 81242 | 2 | 1.920 | 42313.5 |
147 | 2016-12-04 11:48:39 | petroleum | 1 | 81242 | 2 | 2.073 | 39190.5 |
146 | 2016-11-20 16:45:31 | petroleum | 1 | 81242 | 2 | 2.063 | 39380.5 |
145 | 2016-11-20 16:41:14 | petroleum | 1 | 81242 | 2 | 1.863 | 43608.2 |
144 | 2016-10-03 16:56:00 | petroleum | 1 | 81242 | 2 | 2.163 | 37559.9 |
143 | 2016-08-04 15:05:17 | petroleum | 1 | 81242 | 2 | 1.810 | 44885.1 |
142 | 2016-08-04 15:01:55 | petroleum | 1 | 81242 | 2 | 1.766 | 46003.4 |
141 | 2016-07-22 10:08:27 | petroleum | 3 | 148641 | 19 | 10.376 | 14325.5 |
140 | 2016-07-22 07:43:59 | petroleum | 5 | 174418 | 1181 | 45.653 | 3820.5 |
139 | 2016-07-18 12:24:57 | petroleum | 1 | 81242 | 2 | 2.130 | 38141.8 |
138 | 2016-07-10 14:03:41 | petroleum | 1 | 81242 | 2 | 5.970 | 13608.4 |
137 | 2016-06-16 23:31:28 | petroleum | 2 | 121436 | 3 | 6.610 | 18371.6 |
136 | 2016-04-14 10:12:34 | petroleum | 1 | 81242 | 2 | 3.776 | 21515.4 |
135 | 2016-04-13 13:05:07 | petroleum | 1 | 81242 | 2 | 4.486 | 18110.1 |
134 | 2016-04-01 10:35:45 | petroleum | 1 | 81242 | 2 | 1.503 | 54053.2 |
133 | 2016-03-28 18:51:51 | petroleum | 1 | 81242 | 2 | 5.920 | 13723.3 |
132 | 2016-03-09 11:34:22 | petroleum | 1 | 81242 | 2 | 2.896 | 28053.2 |
131 | 2016-03-07 01:57:35 | petroleum | 1 | 81242 | 2 | 1.756 | 46265.4 |
130 | 2016-03-04 10:45:41 | petroleum | 5 | 174418 | 1181 | 77.526 | 2249.8 |