History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pizzeria"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
214 | 2024-04-26 14:25:23 | pizzeria | 1 | 82945 | 2 | 1.373 | 60411.5 |
213 | 2024-04-22 23:47:17 | pizzeria | 4 | 161609 | 194 | 11.093 | 14568.6 |
212 | 2024-04-19 16:19:26 | pizzeria | 3 | 146162 | 12 | 28.143 | 5193.5 |
211 | 2024-04-12 10:20:37 | pizzeria | 3 | 146162 | 12 | 17.596 | 8306.5 |
210 | 2024-04-10 22:50:32 | pizzeria | 4 | 161609 | 194 | 26.440 | 6112.3 |
209 | 2024-04-09 22:53:03 | pizzeria | 4 | 161609 | 194 | 14.733 | 10969.2 |
208 | 2024-04-09 22:53:04 | pizzeria | 2 | 121059 | 2 | 6.000 | 20176.5 |
207 | 2024-04-09 22:53:06 | pizzeria | 1 | 82945 | 2 | 3.750 | 22118.7 |
206 | 2024-04-09 22:52:33 | pizzeria | 3 | 146162 | 12 | 8.233 | 17753.2 |
205 | 2024-04-08 04:45:15 | pizzeria | 2 | 121059 | 2 | 7.796 | 15528.3 |
204 | 2024-04-08 04:45:14 | pizzeria | 3 | 146162 | 12 | 8.640 | 16916.9 |
203 | 2024-04-08 04:45:12 | pizzeria | 1 | 82945 | 2 | 2.250 | 36864.4 |
202 | 2024-04-03 19:26:32 | pizzeria | 4 | 161609 | 194 | 25.016 | 6460.2 |
201 | 2024-03-29 11:05:48 | pizzeria | 4 | 161609 | 194 | 25.143 | 6427.6 |
200 | 2024-03-29 11:05:03 | pizzeria | 4 | 161609 | 194 | 18.140 | 8909.0 |
199 | 2024-03-25 12:20:36 | pizzeria | 1 | 82945 | 2 | 1.296 | 64000.8 |
198 | 2024-03-21 21:33:35 | pizzeria | 1 | 82945 | 2 | 4.516 | 18366.9 |
197 | 2024-03-21 20:35:12 | pizzeria | 1 | 82945 | 2 | 4.466 | 18572.5 |
196 | 2024-03-21 19:17:19 | pizzeria | 1 | 82945 | 2 | 3.326 | 24938.4 |
195 | 2024-03-20 05:42:44 | pizzeria | 2 | 121059 | 2 | 5.580 | 21695.2 |
194 | 2024-03-20 05:38:42 | pizzeria | 1 | 82945 | 2 | 1.466 | 56579.1 |
193 | 2024-03-20 05:37:34 | pizzeria | 3 | 146162 | 12 | 8.000 | 18270.3 |
192 | 2024-03-12 04:02:54 | pizzeria | 2 | 121059 | 2 | 13.046 | 9279.4 |
191 | 2024-03-12 01:13:04 | pizzeria | 3 | 146162 | 12 | 7.953 | 18378.2 |
190 | 2024-03-10 16:11:04 | pizzeria | 4 | 161609 | 194 | 39.986 | 4041.6 |
189 | 2024-03-10 01:31:21 | pizzeria | 3 | 146162 | 12 | 26.283 | 5561.1 |
188 | 2024-03-10 01:31:20 | pizzeria | 3 | 146162 | 12 | 26.050 | 5610.8 |
187 | 2024-03-10 01:31:23 | pizzeria | 2 | 121059 | 2 | 12.940 | 9355.4 |
186 | 2024-03-10 01:31:10 | pizzeria | 4 | 161609 | 194 | 23.983 | 6738.5 |
185 | 2024-03-10 01:31:18 | pizzeria | 1 | 82945 | 2 | 1.670 | 49667.7 |
184 | 2024-03-10 01:31:10 | pizzeria | 2 | 121059 | 2 | 4.250 | 28484.5 |
183 | 2024-03-10 01:31:01 | pizzeria | 1 | 82945 | 2 | 3.093 | 26817.0 |
182 | 2024-03-02 11:21:26 | pizzeria | 3 | 146162 | 12 | 7.530 | 19410.6 |
181 | 2024-03-01 00:04:03 | pizzeria | 3 | 146162 | 12 | 6.783 | 21548.3 |
180 | 2024-03-01 00:04:07 | pizzeria | 1 | 82945 | 2 | 1.486 | 55817.6 |
179 | 2024-03-01 00:03:59 | pizzeria | 2 | 121059 | 2 | 7.376 | 16412.6 |
178 | 2024-02-28 04:43:13 | pizzeria | 4 | 161609 | 194 | 23.096 | 6997.3 |
177 | 2024-02-28 03:16:36 | pizzeria | 4 | 161609 | 194 | 15.983 | 10111.3 |
176 | 2024-02-28 02:53:52 | pizzeria | 4 | 161609 | 194 | 25.003 | 6463.6 |
175 | 2024-02-05 20:11:54 | pizzeria | 3 | 146162 | 12 | 10.126 | 14434.3 |
174 | 2024-02-05 20:11:26 | pizzeria | 4 | 161609 | 194 | 11.936 | 13539.6 |
173 | 2024-02-05 20:11:22 | pizzeria | 3 | 146162 | 12 | 9.406 | 15539.2 |
172 | 2024-02-05 20:11:14 | pizzeria | 2 | 121059 | 2 | 3.703 | 32692.1 |
171 | 2024-02-04 05:30:55 | pizzeria | 2 | 121059 | 2 | 3.706 | 32665.7 |
170 | 2024-02-04 05:30:31 | pizzeria | 1 | 82945 | 2 | 1.280 | 64800.8 |
169 | 2024-01-30 16:17:19 | pizzeria | 2 | 121059 | 2 | 7.220 | 16767.2 |
168 | 2024-01-30 16:17:15 | pizzeria | 3 | 146162 | 12 | 8.766 | 16673.7 |
167 | 2024-01-30 16:17:11 | pizzeria | 1 | 82945 | 2 | 1.453 | 57085.3 |
166 | 2024-01-30 03:24:43 | pizzeria | 3 | 146162 | 12 | 8.906 | 16411.6 |
165 | 2024-01-30 03:24:39 | pizzeria | 2 | 121059 | 2 | 4.470 | 27082.6 |
164 | 2024-01-29 02:54:26 | pizzeria | 1 | 82945 | 2 | 1.390 | 59672.7 |
163 | 2024-01-26 18:07:27 | pizzeria | 4 | 161609 | 194 | 12.186 | 13261.9 |
162 | 2024-01-25 23:43:29 | pizzeria | 4 | 161609 | 194 | 17.673 | 9144.4 |
161 | 2024-01-05 03:47:16 | pizzeria | 1 | 82945 | 2 | 1.263 | 65673.0 |
160 | 2023-12-10 19:19:10 | pizzeria | 4 | 161609 | 194 | 12.670 | 12755.2 |
159 | 2023-12-01 07:45:12 | pizzeria | 4 | 161609 | 194 | 12.466 | 12964.0 |
158 | 2023-11-27 03:32:09 | pizzeria | 1 | 82945 | 2 | 1.296 | 64000.8 |
157 | 2023-11-22 06:17:16 | pizzeria | 3 | 146162 | 12 | 6.953 | 21021.4 |
156 | 2023-11-20 18:18:26 | pizzeria | 1 | 82945 | 2 | 1.393 | 59544.1 |
155 | 2023-11-10 00:37:31 | pizzeria | 4 | 161609 | 194 | 12.500 | 12928.7 |
154 | 2023-10-29 23:14:10 | pizzeria | 1 | 82945 | 2 | 1.296 | 64000.8 |
153 | 2023-10-28 05:02:44 | pizzeria | 1 | 82945 | 2 | 1.500 | 55296.7 |
152 | 2023-10-27 03:20:40 | pizzeria | 4 | 161609 | 194 | 13.203 | 12240.3 |
151 | 2023-10-20 18:39:35 | pizzeria | 4 | 161609 | 194 | 23.203 | 6965.0 |
150 | 2023-10-17 14:13:37 | pizzeria | 4 | 161609 | 194 | 29.656 | 5449.5 |
149 | 2023-10-13 12:00:01 | pizzeria | 4 | 161609 | 194 | 13.206 | 12237.5 |
148 | 2023-10-05 18:09:17 | pizzeria | 1 | 82945 | 2 | 1.326 | 62552.8 |
147 | 2023-10-03 10:06:18 | pizzeria | 4 | 161609 | 194 | 13.546 | 11930.4 |
146 | 2023-09-26 17:52:45 | pizzeria | 4 | 161609 | 194 | 13.626 | 11860.3 |
145 | 2023-09-21 07:44:21 | pizzeria | 4 | 161609 | 194 | 10.530 | 15347.5 |
144 | 2023-09-12 19:52:50 | pizzeria | 1 | 82945 | 2 | 1.390 | 59672.7 |
143 | 2023-09-11 11:50:52 | pizzeria | 4 | 161609 | 194 | 13.203 | 12240.3 |
142 | 2023-08-22 16:44:08 | pizzeria | 1 | 82945 | 2 | 1.346 | 61623.3 |
141 | 2023-08-22 14:42:25 | pizzeria | 3 | 146162 | 12 | 6.843 | 21359.3 |
140 | 2023-06-11 19:56:11 | pizzeria | 4 | 161609 | 194 | 10.170 | 15890.8 |
139 | 2023-05-23 08:10:53 | pizzeria | 1 | 82945 | 2 | 1.420 | 58412.0 |
138 | 2023-05-15 09:54:51 | pizzeria | 4 | 161609 | 194 | 10.483 | 15416.3 |
137 | 2023-05-08 08:42:23 | pizzeria | 3 | 146162 | 12 | 5.796 | 25217.7 |
136 | 2023-03-31 14:08:30 | pizzeria | 4 | 161609 | 194 | 12.126 | 13327.5 |
135 | 2023-03-21 03:05:20 | pizzeria | 1 | 82945 | 2 | 1.296 | 64000.8 |
134 | 2023-03-12 13:16:46 | pizzeria | 4 | 161609 | 194 | 9.906 | 16314.3 |
133 | 2023-02-16 03:31:00 | pizzeria | 3 | 146162 | 12 | 6.766 | 21602.4 |
132 | 2023-01-08 00:30:14 | pizzeria | 1 | 82945 | 2 | 1.250 | 66356.0 |
131 | 2022-12-15 23:13:52 | pizzeria | 4 | 161609 | 194 | 10.876 | 14859.2 |
130 | 2022-12-15 02:14:28 | pizzeria | 4 | 161609 | 194 | 10.406 | 15530.4 |
129 | 2022-11-27 05:22:38 | pizzeria | 3 | 146162 | 12 | 7.110 | 20557.2 |
128 | 2022-10-28 14:57:14 | pizzeria | 4 | 161609 | 194 | 10.076 | 16039.0 |
127 | 2022-10-23 23:33:44 | pizzeria | 4 | 161609 | 194 | 10.050 | 16080.5 |
126 | 2022-10-04 12:44:45 | pizzeria | 1 | 82945 | 2 | 1.280 | 64800.8 |
125 | 2022-09-27 06:11:05 | pizzeria | 4 | 161609 | 194 | 10.013 | 16139.9 |
124 | 2022-09-01 16:56:29 | pizzeria | 1 | 82945 | 2 | 1.250 | 66356.0 |
123 | 2022-08-09 09:00:31 | pizzeria | 4 | 161609 | 194 | 10.140 | 15937.8 |
122 | 2022-07-04 01:51:01 | pizzeria | 3 | 146162 | 12 | 6.170 | 23689.1 |
121 | 2022-05-19 00:24:34 | pizzeria | 1 | 82945 | 2 | 1.296 | 64000.8 |
120 | 2021-06-20 16:19:28 | pizzeria | 1 | 82945 | 2 | 1.266 | 65517.4 |
119 | 2021-04-17 04:32:41 | pizzeria | 1 | 82945 | 2 | 1.466 | 56579.1 |
118 | 2021-01-29 18:38:30 | pizzeria | 1 | 82945 | 2 | 1.283 | 64649.3 |
117 | 2020-11-15 13:00:52 | pizzeria | 1 | 82945 | 2 | 1.356 | 61168.9 |
116 | 2020-10-13 22:25:23 | pizzeria | 1 | 82945 | 2 | 1.360 | 60989.0 |
115 | 2020-07-30 23:47:55 | pizzeria | 1 | 82945 | 2 | 1.326 | 62552.8 |