History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"consular"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
219 | 2024-04-26 05:41:58 | consular | 3 | 146162 | 105 | 13.940 | 10485.1 |
218 | 2024-04-21 14:58:58 | consular | 3 | 146162 | 105 | 20.266 | 7212.2 |
217 | 2024-04-19 12:25:41 | consular | 3 | 146162 | 105 | 8.486 | 17223.9 |
216 | 2024-04-19 12:25:40 | consular | 2 | 121059 | 21 | 4.283 | 28265.0 |
215 | 2024-04-19 03:13:27 | consular | 3 | 146162 | 105 | 16.093 | 9082.3 |
214 | 2024-04-19 03:13:27 | consular | 2 | 121059 | 21 | 5.966 | 20291.5 |
213 | 2024-04-19 03:13:13 | consular | 1 | 82945 | 1 | 1.703 | 48705.2 |
212 | 2024-04-03 03:13:13 | consular | 3 | 146162 | 105 | 20.143 | 7256.2 |
211 | 2024-04-01 09:36:29 | consular | 1 | 82945 | 1 | 1.640 | 50576.2 |
210 | 2024-03-29 03:14:00 | consular | 2 | 121059 | 21 | 10.656 | 11360.6 |
209 | 2024-03-28 22:41:21 | consular | 3 | 146162 | 105 | 11.936 | 12245.5 |
208 | 2024-03-28 16:13:18 | consular | 3 | 146162 | 105 | 7.673 | 19048.9 |
207 | 2024-03-28 16:13:19 | consular | 2 | 121059 | 21 | 4.016 | 30144.2 |
206 | 2024-03-28 16:11:49 | consular | 1 | 82945 | 1 | 1.500 | 55296.7 |
205 | 2024-03-26 17:07:48 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
204 | 2024-03-18 17:27:28 | consular | 2 | 121059 | 21 | 3.390 | 35710.6 |
203 | 2024-03-18 17:27:12 | consular | 3 | 146162 | 105 | 7.750 | 18859.6 |
202 | 2024-03-18 11:31:45 | consular | 3 | 146162 | 105 | 15.343 | 9526.3 |
201 | 2024-03-18 11:31:44 | consular | 2 | 121059 | 21 | 4.126 | 29340.5 |
200 | 2024-03-15 10:11:46 | consular | 2 | 121059 | 21 | 8.173 | 14812.1 |
199 | 2024-03-15 10:00:17 | consular | 3 | 146162 | 105 | 9.783 | 14940.4 |
198 | 2024-03-14 18:30:52 | consular | 3 | 146162 | 105 | 23.426 | 6239.3 |
197 | 2024-03-14 18:30:43 | consular | 2 | 121059 | 21 | 8.753 | 13830.6 |
196 | 2024-03-14 18:24:32 | consular | 1 | 82945 | 1 | 1.470 | 56425.2 |
195 | 2024-02-09 08:40:53 | consular | 3 | 146162 | 105 | 15.190 | 9622.3 |
194 | 2024-02-09 03:59:42 | consular | 3 | 146162 | 105 | 19.080 | 7660.5 |
193 | 2024-02-04 10:08:24 | consular | 1 | 82945 | 1 | 2.406 | 34474.2 |
192 | 2023-12-21 18:58:00 | consular | 1 | 82945 | 1 | 1.610 | 51518.6 |
191 | 2023-12-20 21:53:24 | consular | 1 | 82945 | 1 | 1.436 | 57761.1 |
190 | 2023-12-06 13:15:34 | consular | 3 | 146162 | 105 | 6.906 | 21164.5 |
189 | 2023-12-04 08:42:45 | consular | 1 | 82945 | 1 | 1.453 | 57085.3 |
188 | 2023-12-02 22:06:22 | consular | 1 | 82945 | 1 | 1.326 | 62552.8 |
187 | 2023-11-27 12:48:09 | consular | 1 | 82945 | 1 | 1.390 | 59672.7 |
186 | 2023-11-11 02:00:55 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
185 | 2023-10-22 12:18:24 | consular | 1 | 82945 | 1 | 1.516 | 54713.1 |
184 | 2023-10-08 00:11:15 | consular | 1 | 82945 | 1 | 1.343 | 61761.0 |
183 | 2023-09-04 05:37:06 | consular | 3 | 146162 | 105 | 6.906 | 21164.5 |
182 | 2023-08-19 02:49:39 | consular | 1 | 82945 | 1 | 1.500 | 55296.7 |
181 | 2023-08-04 07:05:32 | consular | 1 | 82945 | 1 | 1.330 | 62364.7 |
180 | 2023-05-02 15:33:15 | consular | 1 | 82945 | 1 | 1.313 | 63172.1 |
179 | 2023-05-01 05:07:33 | consular | 1 | 82945 | 1 | 1.453 | 57085.3 |
178 | 2023-02-25 00:09:29 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
177 | 2023-02-12 06:04:01 | consular | 3 | 146162 | 105 | 6.470 | 22590.7 |
176 | 2023-01-15 05:05:28 | consular | 1 | 82945 | 1 | 1.423 | 58288.8 |
175 | 2022-11-23 00:24:40 | consular | 3 | 146162 | 105 | 6.513 | 22441.6 |
174 | 2022-09-16 19:50:57 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
173 | 2022-07-18 22:19:25 | consular | 1 | 82945 | 1 | 1.420 | 58412.0 |
172 | 2022-06-27 03:00:47 | consular | 3 | 146162 | 105 | 6.690 | 21847.8 |
171 | 2022-06-10 15:32:18 | consular | 2 | 121059 | 21 | 3.453 | 35059.1 |
170 | 2022-06-08 12:15:41 | consular | 2 | 121059 | 21 | 3.250 | 37248.9 |
169 | 2022-05-14 13:22:51 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
168 | 2022-05-11 02:28:05 | consular | 1 | 82945 | 1 | 1.483 | 55930.5 |
167 | 2022-04-07 07:50:36 | consular | 1 | 82945 | 1 | 1.576 | 52630.1 |
166 | 2022-04-05 04:16:31 | consular | 1 | 82945 | 1 | 1.546 | 53651.4 |
165 | 2022-04-02 23:48:25 | consular | 1 | 82945 | 1 | 1.360 | 60989.0 |
164 | 2022-02-09 13:53:04 | consular | 2 | 121059 | 21 | 3.673 | 32959.2 |
163 | 2022-01-23 22:14:58 | consular | 1 | 82945 | 1 | 1.436 | 57761.1 |
162 | 2022-01-23 07:16:59 | consular | 1 | 82945 | 1 | 1.626 | 51011.7 |
161 | 2022-01-21 18:49:17 | consular | 1 | 82945 | 1 | 1.313 | 63172.1 |
160 | 2021-10-10 05:04:15 | consular | 1 | 82945 | 1 | 1.440 | 57600.7 |
159 | 2021-07-08 09:04:26 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
158 | 2021-05-23 17:19:51 | consular | 1 | 82945 | 1 | 1.516 | 54713.1 |
157 | 2021-05-20 23:10:46 | consular | 1 | 82945 | 1 | 1.360 | 60989.0 |
156 | 2021-04-21 07:44:12 | consular | 1 | 82945 | 1 | 1.343 | 61761.0 |
155 | 2021-04-08 13:41:19 | consular | 1 | 82945 | 1 | 1.483 | 55930.5 |
154 | 2021-04-04 09:46:36 | consular | 1 | 82945 | 1 | 1.720 | 48223.8 |
153 | 2021-01-29 21:00:21 | consular | 1 | 82945 | 1 | 1.516 | 54713.1 |
152 | 2021-01-06 03:22:51 | consular | 1 | 82945 | 1 | 1.296 | 64000.8 |
151 | 2020-12-30 10:09:50 | consular | 1 | 82945 | 1 | 1.436 | 57761.1 |
150 | 2020-12-08 18:06:06 | consular | 1 | 82945 | 1 | 1.313 | 63172.1 |
149 | 2020-11-10 09:47:43 | consular | 1 | 82945 | 1 | 1.330 | 62364.7 |
148 | 2020-11-07 10:24:36 | consular | 1 | 82945 | 1 | 2.703 | 30686.3 |
147 | 2020-10-25 05:22:03 | consular | 1 | 82945 | 1 | 1.500 | 55296.7 |
146 | 2020-10-22 00:09:18 | consular | 1 | 82945 | 1 | 1.360 | 60989.0 |
145 | 2020-10-01 11:11:16 | consular | 1 | 82945 | 1 | 1.300 | 63803.8 |
144 | 2020-10-01 10:03:29 | consular | 1 | 82945 | 1 | 1.280 | 64800.8 |
143 | 2020-07-31 01:23:18 | consular | 1 | 82945 | 1 | 1.500 | 55296.7 |
142 | 2020-06-18 04:59:02 | consular | 1 | 82945 | 1 | 1.280 | 64800.8 |
141 | 2020-06-15 02:34:57 | consular | 1 | 82945 | 1 | 1.360 | 60989.0 |
140 | 2020-03-22 01:54:36 | consular | 1 | 82945 | 1 | 1.343 | 61761.0 |
139 | 2020-03-04 16:53:11 | consular | 1 | 82945 | 1 | 1.280 | 64800.8 |
138 | 2020-02-28 11:08:03 | consular | 1 | 82945 | 1 | 1.576 | 52630.1 |
137 | 2020-02-27 02:32:59 | consular | 1 | 82945 | 1 | 3.283 | 25265.0 |
136 | 2020-02-25 10:23:17 | consular | 1 | 82945 | 1 | 1.530 | 54212.4 |
135 | 2020-02-18 20:59:50 | consular | 1 | 82945 | 1 | 1.466 | 56579.1 |
134 | 2020-02-17 15:02:25 | consular | 1 | 82945 | 1 | 1.796 | 46183.2 |
133 | 2020-02-03 04:35:40 | consular | 1 | 82945 | 1 | 5.156 | 16087.1 |
132 | 2020-02-02 22:23:29 | consular | 1 | 82945 | 1 | 3.233 | 25655.7 |
131 | 2020-02-01 13:12:58 | consular | 1 | 82945 | 1 | 1.593 | 52068.4 |
130 | 2020-01-27 15:00:31 | consular | 1 | 82945 | 1 | 2.173 | 38170.7 |
129 | 2020-01-25 04:10:18 | consular | 1 | 82945 | 1 | 2.233 | 37145.1 |
128 | 2020-01-24 05:49:27 | consular | 1 | 82945 | 1 | 3.250 | 25521.5 |
127 | 2020-01-17 21:08:48 | consular | 1 | 82945 | 1 | 2.623 | 31622.2 |
126 | 2020-01-17 19:44:53 | consular | 1 | 82945 | 1 | 1.893 | 43816.7 |
125 | 2020-01-13 05:35:25 | consular | 1 | 82945 | 1 | 1.623 | 51106.0 |
124 | 2020-01-02 11:37:30 | consular | 1 | 82945 | 1 | 1.530 | 54212.4 |
123 | 2020-01-01 03:26:30 | consular | 1 | 82945 | 1 | 1.486 | 55817.6 |
122 | 2019-12-04 15:15:04 | consular | 1 | 82945 | 1 | 1.406 | 58993.6 |
121 | 2019-09-05 12:16:43 | consular | 1 | 82945 | 1 | 1.260 | 65829.4 |
120 | 2019-08-21 05:24:22 | consular | 1 | 82945 | 1 | 1.243 | 66729.7 |