History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roadblocks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
255 | 2024-04-27 15:28:57 | roadblocks | 3 | 140603 | 13 | 24.423 | 5757.0 |
254 | 2024-04-27 10:33:39 | roadblocks | 4 | 161450 | 70 | 31.093 | 5192.5 |
253 | 2024-04-16 06:20:46 | roadblocks | 1 | 67641 | 2 | 1.376 | 49157.7 |
252 | 2024-03-30 12:45:27 | roadblocks | 1 | 67641 | 2 | 5.310 | 12738.4 |
251 | 2024-03-28 02:51:39 | roadblocks | 1 | 67641 | 2 | 1.186 | 57032.9 |
250 | 2024-03-26 12:29:57 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
249 | 2024-03-05 09:56:57 | roadblocks | 4 | 161450 | 70 | 30.376 | 5315.1 |
248 | 2024-03-01 07:20:40 | roadblocks | 1 | 67641 | 2 | 1.296 | 52192.1 |
247 | 2024-02-25 20:00:54 | roadblocks | 3 | 140603 | 13 | 9.470 | 14847.2 |
246 | 2024-02-25 20:00:56 | roadblocks | 2 | 108824 | 4 | 4.546 | 23938.4 |
245 | 2024-02-25 20:00:48 | roadblocks | 1 | 67641 | 2 | 2.500 | 27056.4 |
244 | 2024-02-25 07:57:47 | roadblocks | 1 | 67641 | 2 | 1.076 | 62863.4 |
243 | 2024-02-20 02:56:24 | roadblocks | 4 | 161450 | 70 | 38.720 | 4169.7 |
242 | 2024-02-17 20:50:03 | roadblocks | 4 | 161450 | 70 | 14.093 | 11456.0 |
241 | 2024-02-17 05:58:49 | roadblocks | 5 | 173545 | 373 | 57.816 | 3001.7 |
240 | 2024-02-15 17:23:31 | roadblocks | 5 | 173545 | 373 | 61.160 | 2837.6 |
239 | 2024-02-15 08:05:07 | roadblocks | 5 | 173545 | 373 | 24.690 | 7029.0 |
238 | 2024-02-15 08:05:10 | roadblocks | 4 | 161450 | 70 | 14.156 | 11405.1 |
237 | 2024-02-15 08:05:11 | roadblocks | 3 | 140603 | 13 | 11.843 | 11872.2 |
236 | 2024-02-15 08:05:06 | roadblocks | 2 | 108824 | 4 | 3.830 | 28413.6 |
235 | 2024-02-15 07:36:21 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
234 | 2024-02-13 08:21:17 | roadblocks | 2 | 108824 | 4 | 3.033 | 35880.0 |
233 | 2024-02-12 23:10:19 | roadblocks | 1 | 67641 | 2 | 1.140 | 59334.2 |
232 | 2024-02-03 21:03:29 | roadblocks | 1 | 67641 | 2 | 1.110 | 60937.8 |
231 | 2024-01-26 04:05:39 | roadblocks | 1 | 67641 | 2 | 2.423 | 27916.2 |
230 | 2024-01-01 00:52:53 | roadblocks | 1 | 67641 | 2 | 1.046 | 64666.3 |
229 | 2023-12-01 00:03:56 | roadblocks | 1 | 67641 | 2 | 1.236 | 54725.7 |
228 | 2023-11-13 01:18:03 | roadblocks | 2 | 108824 | 4 | 2.703 | 40260.5 |
227 | 2023-10-25 09:07:20 | roadblocks | 1 | 67641 | 2 | 1.030 | 65670.9 |
226 | 2023-10-17 08:25:12 | roadblocks | 1 | 67641 | 2 | 2.610 | 25916.1 |
225 | 2023-09-15 17:31:00 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
224 | 2023-08-16 03:23:02 | roadblocks | 2 | 108824 | 4 | 3.250 | 33484.3 |
223 | 2023-07-08 23:30:09 | roadblocks | 1 | 67641 | 2 | 1.110 | 60937.8 |
222 | 2023-05-14 13:05:15 | roadblocks | 1 | 67641 | 2 | 1.186 | 57032.9 |
221 | 2023-04-28 07:15:10 | roadblocks | 2 | 108824 | 4 | 3.076 | 35378.4 |
220 | 2023-04-16 04:03:31 | roadblocks | 1 | 67641 | 2 | 1.013 | 66773.0 |
219 | 2023-02-08 10:12:48 | roadblocks | 1 | 67641 | 2 | 1.140 | 59334.2 |
218 | 2023-02-01 05:31:32 | roadblocks | 2 | 108824 | 4 | 3.063 | 35528.6 |
217 | 2022-12-22 13:16:46 | roadblocks | 1 | 67641 | 2 | 1.046 | 64666.3 |
216 | 2022-11-14 18:08:53 | roadblocks | 2 | 108824 | 4 | 2.720 | 40008.8 |
215 | 2022-07-15 10:16:29 | roadblocks | 1 | 67641 | 2 | 1.016 | 66575.8 |
214 | 2022-07-09 12:54:48 | roadblocks | 1 | 67641 | 2 | 1.046 | 64666.3 |
213 | 2022-05-14 21:22:29 | roadblocks | 2 | 108824 | 4 | 2.673 | 40712.3 |
212 | 2022-03-03 10:11:29 | roadblocks | 1 | 67641 | 2 | 1.423 | 47534.1 |
211 | 2022-01-25 14:55:22 | roadblocks | 1 | 67641 | 2 | 1.220 | 55443.4 |
210 | 2021-09-24 01:37:25 | roadblocks | 3 | 140603 | 13 | 6.250 | 22496.5 |
209 | 2021-09-03 17:11:28 | roadblocks | 1 | 67641 | 2 | 1.140 | 59334.2 |
208 | 2021-05-14 03:06:23 | roadblocks | 1 | 67641 | 2 | 1.343 | 50365.6 |
207 | 2021-02-01 00:50:56 | roadblocks | 1 | 67641 | 2 | 1.030 | 65670.9 |
206 | 2020-10-27 03:44:35 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
205 | 2020-10-09 04:53:47 | roadblocks | 1 | 67641 | 2 | 1.030 | 65670.9 |
204 | 2020-05-20 21:36:47 | roadblocks | 1 | 67641 | 2 | 1.046 | 64666.3 |
203 | 2020-02-20 13:04:06 | roadblocks | 4 | 161450 | 70 | 22.936 | 7039.2 |
202 | 2020-02-13 08:00:54 | roadblocks | 1 | 67641 | 2 | 1.390 | 48662.6 |
201 | 2020-02-11 03:51:56 | roadblocks | 4 | 161450 | 70 | 24.186 | 6675.3 |
200 | 2020-02-11 02:04:25 | roadblocks | 4 | 161450 | 70 | 17.093 | 9445.4 |
199 | 2020-02-10 09:24:17 | roadblocks | 4 | 161450 | 70 | 14.313 | 11280.0 |
198 | 2020-02-10 08:38:33 | roadblocks | 1 | 67641 | 2 | 1.280 | 52844.5 |
197 | 2020-02-09 23:12:14 | roadblocks | 1 | 67641 | 2 | 2.250 | 30062.7 |
196 | 2020-01-25 10:43:55 | roadblocks | 4 | 161450 | 70 | 31.113 | 5189.1 |
195 | 2020-01-22 17:54:15 | roadblocks | 2 | 108824 | 4 | 3.016 | 36082.2 |
194 | 2020-01-22 11:52:25 | roadblocks | 3 | 140603 | 13 | 7.376 | 19062.2 |
193 | 2020-01-22 11:52:04 | roadblocks | 4 | 161450 | 70 | 19.720 | 8187.1 |
192 | 2020-01-22 08:16:34 | roadblocks | 1 | 67641 | 2 | 1.310 | 51634.4 |
191 | 2020-01-19 09:41:05 | roadblocks | 1 | 67641 | 2 | 1.170 | 57812.8 |
190 | 2020-01-16 17:24:18 | roadblocks | 3 | 140603 | 13 | 10.393 | 13528.6 |
189 | 2020-01-16 09:44:08 | roadblocks | 1 | 67641 | 2 | 1.406 | 48108.8 |
188 | 2020-01-09 21:12:59 | roadblocks | 4 | 161450 | 70 | 12.390 | 13030.7 |
187 | 2020-01-07 02:36:35 | roadblocks | 4 | 161450 | 70 | 33.626 | 4801.3 |
186 | 2020-01-06 21:42:28 | roadblocks | 4 | 161450 | 70 | 40.673 | 3969.5 |
185 | 2020-01-06 21:41:28 | roadblocks | 5 | 173545 | 373 | 39.130 | 4435.1 |
184 | 2020-01-06 21:40:35 | roadblocks | 2 | 108824 | 4 | 9.003 | 12087.5 |
183 | 2020-01-06 21:36:32 | roadblocks | 3 | 140603 | 13 | 6.873 | 20457.3 |
182 | 2020-01-06 18:04:49 | roadblocks | 1 | 67641 | 2 | 1.173 | 57665.0 |
181 | 2019-10-20 00:24:49 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
180 | 2019-07-23 20:40:55 | roadblocks | 1 | 67641 | 2 | 1.143 | 59178.5 |
179 | 2019-06-20 02:40:56 | roadblocks | 1 | 67641 | 2 | 1.006 | 67237.6 |
178 | 2019-02-07 16:12:20 | roadblocks | 1 | 67641 | 2 | 1.123 | 60232.4 |
177 | 2019-01-04 08:08:05 | roadblocks | 1 | 67641 | 2 | 1.156 | 58513.0 |
176 | 2018-12-18 00:55:07 | roadblocks | 1 | 67641 | 2 | 1.000 | 67641.0 |
175 | 2018-11-19 19:33:49 | roadblocks | 1 | 67641 | 2 | 0.993 | 68117.8 |
174 | 2018-10-03 21:57:54 | roadblocks | 1 | 67641 | 2 | 0.993 | 68117.8 |
173 | 2018-09-11 05:18:46 | roadblocks | 1 | 67641 | 2 | 1.170 | 57812.8 |
172 | 2018-06-19 22:59:46 | roadblocks | 1 | 67641 | 2 | 1.096 | 61716.2 |
171 | 2018-06-19 18:44:31 | roadblocks | 1 | 67641 | 2 | 1.143 | 59178.5 |
170 | 2018-05-28 05:35:35 | roadblocks | 1 | 67641 | 2 | 0.990 | 68324.2 |
169 | 2018-04-17 22:08:56 | roadblocks | 1 | 67641 | 2 | 0.993 | 68117.8 |
168 | 2018-03-22 16:54:03 | roadblocks | 1 | 67641 | 2 | 3.023 | 22375.5 |
167 | 2017-12-11 00:35:54 | roadblocks | 1 | 67641 | 2 | 1.826 | 37043.3 |
166 | 2017-11-15 04:47:12 | roadblocks | 1 | 67641 | 2 | 1.490 | 45396.6 |
165 | 2017-11-09 19:37:23 | roadblocks | 1 | 67641 | 2 | 2.216 | 30523.9 |
164 | 2017-10-27 16:28:59 | roadblocks | 1 | 67641 | 2 | 3.006 | 22502.0 |
163 | 2017-07-05 03:28:46 | roadblocks | 1 | 67641 | 2 | 1.333 | 50743.4 |
162 | 2016-12-11 23:13:08 | roadblocks | 1 | 67641 | 2 | 1.513 | 44706.5 |
161 | 2016-11-29 08:27:51 | roadblocks | 1 | 67641 | 2 | 1.466 | 46139.8 |
160 | 2016-11-11 10:28:02 | roadblocks | 1 | 67641 | 2 | 1.420 | 47634.5 |
159 | 2016-11-09 07:39:51 | roadblocks | 1 | 67641 | 2 | 1.543 | 43837.3 |
158 | 2016-11-03 18:57:58 | roadblocks | 1 | 67641 | 2 | 1.476 | 45827.2 |
157 | 2016-10-30 20:37:11 | roadblocks | 1 | 67641 | 2 | 1.480 | 45703.4 |
156 | 2016-10-29 07:21:39 | roadblocks | 1 | 67641 | 2 | 1.446 | 46778.0 |