History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"freights"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
245 | 2024-04-29 18:31:37 | freights | 1 | 82945 | 3 | 2.873 | 28870.5 |
244 | 2024-04-28 04:34:57 | freights | 2 | 121059 | 23 | 12.546 | 9649.2 |
243 | 2024-04-28 03:57:59 | freights | 3 | 146162 | 113 | 7.576 | 19292.8 |
242 | 2024-04-28 03:58:02 | freights | 2 | 121059 | 23 | 3.923 | 30858.8 |
241 | 2024-04-28 03:57:51 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
240 | 2024-04-28 03:57:37 | freights | 3 | 146162 | 113 | 7.890 | 18525.0 |
239 | 2024-04-28 01:58:56 | freights | 3 | 146162 | 113 | 8.546 | 17103.0 |
238 | 2024-04-10 07:56:23 | freights | 1 | 82945 | 3 | 2.110 | 39310.4 |
237 | 2024-04-04 17:46:36 | freights | 1 | 82945 | 3 | 1.280 | 64800.8 |
236 | 2024-03-30 09:25:26 | freights | 1 | 82945 | 3 | 5.000 | 16589.0 |
235 | 2024-03-29 22:26:22 | freights | 1 | 82945 | 3 | 3.030 | 27374.6 |
234 | 2024-03-25 15:50:01 | freights | 1 | 82945 | 3 | 1.310 | 63316.8 |
233 | 2024-03-07 19:16:54 | freights | 2 | 121059 | 23 | 8.940 | 13541.3 |
232 | 2024-03-07 06:06:18 | freights | 3 | 146162 | 113 | 19.190 | 7616.6 |
231 | 2024-03-06 13:23:32 | freights | 3 | 146162 | 113 | 16.470 | 8874.4 |
230 | 2024-03-06 00:48:57 | freights | 2 | 121059 | 23 | 8.220 | 14727.4 |
229 | 2024-03-06 00:48:53 | freights | 1 | 82945 | 3 | 1.580 | 52496.8 |
228 | 2024-03-05 15:00:44 | freights | 2 | 121059 | 23 | 3.906 | 30993.1 |
227 | 2024-03-01 19:35:40 | freights | 2 | 121059 | 23 | 7.156 | 16917.1 |
226 | 2024-03-01 19:33:58 | freights | 1 | 82945 | 3 | 1.780 | 46598.3 |
225 | 2024-03-01 19:30:56 | freights | 3 | 146162 | 113 | 20.783 | 7032.8 |
224 | 2024-02-29 06:36:11 | freights | 1 | 82945 | 3 | 2.733 | 30349.4 |
223 | 2024-02-28 07:09:09 | freights | 2 | 121059 | 23 | 14.720 | 8224.1 |
222 | 2024-02-28 07:08:59 | freights | 3 | 146162 | 113 | 21.190 | 6897.7 |
221 | 2024-02-28 07:08:51 | freights | 1 | 82945 | 3 | 4.686 | 17700.6 |
220 | 2024-02-07 10:25:06 | freights | 2 | 121059 | 23 | 3.626 | 33386.4 |
219 | 2024-02-07 10:25:03 | freights | 3 | 146162 | 113 | 6.826 | 21412.5 |
218 | 2024-02-05 08:32:22 | freights | 3 | 146162 | 113 | 16.860 | 8669.2 |
217 | 2024-02-05 03:19:16 | freights | 2 | 121059 | 23 | 12.076 | 10024.8 |
216 | 2024-02-05 03:18:47 | freights | 3 | 146162 | 113 | 7.533 | 19402.9 |
215 | 2024-01-18 10:50:54 | freights | 2 | 121059 | 23 | 3.623 | 33414.0 |
214 | 2024-01-12 23:30:08 | freights | 3 | 146162 | 113 | 7.610 | 19206.6 |
213 | 2024-01-12 23:30:09 | freights | 2 | 121059 | 23 | 4.093 | 29577.1 |
212 | 2024-01-05 05:29:25 | freights | 3 | 146162 | 113 | 7.423 | 19690.4 |
211 | 2024-01-05 05:29:23 | freights | 2 | 121059 | 23 | 3.906 | 30993.1 |
210 | 2023-12-25 14:51:53 | freights | 1 | 82945 | 3 | 1.500 | 55296.7 |
209 | 2023-12-16 19:17:47 | freights | 3 | 146162 | 113 | 6.313 | 23152.5 |
208 | 2023-12-10 16:19:25 | freights | 1 | 82945 | 3 | 1.313 | 63172.1 |
207 | 2023-12-08 13:09:19 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
206 | 2023-12-08 13:09:18 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
205 | 2023-11-17 21:43:30 | freights | 1 | 82945 | 3 | 1.533 | 54106.3 |
204 | 2023-11-13 22:30:50 | freights | 1 | 82945 | 3 | 1.280 | 64800.8 |
203 | 2023-11-04 23:17:46 | freights | 1 | 82945 | 3 | 1.513 | 54821.5 |
202 | 2023-11-02 11:29:17 | freights | 3 | 146162 | 113 | 9.500 | 15385.5 |
201 | 2023-10-25 13:55:34 | freights | 1 | 82945 | 3 | 1.296 | 64000.8 |
200 | 2023-10-25 13:52:50 | freights | 3 | 146162 | 113 | 8.593 | 17009.4 |
199 | 2023-10-17 20:32:30 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
198 | 2023-10-17 15:48:30 | freights | 3 | 146162 | 113 | 19.156 | 7630.1 |
197 | 2023-10-17 15:48:27 | freights | 2 | 121059 | 23 | 15.453 | 7834.0 |
196 | 2023-10-14 08:09:46 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
195 | 2023-10-11 00:26:00 | freights | 1 | 82945 | 3 | 1.280 | 64800.8 |
194 | 2023-10-09 09:55:07 | freights | 1 | 82945 | 3 | 1.576 | 52630.1 |
193 | 2023-09-16 09:56:23 | freights | 3 | 146162 | 113 | 9.016 | 16211.4 |
192 | 2023-09-14 16:12:34 | freights | 1 | 82945 | 3 | 1.406 | 58993.6 |
191 | 2023-08-10 19:55:57 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
190 | 2023-08-03 19:22:38 | freights | 1 | 82945 | 3 | 1.296 | 64000.8 |
189 | 2023-06-19 19:21:05 | freights | 3 | 146162 | 113 | 11.250 | 12992.2 |
188 | 2023-05-11 15:12:08 | freights | 1 | 82945 | 3 | 1.266 | 65517.4 |
187 | 2023-04-08 00:51:23 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
186 | 2023-03-15 13:20:01 | freights | 3 | 146162 | 113 | 6.186 | 23627.9 |
185 | 2023-03-05 19:36:10 | freights | 1 | 82945 | 3 | 1.343 | 61761.0 |
184 | 2022-12-27 16:17:10 | freights | 1 | 82945 | 3 | 1.236 | 67107.6 |
183 | 2022-12-19 01:21:06 | freights | 1 | 82945 | 3 | 1.436 | 57761.1 |
182 | 2022-12-19 01:17:49 | freights | 3 | 146162 | 113 | 6.390 | 22873.6 |
181 | 2022-11-28 08:23:37 | freights | 3 | 146162 | 113 | 6.423 | 22756.0 |
180 | 2022-11-26 17:19:05 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
179 | 2022-11-24 22:43:41 | freights | 1 | 82945 | 3 | 1.423 | 58288.8 |
178 | 2022-11-22 10:26:56 | freights | 1 | 82945 | 3 | 1.406 | 58993.6 |
177 | 2022-10-21 04:34:32 | freights | 3 | 146162 | 113 | 6.346 | 23032.1 |
176 | 2022-09-16 21:09:28 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
175 | 2022-08-15 07:45:44 | freights | 3 | 146162 | 113 | 6.610 | 22112.3 |
174 | 2022-08-12 10:30:58 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
173 | 2022-07-19 01:19:35 | freights | 1 | 82945 | 3 | 1.266 | 65517.4 |
172 | 2022-07-03 00:45:41 | freights | 1 | 82945 | 3 | 1.266 | 65517.4 |
171 | 2022-06-30 19:29:09 | freights | 1 | 82945 | 3 | 1.216 | 68211.3 |
170 | 2022-06-18 02:25:11 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
169 | 2022-05-04 22:30:29 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
168 | 2022-04-01 02:46:29 | freights | 1 | 82945 | 3 | 1.830 | 45325.1 |
167 | 2022-03-07 20:09:40 | freights | 1 | 82945 | 3 | 1.670 | 49667.7 |
166 | 2021-12-14 02:41:04 | freights | 1 | 82945 | 3 | 1.373 | 60411.5 |
165 | 2021-12-11 03:51:46 | freights | 1 | 82945 | 3 | 1.453 | 57085.3 |
164 | 2021-10-25 09:16:11 | freights | 1 | 82945 | 3 | 1.236 | 67107.6 |
163 | 2021-10-23 12:11:35 | freights | 1 | 82945 | 3 | 1.376 | 60279.8 |
162 | 2021-10-23 09:11:44 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
161 | 2021-09-11 08:20:35 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
160 | 2021-09-09 03:41:19 | freights | 1 | 82945 | 3 | 1.423 | 58288.8 |
159 | 2021-08-28 05:58:55 | freights | 1 | 82945 | 3 | 1.250 | 66356.0 |
158 | 2021-08-20 08:02:43 | freights | 1 | 82945 | 3 | 1.436 | 57761.1 |
157 | 2021-08-14 22:18:21 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
156 | 2021-06-02 23:49:57 | freights | 1 | 82945 | 3 | 1.406 | 58993.6 |
155 | 2021-05-27 11:35:25 | freights | 1 | 82945 | 3 | 1.456 | 56967.7 |
154 | 2021-05-08 18:53:10 | freights | 1 | 82945 | 3 | 1.626 | 51011.7 |
153 | 2021-04-07 06:14:00 | freights | 1 | 82945 | 3 | 1.263 | 65673.0 |
152 | 2021-04-02 19:46:40 | freights | 1 | 82945 | 3 | 1.423 | 58288.8 |
151 | 2021-02-22 04:42:34 | freights | 1 | 82945 | 3 | 1.390 | 59672.7 |
150 | 2021-01-22 05:54:25 | freights | 1 | 82945 | 3 | 1.360 | 60989.0 |
149 | 2020-12-23 10:08:46 | freights | 1 | 82945 | 3 | 2.546 | 32578.6 |
148 | 2020-11-19 03:17:24 | freights | 1 | 82945 | 3 | 1.500 | 55296.7 |
147 | 2020-11-07 03:05:19 | freights | 1 | 82945 | 3 | 1.720 | 48223.8 |
146 | 2020-10-29 03:08:22 | freights | 1 | 82945 | 3 | 1.420 | 58412.0 |