History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"complaint"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
274 | 2024-04-13 14:20:23 | complaint | 1 | 81242 | 5 | 1.810 | 44885.1 |
273 | 2024-04-13 06:10:00 | complaint | 4 | 165329 | 361 | 12.686 | 13032.4 |
272 | 2024-04-11 11:24:00 | complaint | 1 | 81242 | 5 | 1.266 | 64172.2 |
271 | 2024-04-10 05:12:10 | complaint | 1 | 81242 | 5 | 2.313 | 35124.1 |
270 | 2024-04-01 06:30:05 | complaint | 1 | 81242 | 5 | 1.516 | 53589.7 |
269 | 2024-03-29 20:44:43 | complaint | 1 | 81242 | 5 | 4.126 | 19690.3 |
268 | 2024-03-29 02:06:53 | complaint | 1 | 81242 | 5 | 3.080 | 26377.3 |
267 | 2024-03-23 12:40:28 | complaint | 2 | 121436 | 14 | 3.470 | 34996.0 |
266 | 2024-03-16 16:27:34 | complaint | 3 | 148641 | 57 | 7.593 | 19576.1 |
265 | 2024-03-08 22:05:11 | complaint | 1 | 81242 | 5 | 2.733 | 29726.3 |
264 | 2024-02-28 00:38:37 | complaint | 1 | 81242 | 5 | 1.360 | 59736.8 |
263 | 2024-02-26 04:24:43 | complaint | 1 | 81242 | 5 | 4.830 | 16820.3 |
262 | 2024-01-30 02:48:38 | complaint | 1 | 81242 | 5 | 1.750 | 46424.0 |
261 | 2024-01-29 13:41:47 | complaint | 1 | 81242 | 5 | 1.483 | 54782.2 |
260 | 2024-01-28 14:12:59 | complaint | 1 | 81242 | 5 | 1.486 | 54671.6 |
259 | 2024-01-06 13:24:37 | complaint | 1 | 81242 | 5 | 1.266 | 64172.2 |
258 | 2023-12-13 00:37:37 | complaint | 2 | 121436 | 14 | 3.140 | 38673.9 |
257 | 2023-12-12 10:10:12 | complaint | 4 | 165329 | 361 | 10.453 | 15816.4 |
256 | 2023-12-11 10:32:21 | complaint | 1 | 81242 | 5 | 1.266 | 64172.2 |
255 | 2023-12-03 18:38:17 | complaint | 4 | 165329 | 361 | 13.420 | 12319.6 |
254 | 2023-12-03 18:38:11 | complaint | 3 | 148641 | 57 | 8.140 | 18260.6 |
253 | 2023-12-03 18:38:14 | complaint | 2 | 121436 | 14 | 3.970 | 30588.4 |
252 | 2023-12-03 13:48:30 | complaint | 1 | 81242 | 5 | 1.373 | 59171.2 |
251 | 2023-12-03 13:48:28 | complaint | 1 | 81242 | 5 | 1.420 | 57212.7 |
250 | 2023-12-02 10:45:40 | complaint | 2 | 121436 | 14 | 3.173 | 38271.7 |
249 | 2023-11-30 13:10:22 | complaint | 3 | 148641 | 57 | 8.860 | 16776.6 |
248 | 2023-11-26 17:03:34 | complaint | 2 | 121436 | 14 | 3.763 | 32271.1 |
247 | 2023-11-11 03:29:31 | complaint | 1 | 81242 | 5 | 1.403 | 57905.9 |
246 | 2023-11-11 03:23:16 | complaint | 3 | 148641 | 57 | 8.766 | 16956.5 |
245 | 2023-11-11 03:22:43 | complaint | 4 | 165329 | 361 | 14.533 | 11376.1 |
244 | 2023-11-10 02:19:05 | complaint | 4 | 165329 | 361 | 18.186 | 9091.0 |
243 | 2023-11-10 02:18:40 | complaint | 3 | 148641 | 57 | 14.296 | 10397.4 |
242 | 2023-11-10 02:03:42 | complaint | 1 | 81242 | 5 | 1.470 | 55266.7 |
241 | 2023-11-07 08:12:55 | complaint | 4 | 165329 | 361 | 27.500 | 6012.0 |
240 | 2023-11-07 08:12:45 | complaint | 4 | 165329 | 361 | 14.533 | 11376.1 |
239 | 2023-11-07 08:12:43 | complaint | 3 | 148641 | 57 | 7.313 | 20325.6 |
238 | 2023-11-07 08:12:42 | complaint | 2 | 121436 | 14 | 5.076 | 23923.6 |
237 | 2023-11-07 06:03:03 | complaint | 1 | 81242 | 5 | 1.453 | 55913.3 |
236 | 2023-10-30 03:21:03 | complaint | 1 | 81242 | 5 | 1.250 | 64993.6 |
235 | 2023-10-27 23:57:37 | complaint | 1 | 81242 | 5 | 1.313 | 61875.1 |
234 | 2023-10-20 04:10:44 | complaint | 1 | 81242 | 5 | 1.393 | 58321.6 |
233 | 2023-10-18 01:06:23 | complaint | 1 | 81242 | 5 | 1.420 | 57212.7 |
232 | 2023-10-12 03:49:09 | complaint | 1 | 81242 | 5 | 1.423 | 57092.1 |
231 | 2023-10-04 05:48:51 | complaint | 1 | 81242 | 5 | 1.280 | 63470.3 |
230 | 2023-09-23 12:29:53 | complaint | 1 | 81242 | 5 | 1.313 | 61875.1 |
229 | 2023-09-12 05:41:21 | complaint | 1 | 81242 | 5 | 1.390 | 58447.5 |
228 | 2023-09-11 07:03:28 | complaint | 4 | 165329 | 361 | 12.733 | 12984.3 |
227 | 2023-08-31 13:21:31 | complaint | 2 | 121436 | 14 | 3.096 | 39223.5 |
226 | 2023-08-29 11:27:38 | complaint | 3 | 148641 | 57 | 6.063 | 24516.1 |
225 | 2023-08-23 01:46:37 | complaint | 1 | 81242 | 5 | 1.280 | 63470.3 |
224 | 2023-08-08 09:08:31 | complaint | 1 | 81242 | 5 | 1.280 | 63470.3 |
223 | 2023-06-02 14:59:14 | complaint | 4 | 165329 | 361 | 10.983 | 15053.2 |
222 | 2023-05-23 07:04:22 | complaint | 1 | 81242 | 5 | 1.420 | 57212.7 |
221 | 2023-05-16 08:19:32 | complaint | 2 | 121436 | 14 | 3.326 | 36511.1 |
220 | 2023-05-15 12:49:04 | complaint | 3 | 148641 | 57 | 6.126 | 24264.0 |
219 | 2023-04-23 10:39:25 | complaint | 1 | 81242 | 5 | 1.296 | 62686.7 |
218 | 2023-03-20 22:57:49 | complaint | 1 | 81242 | 5 | 1.390 | 58447.5 |
217 | 2023-03-10 10:55:55 | complaint | 4 | 165329 | 361 | 10.190 | 16224.6 |
216 | 2023-02-23 05:55:30 | complaint | 3 | 148641 | 57 | 6.046 | 24585.0 |
215 | 2023-02-22 03:01:00 | complaint | 2 | 121436 | 14 | 3.173 | 38271.7 |
214 | 2023-01-11 00:57:40 | complaint | 1 | 81242 | 5 | 1.250 | 64993.6 |
213 | 2023-01-06 12:27:05 | complaint | 1 | 81242 | 5 | 1.250 | 64993.6 |
212 | 2022-12-15 19:11:09 | complaint | 4 | 165329 | 361 | 18.983 | 8709.3 |
211 | 2022-12-03 06:29:03 | complaint | 3 | 148641 | 57 | 6.013 | 24719.9 |
210 | 2022-12-02 12:31:28 | complaint | 2 | 121436 | 14 | 3.063 | 39646.1 |
209 | 2022-09-25 11:40:14 | complaint | 1 | 81242 | 5 | 1.376 | 59042.2 |
208 | 2022-09-16 09:25:50 | complaint | 1 | 81242 | 5 | 1.313 | 61875.1 |
207 | 2022-08-07 01:59:29 | complaint | 4 | 165329 | 361 | 10.560 | 15656.2 |
206 | 2022-07-06 10:47:56 | complaint | 3 | 148641 | 57 | 6.160 | 24130.0 |
205 | 2022-06-14 09:03:35 | complaint | 3 | 148641 | 57 | 6.516 | 22811.7 |
204 | 2022-05-17 15:25:54 | complaint | 1 | 81242 | 5 | 2.000 | 40621.0 |
203 | 2022-05-14 02:08:11 | complaint | 1 | 81242 | 5 | 1.780 | 45641.6 |
202 | 2022-05-12 18:11:01 | complaint | 1 | 81242 | 5 | 1.266 | 64172.2 |
201 | 2022-05-07 09:05:24 | complaint | 3 | 148641 | 57 | 6.126 | 24264.0 |
200 | 2022-04-20 11:28:57 | complaint | 2 | 121436 | 14 | 4.983 | 24370.1 |
199 | 2022-04-18 08:08:45 | complaint | 2 | 121436 | 14 | 3.266 | 37181.9 |
198 | 2022-04-03 15:11:33 | complaint | 3 | 148641 | 57 | 6.703 | 22175.3 |
197 | 2022-04-01 11:01:03 | complaint | 3 | 148641 | 57 | 5.970 | 24898.0 |
196 | 2022-03-10 11:00:34 | complaint | 4 | 165329 | 361 | 10.970 | 15071.0 |
195 | 2022-01-29 14:25:16 | complaint | 1 | 81242 | 5 | 1.486 | 54671.6 |
194 | 2022-01-27 09:13:25 | complaint | 1 | 81242 | 5 | 1.280 | 63470.3 |
193 | 2022-01-26 09:59:49 | complaint | 1 | 81242 | 5 | 1.313 | 61875.1 |
192 | 2021-12-23 18:41:27 | complaint | 2 | 121436 | 14 | 7.656 | 15861.5 |
191 | 2021-12-15 00:20:54 | complaint | 3 | 148641 | 57 | 7.173 | 20722.3 |
190 | 2021-11-20 16:07:46 | complaint | 1 | 81242 | 5 | 1.500 | 54161.3 |
189 | 2021-10-24 13:41:27 | complaint | 2 | 121436 | 14 | 3.826 | 31739.7 |
188 | 2021-10-09 20:09:14 | complaint | 1 | 81242 | 5 | 1.266 | 64172.2 |
187 | 2021-10-08 11:48:10 | complaint | 1 | 81242 | 5 | 1.296 | 62686.7 |
186 | 2021-09-19 09:22:11 | complaint | 1 | 81242 | 5 | 2.686 | 30246.5 |
185 | 2021-07-07 22:08:45 | complaint | 1 | 81242 | 5 | 1.530 | 53099.3 |
184 | 2021-06-16 09:20:45 | complaint | 1 | 81242 | 5 | 1.436 | 56575.2 |
183 | 2021-05-20 04:06:24 | complaint | 1 | 81242 | 5 | 1.296 | 62686.7 |
182 | 2021-04-08 02:47:50 | complaint | 1 | 81242 | 5 | 1.436 | 56575.2 |
181 | 2021-04-03 23:01:51 | complaint | 1 | 81242 | 5 | 1.453 | 55913.3 |
180 | 2021-02-05 03:10:46 | complaint | 1 | 81242 | 5 | 1.326 | 61268.5 |
179 | 2020-12-29 22:39:30 | complaint | 1 | 81242 | 5 | 2.546 | 31909.7 |
178 | 2020-11-18 05:38:52 | complaint | 1 | 81242 | 5 | 1.283 | 63321.9 |
177 | 2020-09-26 15:20:55 | complaint | 1 | 81242 | 5 | 1.436 | 56575.2 |
176 | 2020-06-21 00:21:42 | complaint | 1 | 81242 | 5 | 1.436 | 56575.2 |
175 | 2020-06-17 20:22:22 | complaint | 1 | 81242 | 5 | 1.250 | 64993.6 |