History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transport"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
219 | 2024-05-14 10:06:34 | transport | 4 | 165329 | 179 | 44.270 | 3734.6 |
218 | 2024-05-14 10:06:37 | transport | 2 | 121436 | 8 | 7.733 | 15703.6 |
217 | 2024-05-14 08:06:31 | transport | 1 | 81242 | 2 | 1.250 | 64993.6 |
216 | 2024-05-12 20:37:01 | transport | 1 | 81242 | 2 | 2.390 | 33992.5 |
215 | 2024-05-10 17:28:18 | transport | 1 | 81242 | 2 | 6.156 | 13197.2 |
214 | 2024-05-09 07:41:37 | transport | 3 | 148641 | 38 | 19.923 | 7460.8 |
213 | 2024-05-09 07:41:39 | transport | 2 | 121436 | 8 | 4.500 | 26985.8 |
212 | 2024-05-09 07:35:14 | transport | 1 | 81242 | 2 | 3.076 | 26411.6 |
211 | 2024-05-02 11:46:45 | transport | 2 | 121436 | 8 | 6.783 | 17903.0 |
210 | 2024-05-02 10:21:01 | transport | 1 | 81242 | 2 | 2.390 | 33992.5 |
209 | 2024-04-14 01:11:49 | transport | 2 | 121436 | 8 | 11.436 | 10618.7 |
208 | 2024-04-13 18:29:59 | transport | 4 | 165329 | 179 | 21.360 | 7740.1 |
207 | 2024-04-12 04:23:50 | transport | 4 | 165329 | 179 | 41.893 | 3946.5 |
206 | 2024-04-12 04:23:48 | transport | 3 | 148641 | 38 | 12.610 | 11787.5 |
205 | 2024-04-10 09:45:40 | transport | 4 | 165329 | 179 | 27.436 | 6026.0 |
204 | 2024-04-10 09:45:42 | transport | 3 | 148641 | 38 | 25.283 | 5879.1 |
203 | 2024-04-10 09:45:43 | transport | 2 | 121436 | 8 | 12.780 | 9502.0 |
202 | 2024-04-10 09:42:49 | transport | 1 | 81242 | 2 | 1.546 | 52549.8 |
201 | 2024-04-08 15:01:14 | transport | 1 | 81242 | 2 | 1.300 | 62493.8 |
200 | 2024-03-27 20:27:52 | transport | 2 | 121436 | 8 | 12.796 | 9490.2 |
199 | 2024-03-27 18:55:13 | transport | 1 | 81242 | 2 | 1.610 | 50460.9 |
198 | 2024-03-12 04:13:50 | transport | 1 | 81242 | 2 | 1.263 | 64324.6 |
197 | 2024-03-08 14:21:08 | transport | 3 | 148641 | 38 | 27.486 | 5407.9 |
196 | 2024-03-05 04:37:23 | transport | 4 | 165329 | 179 | 31.953 | 5174.1 |
195 | 2024-03-05 04:37:22 | transport | 3 | 148641 | 38 | 20.250 | 7340.3 |
194 | 2024-03-05 04:37:23 | transport | 2 | 121436 | 8 | 5.596 | 21700.5 |
193 | 2024-03-05 02:34:35 | transport | 1 | 81242 | 2 | 1.560 | 52078.2 |
192 | 2024-03-02 15:30:56 | transport | 3 | 148641 | 38 | 23.970 | 6201.1 |
191 | 2024-03-02 15:30:55 | transport | 2 | 121436 | 8 | 13.123 | 9253.7 |
190 | 2024-03-02 12:36:36 | transport | 3 | 148641 | 38 | 13.046 | 11393.6 |
189 | 2024-03-02 12:36:41 | transport | 2 | 121436 | 8 | 4.470 | 27166.9 |
188 | 2024-03-02 12:36:34 | transport | 1 | 81242 | 2 | 3.030 | 26812.5 |
187 | 2024-03-02 12:36:03 | transport | 4 | 165329 | 179 | 22.390 | 7384.1 |
186 | 2024-03-02 12:36:23 | transport | 1 | 81242 | 2 | 1.593 | 50999.4 |
185 | 2024-03-02 07:45:22 | transport | 4 | 165329 | 179 | 41.143 | 4018.4 |
184 | 2024-02-08 04:01:46 | transport | 3 | 148641 | 38 | 6.893 | 21564.1 |
183 | 2024-02-02 08:19:27 | transport | 1 | 81242 | 2 | 1.373 | 59171.2 |
182 | 2024-02-01 04:03:40 | transport | 1 | 81242 | 2 | 1.406 | 57782.4 |
181 | 2024-01-31 19:17:52 | transport | 1 | 81242 | 2 | 1.500 | 54161.3 |
180 | 2024-01-31 08:57:46 | transport | 1 | 81242 | 2 | 2.093 | 38816.1 |
179 | 2024-01-29 11:25:04 | transport | 1 | 81242 | 2 | 2.936 | 27671.0 |
178 | 2024-01-15 13:45:17 | transport | 3 | 148641 | 38 | 9.063 | 16400.9 |
177 | 2023-12-19 23:48:05 | transport | 1 | 81242 | 2 | 2.750 | 29542.5 |
176 | 2023-12-18 12:17:55 | transport | 1 | 81242 | 2 | 1.233 | 65889.7 |
175 | 2023-12-11 16:36:32 | transport | 1 | 81242 | 2 | 1.263 | 64324.6 |
174 | 2023-11-27 20:33:06 | transport | 1 | 81242 | 2 | 1.403 | 57905.9 |
173 | 2023-11-21 16:17:34 | transport | 4 | 165329 | 179 | 11.670 | 14167.0 |
172 | 2023-11-12 15:20:18 | transport | 3 | 148641 | 38 | 6.410 | 23188.9 |
171 | 2023-09-13 01:57:49 | transport | 1 | 81242 | 2 | 1.330 | 61084.2 |
170 | 2023-08-21 14:53:41 | transport | 4 | 165329 | 179 | 12.686 | 13032.4 |
169 | 2023-08-15 11:20:49 | transport | 3 | 148641 | 38 | 7.236 | 20541.9 |
168 | 2023-07-10 13:12:09 | transport | 1 | 81242 | 2 | 1.313 | 61875.1 |
167 | 2023-06-27 19:53:44 | transport | 1 | 81242 | 2 | 1.406 | 57782.4 |
166 | 2023-05-03 15:07:10 | transport | 4 | 165329 | 179 | 10.530 | 15700.8 |
165 | 2023-04-30 12:24:07 | transport | 3 | 148641 | 38 | 6.233 | 23847.4 |
164 | 2023-04-06 21:31:04 | transport | 1 | 81242 | 2 | 1.236 | 65729.8 |
163 | 2023-02-10 17:52:26 | transport | 4 | 165329 | 179 | 23.846 | 6933.2 |
162 | 2023-02-06 09:46:01 | transport | 3 | 148641 | 38 | 6.110 | 24327.5 |
161 | 2023-01-19 23:31:41 | transport | 1 | 81242 | 2 | 1.250 | 64993.6 |
160 | 2022-11-23 07:54:59 | transport | 4 | 165329 | 179 | 11.766 | 14051.4 |
159 | 2022-11-20 04:47:47 | transport | 3 | 148641 | 38 | 6.110 | 24327.5 |
158 | 2022-11-17 09:30:03 | transport | 1 | 81242 | 2 | 1.250 | 64993.6 |
157 | 2022-07-08 09:28:53 | transport | 1 | 81242 | 2 | 1.436 | 56575.2 |
156 | 2022-06-27 05:07:17 | transport | 4 | 165329 | 179 | 10.580 | 15626.6 |
155 | 2022-06-23 08:13:40 | transport | 3 | 148641 | 38 | 6.266 | 23721.8 |
154 | 2022-05-19 04:09:34 | transport | 1 | 81242 | 2 | 1.453 | 55913.3 |
153 | 2022-03-08 20:23:35 | transport | 1 | 81242 | 2 | 2.813 | 28880.9 |
152 | 2022-03-06 16:36:31 | transport | 1 | 81242 | 2 | 1.233 | 65889.7 |
151 | 2021-12-02 17:31:57 | transport | 1 | 81242 | 2 | 1.406 | 57782.4 |
150 | 2021-12-01 18:43:56 | transport | 1 | 81242 | 2 | 1.456 | 55798.1 |
149 | 2021-11-30 22:48:06 | transport | 1 | 81242 | 2 | 1.310 | 62016.8 |
148 | 2021-11-29 18:42:25 | transport | 1 | 81242 | 2 | 1.623 | 50056.7 |
147 | 2021-11-14 04:27:14 | transport | 1 | 81242 | 2 | 1.796 | 45235.0 |
146 | 2021-09-21 15:30:47 | transport | 1 | 81242 | 2 | 2.830 | 28707.4 |
145 | 2021-09-20 22:02:10 | transport | 1 | 81242 | 2 | 1.236 | 65729.8 |
144 | 2021-09-20 04:49:22 | transport | 1 | 81242 | 2 | 1.283 | 63321.9 |
143 | 2021-09-14 15:13:38 | transport | 1 | 81242 | 2 | 1.390 | 58447.5 |
142 | 2021-03-11 17:40:51 | transport | 1 | 81242 | 2 | 1.250 | 64993.6 |
141 | 2020-11-27 09:19:15 | transport | 1 | 81242 | 2 | 1.250 | 64993.6 |
140 | 2020-11-10 17:08:57 | transport | 1 | 81242 | 2 | 1.216 | 66810.9 |
139 | 2020-10-30 10:44:59 | transport | 1 | 81242 | 2 | 1.296 | 62686.7 |
138 | 2020-10-08 04:05:15 | transport | 1 | 81242 | 2 | 1.236 | 65729.8 |
137 | 2020-03-27 20:14:18 | transport | 1 | 81242 | 2 | 1.483 | 54782.2 |
136 | 2020-03-27 06:59:02 | transport | 1 | 81242 | 2 | 2.483 | 32719.3 |
135 | 2020-03-24 07:51:22 | transport | 1 | 81242 | 2 | 1.686 | 48186.2 |
134 | 2020-02-25 21:22:06 | transport | 1 | 81242 | 2 | 1.436 | 56575.2 |
133 | 2020-02-25 15:42:36 | transport | 1 | 81242 | 2 | 1.516 | 53589.7 |
132 | 2020-02-25 05:57:01 | transport | 1 | 81242 | 2 | 3.126 | 25989.1 |
131 | 2020-02-13 03:11:47 | transport | 1 | 81242 | 2 | 3.030 | 26812.5 |
130 | 2020-01-31 03:05:52 | transport | 1 | 81242 | 2 | 1.390 | 58447.5 |
129 | 2020-01-30 16:11:54 | transport | 1 | 81242 | 2 | 1.516 | 53589.7 |
128 | 2020-01-28 04:32:53 | transport | 1 | 81242 | 2 | 1.513 | 53696.0 |
127 | 2020-01-28 00:38:23 | transport | 1 | 81242 | 2 | 3.096 | 26241.0 |
126 | 2020-01-20 11:07:57 | transport | 1 | 81242 | 2 | 1.546 | 52549.8 |
125 | 2020-01-17 05:31:34 | transport | 1 | 81242 | 2 | 1.533 | 52995.4 |
124 | 2020-01-05 02:30:16 | transport | 1 | 81242 | 2 | 1.546 | 52549.8 |
123 | 2020-01-03 01:16:28 | transport | 1 | 81242 | 2 | 3.596 | 22592.3 |
122 | 2019-12-16 04:34:38 | transport | 1 | 81242 | 2 | 1.256 | 64683.1 |
121 | 2019-10-19 06:37:28 | transport | 1 | 81242 | 2 | 1.403 | 57905.9 |
120 | 2019-09-14 17:15:50 | transport | 1 | 81242 | 2 | 1.273 | 63819.3 |