History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"motorway"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
207 | 2024-05-16 10:36:00 | motorway | 3 | 146162 | 27 | 9.733 | 15017.2 |
206 | 2024-05-16 10:36:02 | motorway | 1 | 82945 | 2 | 2.890 | 28700.7 |
205 | 2024-05-16 10:35:59 | motorway | 2 | 121059 | 6 | 4.050 | 29891.1 |
204 | 2024-05-16 07:36:58 | motorway | 1 | 82945 | 2 | 1.456 | 56967.7 |
203 | 2024-05-11 23:50:55 | motorway | 1 | 82945 | 2 | 4.986 | 16635.6 |
202 | 2024-05-09 15:36:36 | motorway | 4 | 161609 | 250 | 49.503 | 3264.6 |
201 | 2024-05-07 13:25:35 | motorway | 4 | 161609 | 250 | 31.720 | 5094.9 |
200 | 2024-05-07 08:38:32 | motorway | 1 | 82945 | 2 | 1.500 | 55296.7 |
199 | 2024-05-06 23:05:47 | motorway | 4 | 161609 | 250 | 15.610 | 10352.9 |
198 | 2024-05-05 18:29:47 | motorway | 3 | 146162 | 27 | 20.986 | 6964.7 |
197 | 2024-05-05 14:20:37 | motorway | 4 | 161609 | 250 | 22.440 | 7201.8 |
196 | 2024-05-05 14:20:05 | motorway | 3 | 146162 | 27 | 14.033 | 10415.6 |
195 | 2024-05-04 15:06:39 | motorway | 4 | 161609 | 250 | 14.983 | 10786.2 |
194 | 2024-05-04 12:12:12 | motorway | 4 | 161609 | 250 | 26.970 | 5992.2 |
193 | 2024-05-04 12:12:20 | motorway | 3 | 146162 | 27 | 14.673 | 9961.3 |
192 | 2024-05-04 12:12:28 | motorway | 1 | 82945 | 2 | 1.643 | 50483.9 |
191 | 2024-05-04 12:12:24 | motorway | 1 | 82945 | 2 | 2.750 | 30161.8 |
190 | 2024-05-04 12:12:16 | motorway | 2 | 121059 | 6 | 4.300 | 28153.3 |
189 | 2024-05-01 20:17:12 | motorway | 1 | 82945 | 2 | 3.076 | 26965.2 |
188 | 2024-04-29 21:19:17 | motorway | 1 | 82945 | 2 | 1.500 | 55296.7 |
187 | 2024-04-24 18:25:17 | motorway | 1 | 82945 | 2 | 1.470 | 56425.2 |
186 | 2024-04-16 11:54:20 | motorway | 3 | 146162 | 27 | 14.546 | 10048.3 |
185 | 2024-04-16 07:29:11 | motorway | 3 | 146162 | 27 | 7.610 | 19206.6 |
184 | 2024-04-16 07:29:14 | motorway | 2 | 121059 | 6 | 4.123 | 29361.9 |
183 | 2024-04-16 07:29:10 | motorway | 1 | 82945 | 2 | 1.470 | 56425.2 |
182 | 2024-04-11 00:40:03 | motorway | 2 | 121059 | 6 | 4.063 | 29795.5 |
181 | 2024-04-11 00:40:02 | motorway | 1 | 82945 | 2 | 3.110 | 26670.4 |
180 | 2024-04-07 21:14:40 | motorway | 4 | 161609 | 250 | 30.983 | 5216.1 |
179 | 2024-04-07 11:53:07 | motorway | 4 | 161609 | 250 | 28.016 | 5768.5 |
178 | 2024-04-06 14:32:45 | motorway | 4 | 161609 | 250 | 25.110 | 6436.0 |
177 | 2024-04-05 09:43:00 | motorway | 4 | 161609 | 250 | 28.393 | 5691.9 |
176 | 2024-04-03 12:49:35 | motorway | 2 | 121059 | 6 | 9.033 | 13401.9 |
175 | 2024-04-03 12:49:00 | motorway | 3 | 146162 | 27 | 22.656 | 6451.4 |
174 | 2024-04-03 12:49:06 | motorway | 3 | 146162 | 27 | 9.560 | 15288.9 |
173 | 2024-04-03 10:40:04 | motorway | 3 | 146162 | 27 | 10.453 | 13982.8 |
172 | 2024-04-01 15:48:44 | motorway | 1 | 82945 | 2 | 1.530 | 54212.4 |
171 | 2024-04-01 15:48:07 | motorway | 4 | 161609 | 250 | 18.906 | 8548.0 |
170 | 2024-04-01 15:48:08 | motorway | 3 | 146162 | 27 | 16.673 | 8766.4 |
169 | 2024-04-01 15:47:38 | motorway | 4 | 161609 | 250 | 34.266 | 4716.3 |
168 | 2024-04-01 15:47:34 | motorway | 1 | 82945 | 2 | 1.420 | 58412.0 |
167 | 2024-04-01 15:47:28 | motorway | 2 | 121059 | 6 | 4.173 | 29010.1 |
166 | 2024-04-01 08:47:13 | motorway | 1 | 82945 | 2 | 3.110 | 26670.4 |
165 | 2024-04-01 08:26:05 | motorway | 1 | 82945 | 2 | 3.016 | 27501.7 |
164 | 2024-04-01 08:25:46 | motorway | 2 | 121059 | 6 | 9.720 | 12454.6 |
163 | 2024-03-20 00:33:45 | motorway | 2 | 121059 | 6 | 5.453 | 22200.4 |
162 | 2024-03-12 00:23:46 | motorway | 1 | 82945 | 2 | 4.250 | 19516.5 |
161 | 2024-03-07 10:30:41 | motorway | 2 | 121059 | 6 | 8.530 | 14192.1 |
160 | 2024-03-07 10:30:40 | motorway | 3 | 146162 | 27 | 8.923 | 16380.4 |
159 | 2024-03-07 06:22:33 | motorway | 1 | 82945 | 2 | 1.720 | 48223.8 |
158 | 2024-03-06 23:40:57 | motorway | 4 | 161609 | 250 | 45.316 | 3566.3 |
157 | 2024-03-06 08:00:51 | motorway | 4 | 161609 | 250 | 36.486 | 4429.3 |
156 | 2024-03-05 09:21:27 | motorway | 4 | 161609 | 250 | 16.046 | 10071.6 |
155 | 2024-03-05 01:40:37 | motorway | 4 | 161609 | 250 | 39.456 | 4095.9 |
154 | 2024-03-02 16:01:37 | motorway | 3 | 146162 | 27 | 7.423 | 19690.4 |
153 | 2024-03-02 09:15:09 | motorway | 4 | 161609 | 250 | 15.563 | 10384.2 |
152 | 2024-03-02 07:26:54 | motorway | 4 | 161609 | 250 | 33.736 | 4790.4 |
151 | 2024-03-02 07:26:55 | motorway | 3 | 146162 | 27 | 14.826 | 9858.5 |
150 | 2024-03-02 07:26:55 | motorway | 2 | 121059 | 6 | 7.453 | 16243.0 |
149 | 2024-03-02 07:26:51 | motorway | 1 | 82945 | 2 | 4.796 | 17294.6 |
148 | 2024-02-28 12:34:21 | motorway | 1 | 82945 | 2 | 1.500 | 55296.7 |
147 | 2024-02-27 21:49:07 | motorway | 2 | 121059 | 6 | 12.640 | 9577.5 |
146 | 2024-02-27 21:49:04 | motorway | 1 | 82945 | 2 | 3.156 | 26281.7 |
145 | 2024-02-04 08:20:35 | motorway | 3 | 146162 | 27 | 15.000 | 9744.1 |
144 | 2024-01-30 19:00:35 | motorway | 3 | 146162 | 27 | 9.830 | 14869.0 |
143 | 2024-01-30 02:47:41 | motorway | 4 | 161609 | 250 | 13.770 | 11736.3 |
142 | 2024-01-30 01:19:31 | motorway | 4 | 161609 | 250 | 16.263 | 9937.2 |
141 | 2024-01-30 01:15:03 | motorway | 3 | 146162 | 27 | 7.173 | 20376.7 |
140 | 2024-01-30 01:14:48 | motorway | 4 | 161609 | 250 | 13.313 | 12139.2 |
139 | 2024-01-30 01:14:43 | motorway | 2 | 121059 | 6 | 3.856 | 31395.0 |
138 | 2023-12-23 22:57:46 | motorway | 1 | 82945 | 2 | 1.296 | 64000.8 |
137 | 2023-11-28 16:43:34 | motorway | 2 | 121059 | 6 | 3.686 | 32842.9 |
136 | 2023-11-18 14:29:14 | motorway | 4 | 161609 | 250 | 17.453 | 9259.7 |
135 | 2023-11-18 14:29:05 | motorway | 3 | 146162 | 27 | 9.016 | 16211.4 |
134 | 2023-11-18 14:29:09 | motorway | 2 | 121059 | 6 | 3.796 | 31891.2 |
133 | 2023-11-08 15:49:25 | motorway | 1 | 82945 | 2 | 1.406 | 58993.6 |
132 | 2023-10-11 02:15:12 | motorway | 1 | 82945 | 2 | 1.486 | 55817.6 |
131 | 2023-08-28 04:17:57 | motorway | 2 | 121059 | 6 | 3.653 | 33139.6 |
130 | 2023-08-06 08:02:59 | motorway | 1 | 82945 | 2 | 1.250 | 66356.0 |
129 | 2023-05-11 19:40:49 | motorway | 2 | 121059 | 6 | 3.656 | 33112.4 |
128 | 2023-05-06 19:57:50 | motorway | 1 | 82945 | 2 | 1.233 | 67270.9 |
127 | 2023-04-22 11:55:18 | motorway | 1 | 82945 | 2 | 1.313 | 63172.1 |
126 | 2023-03-20 04:23:27 | motorway | 1 | 82945 | 2 | 1.406 | 58993.6 |
125 | 2023-02-28 10:53:40 | motorway | 1 | 82945 | 2 | 1.393 | 59544.1 |
124 | 2023-02-15 07:03:25 | motorway | 2 | 121059 | 6 | 3.376 | 35858.7 |
123 | 2022-12-25 02:14:48 | motorway | 1 | 82945 | 2 | 2.593 | 31988.0 |
122 | 2022-11-27 07:21:41 | motorway | 2 | 121059 | 6 | 3.546 | 34139.6 |
121 | 2022-09-13 09:02:42 | motorway | 1 | 82945 | 2 | 1.283 | 64649.3 |
120 | 2022-07-18 04:56:33 | motorway | 1 | 82945 | 2 | 1.313 | 63172.1 |
119 | 2022-07-15 21:37:18 | motorway | 1 | 82945 | 2 | 1.280 | 64800.8 |
118 | 2022-07-04 20:11:10 | motorway | 2 | 121059 | 6 | 3.173 | 38152.9 |
117 | 2022-05-25 02:03:01 | motorway | 1 | 82945 | 2 | 1.283 | 64649.3 |
116 | 2022-03-15 17:30:19 | motorway | 1 | 82945 | 2 | 1.513 | 54821.5 |
115 | 2022-02-16 01:24:48 | motorway | 2 | 121059 | 6 | 3.186 | 37997.2 |
114 | 2022-02-13 20:35:37 | motorway | 2 | 121059 | 6 | 3.533 | 34265.2 |
113 | 2021-12-25 22:52:16 | motorway | 1 | 82945 | 2 | 1.280 | 64800.8 |
112 | 2021-11-29 02:23:53 | motorway | 2 | 121059 | 6 | 4.283 | 28265.0 |
111 | 2021-11-16 06:40:55 | motorway | 1 | 82945 | 2 | 1.606 | 51646.9 |
110 | 2021-06-05 12:19:41 | motorway | 1 | 82945 | 2 | 1.440 | 57600.7 |
109 | 2021-05-20 04:58:31 | motorway | 1 | 82945 | 2 | 1.283 | 64649.3 |
108 | 2021-02-15 15:15:09 | motorway | 1 | 82945 | 2 | 1.423 | 58288.8 |