History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pistaches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
248 | 2024-04-11 02:33:57 | pistaches | 1 | 81242 | 2 | 1.516 | 53589.7 |
247 | 2024-04-08 16:49:01 | pistaches | 1 | 81242 | 2 | 4.860 | 16716.5 |
246 | 2024-04-06 19:16:07 | pistaches | 1 | 81242 | 2 | 6.266 | 12965.5 |
245 | 2024-04-02 04:21:06 | pistaches | 3 | 148641 | 84 | 16.640 | 8932.8 |
244 | 2024-03-31 22:15:05 | pistaches | 1 | 81242 | 2 | 3.220 | 25230.4 |
243 | 2024-03-31 10:44:32 | pistaches | 3 | 148641 | 84 | 23.376 | 6358.7 |
242 | 2024-03-31 10:23:58 | pistaches | 4 | 165329 | 653 | 43.940 | 3762.6 |
241 | 2024-03-31 10:23:39 | pistaches | 3 | 148641 | 84 | 25.516 | 5825.4 |
240 | 2024-03-30 19:19:55 | pistaches | 1 | 81242 | 2 | 4.766 | 17046.2 |
239 | 2024-03-26 19:38:41 | pistaches | 3 | 148641 | 84 | 24.173 | 6149.1 |
238 | 2024-03-26 19:38:34 | pistaches | 2 | 121436 | 9 | 8.906 | 13635.3 |
237 | 2024-03-24 16:22:22 | pistaches | 4 | 165329 | 653 | 44.423 | 3721.7 |
236 | 2024-03-22 12:52:37 | pistaches | 4 | 165329 | 653 | 25.253 | 6546.9 |
235 | 2024-03-22 01:18:18 | pistaches | 4 | 165329 | 653 | 15.766 | 10486.4 |
234 | 2024-03-21 23:35:07 | pistaches | 4 | 165329 | 653 | 34.816 | 4748.7 |
233 | 2024-03-20 03:28:32 | pistaches | 3 | 148641 | 84 | 26.123 | 5690.0 |
232 | 2024-03-20 03:28:29 | pistaches | 4 | 165329 | 653 | 29.110 | 5679.5 |
231 | 2024-03-20 03:28:29 | pistaches | 2 | 121436 | 9 | 8.546 | 14209.7 |
230 | 2024-03-20 03:06:14 | pistaches | 1 | 81242 | 2 | 1.456 | 55798.1 |
229 | 2024-03-01 09:59:41 | pistaches | 1 | 81242 | 2 | 4.860 | 16716.5 |
228 | 2024-02-28 12:26:57 | pistaches | 1 | 81242 | 2 | 1.423 | 57092.1 |
227 | 2024-02-01 13:13:28 | pistaches | 1 | 81242 | 2 | 1.220 | 66591.8 |
226 | 2024-01-30 21:11:59 | pistaches | 1 | 81242 | 2 | 1.436 | 56575.2 |
225 | 2024-01-29 11:18:15 | pistaches | 1 | 81242 | 2 | 1.423 | 57092.1 |
224 | 2024-01-29 11:01:47 | pistaches | 1 | 81242 | 2 | 1.453 | 55913.3 |
223 | 2024-01-25 02:51:28 | pistaches | 1 | 81242 | 2 | 1.236 | 65729.8 |
222 | 2024-01-14 23:25:45 | pistaches | 1 | 81242 | 2 | 1.453 | 55913.3 |
221 | 2024-01-03 20:21:22 | pistaches | 3 | 148641 | 84 | 7.330 | 20278.4 |
220 | 2023-12-31 10:22:46 | pistaches | 1 | 81242 | 2 | 1.236 | 65729.8 |
219 | 2023-12-17 05:41:00 | pistaches | 3 | 148641 | 84 | 7.456 | 19935.8 |
218 | 2023-12-17 05:40:59 | pistaches | 2 | 121436 | 9 | 3.783 | 32100.4 |
217 | 2023-11-26 04:43:22 | pistaches | 4 | 165329 | 653 | 12.860 | 12856.1 |
216 | 2023-11-21 06:30:01 | pistaches | 1 | 81242 | 2 | 1.313 | 61875.1 |
215 | 2023-11-19 11:59:09 | pistaches | 4 | 165329 | 653 | 13.766 | 12010.0 |
214 | 2023-11-11 19:25:43 | pistaches | 1 | 81242 | 2 | 1.296 | 62686.7 |
213 | 2023-11-08 15:28:40 | pistaches | 1 | 81242 | 2 | 1.233 | 65889.7 |
212 | 2023-11-03 14:48:29 | pistaches | 4 | 165329 | 653 | 13.050 | 12668.9 |
211 | 2023-11-03 14:48:30 | pistaches | 3 | 148641 | 84 | 7.783 | 19098.2 |
210 | 2023-11-03 14:48:32 | pistaches | 2 | 121436 | 9 | 3.953 | 30720.0 |
209 | 2023-10-21 02:09:00 | pistaches | 1 | 81242 | 2 | 1.436 | 56575.2 |
208 | 2023-10-06 18:01:38 | pistaches | 3 | 148641 | 84 | 7.123 | 20867.8 |
207 | 2023-09-10 18:54:32 | pistaches | 1 | 81242 | 2 | 1.530 | 53099.3 |
206 | 2023-08-29 05:19:28 | pistaches | 1 | 81242 | 2 | 1.296 | 62686.7 |
205 | 2023-07-16 23:19:17 | pistaches | 3 | 148641 | 84 | 6.500 | 22867.8 |
204 | 2023-05-31 00:34:26 | pistaches | 1 | 81242 | 2 | 1.233 | 65889.7 |
203 | 2023-05-10 23:15:22 | pistaches | 1 | 81242 | 2 | 1.376 | 59042.2 |
202 | 2023-04-02 22:22:18 | pistaches | 3 | 148641 | 84 | 13.173 | 11283.8 |
201 | 2023-03-24 12:55:20 | pistaches | 1 | 81242 | 2 | 1.250 | 64993.6 |
200 | 2023-01-10 06:36:46 | pistaches | 1 | 81242 | 2 | 1.356 | 59913.0 |
199 | 2023-01-10 06:01:23 | pistaches | 1 | 81242 | 2 | 1.420 | 57212.7 |
198 | 2022-12-29 17:32:04 | pistaches | 3 | 148641 | 84 | 6.046 | 24585.0 |
197 | 2022-10-13 17:59:07 | pistaches | 1 | 81242 | 2 | 1.236 | 65729.8 |
196 | 2022-09-08 10:41:01 | pistaches | 1 | 81242 | 2 | 1.236 | 65729.8 |
195 | 2022-08-31 14:54:56 | pistaches | 3 | 148641 | 84 | 6.250 | 23782.6 |
194 | 2022-08-29 06:51:55 | pistaches | 3 | 148641 | 84 | 11.203 | 13268.0 |
193 | 2022-06-02 12:05:34 | pistaches | 1 | 81242 | 2 | 1.360 | 59736.8 |
192 | 2022-04-25 09:06:49 | pistaches | 1 | 81242 | 2 | 1.656 | 49059.2 |
191 | 2022-03-21 21:04:03 | pistaches | 3 | 148641 | 84 | 7.470 | 19898.4 |
190 | 2022-02-12 09:05:21 | pistaches | 1 | 81242 | 2 | 1.390 | 58447.5 |
189 | 2022-02-10 05:25:09 | pistaches | 1 | 81242 | 2 | 1.343 | 60492.9 |
188 | 2021-12-30 06:15:16 | pistaches | 1 | 81242 | 2 | 1.326 | 61268.5 |
187 | 2021-12-01 21:35:30 | pistaches | 1 | 81242 | 2 | 1.423 | 57092.1 |
186 | 2021-10-13 09:42:13 | pistaches | 1 | 81242 | 2 | 1.280 | 63470.3 |
185 | 2021-10-11 08:01:25 | pistaches | 1 | 81242 | 2 | 1.233 | 65889.7 |
184 | 2021-09-10 08:08:15 | pistaches | 1 | 81242 | 2 | 1.216 | 66810.9 |
183 | 2021-06-06 03:09:54 | pistaches | 1 | 81242 | 2 | 1.423 | 57092.1 |
182 | 2021-05-11 15:05:36 | pistaches | 1 | 81242 | 2 | 1.546 | 52549.8 |
181 | 2021-04-10 08:32:34 | pistaches | 1 | 81242 | 2 | 1.423 | 57092.1 |
180 | 2021-03-14 10:38:35 | pistaches | 1 | 81242 | 2 | 1.436 | 56575.2 |
179 | 2021-03-04 01:10:35 | pistaches | 1 | 81242 | 2 | 1.266 | 64172.2 |
178 | 2020-11-29 13:48:47 | pistaches | 1 | 81242 | 2 | 1.296 | 62686.7 |
177 | 2020-11-23 21:15:08 | pistaches | 1 | 81242 | 2 | 1.220 | 66591.8 |
176 | 2020-11-19 09:32:49 | pistaches | 1 | 81242 | 2 | 1.330 | 61084.2 |
175 | 2020-11-04 01:23:56 | pistaches | 1 | 81242 | 2 | 1.356 | 59913.0 |
174 | 2020-10-31 02:52:58 | pistaches | 1 | 81242 | 2 | 1.283 | 63321.9 |
173 | 2020-08-28 23:18:46 | pistaches | 1 | 81242 | 2 | 1.296 | 62686.7 |
172 | 2020-08-15 23:30:30 | pistaches | 1 | 81242 | 2 | 1.280 | 63470.3 |
171 | 2020-08-03 23:57:15 | pistaches | 1 | 81242 | 2 | 1.310 | 62016.8 |
170 | 2020-05-14 16:08:20 | pistaches | 1 | 81242 | 2 | 1.283 | 63321.9 |
169 | 2020-03-31 22:04:28 | pistaches | 1 | 81242 | 2 | 1.233 | 65889.7 |
168 | 2020-03-23 07:32:34 | pistaches | 1 | 81242 | 2 | 1.470 | 55266.7 |
167 | 2020-03-11 12:04:01 | pistaches | 1 | 81242 | 2 | 1.236 | 65729.8 |
166 | 2020-02-28 15:27:53 | pistaches | 1 | 81242 | 2 | 1.610 | 50460.9 |
165 | 2020-02-24 00:40:08 | pistaches | 1 | 81242 | 2 | 1.546 | 52549.8 |
164 | 2020-02-18 18:33:47 | pistaches | 1 | 81242 | 2 | 1.576 | 51549.5 |
163 | 2020-02-15 06:34:52 | pistaches | 1 | 81242 | 2 | 1.516 | 53589.7 |
162 | 2020-02-07 15:45:50 | pistaches | 1 | 81242 | 2 | 3.203 | 25364.3 |
161 | 2020-02-06 04:38:31 | pistaches | 1 | 81242 | 2 | 1.250 | 64993.6 |
160 | 2020-02-02 09:20:11 | pistaches | 1 | 81242 | 2 | 1.360 | 59736.8 |
159 | 2020-02-02 04:11:12 | pistaches | 1 | 81242 | 2 | 1.483 | 54782.2 |
158 | 2020-01-23 08:46:19 | pistaches | 1 | 81242 | 2 | 1.596 | 50903.5 |
157 | 2020-01-22 23:50:04 | pistaches | 1 | 81242 | 2 | 3.033 | 26786.0 |
156 | 2020-01-20 20:59:41 | pistaches | 1 | 81242 | 2 | 1.560 | 52078.2 |
155 | 2020-01-17 12:49:53 | pistaches | 1 | 81242 | 2 | 1.610 | 50460.9 |
154 | 2020-01-17 11:55:30 | pistaches | 1 | 81242 | 2 | 1.530 | 53099.3 |
153 | 2020-01-11 20:04:24 | pistaches | 1 | 81242 | 2 | 1.580 | 51419.0 |
152 | 2020-01-06 17:28:32 | pistaches | 1 | 81242 | 2 | 1.296 | 62686.7 |
151 | 2020-01-01 03:48:53 | pistaches | 1 | 81242 | 2 | 1.373 | 59171.2 |
150 | 2019-12-31 06:49:13 | pistaches | 1 | 81242 | 2 | 1.330 | 61084.2 |
149 | 2019-11-24 14:52:33 | pistaches | 1 | 81242 | 2 | 1.233 | 65889.7 |