History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gunsmith"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
198 | 2024-05-27 03:41:57 | gunsmith | 1 | 82945 | 2 | 3.486 | 23793.7 |
197 | 2024-05-27 03:41:23 | gunsmith | 2 | 121059 | 4 | 13.563 | 8925.7 |
196 | 2024-05-19 12:48:55 | gunsmith | 3 | 146162 | 22 | 20.530 | 7119.4 |
195 | 2024-05-19 12:48:49 | gunsmith | 2 | 121059 | 4 | 7.940 | 15246.7 |
194 | 2024-05-18 21:15:59 | gunsmith | 3 | 146162 | 22 | 22.503 | 6495.2 |
193 | 2024-05-18 00:46:42 | gunsmith | 3 | 146162 | 22 | 8.750 | 16704.2 |
192 | 2024-05-15 08:35:55 | gunsmith | 3 | 146162 | 22 | 7.953 | 18378.2 |
191 | 2024-05-15 08:35:56 | gunsmith | 2 | 121059 | 4 | 4.280 | 28284.8 |
190 | 2024-05-15 08:35:51 | gunsmith | 1 | 82945 | 2 | 1.406 | 58993.6 |
189 | 2024-05-11 07:28:22 | gunsmith | 1 | 82945 | 2 | 3.110 | 26670.4 |
188 | 2024-05-11 07:28:11 | gunsmith | 2 | 121059 | 4 | 4.030 | 30039.5 |
187 | 2024-05-10 00:52:29 | gunsmith | 1 | 82945 | 2 | 3.283 | 25265.0 |
186 | 2024-05-09 21:53:28 | gunsmith | 2 | 121059 | 4 | 4.173 | 29010.1 |
185 | 2024-05-07 17:56:06 | gunsmith | 4 | 161609 | 202 | 33.330 | 4848.8 |
184 | 2024-05-07 09:03:44 | gunsmith | 3 | 146162 | 22 | 16.423 | 8899.8 |
183 | 2024-05-07 07:23:44 | gunsmith | 4 | 161609 | 202 | 28.220 | 5726.8 |
182 | 2024-05-06 23:53:41 | gunsmith | 4 | 161609 | 202 | 28.110 | 5749.2 |
181 | 2024-05-06 12:32:52 | gunsmith | 4 | 161609 | 202 | 28.300 | 5710.6 |
180 | 2024-05-06 12:29:17 | gunsmith | 1 | 82945 | 2 | 1.563 | 53067.8 |
179 | 2024-05-06 12:25:04 | gunsmith | 4 | 161609 | 202 | 25.016 | 6460.2 |
178 | 2024-05-06 12:25:13 | gunsmith | 3 | 146162 | 22 | 7.906 | 18487.5 |
177 | 2024-05-06 12:25:08 | gunsmith | 2 | 121059 | 4 | 4.203 | 28803.0 |
176 | 2024-04-29 15:37:57 | gunsmith | 1 | 82945 | 2 | 1.440 | 57600.7 |
175 | 2024-04-15 02:43:02 | gunsmith | 1 | 82945 | 2 | 1.750 | 47397.1 |
174 | 2024-04-15 02:41:17 | gunsmith | 3 | 146162 | 22 | 20.250 | 7217.9 |
173 | 2024-04-14 04:34:25 | gunsmith | 3 | 146162 | 22 | 10.966 | 13328.7 |
172 | 2024-04-12 22:00:00 | gunsmith | 1 | 82945 | 2 | 2.360 | 35146.2 |
171 | 2024-04-11 04:50:14 | gunsmith | 2 | 121059 | 4 | 3.360 | 36029.5 |
170 | 2024-04-06 19:35:16 | gunsmith | 4 | 161609 | 202 | 38.610 | 4185.7 |
169 | 2024-04-04 22:56:42 | gunsmith | 4 | 161609 | 202 | 43.410 | 3722.9 |
168 | 2024-04-04 15:20:50 | gunsmith | 4 | 161609 | 202 | 15.860 | 10189.7 |
167 | 2024-04-04 15:20:50 | gunsmith | 3 | 146162 | 22 | 15.393 | 9495.4 |
166 | 2024-04-04 15:12:09 | gunsmith | 4 | 161609 | 202 | 24.233 | 6669.0 |
165 | 2024-04-04 15:12:10 | gunsmith | 2 | 121059 | 4 | 9.593 | 12619.5 |
164 | 2024-04-04 15:12:11 | gunsmith | 3 | 146162 | 22 | 8.390 | 17421.0 |
163 | 2024-04-04 15:12:08 | gunsmith | 1 | 82945 | 2 | 3.063 | 27079.7 |
162 | 2024-03-31 12:48:10 | gunsmith | 1 | 82945 | 2 | 4.796 | 17294.6 |
161 | 2024-03-11 02:32:18 | gunsmith | 1 | 82945 | 2 | 1.546 | 53651.4 |
160 | 2024-03-11 02:31:52 | gunsmith | 3 | 146162 | 22 | 7.173 | 20376.7 |
159 | 2024-03-11 02:31:53 | gunsmith | 2 | 121059 | 4 | 3.576 | 33853.2 |
158 | 2024-03-08 15:38:50 | gunsmith | 2 | 121059 | 4 | 9.203 | 13154.3 |
157 | 2024-03-07 18:49:05 | gunsmith | 3 | 146162 | 22 | 15.593 | 9373.6 |
156 | 2024-03-06 22:12:40 | gunsmith | 4 | 161609 | 202 | 17.563 | 9201.7 |
155 | 2024-03-05 16:55:11 | gunsmith | 4 | 161609 | 202 | 16.483 | 9804.6 |
154 | 2024-03-05 06:48:48 | gunsmith | 4 | 161609 | 202 | 37.940 | 4259.6 |
153 | 2024-03-05 06:48:59 | gunsmith | 3 | 146162 | 22 | 26.906 | 5432.3 |
152 | 2024-03-05 06:48:50 | gunsmith | 2 | 121059 | 4 | 7.000 | 17294.1 |
151 | 2024-03-05 06:41:43 | gunsmith | 1 | 82945 | 2 | 3.106 | 26704.8 |
150 | 2024-03-02 01:49:56 | gunsmith | 3 | 146162 | 22 | 24.826 | 5887.5 |
149 | 2024-03-02 01:49:56 | gunsmith | 2 | 121059 | 4 | 4.190 | 28892.4 |
148 | 2024-03-01 05:13:57 | gunsmith | 1 | 82945 | 2 | 1.436 | 57761.1 |
147 | 2024-03-01 05:09:24 | gunsmith | 2 | 121059 | 4 | 4.250 | 28484.5 |
146 | 2024-03-01 05:08:04 | gunsmith | 4 | 161609 | 202 | 16.970 | 9523.2 |
145 | 2024-03-01 05:08:00 | gunsmith | 3 | 146162 | 22 | 11.890 | 12292.9 |
144 | 2024-03-01 05:07:55 | gunsmith | 3 | 146162 | 22 | 8.046 | 18165.8 |
143 | 2024-03-01 05:07:59 | gunsmith | 1 | 82945 | 2 | 1.940 | 42755.2 |
142 | 2024-03-01 05:07:51 | gunsmith | 2 | 121059 | 4 | 3.733 | 32429.4 |
141 | 2024-02-21 07:22:29 | gunsmith | 4 | 161609 | 202 | 17.766 | 9096.5 |
140 | 2024-02-09 21:17:59 | gunsmith | 1 | 82945 | 2 | 3.140 | 26415.6 |
139 | 2024-02-05 11:23:01 | gunsmith | 3 | 146162 | 22 | 17.296 | 8450.6 |
138 | 2024-01-31 20:19:47 | gunsmith | 2 | 121059 | 4 | 3.436 | 35232.5 |
137 | 2024-01-31 20:19:12 | gunsmith | 3 | 146162 | 22 | 6.046 | 24175.0 |
136 | 2024-01-31 06:50:55 | gunsmith | 4 | 161609 | 202 | 13.546 | 11930.4 |
135 | 2024-01-31 04:49:11 | gunsmith | 4 | 161609 | 202 | 10.500 | 15391.3 |
134 | 2024-01-30 20:04:09 | gunsmith | 1 | 82945 | 2 | 3.093 | 26817.0 |
133 | 2024-01-30 20:03:47 | gunsmith | 4 | 161609 | 202 | 24.283 | 6655.2 |
132 | 2024-01-30 20:03:59 | gunsmith | 1 | 82945 | 2 | 2.593 | 31988.0 |
131 | 2024-01-30 20:03:51 | gunsmith | 3 | 146162 | 22 | 8.123 | 17993.6 |
130 | 2024-01-30 20:03:43 | gunsmith | 2 | 121059 | 4 | 5.970 | 20277.9 |
129 | 2024-01-06 10:03:34 | gunsmith | 1 | 82945 | 2 | 1.360 | 60989.0 |
128 | 2023-11-19 22:00:08 | gunsmith | 1 | 82945 | 2 | 1.436 | 57761.1 |
127 | 2023-10-29 01:51:05 | gunsmith | 1 | 82945 | 2 | 1.373 | 60411.5 |
126 | 2023-08-23 01:14:56 | gunsmith | 1 | 82945 | 2 | 1.280 | 64800.8 |
125 | 2023-05-23 13:35:04 | gunsmith | 1 | 82945 | 2 | 1.203 | 68948.5 |
124 | 2023-03-20 23:17:14 | gunsmith | 1 | 82945 | 2 | 1.203 | 68948.5 |
123 | 2023-01-07 17:09:56 | gunsmith | 1 | 82945 | 2 | 1.203 | 68948.5 |
122 | 2022-10-04 02:55:27 | gunsmith | 1 | 82945 | 2 | 1.330 | 62364.7 |
121 | 2022-05-21 09:10:48 | gunsmith | 1 | 82945 | 2 | 1.406 | 58993.6 |
120 | 2022-05-19 03:46:49 | gunsmith | 1 | 82945 | 2 | 1.453 | 57085.3 |
119 | 2021-07-29 10:02:52 | gunsmith | 1 | 82945 | 2 | 1.360 | 60989.0 |
118 | 2021-06-22 18:32:03 | gunsmith | 1 | 82945 | 2 | 1.420 | 58412.0 |
117 | 2021-03-23 17:46:44 | gunsmith | 1 | 82945 | 2 | 1.453 | 57085.3 |
116 | 2021-02-02 03:20:15 | gunsmith | 1 | 82945 | 2 | 1.423 | 58288.8 |
115 | 2020-11-18 09:47:28 | gunsmith | 1 | 82945 | 2 | 1.343 | 61761.0 |
114 | 2020-10-29 21:24:35 | gunsmith | 1 | 82945 | 2 | 1.356 | 61168.9 |
113 | 2020-10-18 09:10:09 | gunsmith | 1 | 82945 | 2 | 1.360 | 60989.0 |
112 | 2020-09-03 02:11:55 | gunsmith | 1 | 82945 | 2 | 1.313 | 63172.1 |
111 | 2020-03-18 23:02:08 | gunsmith | 1 | 82945 | 2 | 1.280 | 64800.8 |
110 | 2020-03-16 04:02:12 | gunsmith | 1 | 82945 | 2 | 1.250 | 66356.0 |
109 | 2020-02-20 14:10:49 | gunsmith | 1 | 82945 | 2 | 2.076 | 39954.2 |
108 | 2020-02-18 01:57:42 | gunsmith | 1 | 82945 | 2 | 1.483 | 55930.5 |
107 | 2020-02-09 16:47:34 | gunsmith | 1 | 82945 | 2 | 3.170 | 26165.6 |
106 | 2020-02-09 15:40:48 | gunsmith | 1 | 82945 | 2 | 2.783 | 29804.2 |
105 | 2020-02-04 15:09:51 | gunsmith | 1 | 82945 | 2 | 1.516 | 54713.1 |
104 | 2020-01-27 23:00:45 | gunsmith | 1 | 82945 | 2 | 1.546 | 53651.4 |
103 | 2020-01-15 09:50:05 | gunsmith | 1 | 82945 | 2 | 1.546 | 53651.4 |
102 | 2020-01-11 21:22:24 | gunsmith | 1 | 82945 | 2 | 1.546 | 53651.4 |
101 | 2020-01-06 18:29:59 | gunsmith | 1 | 82945 | 2 | 3.016 | 27501.7 |
100 | 2019-12-04 16:10:35 | gunsmith | 1 | 82945 | 2 | 1.453 | 57085.3 |
99 | 2019-09-02 10:43:30 | gunsmith | 1 | 82945 | 2 | 1.380 | 60105.1 |