History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"floodgate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
188 | 2024-04-19 16:43:44 | floodgate | 3 | 148641 | 15 | 16.843 | 8825.1 |
187 | 2024-04-19 16:43:44 | floodgate | 2 | 121436 | 3 | 14.110 | 8606.4 |
186 | 2024-04-19 15:16:41 | floodgate | 1 | 81242 | 2 | 1.533 | 52995.4 |
185 | 2024-04-18 04:14:52 | floodgate | 4 | 165329 | 118 | 25.800 | 6408.1 |
184 | 2024-04-17 04:30:24 | floodgate | 4 | 165329 | 118 | 11.876 | 13921.3 |
183 | 2024-04-11 20:05:01 | floodgate | 2 | 121436 | 3 | 10.313 | 11775.0 |
182 | 2024-04-11 20:04:58 | floodgate | 1 | 81242 | 2 | 1.500 | 54161.3 |
181 | 2024-04-11 20:04:31 | floodgate | 2 | 121436 | 3 | 8.390 | 14473.9 |
180 | 2024-04-11 20:04:22 | floodgate | 3 | 148641 | 15 | 9.156 | 16234.3 |
179 | 2024-04-11 20:04:11 | floodgate | 1 | 81242 | 2 | 1.436 | 56575.2 |
178 | 2024-04-11 20:04:02 | floodgate | 1 | 81242 | 2 | 3.203 | 25364.3 |
177 | 2024-04-08 22:10:31 | floodgate | 4 | 165329 | 118 | 17.440 | 9479.9 |
176 | 2024-04-07 16:55:40 | floodgate | 4 | 165329 | 118 | 25.033 | 6604.4 |
175 | 2024-04-07 16:55:41 | floodgate | 3 | 148641 | 15 | 16.940 | 8774.6 |
174 | 2024-04-07 16:55:26 | floodgate | 2 | 121436 | 3 | 5.516 | 22015.2 |
173 | 2024-04-04 19:50:06 | floodgate | 3 | 148641 | 15 | 25.190 | 5900.8 |
172 | 2024-04-04 19:50:12 | floodgate | 4 | 165329 | 118 | 17.206 | 9608.8 |
171 | 2024-04-04 19:50:06 | floodgate | 2 | 121436 | 3 | 4.500 | 26985.8 |
170 | 2024-04-04 19:49:35 | floodgate | 1 | 81242 | 2 | 1.516 | 53589.7 |
169 | 2024-03-29 04:28:13 | floodgate | 1 | 81242 | 2 | 2.953 | 27511.7 |
168 | 2024-03-19 06:58:34 | floodgate | 4 | 165329 | 118 | 30.830 | 5362.6 |
167 | 2024-03-19 06:58:37 | floodgate | 3 | 148641 | 15 | 20.016 | 7426.1 |
166 | 2024-03-19 06:58:39 | floodgate | 2 | 121436 | 3 | 8.453 | 14366.0 |
165 | 2024-03-19 06:56:51 | floodgate | 1 | 81242 | 2 | 1.376 | 59042.2 |
164 | 2024-03-17 16:32:30 | floodgate | 1 | 81242 | 2 | 1.500 | 54161.3 |
163 | 2024-03-12 00:22:50 | floodgate | 1 | 81242 | 2 | 4.673 | 17385.4 |
162 | 2024-03-09 06:06:18 | floodgate | 1 | 81242 | 2 | 3.126 | 25989.1 |
161 | 2024-03-09 06:05:54 | floodgate | 3 | 148641 | 15 | 12.936 | 11490.5 |
160 | 2024-03-09 06:05:55 | floodgate | 2 | 121436 | 3 | 7.703 | 15764.8 |
159 | 2024-03-09 04:24:10 | floodgate | 1 | 81242 | 2 | 2.623 | 30972.9 |
158 | 2024-03-05 17:32:39 | floodgate | 3 | 148641 | 15 | 13.423 | 11073.6 |
157 | 2024-03-05 17:32:42 | floodgate | 2 | 121436 | 3 | 8.466 | 14344.0 |
156 | 2024-03-03 14:25:34 | floodgate | 4 | 165329 | 118 | 24.186 | 6835.7 |
155 | 2024-03-03 14:25:29 | floodgate | 2 | 121436 | 3 | 11.936 | 10173.9 |
154 | 2024-03-03 14:25:31 | floodgate | 3 | 148641 | 15 | 8.420 | 17653.3 |
153 | 2024-03-03 14:17:52 | floodgate | 1 | 81242 | 2 | 1.203 | 67532.8 |
152 | 2024-02-26 16:17:51 | floodgate | 1 | 81242 | 2 | 5.300 | 15328.7 |
151 | 2024-02-19 15:08:59 | floodgate | 4 | 165329 | 118 | 22.860 | 7232.2 |
150 | 2024-02-19 00:12:25 | floodgate | 1 | 81242 | 2 | 10.093 | 8049.3 |
149 | 2024-02-10 18:59:51 | floodgate | 4 | 165329 | 118 | 16.550 | 9989.7 |
148 | 2024-02-10 18:55:48 | floodgate | 1 | 81242 | 2 | 1.203 | 67532.8 |
147 | 2024-02-10 17:40:33 | floodgate | 3 | 148641 | 15 | 12.843 | 11573.7 |
146 | 2024-02-10 17:40:17 | floodgate | 2 | 121436 | 3 | 3.983 | 30488.6 |
145 | 2024-02-07 01:10:05 | floodgate | 3 | 148641 | 15 | 6.423 | 23142.0 |
144 | 2024-02-07 01:10:01 | floodgate | 2 | 121436 | 3 | 3.563 | 34082.5 |
143 | 2024-02-07 01:08:46 | floodgate | 1 | 81242 | 2 | 1.343 | 60492.9 |
142 | 2024-02-07 01:08:29 | floodgate | 1 | 81242 | 2 | 1.686 | 48186.2 |
141 | 2024-01-27 05:17:17 | floodgate | 1 | 81242 | 2 | 2.406 | 33766.4 |
140 | 2024-01-05 01:46:43 | floodgate | 1 | 81242 | 2 | 1.343 | 60492.9 |
139 | 2023-12-16 14:46:43 | floodgate | 1 | 81242 | 2 | 1.203 | 67532.8 |
138 | 2023-12-09 16:07:57 | floodgate | 4 | 165329 | 118 | 10.516 | 15721.7 |
137 | 2023-10-03 14:52:55 | floodgate | 1 | 81242 | 2 | 1.236 | 65729.8 |
136 | 2023-09-07 15:54:06 | floodgate | 4 | 165329 | 118 | 10.046 | 16457.2 |
135 | 2023-07-31 10:52:57 | floodgate | 1 | 81242 | 2 | 1.376 | 59042.2 |
134 | 2023-05-28 00:57:37 | floodgate | 4 | 165329 | 118 | 9.796 | 16877.2 |
133 | 2023-04-27 23:02:21 | floodgate | 1 | 81242 | 2 | 1.190 | 68270.6 |
132 | 2023-03-04 14:11:45 | floodgate | 4 | 165329 | 118 | 9.753 | 16951.6 |
131 | 2023-02-19 03:34:45 | floodgate | 1 | 81242 | 2 | 1.313 | 61875.1 |
130 | 2022-12-16 00:22:40 | floodgate | 1 | 81242 | 2 | 1.173 | 69260.0 |
129 | 2022-12-11 22:33:01 | floodgate | 4 | 165329 | 118 | 10.110 | 16353.0 |
128 | 2022-08-26 18:23:04 | floodgate | 1 | 81242 | 2 | 1.203 | 67532.8 |
127 | 2022-07-27 03:52:52 | floodgate | 4 | 165329 | 118 | 10.033 | 16478.5 |
126 | 2022-04-29 02:42:02 | floodgate | 1 | 81242 | 2 | 1.423 | 57092.1 |
125 | 2021-10-03 05:53:32 | floodgate | 2 | 121436 | 3 | 7.170 | 16936.7 |
124 | 2021-09-29 20:03:08 | floodgate | 2 | 121436 | 3 | 2.953 | 41122.9 |
123 | 2021-04-13 13:51:02 | floodgate | 1 | 81242 | 2 | 1.356 | 59913.0 |
122 | 2020-10-08 08:30:18 | floodgate | 1 | 81242 | 2 | 1.296 | 62686.7 |
121 | 2020-03-29 07:43:04 | floodgate | 1 | 81242 | 2 | 1.203 | 67532.8 |
120 | 2020-03-26 06:17:17 | floodgate | 1 | 81242 | 2 | 2.906 | 27956.6 |
119 | 2020-02-09 21:56:39 | floodgate | 1 | 81242 | 2 | 2.893 | 28082.3 |
118 | 2020-02-05 23:24:37 | floodgate | 1 | 81242 | 2 | 3.060 | 26549.7 |
117 | 2020-02-04 10:35:19 | floodgate | 1 | 81242 | 2 | 3.080 | 26377.3 |
116 | 2020-02-02 07:22:28 | floodgate | 1 | 81242 | 2 | 1.330 | 61084.2 |
115 | 2020-01-31 06:23:19 | floodgate | 1 | 81242 | 2 | 1.406 | 57782.4 |
114 | 2020-01-20 01:10:08 | floodgate | 1 | 81242 | 2 | 2.876 | 28248.3 |
113 | 2020-01-06 20:56:08 | floodgate | 1 | 81242 | 2 | 2.953 | 27511.7 |
112 | 2020-01-05 00:50:21 | floodgate | 1 | 81242 | 2 | 1.376 | 59042.2 |
111 | 2019-12-21 03:32:10 | floodgate | 1 | 81242 | 2 | 1.576 | 51549.5 |
110 | 2019-10-22 01:33:15 | floodgate | 1 | 81242 | 2 | 1.186 | 68500.8 |
109 | 2019-09-19 23:46:25 | floodgate | 1 | 81242 | 2 | 1.093 | 74329.4 |
108 | 2019-06-14 03:03:40 | floodgate | 1 | 81242 | 2 | 1.340 | 60628.4 |
107 | 2019-02-20 10:51:57 | floodgate | 1 | 81242 | 2 | 1.190 | 68270.6 |
106 | 2019-02-10 23:13:48 | floodgate | 1 | 81242 | 2 | 1.160 | 70036.2 |
105 | 2018-12-20 16:54:52 | floodgate | 1 | 81242 | 2 | 1.310 | 62016.8 |
104 | 2018-10-25 19:33:03 | floodgate | 1 | 81242 | 2 | 1.410 | 57618.4 |
103 | 2018-07-24 17:28:12 | floodgate | 1 | 81242 | 2 | 1.376 | 59042.2 |
102 | 2018-01-04 01:18:12 | floodgate | 1 | 81242 | 2 | 2.013 | 40358.7 |
101 | 2017-11-26 16:29:35 | floodgate | 1 | 81242 | 2 | 1.613 | 50367.0 |
100 | 2017-11-26 16:23:42 | floodgate | 1 | 81242 | 2 | 1.660 | 48941.0 |
99 | 2017-03-26 09:50:29 | floodgate | 1 | 81242 | 2 | 1.790 | 45386.6 |
98 | 2016-12-29 08:31:57 | floodgate | 4 | 165329 | 118 | 19.146 | 8635.2 |
97 | 2016-12-20 00:40:37 | floodgate | 4 | 165329 | 118 | 14.413 | 11470.8 |
96 | 2016-12-12 06:52:31 | floodgate | 4 | 165329 | 118 | 26.916 | 6142.4 |
95 | 2016-10-31 10:48:52 | floodgate | 1 | 81242 | 2 | 1.923 | 42247.5 |
94 | 2016-10-21 00:21:28 | floodgate | 4 | 165329 | 118 | 21.533 | 7677.9 |
93 | 2016-10-19 03:06:04 | floodgate | 4 | 165329 | 118 | 26.820 | 6164.4 |
92 | 2016-08-14 21:59:26 | floodgate | 4 | 165329 | 118 | 20.743 | 7970.4 |
91 | 2016-07-15 01:28:34 | floodgate | 1 | 81242 | 2 | 1.973 | 41176.9 |
90 | 2016-07-11 20:45:53 | floodgate | 2 | 121436 | 3 | 5.316 | 22843.5 |
89 | 2016-07-10 21:10:07 | floodgate | 1 | 81242 | 2 | 2.036 | 39902.8 |