History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"consolidate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
193 | 2024-05-06 05:32:31 | consolidate | 2 | 86808 | 6 | 5.393 | 16096.4 |
192 | 2024-05-06 05:32:27 | consolidate | 3 | 121633 | 17 | 6.170 | 19713.6 |
191 | 2024-05-06 05:31:39 | consolidate | 1 | 49908 | 3 | 1.923 | 25953.2 |
190 | 2024-05-05 08:52:32 | consolidate | 5 | 164607 | 321 | 39.563 | 4160.6 |
189 | 2024-05-04 20:32:42 | consolidate | 1 | 49908 | 3 | 0.876 | 56972.6 |
188 | 2024-05-04 15:38:04 | consolidate | 5 | 164607 | 321 | 25.796 | 6381.1 |
187 | 2024-05-03 14:47:53 | consolidate | 1 | 49908 | 3 | 0.873 | 57168.4 |
186 | 2024-04-17 22:31:22 | consolidate | 4 | 148819 | 55 | 16.436 | 9054.5 |
185 | 2024-04-16 11:11:43 | consolidate | 4 | 148819 | 55 | 20.063 | 7417.6 |
184 | 2024-04-15 03:10:48 | consolidate | 4 | 148819 | 55 | 29.486 | 5047.1 |
183 | 2024-04-14 13:54:51 | consolidate | 4 | 148819 | 55 | 25.783 | 5772.0 |
182 | 2024-04-14 10:28:58 | consolidate | 3 | 121633 | 17 | 14.003 | 8686.2 |
181 | 2024-04-14 10:28:57 | consolidate | 1 | 49908 | 3 | 2.390 | 20882.0 |
180 | 2024-04-14 10:28:55 | consolidate | 2 | 86808 | 6 | 3.110 | 27912.5 |
179 | 2024-04-14 10:11:27 | consolidate | 1 | 49908 | 3 | 0.843 | 59202.8 |
178 | 2024-04-14 00:56:14 | consolidate | 4 | 148819 | 55 | 45.346 | 3281.9 |
177 | 2024-04-14 00:56:12 | consolidate | 3 | 121633 | 17 | 15.343 | 7927.6 |
176 | 2024-04-14 00:56:13 | consolidate | 2 | 86808 | 6 | 8.923 | 9728.6 |
175 | 2024-04-08 03:20:44 | consolidate | 1 | 49908 | 3 | 0.780 | 63984.6 |
174 | 2024-04-06 02:54:56 | consolidate | 4 | 148819 | 55 | 19.750 | 7535.1 |
173 | 2024-04-06 02:55:01 | consolidate | 3 | 121633 | 17 | 8.190 | 14851.4 |
172 | 2024-04-06 02:54:59 | consolidate | 2 | 86808 | 6 | 8.983 | 9663.6 |
171 | 2024-04-06 02:53:55 | consolidate | 1 | 49908 | 3 | 3.063 | 16293.8 |
170 | 2024-04-03 03:45:09 | consolidate | 3 | 121633 | 17 | 13.126 | 9266.6 |
169 | 2024-04-03 03:45:04 | consolidate | 2 | 86808 | 6 | 5.936 | 14624.0 |
168 | 2024-04-03 03:44:52 | consolidate | 1 | 49908 | 3 | 1.016 | 49122.0 |
167 | 2024-03-25 23:45:37 | consolidate | 3 | 121633 | 17 | 11.690 | 10404.9 |
166 | 2024-03-25 23:45:30 | consolidate | 2 | 86808 | 6 | 6.330 | 13713.7 |
165 | 2024-03-25 21:53:28 | consolidate | 1 | 49908 | 3 | 0.936 | 53320.5 |
164 | 2024-03-17 20:37:21 | consolidate | 4 | 148819 | 55 | 29.346 | 5071.2 |
163 | 2024-03-17 20:36:24 | consolidate | 5 | 164607 | 321 | 60.330 | 2728.4 |
162 | 2024-03-15 10:53:29 | consolidate | 4 | 148819 | 55 | 12.376 | 12024.8 |
161 | 2024-03-14 22:19:38 | consolidate | 5 | 164607 | 321 | 65.706 | 2505.2 |
160 | 2024-03-14 18:49:47 | consolidate | 5 | 164607 | 321 | 52.660 | 3125.8 |
159 | 2024-03-13 23:45:31 | consolidate | 5 | 164607 | 321 | 20.563 | 8005.0 |
158 | 2024-03-13 23:45:02 | consolidate | 4 | 148819 | 55 | 22.453 | 6628.0 |
157 | 2024-03-13 07:52:31 | consolidate | 5 | 164607 | 321 | 33.220 | 4955.1 |
156 | 2024-03-13 06:08:59 | consolidate | 1 | 49908 | 3 | 0.923 | 54071.5 |
155 | 2024-03-13 06:08:22 | consolidate | 4 | 148819 | 55 | 16.846 | 8834.1 |
154 | 2024-03-13 06:08:19 | consolidate | 5 | 164607 | 321 | 17.343 | 9491.3 |
153 | 2024-03-13 06:08:19 | consolidate | 3 | 121633 | 17 | 6.236 | 19505.0 |
152 | 2024-03-13 06:08:23 | consolidate | 2 | 86808 | 6 | 2.796 | 31047.2 |
151 | 2024-03-13 06:07:53 | consolidate | 1 | 49908 | 3 | 0.763 | 65410.2 |
150 | 2024-02-20 06:28:06 | consolidate | 4 | 148819 | 55 | 23.940 | 6216.3 |
149 | 2024-02-20 06:28:09 | consolidate | 2 | 86808 | 6 | 3.156 | 27505.7 |
148 | 2024-02-19 16:11:50 | consolidate | 1 | 49908 | 3 | 0.890 | 56076.4 |
147 | 2024-02-19 12:18:54 | consolidate | 3 | 121633 | 17 | 7.233 | 16816.4 |
146 | 2024-02-19 12:18:53 | consolidate | 2 | 86808 | 6 | 3.860 | 22489.1 |
145 | 2024-02-19 05:28:13 | consolidate | 1 | 49908 | 3 | 0.953 | 52369.4 |
144 | 2024-02-13 21:43:50 | consolidate | 2 | 86808 | 6 | 5.890 | 14738.2 |
143 | 2024-02-13 20:14:54 | consolidate | 1 | 49908 | 3 | 0.923 | 54071.5 |
142 | 2024-02-13 20:08:30 | consolidate | 1 | 49908 | 3 | 0.876 | 56972.6 |
141 | 2024-02-12 08:54:25 | consolidate | 3 | 121633 | 17 | 16.470 | 7385.1 |
140 | 2024-02-12 03:29:48 | consolidate | 3 | 121633 | 17 | 13.953 | 8717.3 |
139 | 2024-02-11 20:39:09 | consolidate | 5 | 164607 | 321 | 60.160 | 2736.2 |
138 | 2024-02-11 08:49:19 | consolidate | 5 | 164607 | 321 | 58.660 | 2806.1 |
137 | 2024-02-09 22:52:35 | consolidate | 4 | 148819 | 55 | 11.736 | 12680.6 |
136 | 2024-02-09 08:44:34 | consolidate | 3 | 121633 | 17 | 12.516 | 9718.2 |
135 | 2024-02-09 08:44:33 | consolidate | 4 | 148819 | 55 | 11.326 | 13139.6 |
134 | 2024-02-08 21:31:10 | consolidate | 4 | 148819 | 55 | 39.783 | 3740.8 |
133 | 2024-02-08 21:31:12 | consolidate | 4 | 148819 | 55 | 25.223 | 5900.1 |
132 | 2024-02-08 21:31:13 | consolidate | 2 | 86808 | 6 | 8.206 | 10578.6 |
131 | 2024-02-08 21:31:00 | consolidate | 3 | 121633 | 17 | 11.736 | 10364.1 |
130 | 2024-02-08 21:31:02 | consolidate | 2 | 86808 | 6 | 8.766 | 9902.8 |
129 | 2024-02-08 21:30:30 | consolidate | 3 | 121633 | 17 | 11.190 | 10869.8 |
128 | 2024-02-08 21:30:12 | consolidate | 1 | 49908 | 3 | 0.923 | 54071.5 |
127 | 2024-02-08 21:30:06 | consolidate | 1 | 49908 | 3 | 1.796 | 27788.4 |
126 | 2024-01-03 14:37:20 | consolidate | 1 | 49908 | 3 | 0.906 | 55086.1 |
125 | 2023-12-27 07:41:47 | consolidate | 1 | 49908 | 3 | 0.780 | 63984.6 |
124 | 2023-12-25 14:46:32 | consolidate | 5 | 164607 | 321 | 14.096 | 11677.6 |
123 | 2023-12-25 01:02:58 | consolidate | 1 | 49908 | 3 | 0.780 | 63984.6 |
122 | 2023-12-19 23:39:24 | consolidate | 3 | 121633 | 17 | 4.626 | 26293.3 |
121 | 2023-12-18 20:32:54 | consolidate | 2 | 86808 | 6 | 2.513 | 34543.6 |
120 | 2023-11-28 06:43:28 | consolidate | 5 | 164607 | 321 | 20.140 | 8173.1 |
119 | 2023-10-26 19:51:40 | consolidate | 5 | 164607 | 321 | 36.283 | 4536.8 |
118 | 2023-10-26 00:04:32 | consolidate | 1 | 49908 | 3 | 0.953 | 52369.4 |
117 | 2023-10-22 16:54:22 | consolidate | 1 | 49908 | 3 | 0.873 | 57168.4 |
116 | 2023-10-15 21:15:58 | consolidate | 1 | 49908 | 3 | 0.966 | 51664.6 |
115 | 2023-10-15 21:11:05 | consolidate | 5 | 164607 | 321 | 18.220 | 9034.4 |
114 | 2023-10-15 21:11:04 | consolidate | 3 | 121633 | 17 | 5.250 | 23168.2 |
113 | 2023-10-14 23:58:04 | consolidate | 1 | 49908 | 3 | 0.843 | 59202.8 |
112 | 2023-10-09 20:16:30 | consolidate | 1 | 49908 | 3 | 0.796 | 62698.5 |
111 | 2023-09-26 08:22:43 | consolidate | 5 | 164607 | 321 | 16.626 | 9900.6 |
110 | 2023-09-20 19:22:35 | consolidate | 3 | 121633 | 17 | 10.063 | 12087.2 |
109 | 2023-09-19 14:38:20 | consolidate | 2 | 86808 | 6 | 2.093 | 41475.4 |
108 | 2023-08-09 20:16:14 | consolidate | 1 | 49908 | 3 | 0.780 | 63984.6 |
107 | 2023-07-05 21:03:31 | consolidate | 5 | 164607 | 321 | 15.123 | 10884.5 |
106 | 2023-06-26 14:07:42 | consolidate | 3 | 121633 | 17 | 4.906 | 24792.7 |
105 | 2023-05-10 07:48:32 | consolidate | 1 | 49908 | 3 | 1.703 | 29305.9 |
104 | 2023-03-29 14:01:34 | consolidate | 5 | 164607 | 321 | 13.190 | 12479.7 |
103 | 2023-03-22 06:52:32 | consolidate | 3 | 121633 | 17 | 5.606 | 21696.9 |
102 | 2023-03-14 23:37:06 | consolidate | 2 | 86808 | 6 | 2.126 | 40831.6 |
101 | 2023-03-05 02:27:55 | consolidate | 1 | 49908 | 3 | 0.763 | 65410.2 |
100 | 2023-02-01 23:50:40 | consolidate | 5 | 164607 | 321 | 15.970 | 10307.3 |
99 | 2022-12-27 06:02:32 | consolidate | 1 | 49908 | 3 | 0.750 | 66544.0 |
98 | 2022-12-26 19:04:00 | consolidate | 5 | 164607 | 321 | 12.906 | 12754.3 |
97 | 2022-12-21 15:04:53 | consolidate | 3 | 121633 | 17 | 4.546 | 26756.0 |
96 | 2022-12-18 14:02:01 | consolidate | 2 | 86808 | 6 | 2.046 | 42428.2 |
95 | 2022-12-17 05:05:10 | consolidate | 5 | 164607 | 321 | 13.970 | 11782.9 |
94 | 2022-12-11 05:36:11 | consolidate | 5 | 164607 | 321 | 13.313 | 12364.4 |