History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"blackthorn"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-05-11 14:36:32 | blackthorn | 4 | 161450 | 49 | 21.420 | 7537.3 |
199 | 2024-05-11 00:17:59 | blackthorn | 4 | 161450 | 49 | 27.113 | 5954.7 |
198 | 2024-05-11 00:17:59 | blackthorn | 2 | 108824 | 3 | 7.640 | 14244.0 |
197 | 2024-05-11 00:17:55 | blackthorn | 3 | 140603 | 8 | 8.280 | 16981.0 |
196 | 2024-05-11 00:14:59 | blackthorn | 4 | 161450 | 49 | 49.676 | 3250.1 |
195 | 2024-05-11 00:15:16 | blackthorn | 2 | 108824 | 3 | 11.173 | 9739.9 |
194 | 2024-05-11 00:15:05 | blackthorn | 3 | 140603 | 8 | 19.453 | 7227.8 |
193 | 2024-05-11 00:13:41 | blackthorn | 1 | 67641 | 2 | 1.173 | 57665.0 |
192 | 2024-05-11 00:13:33 | blackthorn | 1 | 67641 | 2 | 1.203 | 56226.9 |
191 | 2024-04-28 09:57:13 | blackthorn | 5 | 173545 | 363 | 32.363 | 5362.5 |
190 | 2024-04-28 03:07:31 | blackthorn | 5 | 173545 | 363 | 39.440 | 4400.2 |
189 | 2024-03-31 17:54:01 | blackthorn | 3 | 140603 | 8 | 21.126 | 6655.4 |
188 | 2024-03-31 17:54:02 | blackthorn | 2 | 108824 | 3 | 10.423 | 10440.8 |
187 | 2024-03-29 13:13:32 | blackthorn | 4 | 161450 | 49 | 23.890 | 6758.1 |
186 | 2024-03-29 13:13:29 | blackthorn | 2 | 108824 | 3 | 11.843 | 9188.9 |
185 | 2024-03-29 13:13:24 | blackthorn | 3 | 140603 | 8 | 7.796 | 18035.3 |
184 | 2024-03-29 13:11:27 | blackthorn | 1 | 67641 | 2 | 2.656 | 25467.2 |
183 | 2024-03-26 05:17:57 | blackthorn | 5 | 173545 | 363 | 40.160 | 4321.3 |
182 | 2024-03-25 05:08:49 | blackthorn | 1 | 67641 | 2 | 1.093 | 61885.6 |
181 | 2024-03-24 18:40:17 | blackthorn | 5 | 173545 | 363 | 74.096 | 2342.2 |
180 | 2024-03-24 18:40:21 | blackthorn | 2 | 108824 | 3 | 7.250 | 15010.2 |
179 | 2024-03-24 16:41:18 | blackthorn | 1 | 67641 | 2 | 1.143 | 59178.5 |
178 | 2024-03-23 18:03:38 | blackthorn | 1 | 67641 | 2 | 2.516 | 26884.3 |
177 | 2024-03-04 00:53:26 | blackthorn | 4 | 161450 | 49 | 28.270 | 5711.0 |
176 | 2024-03-04 00:53:30 | blackthorn | 4 | 161450 | 49 | 13.890 | 11623.5 |
175 | 2024-03-04 00:53:24 | blackthorn | 2 | 108824 | 3 | 10.436 | 10427.8 |
174 | 2024-03-04 00:53:26 | blackthorn | 3 | 140603 | 8 | 7.923 | 17746.2 |
173 | 2024-03-04 00:50:13 | blackthorn | 1 | 67641 | 2 | 2.513 | 26916.4 |
172 | 2024-02-21 15:59:17 | blackthorn | 5 | 173545 | 363 | 72.630 | 2389.4 |
171 | 2024-02-21 15:59:09 | blackthorn | 4 | 161450 | 49 | 35.703 | 4522.0 |
170 | 2024-02-21 15:59:09 | blackthorn | 3 | 140603 | 8 | 7.503 | 18739.6 |
169 | 2024-02-21 15:59:08 | blackthorn | 2 | 108824 | 3 | 7.076 | 15379.3 |
168 | 2024-02-21 02:18:18 | blackthorn | 1 | 67641 | 2 | 1.186 | 57032.9 |
167 | 2024-02-06 13:33:55 | blackthorn | 1 | 67641 | 2 | 1.140 | 59334.2 |
166 | 2024-02-03 00:27:24 | blackthorn | 1 | 67641 | 2 | 1.080 | 62630.6 |
165 | 2024-02-03 00:27:19 | blackthorn | 1 | 67641 | 2 | 1.686 | 40119.2 |
164 | 2023-12-31 15:15:12 | blackthorn | 2 | 108824 | 3 | 3.593 | 30287.8 |
163 | 2023-12-31 15:15:00 | blackthorn | 3 | 140603 | 8 | 6.516 | 21578.1 |
162 | 2023-12-26 00:44:00 | blackthorn | 4 | 161450 | 49 | 10.173 | 15870.4 |
161 | 2023-12-19 14:51:06 | blackthorn | 1 | 67641 | 2 | 1.016 | 66575.8 |
160 | 2023-12-14 02:53:05 | blackthorn | 5 | 173545 | 363 | 17.503 | 9915.2 |
159 | 2023-12-12 20:55:27 | blackthorn | 4 | 161450 | 49 | 22.220 | 7266.0 |
158 | 2023-12-12 20:55:23 | blackthorn | 2 | 108824 | 3 | 7.106 | 15314.4 |
157 | 2023-12-12 20:55:20 | blackthorn | 3 | 140603 | 8 | 7.550 | 18622.9 |
156 | 2023-12-12 02:43:07 | blackthorn | 5 | 173545 | 363 | 15.843 | 10954.0 |
155 | 2023-12-06 11:39:52 | blackthorn | 5 | 173545 | 363 | 17.703 | 9803.1 |
154 | 2023-12-06 11:39:56 | blackthorn | 4 | 161450 | 49 | 11.296 | 14292.7 |
153 | 2023-12-06 11:39:47 | blackthorn | 3 | 140603 | 8 | 8.203 | 17140.4 |
152 | 2023-12-06 11:39:50 | blackthorn | 2 | 108824 | 3 | 3.123 | 34846.0 |
151 | 2023-11-24 09:09:41 | blackthorn | 5 | 173545 | 363 | 15.580 | 11139.0 |
150 | 2023-11-14 15:35:59 | blackthorn | 1 | 67641 | 2 | 1.000 | 67641.0 |
149 | 2023-11-11 11:30:51 | blackthorn | 1 | 67641 | 2 | 0.986 | 68601.4 |
148 | 2023-11-11 09:20:00 | blackthorn | 5 | 173545 | 363 | 19.910 | 8716.5 |
147 | 2023-11-11 09:20:02 | blackthorn | 4 | 161450 | 49 | 12.706 | 12706.6 |
146 | 2023-11-11 09:20:03 | blackthorn | 3 | 140603 | 8 | 8.140 | 17273.1 |
145 | 2023-11-11 09:20:04 | blackthorn | 2 | 108824 | 3 | 3.203 | 33975.6 |
144 | 2023-11-02 08:39:20 | blackthorn | 1 | 67641 | 2 | 1.140 | 59334.2 |
143 | 2023-10-28 04:01:52 | blackthorn | 1 | 67641 | 2 | 1.093 | 61885.6 |
142 | 2023-10-21 08:03:50 | blackthorn | 1 | 67641 | 2 | 0.966 | 70021.7 |
141 | 2023-10-12 21:21:42 | blackthorn | 1 | 67641 | 2 | 1.016 | 66575.8 |
140 | 2023-10-08 00:29:02 | blackthorn | 1 | 67641 | 2 | 1.000 | 67641.0 |
139 | 2023-08-04 22:11:09 | blackthorn | 1 | 67641 | 2 | 1.000 | 67641.0 |
138 | 2023-05-03 13:28:39 | blackthorn | 1 | 67641 | 2 | 1.016 | 66575.8 |
137 | 2023-02-27 14:41:02 | blackthorn | 1 | 67641 | 2 | 0.970 | 69733.0 |
136 | 2022-12-22 14:55:03 | blackthorn | 1 | 67641 | 2 | 0.986 | 68601.4 |
135 | 2022-09-08 03:27:32 | blackthorn | 1 | 67641 | 2 | 0.970 | 69733.0 |
134 | 2021-05-07 22:57:16 | blackthorn | 5 | 173545 | 363 | 23.470 | 7394.3 |
133 | 2021-04-03 10:03:35 | blackthorn | 5 | 173545 | 363 | 14.376 | 12071.9 |
132 | 2021-03-28 05:57:51 | blackthorn | 1 | 67641 | 2 | 0.983 | 68810.8 |
131 | 2021-02-27 03:19:07 | blackthorn | 1 | 67641 | 2 | 1.000 | 67641.0 |
130 | 2021-02-21 13:39:24 | blackthorn | 5 | 173545 | 363 | 14.720 | 11789.7 |
129 | 2021-02-06 09:24:07 | blackthorn | 1 | 67641 | 2 | 1.016 | 66575.8 |
128 | 2021-01-22 19:52:25 | blackthorn | 5 | 173545 | 363 | 14.906 | 11642.6 |
127 | 2020-03-31 11:34:23 | blackthorn | 1 | 67641 | 2 | 0.983 | 68810.8 |
126 | 2020-03-26 11:36:35 | blackthorn | 1 | 67641 | 2 | 1.140 | 59334.2 |
125 | 2020-02-19 23:55:43 | blackthorn | 1 | 67641 | 2 | 1.250 | 54112.8 |
124 | 2020-02-18 03:43:34 | blackthorn | 5 | 173545 | 363 | 23.533 | 7374.5 |
123 | 2020-02-15 14:16:22 | blackthorn | 5 | 173545 | 363 | 17.390 | 9979.6 |
122 | 2020-02-14 18:28:52 | blackthorn | 5 | 173545 | 363 | 32.080 | 5409.8 |
121 | 2020-02-14 04:48:36 | blackthorn | 5 | 173545 | 363 | 37.456 | 4633.3 |
120 | 2020-02-14 00:21:50 | blackthorn | 5 | 173545 | 363 | 22.766 | 7623.0 |
119 | 2020-02-13 05:45:55 | blackthorn | 5 | 173545 | 363 | 31.096 | 5580.9 |
118 | 2020-02-10 18:17:15 | blackthorn | 1 | 67641 | 2 | 1.280 | 52844.5 |
117 | 2020-02-06 14:13:15 | blackthorn | 1 | 67641 | 2 | 1.123 | 60232.4 |
116 | 2020-01-24 21:45:04 | blackthorn | 1 | 67641 | 2 | 1.233 | 54858.9 |
115 | 2020-01-22 23:55:02 | blackthorn | 4 | 161450 | 49 | 12.376 | 13045.4 |
114 | 2020-01-22 19:15:23 | blackthorn | 1 | 67641 | 2 | 2.110 | 32057.3 |
113 | 2020-01-22 02:24:19 | blackthorn | 4 | 161450 | 49 | 32.390 | 4984.6 |
112 | 2020-01-15 22:15:37 | blackthorn | 1 | 67641 | 2 | 1.173 | 57665.0 |
111 | 2020-01-15 16:02:12 | blackthorn | 5 | 173545 | 363 | 18.313 | 9476.6 |
110 | 2020-01-15 11:58:20 | blackthorn | 5 | 173545 | 363 | 43.253 | 4012.3 |
109 | 2020-01-15 08:01:15 | blackthorn | 5 | 173545 | 363 | 19.783 | 8772.4 |
108 | 2020-01-15 06:40:17 | blackthorn | 5 | 173545 | 363 | 37.656 | 4608.7 |
107 | 2020-01-03 02:33:41 | blackthorn | 1 | 67641 | 2 | 1.220 | 55443.4 |
106 | 2020-01-02 13:03:06 | blackthorn | 4 | 161450 | 49 | 22.673 | 7120.8 |
105 | 2019-12-17 13:57:08 | blackthorn | 1 | 67641 | 2 | 1.046 | 64666.3 |
104 | 2019-12-12 13:49:41 | blackthorn | 4 | 161450 | 49 | 11.220 | 14389.5 |
103 | 2019-11-15 17:57:31 | blackthorn | 5 | 173545 | 363 | 15.546 | 11163.3 |
102 | 2019-10-27 20:59:47 | blackthorn | 5 | 173545 | 363 | 14.393 | 12057.6 |
101 | 2019-10-27 20:59:27 | blackthorn | 4 | 161450 | 49 | 9.266 | 17423.9 |