History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"overpasses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
201 | 2024-05-05 22:17:07 | overpasses | 3 | 140603 | 51 | 6.376 | 22051.9 |
200 | 2024-05-05 22:17:08 | overpasses | 2 | 108824 | 6 | 3.046 | 35726.9 |
199 | 2024-05-05 22:16:43 | overpasses | 4 | 161450 | 336 | 16.360 | 9868.6 |
198 | 2024-05-05 21:06:23 | overpasses | 1 | 67641 | 2 | 1.986 | 34058.9 |
197 | 2024-05-03 14:58:42 | overpasses | 1 | 67641 | 2 | 2.170 | 31171.0 |
196 | 2024-04-28 17:48:08 | overpasses | 1 | 67641 | 2 | 1.093 | 61885.6 |
195 | 2024-04-26 04:05:32 | overpasses | 1 | 67641 | 2 | 1.190 | 56841.2 |
194 | 2024-04-26 03:56:52 | overpasses | 1 | 67641 | 2 | 1.160 | 58311.2 |
193 | 2024-04-08 05:07:48 | overpasses | 1 | 67641 | 2 | 1.110 | 60937.8 |
192 | 2024-03-29 10:22:55 | overpasses | 1 | 67641 | 2 | 1.156 | 58513.0 |
191 | 2024-03-28 17:23:32 | overpasses | 2 | 108824 | 6 | 8.686 | 12528.7 |
190 | 2024-03-27 01:41:26 | overpasses | 1 | 67641 | 2 | 1.140 | 59334.2 |
189 | 2024-03-25 23:01:41 | overpasses | 2 | 108824 | 6 | 3.936 | 27648.4 |
188 | 2024-03-25 23:01:29 | overpasses | 1 | 67641 | 2 | 1.143 | 59178.5 |
187 | 2024-03-24 03:43:20 | overpasses | 4 | 161450 | 336 | 28.923 | 5582.1 |
186 | 2024-03-23 08:11:31 | overpasses | 4 | 161450 | 336 | 40.190 | 4017.2 |
185 | 2024-03-23 08:07:38 | overpasses | 1 | 67641 | 2 | 2.233 | 30291.5 |
184 | 2024-03-10 13:09:48 | overpasses | 3 | 140603 | 51 | 8.173 | 17203.4 |
183 | 2024-03-10 09:27:52 | overpasses | 1 | 67641 | 2 | 1.296 | 52192.1 |
182 | 2024-03-09 22:08:23 | overpasses | 3 | 140603 | 51 | 15.783 | 8908.5 |
181 | 2024-03-08 17:57:20 | overpasses | 3 | 140603 | 51 | 17.203 | 8173.2 |
180 | 2024-03-08 17:57:25 | overpasses | 2 | 108824 | 6 | 7.206 | 15101.9 |
179 | 2024-03-07 05:56:53 | overpasses | 1 | 67641 | 2 | 2.576 | 26258.2 |
178 | 2024-02-25 21:28:18 | overpasses | 4 | 161450 | 336 | 37.813 | 4269.7 |
177 | 2024-02-25 21:28:01 | overpasses | 2 | 108824 | 6 | 21.686 | 5018.2 |
176 | 2024-02-25 21:28:02 | overpasses | 3 | 140603 | 51 | 14.436 | 9739.7 |
175 | 2024-02-25 20:57:20 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
174 | 2024-02-21 05:39:27 | overpasses | 4 | 161450 | 336 | 30.030 | 5376.3 |
173 | 2024-02-20 21:02:45 | overpasses | 1 | 67641 | 2 | 1.186 | 57032.9 |
172 | 2024-02-19 11:41:13 | overpasses | 1 | 67641 | 2 | 2.436 | 27767.2 |
171 | 2024-02-07 06:55:22 | overpasses | 1 | 67641 | 2 | 1.173 | 57665.0 |
170 | 2024-02-07 00:59:54 | overpasses | 1 | 67641 | 2 | 1.106 | 61158.2 |
169 | 2024-02-04 07:30:12 | overpasses | 4 | 161450 | 336 | 23.563 | 6851.8 |
168 | 2024-02-04 07:30:04 | overpasses | 3 | 140603 | 51 | 10.330 | 13611.1 |
167 | 2024-02-04 07:29:57 | overpasses | 2 | 108824 | 6 | 3.360 | 32388.1 |
166 | 2024-02-04 07:21:33 | overpasses | 1 | 67641 | 2 | 1.233 | 54858.9 |
165 | 2024-01-26 08:14:31 | overpasses | 1 | 67641 | 2 | 1.123 | 60232.4 |
164 | 2024-01-20 05:04:54 | overpasses | 1 | 67641 | 2 | 1.013 | 66773.0 |
163 | 2024-01-12 10:22:55 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
162 | 2023-12-13 16:30:54 | overpasses | 1 | 67641 | 2 | 1.030 | 65670.9 |
161 | 2023-12-03 02:19:29 | overpasses | 1 | 67641 | 2 | 1.200 | 56367.5 |
160 | 2023-11-11 12:54:00 | overpasses | 1 | 67641 | 2 | 0.983 | 68810.8 |
159 | 2023-09-28 04:03:16 | overpasses | 1 | 67641 | 2 | 1.046 | 64666.3 |
158 | 2023-09-09 10:43:38 | overpasses | 1 | 67641 | 2 | 1.106 | 61158.2 |
157 | 2023-07-25 13:26:09 | overpasses | 1 | 67641 | 2 | 1.156 | 58513.0 |
156 | 2023-05-09 12:55:44 | overpasses | 1 | 67641 | 2 | 1.140 | 59334.2 |
155 | 2023-04-19 00:15:46 | overpasses | 1 | 67641 | 2 | 0.983 | 68810.8 |
154 | 2023-02-05 06:00:43 | overpasses | 1 | 67641 | 2 | 0.970 | 69733.0 |
153 | 2023-01-16 04:50:28 | overpasses | 1 | 67641 | 2 | 1.186 | 57032.9 |
152 | 2022-12-04 10:49:39 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
151 | 2022-09-07 00:31:43 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
150 | 2022-07-30 21:45:48 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
149 | 2022-04-27 15:53:16 | overpasses | 1 | 67641 | 2 | 1.140 | 59334.2 |
148 | 2022-03-27 12:07:35 | overpasses | 1 | 67641 | 2 | 1.016 | 66575.8 |
147 | 2022-03-25 07:56:31 | overpasses | 1 | 67641 | 2 | 1.033 | 65480.2 |
146 | 2022-01-15 05:29:15 | overpasses | 1 | 67641 | 2 | 1.156 | 58513.0 |
145 | 2021-12-29 00:51:36 | overpasses | 1 | 67641 | 2 | 1.013 | 66773.0 |
144 | 2021-10-29 18:51:33 | overpasses | 1 | 67641 | 2 | 1.110 | 60937.8 |
143 | 2021-09-24 19:40:52 | overpasses | 1 | 67641 | 2 | 1.156 | 58513.0 |
142 | 2021-09-12 07:06:50 | overpasses | 1 | 67641 | 2 | 1.080 | 62630.6 |
141 | 2021-06-12 00:50:12 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
140 | 2021-04-17 05:04:08 | overpasses | 1 | 67641 | 2 | 1.423 | 47534.1 |
139 | 2021-03-08 23:31:39 | overpasses | 1 | 67641 | 2 | 1.110 | 60937.8 |
138 | 2021-03-05 19:34:37 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
137 | 2021-02-26 16:05:58 | overpasses | 1 | 67641 | 2 | 0.986 | 68601.4 |
136 | 2021-01-29 18:25:31 | overpasses | 1 | 67641 | 2 | 0.983 | 68810.8 |
135 | 2021-01-01 10:18:05 | overpasses | 1 | 67641 | 2 | 1.156 | 58513.0 |
134 | 2020-11-26 19:17:39 | overpasses | 1 | 67641 | 2 | 1.126 | 60071.9 |
133 | 2020-11-13 22:48:05 | overpasses | 3 | 140603 | 51 | 5.796 | 24258.6 |
132 | 2020-11-11 21:17:54 | overpasses | 1 | 67641 | 2 | 1.296 | 52192.1 |
131 | 2020-10-20 09:45:53 | overpasses | 1 | 67641 | 2 | 1.766 | 38301.8 |
130 | 2020-10-17 21:16:58 | overpasses | 1 | 67641 | 2 | 1.126 | 60071.9 |
129 | 2020-10-17 09:22:07 | overpasses | 1 | 67641 | 2 | 1.000 | 67641.0 |
128 | 2020-08-14 17:52:12 | overpasses | 1 | 67641 | 2 | 1.030 | 65670.9 |
127 | 2020-05-07 13:27:14 | overpasses | 1 | 67641 | 2 | 1.076 | 62863.4 |
126 | 2020-03-30 09:38:02 | overpasses | 1 | 67641 | 2 | 1.126 | 60071.9 |
125 | 2020-03-24 10:38:25 | overpasses | 1 | 67641 | 2 | 2.313 | 29243.8 |
124 | 2020-03-02 20:16:29 | overpasses | 1 | 67641 | 2 | 2.500 | 27056.4 |
123 | 2020-02-23 11:15:34 | overpasses | 1 | 67641 | 2 | 1.360 | 49736.0 |
122 | 2020-02-20 09:14:35 | overpasses | 4 | 161450 | 336 | 12.906 | 12509.7 |
121 | 2020-02-18 18:34:38 | overpasses | 4 | 161450 | 336 | 12.580 | 12833.9 |
120 | 2020-02-16 19:31:01 | overpasses | 4 | 161450 | 336 | 11.253 | 14347.3 |
119 | 2020-02-15 06:45:08 | overpasses | 1 | 67641 | 2 | 3.876 | 17451.2 |
118 | 2020-02-14 17:09:12 | overpasses | 4 | 161450 | 336 | 15.686 | 10292.6 |
117 | 2020-02-13 15:10:53 | overpasses | 4 | 161450 | 336 | 24.720 | 6531.1 |
116 | 2020-02-13 03:28:24 | overpasses | 4 | 161450 | 336 | 21.783 | 7411.7 |
115 | 2020-02-13 01:26:54 | overpasses | 1 | 67641 | 2 | 1.250 | 54112.8 |
114 | 2020-02-09 09:27:13 | overpasses | 1 | 67641 | 2 | 4.063 | 16648.0 |
113 | 2020-02-08 17:37:52 | overpasses | 1 | 67641 | 2 | 1.250 | 54112.8 |
112 | 2020-01-30 02:02:43 | overpasses | 1 | 67641 | 2 | 1.076 | 62863.4 |
111 | 2020-01-27 02:42:15 | overpasses | 1 | 67641 | 2 | 1.173 | 57665.0 |
110 | 2020-01-24 18:23:19 | overpasses | 1 | 67641 | 2 | 1.296 | 52192.1 |
109 | 2020-01-23 00:19:55 | overpasses | 1 | 67641 | 2 | 2.970 | 22774.7 |
108 | 2020-01-22 21:59:38 | overpasses | 4 | 161450 | 336 | 21.050 | 7669.8 |
107 | 2020-01-22 18:54:54 | overpasses | 4 | 161450 | 336 | 24.076 | 6705.8 |
106 | 2020-01-22 17:37:00 | overpasses | 4 | 161450 | 336 | 29.283 | 5513.4 |
105 | 2020-01-22 05:43:07 | overpasses | 1 | 67641 | 2 | 3.516 | 19238.1 |
104 | 2020-01-16 14:30:24 | overpasses | 4 | 161450 | 336 | 11.140 | 14492.8 |
103 | 2020-01-16 09:46:24 | overpasses | 2 | 108824 | 6 | 6.580 | 16538.6 |
102 | 2020-01-16 06:35:54 | overpasses | 4 | 161450 | 336 | 15.876 | 10169.4 |