History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pedestrians"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
220 | 2024-04-24 09:04:07 | pedestrians | 4 | 148819 | 53 | 17.796 | 8362.5 |
219 | 2024-04-23 16:15:31 | pedestrians | 4 | 148819 | 53 | 31.613 | 4707.5 |
218 | 2024-04-21 21:33:20 | pedestrians | 4 | 148819 | 53 | 26.720 | 5569.6 |
217 | 2024-04-16 02:30:34 | pedestrians | 4 | 148819 | 53 | 39.550 | 3762.8 |
216 | 2024-04-15 05:27:32 | pedestrians | 4 | 148819 | 53 | 21.410 | 6950.9 |
215 | 2024-04-08 12:45:13 | pedestrians | 3 | 121633 | 7 | 12.220 | 9953.6 |
214 | 2024-04-03 03:02:16 | pedestrians | 3 | 121633 | 7 | 13.220 | 9200.7 |
213 | 2024-04-03 03:02:17 | pedestrians | 2 | 86808 | 3 | 8.690 | 9989.4 |
212 | 2024-04-03 02:59:19 | pedestrians | 1 | 49908 | 2 | 4.060 | 12292.6 |
211 | 2024-03-24 14:02:15 | pedestrians | 4 | 148819 | 53 | 24.033 | 6192.3 |
210 | 2024-03-24 14:02:12 | pedestrians | 3 | 121633 | 7 | 20.503 | 5932.4 |
209 | 2024-03-24 14:02:12 | pedestrians | 2 | 86808 | 3 | 7.360 | 11794.6 |
208 | 2024-03-24 14:00:30 | pedestrians | 1 | 49908 | 2 | 2.013 | 24792.8 |
207 | 2024-03-17 12:31:19 | pedestrians | 1 | 49908 | 2 | 1.000 | 49908.0 |
206 | 2024-03-15 03:27:29 | pedestrians | 4 | 148819 | 53 | 25.500 | 5836.0 |
205 | 2024-03-13 22:22:28 | pedestrians | 4 | 148819 | 53 | 30.660 | 4853.8 |
204 | 2024-03-12 22:41:47 | pedestrians | 5 | 164607 | 415 | 39.330 | 4185.3 |
203 | 2024-03-12 20:22:25 | pedestrians | 5 | 164607 | 415 | 40.440 | 4070.4 |
202 | 2024-03-12 16:53:49 | pedestrians | 5 | 164607 | 415 | 30.610 | 5377.6 |
201 | 2024-03-12 16:53:49 | pedestrians | 4 | 148819 | 53 | 16.956 | 8776.8 |
200 | 2024-03-12 16:54:02 | pedestrians | 1 | 49908 | 2 | 0.906 | 55086.1 |
199 | 2024-03-12 16:53:50 | pedestrians | 3 | 121633 | 7 | 11.813 | 10296.5 |
198 | 2024-03-12 16:53:49 | pedestrians | 2 | 86808 | 3 | 2.860 | 30352.4 |
197 | 2024-03-06 17:20:00 | pedestrians | 1 | 49908 | 2 | 3.016 | 16547.7 |
196 | 2024-02-19 17:23:31 | pedestrians | 1 | 49908 | 2 | 1.923 | 25953.2 |
195 | 2024-02-19 14:53:40 | pedestrians | 3 | 121633 | 7 | 5.203 | 23377.5 |
194 | 2024-02-19 14:53:39 | pedestrians | 2 | 86808 | 3 | 4.656 | 18644.3 |
193 | 2024-02-17 17:48:35 | pedestrians | 1 | 49908 | 2 | 0.860 | 58032.6 |
192 | 2024-02-17 16:40:32 | pedestrians | 3 | 121633 | 7 | 5.940 | 20476.9 |
191 | 2024-02-17 16:40:31 | pedestrians | 2 | 86808 | 3 | 2.653 | 32720.7 |
190 | 2024-02-15 18:51:55 | pedestrians | 1 | 49908 | 2 | 2.766 | 18043.4 |
189 | 2024-02-15 10:30:46 | pedestrians | 3 | 121633 | 7 | 14.156 | 8592.3 |
188 | 2024-02-15 10:30:25 | pedestrians | 2 | 86808 | 3 | 6.580 | 13192.7 |
187 | 2024-02-13 21:07:57 | pedestrians | 3 | 121633 | 7 | 12.563 | 9681.8 |
186 | 2024-02-13 21:07:57 | pedestrians | 2 | 86808 | 3 | 8.330 | 10421.1 |
185 | 2024-02-13 21:07:23 | pedestrians | 1 | 49908 | 2 | 2.016 | 24756.0 |
184 | 2024-02-13 19:46:32 | pedestrians | 1 | 49908 | 2 | 1.876 | 26603.4 |
183 | 2024-02-09 12:07:29 | pedestrians | 1 | 49908 | 2 | 0.890 | 56076.4 |
182 | 2024-02-06 17:02:02 | pedestrians | 4 | 148819 | 53 | 11.500 | 12940.8 |
181 | 2024-01-29 19:30:31 | pedestrians | 1 | 49908 | 2 | 0.873 | 57168.4 |
180 | 2024-01-23 06:19:36 | pedestrians | 5 | 164607 | 415 | 34.376 | 4788.4 |
179 | 2024-01-23 03:32:17 | pedestrians | 5 | 164607 | 415 | 19.876 | 8281.7 |
178 | 2024-01-17 23:34:05 | pedestrians | 1 | 49908 | 2 | 0.876 | 56972.6 |
177 | 2024-01-07 13:56:13 | pedestrians | 5 | 164607 | 415 | 14.796 | 11125.1 |
176 | 2024-01-06 21:30:35 | pedestrians | 1 | 49908 | 2 | 0.860 | 58032.6 |
175 | 2023-12-31 20:00:30 | pedestrians | 4 | 148819 | 53 | 9.406 | 15821.7 |
174 | 2023-12-27 04:09:35 | pedestrians | 1 | 49908 | 2 | 0.876 | 56972.6 |
173 | 2023-11-29 15:49:18 | pedestrians | 1 | 49908 | 2 | 0.783 | 63739.5 |
172 | 2023-10-30 04:38:48 | pedestrians | 1 | 49908 | 2 | 0.876 | 56972.6 |
171 | 2023-10-14 20:30:20 | pedestrians | 5 | 164607 | 415 | 17.033 | 9664.0 |
170 | 2023-10-07 02:21:02 | pedestrians | 4 | 148819 | 53 | 9.656 | 15412.1 |
169 | 2023-09-14 14:47:47 | pedestrians | 1 | 49908 | 2 | 0.750 | 66544.0 |
168 | 2023-09-04 16:45:36 | pedestrians | 1 | 49908 | 2 | 0.826 | 60421.3 |
167 | 2023-07-24 18:51:24 | pedestrians | 5 | 164607 | 415 | 13.216 | 12455.1 |
166 | 2023-07-18 08:52:35 | pedestrians | 4 | 148819 | 53 | 8.503 | 17501.9 |
165 | 2023-07-03 13:32:47 | pedestrians | 1 | 49908 | 2 | 0.766 | 65154.0 |
164 | 2023-04-16 06:39:16 | pedestrians | 1 | 49908 | 2 | 0.843 | 59202.8 |
163 | 2023-04-12 05:21:17 | pedestrians | 1 | 49908 | 2 | 0.750 | 66544.0 |
162 | 2023-04-05 01:55:38 | pedestrians | 5 | 164607 | 415 | 13.453 | 12235.7 |
161 | 2023-04-01 22:48:44 | pedestrians | 4 | 148819 | 53 | 8.000 | 18602.4 |
160 | 2023-02-03 15:18:03 | pedestrians | 1 | 49908 | 2 | 0.750 | 66544.0 |
159 | 2023-01-01 18:00:32 | pedestrians | 5 | 164607 | 415 | 13.283 | 12392.3 |
158 | 2022-12-29 06:01:46 | pedestrians | 4 | 148819 | 53 | 8.640 | 17224.4 |
157 | 2022-12-03 15:48:20 | pedestrians | 1 | 49908 | 2 | 0.750 | 66544.0 |
156 | 2022-12-01 15:31:45 | pedestrians | 1 | 49908 | 2 | 0.733 | 68087.3 |
155 | 2022-09-02 21:30:36 | pedestrians | 5 | 164607 | 415 | 13.580 | 12121.3 |
154 | 2022-08-30 06:44:24 | pedestrians | 4 | 148819 | 53 | 8.453 | 17605.5 |
153 | 2022-07-28 07:49:51 | pedestrians | 1 | 49908 | 2 | 0.810 | 61614.8 |
152 | 2022-06-29 00:57:49 | pedestrians | 1 | 49908 | 2 | 0.750 | 66544.0 |
151 | 2022-01-30 00:27:03 | pedestrians | 1 | 49908 | 2 | 0.906 | 55086.1 |
150 | 2021-09-20 20:19:49 | pedestrians | 1 | 49908 | 2 | 0.856 | 58303.7 |
149 | 2021-09-14 03:07:51 | pedestrians | 1 | 49908 | 2 | 0.843 | 59202.8 |
148 | 2021-07-22 21:55:45 | pedestrians | 4 | 148819 | 53 | 9.716 | 15316.9 |
147 | 2021-06-07 01:21:35 | pedestrians | 1 | 49908 | 2 | 0.906 | 55086.1 |
146 | 2021-06-03 20:55:22 | pedestrians | 1 | 49908 | 2 | 0.906 | 55086.1 |
145 | 2021-05-12 16:09:40 | pedestrians | 4 | 148819 | 53 | 8.826 | 16861.4 |
144 | 2021-05-08 08:32:59 | pedestrians | 1 | 49908 | 2 | 1.780 | 28038.2 |
143 | 2021-03-30 09:09:29 | pedestrians | 5 | 164607 | 415 | 15.423 | 10672.8 |
142 | 2021-03-20 02:43:51 | pedestrians | 5 | 164607 | 415 | 13.436 | 12251.2 |
141 | 2021-02-26 19:57:11 | pedestrians | 2 | 86808 | 3 | 2.330 | 37256.7 |
140 | 2021-02-25 07:01:27 | pedestrians | 1 | 49908 | 2 | 0.903 | 55269.1 |
139 | 2021-02-22 20:49:31 | pedestrians | 5 | 164607 | 415 | 14.550 | 11313.2 |
138 | 2021-02-17 08:11:45 | pedestrians | 1 | 49908 | 2 | 0.783 | 63739.5 |
137 | 2021-02-14 16:24:56 | pedestrians | 1 | 49908 | 2 | 1.626 | 30693.7 |
136 | 2021-01-25 21:00:46 | pedestrians | 3 | 121633 | 7 | 4.533 | 26832.8 |
135 | 2021-01-25 16:40:53 | pedestrians | 4 | 148819 | 53 | 8.486 | 17537.0 |
134 | 2020-12-09 06:56:34 | pedestrians | 2 | 86808 | 3 | 2.330 | 37256.7 |
133 | 2020-11-20 08:19:46 | pedestrians | 1 | 49908 | 2 | 0.763 | 65410.2 |
132 | 2020-11-17 13:02:09 | pedestrians | 5 | 164607 | 415 | 16.596 | 9918.5 |
131 | 2020-11-10 08:42:07 | pedestrians | 2 | 86808 | 3 | 2.203 | 39404.4 |
130 | 2020-11-09 01:29:23 | pedestrians | 3 | 121633 | 7 | 5.296 | 22967.0 |
129 | 2020-11-06 20:54:00 | pedestrians | 1 | 49908 | 2 | 0.923 | 54071.5 |
128 | 2020-11-06 02:36:58 | pedestrians | 4 | 148819 | 53 | 9.860 | 15093.2 |
127 | 2020-10-25 01:08:46 | pedestrians | 1 | 49908 | 2 | 0.800 | 62385.0 |
126 | 2020-10-20 13:11:22 | pedestrians | 1 | 49908 | 2 | 1.643 | 30376.1 |
125 | 2020-08-25 17:51:57 | pedestrians | 1 | 49908 | 2 | 0.813 | 61387.5 |
124 | 2020-07-29 05:51:13 | pedestrians | 1 | 49908 | 2 | 0.826 | 60421.3 |
123 | 2020-07-24 02:04:09 | pedestrians | 1 | 49908 | 2 | 1.016 | 49122.0 |
122 | 2020-04-23 16:30:25 | pedestrians | 1 | 49908 | 2 | 0.813 | 61387.5 |
121 | 2020-03-24 08:08:09 | pedestrians | 1 | 49908 | 2 | 0.860 | 58032.6 |