History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nonurgent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
221 | 2024-04-30 16:04:37 | nonurgent | 3 | 148641 | 18 | 7.986 | 18612.7 |
220 | 2024-04-27 02:58:21 | nonurgent | 4 | 165329 | 183 | 47.876 | 3453.3 |
219 | 2024-04-18 22:24:50 | nonurgent | 2 | 121436 | 2 | 3.453 | 35168.3 |
218 | 2024-04-17 21:35:46 | nonurgent | 1 | 81242 | 1 | 1.873 | 43375.3 |
217 | 2024-04-11 08:06:10 | nonurgent | 1 | 81242 | 1 | 1.263 | 64324.6 |
216 | 2024-04-07 23:09:11 | nonurgent | 1 | 81242 | 1 | 3.110 | 26122.8 |
215 | 2024-03-27 18:53:57 | nonurgent | 2 | 121436 | 2 | 3.700 | 32820.5 |
214 | 2024-03-27 18:52:22 | nonurgent | 4 | 165329 | 183 | 27.206 | 6076.9 |
213 | 2024-03-27 18:52:17 | nonurgent | 3 | 148641 | 18 | 8.266 | 17982.2 |
212 | 2024-03-27 17:15:40 | nonurgent | 4 | 165329 | 183 | 41.176 | 4015.2 |
211 | 2024-03-27 17:15:38 | nonurgent | 3 | 148641 | 18 | 15.000 | 9909.4 |
210 | 2024-03-27 17:15:43 | nonurgent | 1 | 81242 | 1 | 3.143 | 25848.6 |
209 | 2024-03-27 17:15:32 | nonurgent | 2 | 121436 | 2 | 7.936 | 15301.9 |
208 | 2024-03-27 17:13:00 | nonurgent | 1 | 81242 | 1 | 1.266 | 64172.2 |
207 | 2024-03-11 18:53:46 | nonurgent | 1 | 81242 | 1 | 4.593 | 17688.2 |
206 | 2024-03-05 16:19:42 | nonurgent | 1 | 81242 | 1 | 1.390 | 58447.5 |
205 | 2024-03-02 07:15:29 | nonurgent | 1 | 81242 | 1 | 3.173 | 25604.2 |
204 | 2024-02-29 05:52:11 | nonurgent | 1 | 81242 | 1 | 1.436 | 56575.2 |
203 | 2024-02-21 06:16:23 | nonurgent | 1 | 81242 | 1 | 1.560 | 52078.2 |
202 | 2024-02-20 23:33:35 | nonurgent | 4 | 165329 | 183 | 15.563 | 10623.2 |
201 | 2024-02-19 04:23:13 | nonurgent | 4 | 165329 | 183 | 32.330 | 5113.8 |
200 | 2024-02-19 04:23:16 | nonurgent | 3 | 148641 | 18 | 15.330 | 9696.1 |
199 | 2024-02-19 04:23:13 | nonurgent | 2 | 121436 | 2 | 9.173 | 13238.4 |
198 | 2024-02-18 20:20:39 | nonurgent | 1 | 81242 | 1 | 2.970 | 27354.2 |
197 | 2024-02-06 05:24:58 | nonurgent | 1 | 81242 | 1 | 1.423 | 57092.1 |
196 | 2024-01-29 14:41:50 | nonurgent | 1 | 81242 | 1 | 1.500 | 54161.3 |
195 | 2024-01-29 03:00:03 | nonurgent | 1 | 81242 | 1 | 1.310 | 62016.8 |
194 | 2024-01-21 12:37:55 | nonurgent | 1 | 81242 | 1 | 1.250 | 64993.6 |
193 | 2024-01-14 11:27:48 | nonurgent | 1 | 81242 | 1 | 1.373 | 59171.2 |
192 | 2023-12-12 04:55:18 | nonurgent | 2 | 121436 | 2 | 3.046 | 39867.4 |
191 | 2023-11-08 13:47:31 | nonurgent | 1 | 81242 | 1 | 1.393 | 58321.6 |
190 | 2023-11-01 16:59:28 | nonurgent | 1 | 81242 | 1 | 1.236 | 65729.8 |
189 | 2023-10-24 10:36:39 | nonurgent | 1 | 81242 | 1 | 1.373 | 59171.2 |
188 | 2023-09-10 10:14:26 | nonurgent | 2 | 121436 | 2 | 3.013 | 40304.0 |
187 | 2023-08-29 15:11:40 | nonurgent | 1 | 81242 | 1 | 1.423 | 57092.1 |
186 | 2023-06-14 15:39:56 | nonurgent | 1 | 81242 | 1 | 1.236 | 65729.8 |
185 | 2023-06-01 11:34:58 | nonurgent | 1 | 81242 | 1 | 1.203 | 67532.8 |
184 | 2023-05-25 15:16:26 | nonurgent | 2 | 121436 | 2 | 2.986 | 40668.5 |
183 | 2023-03-25 00:19:27 | nonurgent | 1 | 81242 | 1 | 1.326 | 61268.5 |
182 | 2023-03-06 14:02:51 | nonurgent | 2 | 121436 | 2 | 3.046 | 39867.4 |
181 | 2023-02-09 16:13:22 | nonurgent | 1 | 81242 | 1 | 1.190 | 68270.6 |
180 | 2023-01-09 12:54:12 | nonurgent | 1 | 81242 | 1 | 1.343 | 60492.9 |
179 | 2022-12-13 06:35:58 | nonurgent | 2 | 121436 | 2 | 3.046 | 39867.4 |
178 | 2022-10-06 05:21:05 | nonurgent | 1 | 81242 | 1 | 1.343 | 60492.9 |
177 | 2022-09-20 12:02:30 | nonurgent | 1 | 81242 | 1 | 1.220 | 66591.8 |
176 | 2022-08-01 14:46:49 | nonurgent | 2 | 121436 | 2 | 3.093 | 39261.6 |
175 | 2022-05-22 05:08:33 | nonurgent | 1 | 81242 | 1 | 1.233 | 65889.7 |
174 | 2022-04-19 15:51:28 | nonurgent | 1 | 81242 | 1 | 1.250 | 64993.6 |
173 | 2021-12-12 07:06:50 | nonurgent | 1 | 81242 | 1 | 1.233 | 65889.7 |
172 | 2021-08-16 02:08:04 | nonurgent | 1 | 81242 | 1 | 1.203 | 67532.8 |
171 | 2021-04-28 01:23:13 | nonurgent | 1 | 81242 | 1 | 2.733 | 29726.3 |
170 | 2021-02-17 06:53:01 | nonurgent | 1 | 81242 | 1 | 1.516 | 53589.7 |
169 | 2021-01-23 10:07:08 | nonurgent | 1 | 81242 | 1 | 1.423 | 57092.1 |
168 | 2021-01-19 18:44:02 | nonurgent | 1 | 81242 | 1 | 1.203 | 67532.8 |
167 | 2020-11-14 06:10:15 | nonurgent | 3 | 148641 | 18 | 6.173 | 24079.2 |
166 | 2020-10-16 09:39:01 | nonurgent | 1 | 81242 | 1 | 1.233 | 65889.7 |
165 | 2020-10-05 16:40:49 | nonurgent | 1 | 81242 | 1 | 1.436 | 56575.2 |
164 | 2020-07-13 07:47:20 | nonurgent | 1 | 81242 | 1 | 1.283 | 63321.9 |
163 | 2020-04-11 18:10:27 | nonurgent | 1 | 81242 | 1 | 1.280 | 63470.3 |
162 | 2020-03-23 09:23:50 | nonurgent | 1 | 81242 | 1 | 1.436 | 56575.2 |
161 | 2020-02-07 02:59:08 | nonurgent | 1 | 81242 | 1 | 3.000 | 27080.7 |
160 | 2020-02-04 23:11:36 | nonurgent | 1 | 81242 | 1 | 1.486 | 54671.6 |
159 | 2020-02-01 07:37:24 | nonurgent | 1 | 81242 | 1 | 3.016 | 26937.0 |
158 | 2020-01-30 21:23:30 | nonurgent | 1 | 81242 | 1 | 1.513 | 53696.0 |
157 | 2020-01-28 08:09:24 | nonurgent | 1 | 81242 | 1 | 2.876 | 28248.3 |
156 | 2020-01-20 16:34:26 | nonurgent | 1 | 81242 | 1 | 2.390 | 33992.5 |
155 | 2020-01-13 11:47:08 | nonurgent | 1 | 81242 | 1 | 1.546 | 52549.8 |
154 | 2020-01-03 16:54:16 | nonurgent | 1 | 81242 | 1 | 1.286 | 63174.2 |
153 | 2020-01-01 21:00:29 | nonurgent | 1 | 81242 | 1 | 3.313 | 24522.2 |
152 | 2019-12-27 22:47:54 | nonurgent | 1 | 81242 | 1 | 1.330 | 61084.2 |
151 | 2019-09-27 08:34:57 | nonurgent | 1 | 81242 | 1 | 1.180 | 68849.2 |
150 | 2019-09-24 04:27:02 | nonurgent | 1 | 81242 | 1 | 1.286 | 63174.2 |
149 | 2019-06-18 05:56:17 | nonurgent | 1 | 81242 | 1 | 1.190 | 68270.6 |
148 | 2019-02-27 17:25:06 | nonurgent | 1 | 81242 | 1 | 1.200 | 67701.7 |
147 | 2019-01-04 15:54:37 | nonurgent | 1 | 81242 | 1 | 2.790 | 29119.0 |
146 | 2018-12-31 18:05:19 | nonurgent | 1 | 81242 | 1 | 1.440 | 56418.1 |
145 | 2018-12-29 21:44:47 | nonurgent | 1 | 81242 | 1 | 1.190 | 68270.6 |
144 | 2018-12-22 04:35:03 | nonurgent | 1 | 81242 | 1 | 1.213 | 66976.1 |
143 | 2018-11-06 14:40:30 | nonurgent | 1 | 81242 | 1 | 2.476 | 32811.8 |
142 | 2018-11-01 19:05:51 | nonurgent | 1 | 81242 | 1 | 1.453 | 55913.3 |
141 | 2018-10-31 16:00:43 | nonurgent | 1 | 81242 | 1 | 1.223 | 66428.5 |
140 | 2018-10-15 08:10:42 | nonurgent | 1 | 81242 | 1 | 1.186 | 68500.8 |
139 | 2018-09-21 06:25:57 | nonurgent | 1 | 81242 | 1 | 1.203 | 67532.8 |
138 | 2018-07-28 20:22:20 | nonurgent | 1 | 81242 | 1 | 1.396 | 58196.3 |
137 | 2018-03-19 01:04:02 | nonurgent | 1 | 81242 | 1 | 1.653 | 49148.2 |
136 | 2018-02-11 15:33:23 | nonurgent | 1 | 81242 | 1 | 1.663 | 48852.7 |
135 | 2017-12-23 18:04:41 | nonurgent | 1 | 81242 | 1 | 1.643 | 49447.4 |
134 | 2017-12-23 18:00:21 | nonurgent | 1 | 81242 | 1 | 2.280 | 35632.5 |
133 | 2017-11-23 16:26:48 | nonurgent | 1 | 81242 | 1 | 1.790 | 45386.6 |
132 | 2017-11-05 10:01:50 | nonurgent | 1 | 81242 | 1 | 1.750 | 46424.0 |
131 | 2017-05-19 15:25:10 | nonurgent | 1 | 81242 | 1 | 1.650 | 49237.6 |
130 | 2017-03-10 02:12:42 | nonurgent | 1 | 81242 | 1 | 1.950 | 41662.6 |
129 | 2017-02-01 08:50:11 | nonurgent | 4 | 165329 | 183 | 14.336 | 11532.4 |
128 | 2017-02-01 07:56:55 | nonurgent | 1 | 81242 | 1 | 1.503 | 54053.2 |
127 | 2017-01-05 14:57:34 | nonurgent | 1 | 81242 | 1 | 1.836 | 44249.5 |
126 | 2016-12-11 17:26:34 | nonurgent | 1 | 81242 | 1 | 3.376 | 24064.6 |
125 | 2016-12-11 17:21:25 | nonurgent | 1 | 81242 | 1 | 3.543 | 22930.3 |
124 | 2016-11-23 22:07:47 | nonurgent | 1 | 81242 | 1 | 1.713 | 47426.7 |
123 | 2016-11-16 22:51:43 | nonurgent | 3 | 148641 | 18 | 10.406 | 14284.2 |
122 | 2016-09-16 02:42:54 | nonurgent | 1 | 81242 | 1 | 1.686 | 48186.2 |