History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roadworks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
219 | 2024-04-19 19:56:33 | roadworks | 2 | 121436 | 7 | 6.016 | 20185.5 |
218 | 2024-04-19 19:56:10 | roadworks | 1 | 81242 | 2 | 4.253 | 19102.3 |
217 | 2024-04-16 08:49:58 | roadworks | 2 | 121436 | 7 | 9.003 | 13488.4 |
216 | 2024-04-16 07:43:29 | roadworks | 1 | 81242 | 2 | 1.656 | 49059.2 |
215 | 2024-04-09 16:01:01 | roadworks | 4 | 165329 | 272 | 43.130 | 3833.3 |
214 | 2024-04-07 16:42:01 | roadworks | 3 | 148641 | 51 | 9.810 | 15152.0 |
213 | 2024-04-07 11:59:45 | roadworks | 3 | 148641 | 51 | 31.440 | 4727.8 |
212 | 2024-04-04 16:35:00 | roadworks | 3 | 148641 | 51 | 28.346 | 5243.8 |
211 | 2024-04-03 22:00:08 | roadworks | 4 | 165329 | 272 | 34.313 | 4818.3 |
210 | 2024-04-03 01:27:19 | roadworks | 4 | 165329 | 272 | 31.736 | 5209.5 |
209 | 2024-04-03 00:28:27 | roadworks | 4 | 165329 | 272 | 44.130 | 3746.4 |
208 | 2024-04-01 18:31:41 | roadworks | 2 | 121436 | 7 | 8.326 | 14585.2 |
207 | 2024-04-01 16:09:24 | roadworks | 4 | 165329 | 272 | 15.173 | 10896.3 |
206 | 2024-04-01 16:09:21 | roadworks | 3 | 148641 | 51 | 8.360 | 17780.0 |
205 | 2024-04-01 16:09:26 | roadworks | 1 | 81242 | 2 | 2.500 | 32496.8 |
204 | 2024-04-01 16:09:20 | roadworks | 2 | 121436 | 7 | 4.203 | 28892.7 |
203 | 2024-04-01 16:09:13 | roadworks | 1 | 81242 | 2 | 1.453 | 55913.3 |
202 | 2024-03-31 23:30:00 | roadworks | 1 | 81242 | 2 | 1.530 | 53099.3 |
201 | 2024-03-19 22:15:04 | roadworks | 1 | 81242 | 2 | 1.330 | 61084.2 |
200 | 2024-03-06 02:16:14 | roadworks | 1 | 81242 | 2 | 4.143 | 19609.5 |
199 | 2024-03-05 08:41:07 | roadworks | 1 | 81242 | 2 | 3.296 | 24648.7 |
198 | 2024-03-03 06:27:10 | roadworks | 4 | 165329 | 272 | 15.613 | 10589.2 |
197 | 2024-03-01 22:48:27 | roadworks | 4 | 165329 | 272 | 33.126 | 4990.9 |
196 | 2024-03-01 22:48:28 | roadworks | 3 | 148641 | 51 | 19.453 | 7641.0 |
195 | 2024-03-01 22:48:35 | roadworks | 2 | 121436 | 7 | 8.733 | 13905.4 |
194 | 2024-03-01 22:48:05 | roadworks | 1 | 81242 | 2 | 4.266 | 19044.1 |
193 | 2024-03-01 16:05:17 | roadworks | 1 | 81242 | 2 | 2.640 | 30773.5 |
192 | 2024-02-08 09:36:46 | roadworks | 1 | 81242 | 2 | 1.610 | 50460.9 |
191 | 2024-02-03 20:55:57 | roadworks | 1 | 81242 | 2 | 1.420 | 57212.7 |
190 | 2024-01-29 23:30:55 | roadworks | 1 | 81242 | 2 | 1.393 | 58321.6 |
189 | 2024-01-17 04:44:35 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
188 | 2023-12-14 15:23:53 | roadworks | 1 | 81242 | 2 | 1.236 | 65729.8 |
187 | 2023-12-04 18:39:24 | roadworks | 2 | 121436 | 7 | 3.233 | 37561.4 |
186 | 2023-11-29 05:21:26 | roadworks | 1 | 81242 | 2 | 1.470 | 55266.7 |
185 | 2023-11-10 00:12:41 | roadworks | 1 | 81242 | 2 | 1.343 | 60492.9 |
184 | 2023-09-14 21:18:19 | roadworks | 1 | 81242 | 2 | 1.360 | 59736.8 |
183 | 2023-09-14 06:38:43 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
182 | 2023-09-02 14:23:44 | roadworks | 2 | 121436 | 7 | 3.403 | 35685.0 |
181 | 2023-08-31 05:57:19 | roadworks | 1 | 81242 | 2 | 1.296 | 62686.7 |
180 | 2023-06-30 23:40:44 | roadworks | 1 | 81242 | 2 | 1.266 | 64172.2 |
179 | 2023-05-22 19:15:19 | roadworks | 2 | 121436 | 7 | 3.140 | 38673.9 |
178 | 2023-05-22 01:55:50 | roadworks | 1 | 81242 | 2 | 1.220 | 66591.8 |
177 | 2023-04-22 05:48:23 | roadworks | 1 | 81242 | 2 | 1.390 | 58447.5 |
176 | 2023-04-20 23:03:48 | roadworks | 1 | 81242 | 2 | 1.423 | 57092.1 |
175 | 2023-04-09 19:41:57 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
174 | 2023-04-07 21:55:20 | roadworks | 1 | 81242 | 2 | 1.500 | 54161.3 |
173 | 2023-03-02 20:41:32 | roadworks | 2 | 121436 | 7 | 3.436 | 35342.3 |
172 | 2023-01-30 19:56:35 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
171 | 2022-12-09 10:50:10 | roadworks | 2 | 121436 | 7 | 3.080 | 39427.3 |
170 | 2022-12-09 01:00:03 | roadworks | 1 | 81242 | 2 | 1.283 | 63321.9 |
169 | 2022-11-28 16:20:40 | roadworks | 1 | 81242 | 2 | 1.280 | 63470.3 |
168 | 2022-07-24 09:10:43 | roadworks | 2 | 121436 | 7 | 3.250 | 37364.9 |
167 | 2022-07-23 19:23:31 | roadworks | 1 | 81242 | 2 | 1.330 | 61084.2 |
166 | 2022-07-22 13:30:24 | roadworks | 1 | 81242 | 2 | 1.250 | 64993.6 |
165 | 2022-03-29 11:41:22 | roadworks | 1 | 81242 | 2 | 1.810 | 44885.1 |
164 | 2022-03-27 08:12:30 | roadworks | 1 | 81242 | 2 | 1.266 | 64172.2 |
163 | 2022-03-11 03:54:43 | roadworks | 1 | 81242 | 2 | 1.940 | 41877.3 |
162 | 2022-03-02 01:00:02 | roadworks | 2 | 121436 | 7 | 3.296 | 36843.4 |
161 | 2022-02-13 16:14:35 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
160 | 2021-12-31 05:25:10 | roadworks | 1 | 81242 | 2 | 1.580 | 51419.0 |
159 | 2021-12-31 02:54:46 | roadworks | 1 | 81242 | 2 | 1.423 | 57092.1 |
158 | 2021-12-28 23:20:52 | roadworks | 1 | 81242 | 2 | 1.296 | 62686.7 |
157 | 2021-11-28 00:30:31 | roadworks | 2 | 121436 | 7 | 4.093 | 29669.2 |
156 | 2021-11-25 22:24:44 | roadworks | 2 | 121436 | 7 | 3.266 | 37181.9 |
155 | 2021-10-31 13:10:21 | roadworks | 1 | 81242 | 2 | 1.220 | 66591.8 |
154 | 2021-10-29 13:38:18 | roadworks | 1 | 81242 | 2 | 1.686 | 48186.2 |
153 | 2021-10-01 04:26:35 | roadworks | 2 | 121436 | 7 | 3.170 | 38307.9 |
152 | 2021-09-22 04:26:38 | roadworks | 1 | 81242 | 2 | 2.546 | 31909.7 |
151 | 2021-09-04 21:21:30 | roadworks | 1 | 81242 | 2 | 1.233 | 65889.7 |
150 | 2021-07-17 20:37:52 | roadworks | 1 | 81242 | 2 | 1.360 | 59736.8 |
149 | 2021-05-06 10:03:20 | roadworks | 1 | 81242 | 2 | 1.576 | 51549.5 |
148 | 2021-04-15 01:48:57 | roadworks | 1 | 81242 | 2 | 1.440 | 56418.1 |
147 | 2021-04-02 21:52:54 | roadworks | 3 | 148641 | 51 | 7.250 | 20502.2 |
146 | 2021-02-23 17:00:58 | roadworks | 1 | 81242 | 2 | 1.420 | 57212.7 |
145 | 2021-01-19 22:37:29 | roadworks | 1 | 81242 | 2 | 1.440 | 56418.1 |
144 | 2021-01-17 21:46:51 | roadworks | 3 | 148641 | 51 | 7.846 | 18944.8 |
143 | 2021-01-01 12:16:25 | roadworks | 1 | 81242 | 2 | 1.343 | 60492.9 |
142 | 2020-11-18 03:20:46 | roadworks | 1 | 81242 | 2 | 1.390 | 58447.5 |
141 | 2020-11-01 21:16:56 | roadworks | 1 | 81242 | 2 | 1.310 | 62016.8 |
140 | 2020-10-29 11:43:49 | roadworks | 3 | 148641 | 51 | 7.596 | 19568.3 |
139 | 2020-10-05 08:07:36 | roadworks | 1 | 81242 | 2 | 1.250 | 64993.6 |
138 | 2020-09-25 10:11:30 | roadworks | 1 | 81242 | 2 | 1.390 | 58447.5 |
137 | 2020-05-29 18:08:30 | roadworks | 1 | 81242 | 2 | 1.236 | 65729.8 |
136 | 2020-03-23 20:06:54 | roadworks | 1 | 81242 | 2 | 1.546 | 52549.8 |
135 | 2020-03-01 03:24:08 | roadworks | 1 | 81242 | 2 | 1.466 | 55417.5 |
134 | 2020-02-29 15:43:10 | roadworks | 1 | 81242 | 2 | 1.513 | 53696.0 |
133 | 2020-02-20 12:53:40 | roadworks | 1 | 81242 | 2 | 1.453 | 55913.3 |
132 | 2020-02-19 17:53:16 | roadworks | 1 | 81242 | 2 | 1.406 | 57782.4 |
131 | 2020-02-19 09:20:01 | roadworks | 1 | 81242 | 2 | 2.890 | 28111.4 |
130 | 2020-02-10 06:57:23 | roadworks | 1 | 81242 | 2 | 1.500 | 54161.3 |
129 | 2020-02-10 03:01:05 | roadworks | 1 | 81242 | 2 | 1.640 | 49537.8 |
128 | 2020-02-03 16:22:40 | roadworks | 1 | 81242 | 2 | 1.516 | 53589.7 |
127 | 2020-01-29 05:24:04 | roadworks | 1 | 81242 | 2 | 4.923 | 16502.5 |
126 | 2020-01-25 10:55:19 | roadworks | 1 | 81242 | 2 | 1.656 | 49059.2 |
125 | 2020-01-25 10:35:03 | roadworks | 1 | 81242 | 2 | 1.736 | 46798.4 |
124 | 2020-01-23 08:15:17 | roadworks | 1 | 81242 | 2 | 3.343 | 24302.1 |
123 | 2020-01-16 07:55:03 | roadworks | 1 | 81242 | 2 | 1.250 | 64993.6 |
122 | 2020-01-16 06:38:34 | roadworks | 1 | 81242 | 2 | 3.140 | 25873.2 |
121 | 2019-12-31 05:09:40 | roadworks | 1 | 81242 | 2 | 1.750 | 46424.0 |
120 | 2019-12-29 11:25:50 | roadworks | 1 | 81242 | 2 | 1.623 | 50056.7 |