History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"involved"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
228 | 2024-05-04 00:27:44 | involved | 2 | 121059 | 18 | 9.690 | 12493.2 |
227 | 2024-05-03 23:38:13 | involved | 2 | 121059 | 18 | 5.643 | 21453.0 |
226 | 2024-05-03 23:30:40 | involved | 3 | 146162 | 107 | 7.800 | 18738.7 |
225 | 2024-04-29 07:03:43 | involved | 1 | 82945 | 4 | 1.403 | 59119.7 |
224 | 2024-04-26 10:15:28 | involved | 1 | 82945 | 4 | 5.030 | 16490.1 |
223 | 2024-04-26 09:02:56 | involved | 1 | 82945 | 4 | 1.533 | 54106.3 |
222 | 2024-04-26 08:46:28 | involved | 3 | 146162 | 107 | 7.530 | 19410.6 |
221 | 2024-04-21 07:45:16 | involved | 3 | 146162 | 107 | 26.983 | 5416.8 |
220 | 2024-04-19 00:14:55 | involved | 3 | 146162 | 107 | 23.690 | 6169.8 |
219 | 2024-04-19 00:14:56 | involved | 2 | 121059 | 18 | 8.546 | 14165.6 |
218 | 2024-04-18 20:40:59 | involved | 1 | 82945 | 4 | 1.560 | 53169.9 |
217 | 2024-04-05 06:08:10 | involved | 2 | 121059 | 18 | 4.766 | 25400.5 |
216 | 2024-04-03 15:10:37 | involved | 2 | 121059 | 18 | 5.800 | 20872.2 |
215 | 2024-04-03 09:28:35 | involved | 3 | 146162 | 107 | 23.986 | 6093.6 |
214 | 2024-04-03 09:28:39 | involved | 2 | 121059 | 18 | 10.016 | 12086.6 |
213 | 2024-04-03 09:27:46 | involved | 1 | 82945 | 4 | 1.750 | 47397.1 |
212 | 2024-03-31 20:45:27 | involved | 1 | 82945 | 4 | 2.550 | 32527.5 |
211 | 2024-03-26 20:35:29 | involved | 1 | 82945 | 4 | 4.763 | 17414.4 |
210 | 2024-03-09 01:50:45 | involved | 3 | 146162 | 107 | 19.110 | 7648.5 |
209 | 2024-03-08 21:51:32 | involved | 1 | 82945 | 4 | 1.623 | 51106.0 |
208 | 2024-03-07 16:39:16 | involved | 2 | 121059 | 18 | 5.513 | 21958.8 |
207 | 2024-03-07 14:22:44 | involved | 1 | 82945 | 4 | 1.346 | 61623.3 |
206 | 2024-03-07 03:21:30 | involved | 3 | 146162 | 107 | 23.563 | 6203.0 |
205 | 2024-03-06 11:01:09 | involved | 1 | 82945 | 4 | 3.250 | 25521.5 |
204 | 2024-03-06 11:00:50 | involved | 3 | 146162 | 107 | 8.673 | 16852.5 |
203 | 2024-03-06 09:34:38 | involved | 3 | 146162 | 107 | 10.766 | 13576.3 |
202 | 2024-03-06 04:52:54 | involved | 1 | 82945 | 4 | 3.063 | 27079.7 |
201 | 2024-03-04 08:09:11 | involved | 1 | 82945 | 4 | 1.406 | 58993.6 |
200 | 2024-02-24 19:15:13 | involved | 1 | 82945 | 4 | 1.436 | 57761.1 |
199 | 2024-02-22 12:47:49 | involved | 2 | 121059 | 18 | 7.173 | 16877.0 |
198 | 2024-02-22 05:39:05 | involved | 2 | 121059 | 18 | 3.140 | 38553.8 |
197 | 2024-02-21 14:20:00 | involved | 2 | 121059 | 18 | 11.983 | 10102.6 |
196 | 2024-02-21 06:28:13 | involved | 1 | 82945 | 4 | 1.546 | 53651.4 |
195 | 2024-02-20 16:27:21 | involved | 2 | 121059 | 18 | 11.060 | 10945.7 |
194 | 2024-02-20 03:22:32 | involved | 3 | 146162 | 107 | 18.640 | 7841.3 |
193 | 2024-02-14 18:44:47 | involved | 3 | 146162 | 107 | 8.296 | 17618.4 |
192 | 2024-02-13 04:56:22 | involved | 2 | 121059 | 18 | 3.313 | 36540.6 |
191 | 2024-02-13 04:52:59 | involved | 3 | 146162 | 107 | 6.440 | 22696.0 |
190 | 2024-02-05 08:51:54 | involved | 3 | 146162 | 107 | 15.876 | 9206.5 |
189 | 2024-02-05 08:42:53 | involved | 2 | 121059 | 18 | 3.670 | 32986.1 |
188 | 2024-02-05 08:42:49 | involved | 3 | 146162 | 107 | 7.110 | 20557.2 |
187 | 2024-02-05 08:42:45 | involved | 1 | 82945 | 4 | 1.440 | 57600.7 |
186 | 2024-02-01 15:18:03 | involved | 1 | 82945 | 4 | 1.216 | 68211.3 |
185 | 2024-01-28 08:51:51 | involved | 1 | 82945 | 4 | 1.373 | 60411.5 |
184 | 2024-01-14 05:29:00 | involved | 2 | 121059 | 18 | 3.640 | 33258.0 |
183 | 2024-01-12 07:53:45 | involved | 2 | 121059 | 18 | 4.060 | 29817.5 |
182 | 2024-01-08 04:33:32 | involved | 1 | 82945 | 4 | 1.373 | 60411.5 |
181 | 2024-01-04 20:25:33 | involved | 1 | 82945 | 4 | 1.266 | 65517.4 |
180 | 2023-11-16 12:50:16 | involved | 2 | 121059 | 18 | 3.140 | 38553.8 |
179 | 2023-10-29 18:18:46 | involved | 1 | 82945 | 4 | 1.266 | 65517.4 |
178 | 2023-10-25 13:46:13 | involved | 1 | 82945 | 4 | 1.376 | 60279.8 |
177 | 2023-09-17 02:02:34 | involved | 1 | 82945 | 4 | 1.470 | 56425.2 |
176 | 2023-08-24 15:22:52 | involved | 1 | 82945 | 4 | 1.393 | 59544.1 |
175 | 2023-08-18 17:38:57 | involved | 2 | 121059 | 18 | 3.563 | 33976.7 |
174 | 2023-05-23 22:56:16 | involved | 1 | 82945 | 4 | 1.263 | 65673.0 |
173 | 2023-05-14 05:17:40 | involved | 1 | 82945 | 4 | 1.313 | 63172.1 |
172 | 2023-05-02 03:59:34 | involved | 2 | 121059 | 18 | 3.016 | 40138.9 |
171 | 2023-03-17 13:06:44 | involved | 1 | 82945 | 4 | 1.250 | 66356.0 |
170 | 2023-02-05 16:48:52 | involved | 2 | 121059 | 18 | 3.126 | 38726.5 |
169 | 2023-01-06 00:58:54 | involved | 1 | 82945 | 4 | 1.220 | 67987.7 |
168 | 2023-01-04 12:03:12 | involved | 1 | 82945 | 4 | 1.220 | 67987.7 |
167 | 2022-11-18 10:42:33 | involved | 2 | 121059 | 18 | 3.140 | 38553.8 |
166 | 2022-09-26 23:27:07 | involved | 1 | 82945 | 4 | 1.236 | 67107.6 |
165 | 2022-08-29 00:22:58 | involved | 1 | 82945 | 4 | 1.263 | 65673.0 |
164 | 2022-06-21 15:51:22 | involved | 2 | 121059 | 18 | 3.030 | 39953.5 |
163 | 2022-05-08 23:24:32 | involved | 1 | 82945 | 4 | 1.233 | 67270.9 |
162 | 2022-05-06 19:59:44 | involved | 1 | 82945 | 4 | 1.423 | 58288.8 |
161 | 2022-04-07 13:25:17 | involved | 1 | 82945 | 4 | 1.423 | 58288.8 |
160 | 2022-02-07 19:09:30 | involved | 1 | 82945 | 4 | 1.313 | 63172.1 |
159 | 2021-12-07 11:18:30 | involved | 1 | 82945 | 4 | 2.813 | 29486.3 |
158 | 2021-08-11 01:59:07 | involved | 1 | 82945 | 4 | 1.266 | 65517.4 |
157 | 2021-06-03 23:53:20 | involved | 1 | 82945 | 4 | 1.250 | 66356.0 |
156 | 2021-05-09 18:13:10 | involved | 1 | 82945 | 4 | 1.233 | 67270.9 |
155 | 2021-04-22 12:37:41 | involved | 1 | 82945 | 4 | 1.403 | 59119.7 |
154 | 2021-04-08 09:42:49 | involved | 1 | 82945 | 4 | 1.390 | 59672.7 |
153 | 2021-01-23 07:02:00 | involved | 1 | 82945 | 4 | 1.280 | 64800.8 |
152 | 2021-01-01 10:26:52 | involved | 1 | 82945 | 4 | 1.233 | 67270.9 |
151 | 2020-12-21 20:23:00 | involved | 3 | 146162 | 107 | 6.266 | 23326.2 |
150 | 2020-12-15 21:03:14 | involved | 2 | 121059 | 18 | 3.093 | 39139.7 |
149 | 2020-11-01 07:23:55 | involved | 2 | 121059 | 18 | 3.673 | 32959.2 |
148 | 2020-10-31 15:48:02 | involved | 3 | 146162 | 107 | 6.203 | 23563.1 |
147 | 2020-10-08 21:37:35 | involved | 1 | 82945 | 4 | 1.390 | 59672.7 |
146 | 2020-09-21 09:41:26 | involved | 1 | 82945 | 4 | 1.313 | 63172.1 |
145 | 2020-08-26 07:34:35 | involved | 1 | 82945 | 4 | 1.360 | 60989.0 |
144 | 2020-05-29 16:32:12 | involved | 1 | 82945 | 4 | 1.266 | 65517.4 |
143 | 2020-03-23 06:59:09 | involved | 1 | 82945 | 4 | 1.406 | 58993.6 |
142 | 2020-02-28 19:27:39 | involved | 1 | 82945 | 4 | 3.250 | 25521.5 |
141 | 2020-02-23 21:39:08 | involved | 1 | 82945 | 4 | 1.593 | 52068.4 |
140 | 2020-02-17 13:50:55 | involved | 1 | 82945 | 4 | 1.296 | 64000.8 |
139 | 2020-02-12 20:37:31 | involved | 1 | 82945 | 4 | 1.656 | 50087.6 |
138 | 2020-02-07 21:01:01 | involved | 1 | 82945 | 4 | 1.596 | 51970.6 |
137 | 2020-02-02 11:34:09 | involved | 2 | 121059 | 18 | 5.470 | 22131.4 |
136 | 2020-01-30 22:55:16 | involved | 1 | 82945 | 4 | 1.373 | 60411.5 |
135 | 2020-01-30 02:01:22 | involved | 3 | 146162 | 107 | 10.640 | 13737.0 |
134 | 2020-01-29 17:21:37 | involved | 3 | 146162 | 107 | 8.440 | 17317.8 |
133 | 2020-01-29 09:56:17 | involved | 1 | 82945 | 4 | 1.906 | 43517.8 |
132 | 2020-01-29 00:41:40 | involved | 3 | 146162 | 107 | 9.920 | 14734.1 |
131 | 2020-01-27 00:24:17 | involved | 2 | 121059 | 18 | 3.656 | 33112.4 |
130 | 2020-01-27 00:22:48 | involved | 3 | 146162 | 107 | 8.173 | 17883.5 |
129 | 2020-01-26 21:39:19 | involved | 1 | 82945 | 4 | 2.126 | 39014.6 |