History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deadbolt"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
207 | 2024-04-26 11:44:06 | deadbolt | 2 | 121059 | 3 | 3.826 | 31641.1 |
206 | 2024-04-26 11:43:23 | deadbolt | 3 | 146162 | 22 | 7.970 | 18339.0 |
205 | 2024-04-25 00:08:15 | deadbolt | 3 | 146162 | 22 | 24.126 | 6058.3 |
204 | 2024-04-25 00:08:13 | deadbolt | 2 | 121059 | 3 | 4.783 | 25310.3 |
203 | 2024-04-24 22:58:16 | deadbolt | 1 | 82945 | 2 | 1.406 | 58993.6 |
202 | 2024-04-13 04:08:16 | deadbolt | 4 | 161609 | 245 | 16.766 | 9639.1 |
201 | 2024-04-12 12:03:16 | deadbolt | 4 | 161609 | 245 | 17.783 | 9087.8 |
200 | 2024-04-11 02:25:54 | deadbolt | 4 | 161609 | 245 | 33.470 | 4828.5 |
199 | 2024-04-11 02:25:58 | deadbolt | 3 | 146162 | 22 | 16.110 | 9072.7 |
198 | 2024-04-11 02:26:00 | deadbolt | 2 | 121059 | 3 | 6.733 | 17979.9 |
197 | 2024-04-11 02:25:42 | deadbolt | 1 | 82945 | 2 | 2.173 | 38170.7 |
196 | 2024-04-01 11:53:36 | deadbolt | 2 | 121059 | 3 | 8.563 | 14137.5 |
195 | 2024-04-01 11:53:35 | deadbolt | 3 | 146162 | 22 | 8.766 | 16673.7 |
194 | 2024-04-01 11:53:35 | deadbolt | 1 | 82945 | 2 | 3.233 | 25655.7 |
193 | 2024-03-29 04:25:28 | deadbolt | 1 | 82945 | 2 | 3.843 | 21583.4 |
192 | 2024-03-24 22:33:51 | deadbolt | 1 | 82945 | 2 | 1.296 | 64000.8 |
191 | 2024-03-24 22:33:47 | deadbolt | 2 | 121059 | 3 | 3.436 | 35232.5 |
190 | 2024-03-21 22:56:13 | deadbolt | 3 | 146162 | 22 | 10.203 | 14325.4 |
189 | 2024-03-18 21:59:38 | deadbolt | 3 | 146162 | 22 | 14.266 | 10245.5 |
188 | 2024-03-18 11:45:36 | deadbolt | 4 | 161609 | 245 | 23.283 | 6941.1 |
187 | 2024-03-18 04:20:12 | deadbolt | 4 | 161609 | 245 | 24.500 | 6596.3 |
186 | 2024-03-14 21:16:45 | deadbolt | 3 | 146162 | 22 | 23.983 | 6094.4 |
185 | 2024-03-14 14:44:57 | deadbolt | 4 | 161609 | 245 | 37.533 | 4305.8 |
184 | 2024-03-13 21:36:38 | deadbolt | 4 | 161609 | 245 | 15.936 | 10141.1 |
183 | 2024-03-12 01:31:45 | deadbolt | 4 | 161609 | 245 | 14.623 | 11051.7 |
182 | 2024-03-12 01:31:46 | deadbolt | 3 | 146162 | 22 | 11.690 | 12503.2 |
181 | 2024-03-12 01:31:48 | deadbolt | 2 | 121059 | 3 | 4.173 | 29010.1 |
180 | 2024-03-12 01:31:23 | deadbolt | 4 | 161609 | 245 | 21.610 | 7478.4 |
179 | 2024-03-12 01:31:38 | deadbolt | 1 | 82945 | 2 | 1.610 | 51518.6 |
178 | 2024-03-12 01:31:25 | deadbolt | 3 | 146162 | 22 | 13.503 | 10824.4 |
177 | 2024-03-12 01:31:26 | deadbolt | 2 | 121059 | 3 | 8.220 | 14727.4 |
176 | 2024-03-12 01:31:21 | deadbolt | 1 | 82945 | 2 | 2.546 | 32578.6 |
175 | 2024-03-02 09:29:02 | deadbolt | 3 | 146162 | 22 | 9.313 | 15694.4 |
174 | 2024-03-02 09:29:01 | deadbolt | 2 | 121059 | 3 | 5.046 | 23991.1 |
173 | 2024-03-02 09:28:52 | deadbolt | 1 | 82945 | 2 | 1.656 | 50087.6 |
172 | 2024-02-18 02:40:23 | deadbolt | 1 | 82945 | 2 | 1.513 | 54821.5 |
171 | 2024-02-14 21:12:57 | deadbolt | 4 | 161609 | 245 | 14.156 | 11416.3 |
170 | 2024-02-09 17:51:53 | deadbolt | 4 | 161609 | 245 | 13.596 | 11886.5 |
169 | 2024-02-06 22:06:18 | deadbolt | 4 | 161609 | 245 | 24.140 | 6694.7 |
168 | 2024-02-06 22:06:21 | deadbolt | 3 | 146162 | 22 | 16.843 | 8677.9 |
167 | 2024-02-06 00:08:10 | deadbolt | 2 | 121059 | 3 | 4.936 | 24525.7 |
166 | 2024-02-06 00:07:58 | deadbolt | 3 | 146162 | 22 | 9.576 | 15263.4 |
165 | 2024-02-05 21:55:37 | deadbolt | 2 | 121059 | 3 | 3.983 | 30393.9 |
164 | 2024-02-05 21:55:21 | deadbolt | 4 | 161609 | 245 | 13.640 | 11848.2 |
163 | 2024-02-05 21:55:25 | deadbolt | 3 | 146162 | 22 | 7.843 | 18636.0 |
162 | 2024-02-05 11:24:25 | deadbolt | 2 | 121059 | 3 | 4.376 | 27664.3 |
161 | 2024-02-05 11:24:13 | deadbolt | 4 | 161609 | 245 | 15.393 | 10498.9 |
160 | 2024-02-05 11:24:03 | deadbolt | 3 | 146162 | 22 | 18.110 | 8070.8 |
159 | 2024-02-05 11:15:22 | deadbolt | 1 | 82945 | 2 | 1.486 | 55817.6 |
158 | 2024-01-15 10:51:37 | deadbolt | 1 | 82945 | 2 | 1.453 | 57085.3 |
157 | 2024-01-12 17:58:01 | deadbolt | 1 | 82945 | 2 | 1.390 | 59672.7 |
156 | 2024-01-11 10:17:15 | deadbolt | 1 | 82945 | 2 | 1.330 | 62364.7 |
155 | 2024-01-05 21:25:18 | deadbolt | 1 | 82945 | 2 | 1.313 | 63172.1 |
154 | 2023-11-13 14:49:12 | deadbolt | 1 | 82945 | 2 | 1.466 | 56579.1 |
153 | 2023-11-06 17:13:11 | deadbolt | 1 | 82945 | 2 | 2.563 | 32362.5 |
152 | 2023-10-30 03:33:23 | deadbolt | 1 | 82945 | 2 | 1.330 | 62364.7 |
151 | 2023-08-28 07:52:27 | deadbolt | 1 | 82945 | 2 | 1.406 | 58993.6 |
150 | 2023-08-24 03:16:35 | deadbolt | 1 | 82945 | 2 | 1.470 | 56425.2 |
149 | 2023-05-31 05:50:55 | deadbolt | 1 | 82945 | 2 | 1.266 | 65517.4 |
148 | 2023-04-22 02:10:26 | deadbolt | 1 | 82945 | 2 | 1.280 | 64800.8 |
147 | 2023-03-24 23:49:18 | deadbolt | 1 | 82945 | 2 | 1.250 | 66356.0 |
146 | 2023-01-09 06:32:11 | deadbolt | 1 | 82945 | 2 | 1.236 | 67107.6 |
145 | 2022-12-15 08:46:15 | deadbolt | 1 | 82945 | 2 | 1.296 | 64000.8 |
144 | 2022-10-12 16:32:51 | deadbolt | 1 | 82945 | 2 | 1.283 | 64649.3 |
143 | 2022-08-02 02:22:04 | deadbolt | 1 | 82945 | 2 | 1.263 | 65673.0 |
142 | 2022-06-02 07:59:26 | deadbolt | 1 | 82945 | 2 | 1.453 | 57085.3 |
141 | 2022-03-14 10:18:52 | deadbolt | 1 | 82945 | 2 | 1.546 | 53651.4 |
140 | 2021-11-03 20:00:27 | deadbolt | 1 | 82945 | 2 | 1.453 | 57085.3 |
139 | 2021-07-21 11:48:14 | deadbolt | 1 | 82945 | 2 | 1.266 | 65517.4 |
138 | 2021-06-02 17:28:55 | deadbolt | 3 | 146162 | 22 | 8.156 | 17920.8 |
137 | 2021-05-08 12:12:32 | deadbolt | 3 | 146162 | 22 | 7.593 | 19249.6 |
136 | 2021-05-02 02:30:30 | deadbolt | 1 | 82945 | 2 | 1.533 | 54106.3 |
135 | 2021-04-18 15:43:23 | deadbolt | 1 | 82945 | 2 | 1.780 | 46598.3 |
134 | 2021-04-14 15:19:38 | deadbolt | 2 | 121059 | 3 | 7.406 | 16346.1 |
133 | 2021-02-21 03:59:32 | deadbolt | 2 | 121059 | 3 | 3.686 | 32842.9 |
132 | 2021-01-22 03:55:28 | deadbolt | 3 | 146162 | 22 | 6.673 | 21903.5 |
131 | 2021-01-15 03:13:52 | deadbolt | 1 | 82945 | 2 | 1.500 | 55296.7 |
130 | 2021-01-01 08:56:20 | deadbolt | 1 | 82945 | 2 | 1.300 | 63803.8 |
129 | 2020-11-17 00:03:16 | deadbolt | 3 | 146162 | 22 | 6.983 | 20931.1 |
128 | 2020-11-08 15:55:08 | deadbolt | 2 | 121059 | 3 | 8.410 | 14394.6 |
127 | 2020-11-02 05:59:55 | deadbolt | 3 | 146162 | 22 | 7.313 | 19986.6 |
126 | 2020-10-20 17:58:27 | deadbolt | 2 | 121059 | 3 | 3.953 | 30624.6 |
125 | 2020-10-20 14:52:58 | deadbolt | 1 | 82945 | 2 | 1.280 | 64800.8 |
124 | 2020-10-17 18:21:48 | deadbolt | 3 | 146162 | 22 | 7.500 | 19488.3 |
123 | 2020-10-04 16:51:43 | deadbolt | 1 | 82945 | 2 | 1.390 | 59672.7 |
122 | 2020-09-29 09:56:04 | deadbolt | 1 | 82945 | 2 | 1.266 | 65517.4 |
121 | 2020-08-27 21:20:50 | deadbolt | 1 | 82945 | 2 | 1.453 | 57085.3 |
120 | 2020-07-29 23:57:04 | deadbolt | 1 | 82945 | 2 | 1.343 | 61761.0 |
119 | 2020-06-07 17:00:07 | deadbolt | 1 | 82945 | 2 | 1.296 | 64000.8 |
118 | 2020-03-27 19:07:06 | deadbolt | 1 | 82945 | 2 | 1.466 | 56579.1 |
117 | 2020-03-22 19:13:00 | deadbolt | 1 | 82945 | 2 | 1.580 | 52496.8 |
116 | 2020-02-26 09:55:32 | deadbolt | 1 | 82945 | 2 | 1.563 | 53067.8 |
115 | 2020-02-14 14:14:46 | deadbolt | 1 | 82945 | 2 | 3.373 | 24590.9 |
114 | 2020-02-06 01:44:41 | deadbolt | 1 | 82945 | 2 | 1.750 | 47397.1 |
113 | 2020-02-05 07:06:38 | deadbolt | 1 | 82945 | 2 | 1.360 | 60989.0 |
112 | 2020-02-03 13:08:51 | deadbolt | 1 | 82945 | 2 | 1.643 | 50483.9 |
111 | 2020-01-29 20:20:27 | deadbolt | 1 | 82945 | 2 | 1.360 | 60989.0 |
110 | 2020-01-22 10:19:14 | deadbolt | 1 | 82945 | 2 | 1.966 | 42189.7 |
109 | 2020-01-16 18:28:08 | deadbolt | 1 | 82945 | 2 | 1.296 | 64000.8 |
108 | 2020-01-04 03:12:16 | deadbolt | 1 | 82945 | 2 | 1.436 | 57761.1 |