History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gazetted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
235 | 2024-04-13 04:37:11 | gazetted | 1 | 82945 | 3 | 1.986 | 41764.9 |
234 | 2024-04-08 13:09:38 | gazetted | 3 | 146162 | 117 | 15.766 | 9270.7 |
233 | 2024-04-08 04:46:45 | gazetted | 2 | 121059 | 11 | 4.173 | 29010.1 |
232 | 2024-04-06 18:57:09 | gazetted | 1 | 82945 | 3 | 1.470 | 56425.2 |
231 | 2024-04-06 18:57:02 | gazetted | 2 | 121059 | 11 | 3.986 | 30371.0 |
230 | 2024-04-06 05:45:43 | gazetted | 3 | 146162 | 117 | 24.270 | 6022.3 |
229 | 2024-04-05 05:55:05 | gazetted | 3 | 146162 | 117 | 8.360 | 17483.5 |
228 | 2024-04-05 03:50:44 | gazetted | 1 | 82945 | 3 | 5.310 | 15620.5 |
227 | 2024-04-04 07:25:55 | gazetted | 3 | 146162 | 117 | 19.673 | 7429.6 |
226 | 2024-04-04 07:25:54 | gazetted | 2 | 121059 | 11 | 6.013 | 20132.9 |
225 | 2024-04-04 07:25:49 | gazetted | 1 | 82945 | 3 | 3.170 | 26165.6 |
224 | 2024-03-28 04:58:59 | gazetted | 1 | 82945 | 3 | 1.233 | 67270.9 |
223 | 2024-03-14 10:47:17 | gazetted | 2 | 121059 | 11 | 7.796 | 15528.3 |
222 | 2024-03-07 09:09:10 | gazetted | 1 | 82945 | 3 | 6.326 | 13111.8 |
221 | 2024-03-06 15:33:47 | gazetted | 1 | 82945 | 3 | 4.873 | 17021.3 |
220 | 2024-03-06 14:57:59 | gazetted | 2 | 121059 | 11 | 4.203 | 28803.0 |
219 | 2024-03-06 00:23:00 | gazetted | 3 | 146162 | 117 | 15.016 | 9733.8 |
218 | 2024-03-04 23:37:34 | gazetted | 1 | 82945 | 3 | 1.263 | 65673.0 |
217 | 2024-03-04 13:07:27 | gazetted | 3 | 146162 | 117 | 25.813 | 5662.3 |
216 | 2024-03-04 02:15:43 | gazetted | 2 | 121059 | 11 | 6.470 | 18710.8 |
215 | 2024-03-04 02:10:01 | gazetted | 3 | 146162 | 117 | 6.580 | 22213.1 |
214 | 2024-03-03 21:08:36 | gazetted | 2 | 121059 | 11 | 3.296 | 36729.1 |
213 | 2024-03-03 21:08:07 | gazetted | 3 | 146162 | 117 | 7.110 | 20557.2 |
212 | 2024-03-02 07:12:30 | gazetted | 3 | 146162 | 117 | 8.123 | 17993.6 |
211 | 2024-03-02 07:12:29 | gazetted | 2 | 121059 | 11 | 7.903 | 15318.1 |
210 | 2024-03-02 07:12:26 | gazetted | 1 | 82945 | 3 | 1.576 | 52630.1 |
209 | 2024-02-22 00:39:28 | gazetted | 1 | 82945 | 3 | 1.483 | 55930.5 |
208 | 2024-02-05 08:05:21 | gazetted | 3 | 146162 | 117 | 8.330 | 17546.5 |
207 | 2024-02-02 19:31:20 | gazetted | 2 | 121059 | 11 | 3.673 | 32959.2 |
206 | 2024-02-02 19:21:20 | gazetted | 3 | 146162 | 117 | 11.343 | 12885.7 |
205 | 2024-01-31 14:38:27 | gazetted | 3 | 146162 | 117 | 6.486 | 22535.0 |
204 | 2024-01-31 14:38:23 | gazetted | 2 | 121059 | 11 | 3.546 | 34139.6 |
203 | 2024-01-31 14:38:15 | gazetted | 1 | 82945 | 3 | 1.376 | 60279.8 |
202 | 2024-01-30 02:22:42 | gazetted | 1 | 82945 | 3 | 1.436 | 57761.1 |
201 | 2024-01-24 05:02:22 | gazetted | 1 | 82945 | 3 | 1.296 | 64000.8 |
200 | 2023-12-31 17:18:52 | gazetted | 1 | 82945 | 3 | 1.436 | 57761.1 |
199 | 2023-12-17 12:11:48 | gazetted | 3 | 146162 | 117 | 6.186 | 23627.9 |
198 | 2023-12-08 00:08:35 | gazetted | 1 | 82945 | 3 | 2.876 | 28840.4 |
197 | 2023-11-26 08:12:11 | gazetted | 2 | 121059 | 11 | 3.483 | 34757.1 |
196 | 2023-11-18 21:08:00 | gazetted | 1 | 82945 | 3 | 1.360 | 60989.0 |
195 | 2023-10-06 14:23:40 | gazetted | 1 | 82945 | 3 | 1.313 | 63172.1 |
194 | 2023-09-24 03:19:17 | gazetted | 3 | 146162 | 117 | 14.313 | 10211.8 |
193 | 2023-09-19 05:49:31 | gazetted | 3 | 146162 | 117 | 6.313 | 23152.5 |
192 | 2023-09-05 21:15:54 | gazetted | 1 | 82945 | 3 | 1.263 | 65673.0 |
191 | 2023-08-26 14:48:28 | gazetted | 2 | 121059 | 11 | 3.486 | 34727.2 |
190 | 2023-06-16 02:23:33 | gazetted | 3 | 146162 | 117 | 7.110 | 20557.2 |
189 | 2023-06-08 01:53:48 | gazetted | 1 | 82945 | 3 | 1.216 | 68211.3 |
188 | 2023-06-03 07:06:04 | gazetted | 1 | 82945 | 3 | 1.233 | 67270.9 |
187 | 2023-05-31 00:46:45 | gazetted | 1 | 82945 | 3 | 1.373 | 60411.5 |
186 | 2023-05-11 20:50:27 | gazetted | 2 | 121059 | 11 | 3.093 | 39139.7 |
185 | 2023-03-27 13:40:39 | gazetted | 1 | 82945 | 3 | 1.280 | 64800.8 |
184 | 2023-03-14 07:26:57 | gazetted | 3 | 146162 | 117 | 14.440 | 10122.0 |
183 | 2023-03-04 08:10:46 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
182 | 2023-02-16 22:25:50 | gazetted | 2 | 121059 | 11 | 3.423 | 35366.3 |
181 | 2023-01-28 10:54:36 | gazetted | 1 | 82945 | 3 | 1.233 | 67270.9 |
180 | 2023-01-24 19:39:00 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
179 | 2023-01-11 00:19:49 | gazetted | 1 | 82945 | 3 | 2.750 | 30161.8 |
178 | 2022-12-16 16:16:52 | gazetted | 3 | 146162 | 117 | 6.016 | 24295.5 |
177 | 2022-11-28 20:31:40 | gazetted | 2 | 121059 | 11 | 3.046 | 39743.6 |
176 | 2022-10-18 13:03:31 | gazetted | 1 | 82945 | 3 | 1.220 | 67987.7 |
175 | 2022-09-18 20:47:10 | gazetted | 1 | 82945 | 3 | 1.266 | 65517.4 |
174 | 2022-08-07 02:44:15 | gazetted | 3 | 146162 | 117 | 6.173 | 23677.6 |
173 | 2022-07-07 14:00:28 | gazetted | 2 | 121059 | 11 | 3.123 | 38763.7 |
172 | 2022-06-07 13:55:13 | gazetted | 1 | 82945 | 3 | 1.280 | 64800.8 |
171 | 2022-05-16 03:39:28 | gazetted | 1 | 82945 | 3 | 1.376 | 60279.8 |
170 | 2022-05-09 17:11:24 | gazetted | 1 | 82945 | 3 | 1.470 | 56425.2 |
169 | 2022-02-16 12:41:52 | gazetted | 2 | 121059 | 11 | 3.623 | 33414.0 |
168 | 2022-02-10 21:58:58 | gazetted | 1 | 82945 | 3 | 1.266 | 65517.4 |
167 | 2022-01-08 14:29:30 | gazetted | 1 | 82945 | 3 | 3.093 | 26817.0 |
166 | 2021-12-01 16:22:50 | gazetted | 2 | 121059 | 11 | 3.233 | 37444.8 |
165 | 2021-11-26 07:19:18 | gazetted | 1 | 82945 | 3 | 1.313 | 63172.1 |
164 | 2021-10-24 07:51:35 | gazetted | 1 | 82945 | 3 | 1.516 | 54713.1 |
163 | 2021-10-24 07:43:08 | gazetted | 1 | 82945 | 3 | 1.420 | 58412.0 |
162 | 2021-09-16 11:07:26 | gazetted | 1 | 82945 | 3 | 1.296 | 64000.8 |
161 | 2021-07-03 12:27:08 | gazetted | 3 | 146162 | 117 | 6.483 | 22545.4 |
160 | 2021-06-16 13:28:40 | gazetted | 1 | 82945 | 3 | 1.376 | 60279.8 |
159 | 2021-04-16 01:13:41 | gazetted | 3 | 146162 | 117 | 6.596 | 22159.2 |
158 | 2021-03-13 16:37:16 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
157 | 2021-03-12 05:20:34 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
156 | 2021-02-22 00:23:54 | gazetted | 3 | 146162 | 117 | 6.300 | 23200.3 |
155 | 2021-01-22 23:55:03 | gazetted | 1 | 82945 | 3 | 1.423 | 58288.8 |
154 | 2020-12-24 08:50:19 | gazetted | 1 | 82945 | 3 | 1.593 | 52068.4 |
153 | 2020-12-06 17:04:33 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
152 | 2020-10-17 20:41:21 | gazetted | 1 | 82945 | 3 | 1.373 | 60411.5 |
151 | 2020-08-28 07:57:32 | gazetted | 1 | 82945 | 3 | 1.580 | 52496.8 |
150 | 2020-07-17 17:23:04 | gazetted | 1 | 82945 | 3 | 1.593 | 52068.4 |
149 | 2020-05-20 15:50:29 | gazetted | 1 | 82945 | 3 | 1.250 | 66356.0 |
148 | 2020-03-28 19:10:33 | gazetted | 1 | 82945 | 3 | 1.516 | 54713.1 |
147 | 2020-02-23 18:17:59 | gazetted | 1 | 82945 | 3 | 2.233 | 37145.1 |
146 | 2020-02-22 17:19:28 | gazetted | 1 | 82945 | 3 | 1.560 | 53169.9 |
145 | 2020-02-09 20:22:51 | gazetted | 1 | 82945 | 3 | 2.783 | 29804.2 |
144 | 2020-02-09 18:17:39 | gazetted | 1 | 82945 | 3 | 2.326 | 35659.9 |
143 | 2020-02-08 21:18:08 | gazetted | 1 | 82945 | 3 | 1.530 | 54212.4 |
142 | 2020-02-03 09:39:34 | gazetted | 1 | 82945 | 3 | 3.250 | 25521.5 |
141 | 2020-01-29 19:09:05 | gazetted | 1 | 82945 | 3 | 1.360 | 60989.0 |
140 | 2020-01-26 17:01:08 | gazetted | 1 | 82945 | 3 | 1.580 | 52496.8 |
139 | 2020-01-25 17:33:55 | gazetted | 1 | 82945 | 3 | 4.890 | 16962.2 |
138 | 2020-01-18 08:24:26 | gazetted | 1 | 82945 | 3 | 1.406 | 58993.6 |
137 | 2020-01-14 11:22:47 | gazetted | 1 | 82945 | 3 | 1.516 | 54713.1 |
136 | 2020-01-03 00:11:32 | gazetted | 1 | 82945 | 3 | 2.720 | 30494.5 |