History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gondolier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
197 | 2024-05-04 11:10:33 | gondolier | 4 | 165329 | 354 | 25.843 | 6397.4 |
196 | 2024-05-04 11:10:30 | gondolier | 2 | 121436 | 6 | 3.703 | 32794.0 |
195 | 2024-05-04 11:10:13 | gondolier | 3 | 148641 | 38 | 10.673 | 13926.8 |
194 | 2024-05-03 10:24:16 | gondolier | 4 | 165329 | 354 | 26.016 | 6354.9 |
193 | 2024-05-03 09:26:19 | gondolier | 3 | 148641 | 38 | 8.983 | 16546.9 |
192 | 2024-05-03 09:26:16 | gondolier | 2 | 121436 | 6 | 5.920 | 20512.8 |
191 | 2024-05-03 07:09:19 | gondolier | 1 | 81242 | 2 | 1.920 | 42313.5 |
190 | 2024-05-03 03:06:43 | gondolier | 1 | 81242 | 2 | 2.890 | 28111.4 |
189 | 2024-05-03 02:37:07 | gondolier | 3 | 148641 | 38 | 8.826 | 16841.3 |
188 | 2024-05-03 02:37:12 | gondolier | 2 | 121436 | 6 | 3.890 | 31217.5 |
187 | 2024-05-03 02:37:03 | gondolier | 4 | 165329 | 354 | 12.313 | 13427.2 |
186 | 2024-05-02 23:04:31 | gondolier | 1 | 81242 | 2 | 1.563 | 51978.2 |
185 | 2024-04-26 11:07:27 | gondolier | 1 | 81242 | 2 | 1.813 | 44810.8 |
184 | 2024-04-05 23:51:06 | gondolier | 1 | 81242 | 2 | 3.126 | 25989.1 |
183 | 2024-03-30 11:27:38 | gondolier | 2 | 121436 | 6 | 3.686 | 32945.2 |
182 | 2024-03-29 07:30:40 | gondolier | 3 | 148641 | 38 | 17.703 | 8396.4 |
181 | 2024-03-27 13:27:07 | gondolier | 1 | 81242 | 2 | 3.250 | 24997.5 |
180 | 2024-03-27 11:29:17 | gondolier | 2 | 121436 | 6 | 4.126 | 29431.9 |
179 | 2024-03-27 11:20:13 | gondolier | 3 | 148641 | 38 | 7.626 | 19491.3 |
178 | 2024-03-26 10:50:46 | gondolier | 1 | 81242 | 2 | 1.406 | 57782.4 |
177 | 2024-03-23 18:48:27 | gondolier | 4 | 165329 | 354 | 32.910 | 5023.7 |
176 | 2024-03-23 08:54:44 | gondolier | 3 | 148641 | 38 | 23.986 | 6197.0 |
175 | 2024-03-21 20:01:30 | gondolier | 4 | 165329 | 354 | 39.033 | 4235.6 |
174 | 2024-03-21 14:36:11 | gondolier | 4 | 165329 | 354 | 40.690 | 4063.1 |
173 | 2024-03-19 17:47:16 | gondolier | 2 | 121436 | 6 | 12.450 | 9753.9 |
172 | 2024-03-19 17:47:16 | gondolier | 3 | 148641 | 38 | 8.763 | 16962.3 |
171 | 2024-03-19 16:49:32 | gondolier | 1 | 81242 | 2 | 1.466 | 55417.5 |
170 | 2024-03-19 15:58:57 | gondolier | 4 | 165329 | 354 | 41.813 | 3954.0 |
169 | 2024-03-19 10:02:05 | gondolier | 4 | 165329 | 354 | 27.846 | 5937.3 |
168 | 2024-03-08 03:08:09 | gondolier | 1 | 81242 | 2 | 4.326 | 18779.9 |
167 | 2024-03-02 19:17:32 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
166 | 2024-02-26 12:12:23 | gondolier | 1 | 81242 | 2 | 1.453 | 55913.3 |
165 | 2024-02-22 17:31:58 | gondolier | 1 | 81242 | 2 | 3.110 | 26122.8 |
164 | 2024-02-22 14:09:35 | gondolier | 4 | 165329 | 354 | 25.016 | 6608.9 |
163 | 2024-02-17 22:02:33 | gondolier | 4 | 165329 | 354 | 14.830 | 11148.3 |
162 | 2024-02-17 03:53:37 | gondolier | 4 | 165329 | 354 | 26.050 | 6346.6 |
161 | 2024-02-14 04:31:52 | gondolier | 3 | 148641 | 38 | 11.953 | 12435.5 |
160 | 2024-02-12 16:14:07 | gondolier | 3 | 148641 | 38 | 24.863 | 5978.4 |
159 | 2024-02-12 15:43:24 | gondolier | 4 | 165329 | 354 | 35.143 | 4704.5 |
158 | 2024-02-11 15:05:11 | gondolier | 3 | 148641 | 38 | 10.376 | 14325.5 |
157 | 2024-02-11 07:07:16 | gondolier | 3 | 148641 | 38 | 33.786 | 4399.5 |
156 | 2024-02-11 07:07:20 | gondolier | 4 | 165329 | 354 | 23.376 | 7072.6 |
155 | 2024-02-11 07:07:15 | gondolier | 2 | 121436 | 6 | 4.080 | 29763.7 |
154 | 2024-02-11 04:53:40 | gondolier | 1 | 81242 | 2 | 1.186 | 68500.8 |
153 | 2024-01-22 18:27:56 | gondolier | 1 | 81242 | 2 | 3.033 | 26786.0 |
152 | 2024-01-02 07:49:31 | gondolier | 3 | 148641 | 38 | 6.080 | 24447.5 |
151 | 2023-12-10 09:44:23 | gondolier | 4 | 165329 | 354 | 18.516 | 8929.0 |
150 | 2023-12-10 09:44:27 | gondolier | 2 | 121436 | 6 | 3.750 | 32382.9 |
149 | 2023-12-10 09:44:20 | gondolier | 3 | 148641 | 38 | 6.483 | 22927.8 |
148 | 2023-12-10 04:02:12 | gondolier | 1 | 81242 | 2 | 1.330 | 61084.2 |
147 | 2023-12-05 11:23:48 | gondolier | 2 | 121436 | 6 | 3.046 | 39867.4 |
146 | 2023-11-27 20:38:24 | gondolier | 1 | 81242 | 2 | 1.436 | 56575.2 |
145 | 2023-11-10 21:41:34 | gondolier | 1 | 81242 | 2 | 1.266 | 64172.2 |
144 | 2023-10-23 09:53:31 | gondolier | 1 | 81242 | 2 | 1.456 | 55798.1 |
143 | 2023-10-05 18:06:24 | gondolier | 3 | 148641 | 38 | 6.030 | 24650.2 |
142 | 2023-09-11 00:57:58 | gondolier | 1 | 81242 | 2 | 1.280 | 63470.3 |
141 | 2023-09-02 20:03:08 | gondolier | 2 | 121436 | 6 | 3.360 | 36141.7 |
140 | 2023-07-16 17:21:46 | gondolier | 3 | 148641 | 38 | 7.173 | 20722.3 |
139 | 2023-07-12 18:15:14 | gondolier | 1 | 81242 | 2 | 1.220 | 66591.8 |
138 | 2023-06-17 02:44:49 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
137 | 2023-05-22 08:27:24 | gondolier | 2 | 121436 | 6 | 3.063 | 39646.1 |
136 | 2023-04-02 14:20:42 | gondolier | 3 | 148641 | 38 | 6.686 | 22231.7 |
135 | 2023-03-31 12:55:31 | gondolier | 1 | 81242 | 2 | 1.250 | 64993.6 |
134 | 2023-03-11 21:02:27 | gondolier | 1 | 81242 | 2 | 1.296 | 62686.7 |
133 | 2023-02-28 15:13:14 | gondolier | 2 | 121436 | 6 | 3.373 | 36002.4 |
132 | 2023-01-12 03:00:20 | gondolier | 1 | 81242 | 2 | 1.186 | 68500.8 |
131 | 2022-12-29 13:15:51 | gondolier | 3 | 148641 | 38 | 6.016 | 24707.6 |
130 | 2022-12-10 09:57:24 | gondolier | 2 | 121436 | 6 | 3.000 | 40478.7 |
129 | 2022-10-26 12:30:28 | gondolier | 1 | 81242 | 2 | 1.516 | 53589.7 |
128 | 2022-10-26 07:12:28 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
127 | 2022-09-01 21:31:10 | gondolier | 3 | 148641 | 38 | 6.033 | 24638.0 |
126 | 2022-07-27 19:29:18 | gondolier | 2 | 121436 | 6 | 3.093 | 39261.6 |
125 | 2022-07-11 04:15:04 | gondolier | 1 | 81242 | 2 | 1.250 | 64993.6 |
124 | 2022-06-21 10:08:40 | gondolier | 1 | 81242 | 2 | 1.250 | 64993.6 |
123 | 2022-06-16 21:14:27 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
122 | 2022-03-11 11:43:07 | gondolier | 1 | 81242 | 2 | 1.296 | 62686.7 |
121 | 2022-03-09 07:22:37 | gondolier | 1 | 81242 | 2 | 1.403 | 57905.9 |
120 | 2022-02-06 01:27:48 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
119 | 2021-10-09 23:06:18 | gondolier | 1 | 81242 | 2 | 1.190 | 68270.6 |
118 | 2021-07-08 01:42:06 | gondolier | 1 | 81242 | 2 | 1.346 | 60358.1 |
117 | 2021-04-08 06:35:40 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
116 | 2021-04-04 02:48:19 | gondolier | 1 | 81242 | 2 | 1.360 | 59736.8 |
115 | 2021-02-25 06:53:04 | gondolier | 1 | 81242 | 2 | 1.266 | 64172.2 |
114 | 2021-02-01 08:09:52 | gondolier | 1 | 81242 | 2 | 1.390 | 58447.5 |
113 | 2020-12-30 02:14:22 | gondolier | 1 | 81242 | 2 | 1.220 | 66591.8 |
112 | 2020-12-07 16:34:41 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
111 | 2020-10-05 13:01:48 | gondolier | 1 | 81242 | 2 | 1.236 | 65729.8 |
110 | 2020-09-26 19:29:18 | gondolier | 1 | 81242 | 2 | 1.203 | 67532.8 |
109 | 2020-06-11 21:14:21 | gondolier | 1 | 81242 | 2 | 1.233 | 65889.7 |
108 | 2020-06-08 21:43:49 | gondolier | 1 | 81242 | 2 | 1.233 | 65889.7 |
107 | 2020-03-26 01:26:42 | gondolier | 1 | 81242 | 2 | 1.406 | 57782.4 |
106 | 2020-03-05 09:05:50 | gondolier | 1 | 81242 | 2 | 1.500 | 54161.3 |
105 | 2020-02-18 16:21:42 | gondolier | 1 | 81242 | 2 | 1.513 | 53696.0 |
104 | 2020-02-04 12:05:16 | gondolier | 1 | 81242 | 2 | 1.660 | 48941.0 |
103 | 2020-01-31 09:15:42 | gondolier | 1 | 81242 | 2 | 1.453 | 55913.3 |
102 | 2020-01-29 10:14:27 | gondolier | 1 | 81242 | 2 | 1.470 | 55266.7 |
101 | 2020-01-27 05:06:49 | gondolier | 1 | 81242 | 2 | 1.623 | 50056.7 |
100 | 2020-01-20 21:07:30 | gondolier | 1 | 81242 | 2 | 3.143 | 25848.6 |
99 | 2020-01-16 18:36:04 | gondolier | 1 | 81242 | 2 | 1.376 | 59042.2 |
98 | 2020-01-03 09:29:51 | gondolier | 1 | 81242 | 2 | 1.403 | 57905.9 |