History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"signpost"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
183 | 2024-04-27 14:26:47 | signpost | 1 | 82945 | 2 | 4.016 | 20653.6 |
182 | 2024-04-25 12:41:23 | signpost | 1 | 82945 | 2 | 1.690 | 49079.9 |
181 | 2024-04-13 04:07:48 | signpost | 1 | 82945 | 2 | 1.686 | 49196.3 |
180 | 2024-04-13 04:06:52 | signpost | 2 | 121059 | 4 | 3.703 | 32692.1 |
179 | 2024-04-11 03:31:33 | signpost | 4 | 161609 | 306 | 13.893 | 11632.4 |
178 | 2024-04-09 21:18:44 | signpost | 4 | 161609 | 306 | 14.830 | 10897.4 |
177 | 2024-04-09 21:18:28 | signpost | 2 | 121059 | 4 | 4.953 | 24441.6 |
176 | 2024-04-08 07:36:53 | signpost | 1 | 82945 | 2 | 2.783 | 29804.2 |
175 | 2024-04-07 18:21:46 | signpost | 3 | 146162 | 31 | 18.076 | 8086.0 |
174 | 2024-04-06 12:29:04 | signpost | 2 | 121059 | 4 | 4.080 | 29671.3 |
173 | 2024-04-04 23:47:22 | signpost | 3 | 146162 | 31 | 27.846 | 5248.9 |
172 | 2024-04-04 06:58:58 | signpost | 3 | 146162 | 31 | 10.420 | 14027.1 |
171 | 2024-04-04 06:58:58 | signpost | 2 | 121059 | 4 | 9.143 | 13240.6 |
170 | 2024-04-04 06:57:51 | signpost | 1 | 82945 | 2 | 1.656 | 50087.6 |
169 | 2024-04-03 17:06:56 | signpost | 4 | 161609 | 306 | 20.800 | 7769.7 |
168 | 2024-03-31 20:59:48 | signpost | 4 | 161609 | 306 | 16.110 | 10031.6 |
167 | 2024-03-31 09:49:19 | signpost | 4 | 161609 | 306 | 41.893 | 3857.7 |
166 | 2024-03-31 09:49:17 | signpost | 3 | 146162 | 31 | 24.800 | 5893.6 |
165 | 2024-03-31 09:49:14 | signpost | 2 | 121059 | 4 | 9.673 | 12515.1 |
164 | 2024-03-31 09:49:07 | signpost | 1 | 82945 | 2 | 5.063 | 16382.6 |
163 | 2024-03-12 00:34:28 | signpost | 4 | 161609 | 306 | 18.000 | 8978.3 |
162 | 2024-03-10 20:53:57 | signpost | 4 | 161609 | 306 | 14.953 | 10807.8 |
161 | 2024-03-10 20:53:46 | signpost | 1 | 82945 | 2 | 3.346 | 24789.3 |
160 | 2024-03-05 09:01:02 | signpost | 3 | 146162 | 31 | 7.576 | 19292.8 |
159 | 2024-03-05 08:45:09 | signpost | 3 | 146162 | 31 | 16.236 | 9002.3 |
158 | 2024-03-02 09:21:37 | signpost | 1 | 82945 | 2 | 5.346 | 15515.3 |
157 | 2024-03-02 08:53:50 | signpost | 3 | 146162 | 31 | 7.483 | 19532.5 |
156 | 2024-03-02 08:53:51 | signpost | 2 | 121059 | 4 | 3.826 | 31641.1 |
155 | 2024-03-01 08:23:10 | signpost | 2 | 121059 | 4 | 4.906 | 24675.7 |
154 | 2024-03-01 08:22:36 | signpost | 3 | 146162 | 31 | 7.263 | 20124.2 |
153 | 2024-02-29 08:03:16 | signpost | 2 | 121059 | 4 | 4.016 | 30144.2 |
152 | 2024-02-29 08:02:08 | signpost | 3 | 146162 | 31 | 6.906 | 21164.5 |
151 | 2024-02-29 06:56:45 | signpost | 1 | 82945 | 2 | 1.626 | 51011.7 |
150 | 2024-02-29 05:17:26 | signpost | 2 | 121059 | 4 | 7.830 | 15460.9 |
149 | 2024-02-29 05:17:22 | signpost | 3 | 146162 | 31 | 8.033 | 18195.2 |
148 | 2024-02-27 05:17:22 | signpost | 4 | 161609 | 306 | 23.050 | 7011.2 |
147 | 2024-02-26 08:25:35 | signpost | 4 | 161609 | 306 | 18.033 | 8961.8 |
146 | 2024-02-08 10:46:42 | signpost | 4 | 161609 | 306 | 69.786 | 2315.8 |
145 | 2024-02-08 10:12:59 | signpost | 1 | 82945 | 2 | 2.343 | 35401.2 |
144 | 2024-02-05 01:18:44 | signpost | 4 | 161609 | 306 | 28.830 | 5605.6 |
143 | 2024-01-27 08:04:23 | signpost | 4 | 161609 | 306 | 11.326 | 14268.9 |
142 | 2024-01-27 08:03:59 | signpost | 2 | 121059 | 4 | 3.673 | 32959.2 |
141 | 2024-01-27 08:03:55 | signpost | 3 | 146162 | 31 | 7.063 | 20694.0 |
140 | 2024-01-26 00:35:34 | signpost | 3 | 146162 | 31 | 8.970 | 16294.5 |
139 | 2024-01-25 22:28:27 | signpost | 3 | 146162 | 31 | 7.500 | 19488.3 |
138 | 2024-01-25 22:28:23 | signpost | 2 | 121059 | 4 | 3.656 | 33112.4 |
137 | 2024-01-25 22:28:19 | signpost | 3 | 146162 | 31 | 7.096 | 20597.8 |
136 | 2023-12-31 22:40:59 | signpost | 1 | 82945 | 2 | 1.440 | 57600.7 |
135 | 2023-12-24 01:06:02 | signpost | 1 | 82945 | 2 | 1.500 | 55296.7 |
134 | 2023-11-05 01:19:07 | signpost | 1 | 82945 | 2 | 1.466 | 56579.1 |
133 | 2023-10-22 22:07:46 | signpost | 1 | 82945 | 2 | 1.263 | 65673.0 |
132 | 2023-10-22 00:05:20 | signpost | 1 | 82945 | 2 | 1.436 | 57761.1 |
131 | 2023-10-15 01:50:54 | signpost | 1 | 82945 | 2 | 1.580 | 52496.8 |
130 | 2023-08-16 18:43:33 | signpost | 1 | 82945 | 2 | 2.000 | 41472.5 |
129 | 2023-05-17 15:51:06 | signpost | 1 | 82945 | 2 | 1.280 | 64800.8 |
128 | 2023-05-16 06:15:34 | signpost | 1 | 82945 | 2 | 1.310 | 63316.8 |
127 | 2023-03-13 15:29:26 | signpost | 1 | 82945 | 2 | 1.266 | 65517.4 |
126 | 2023-01-02 18:23:06 | signpost | 1 | 82945 | 2 | 1.470 | 56425.2 |
125 | 2022-12-28 02:22:26 | signpost | 1 | 82945 | 2 | 1.283 | 64649.3 |
124 | 2022-09-22 05:21:53 | signpost | 1 | 82945 | 2 | 1.310 | 63316.8 |
123 | 2022-07-21 00:28:07 | signpost | 1 | 82945 | 2 | 1.280 | 64800.8 |
122 | 2022-07-17 07:08:34 | signpost | 1 | 82945 | 2 | 1.450 | 57203.4 |
121 | 2022-02-03 06:50:54 | signpost | 1 | 82945 | 2 | 1.296 | 64000.8 |
120 | 2021-09-21 12:52:16 | signpost | 1 | 82945 | 2 | 1.483 | 55930.5 |
119 | 2021-06-02 03:28:25 | signpost | 1 | 82945 | 2 | 1.500 | 55296.7 |
118 | 2021-05-29 02:25:24 | signpost | 1 | 82945 | 2 | 1.516 | 54713.1 |
117 | 2021-04-06 04:38:23 | signpost | 1 | 82945 | 2 | 1.453 | 57085.3 |
116 | 2021-02-26 04:44:48 | signpost | 1 | 82945 | 2 | 1.280 | 64800.8 |
115 | 2021-02-14 05:14:47 | signpost | 1 | 82945 | 2 | 1.280 | 64800.8 |
114 | 2021-01-21 11:39:36 | signpost | 1 | 82945 | 2 | 1.296 | 64000.8 |
113 | 2020-11-11 17:05:47 | signpost | 1 | 82945 | 2 | 1.326 | 62552.8 |
112 | 2020-11-01 11:10:46 | signpost | 1 | 82945 | 2 | 1.500 | 55296.7 |
111 | 2020-08-29 13:29:35 | signpost | 1 | 82945 | 2 | 1.296 | 64000.8 |
110 | 2020-07-23 07:19:51 | signpost | 1 | 82945 | 2 | 1.373 | 60411.5 |
109 | 2020-04-15 00:59:02 | signpost | 1 | 82945 | 2 | 1.453 | 57085.3 |
108 | 2020-03-28 21:43:55 | signpost | 1 | 82945 | 2 | 1.436 | 57761.1 |
107 | 2020-03-27 07:36:10 | signpost | 1 | 82945 | 2 | 1.610 | 51518.6 |
106 | 2020-03-03 22:54:42 | signpost | 1 | 82945 | 2 | 1.453 | 57085.3 |
105 | 2020-02-18 17:06:03 | signpost | 1 | 82945 | 2 | 3.170 | 26165.6 |
104 | 2020-02-07 23:14:19 | signpost | 1 | 82945 | 2 | 1.626 | 51011.7 |
103 | 2020-02-04 12:37:41 | signpost | 1 | 82945 | 2 | 3.046 | 27230.8 |
102 | 2020-02-03 20:52:45 | signpost | 1 | 82945 | 2 | 3.373 | 24590.9 |
101 | 2020-01-31 00:55:15 | signpost | 1 | 82945 | 2 | 1.516 | 54713.1 |
100 | 2020-01-23 12:01:07 | signpost | 1 | 82945 | 2 | 1.763 | 47047.6 |
99 | 2020-01-16 14:53:29 | signpost | 2 | 121059 | 4 | 3.623 | 33414.0 |
98 | 2020-01-16 10:37:32 | signpost | 1 | 82945 | 2 | 3.640 | 22787.1 |
97 | 2020-01-04 23:56:00 | signpost | 1 | 82945 | 2 | 1.750 | 47397.1 |
96 | 2020-01-01 22:06:46 | signpost | 1 | 82945 | 2 | 3.190 | 26001.6 |
95 | 2019-12-22 10:53:18 | signpost | 1 | 82945 | 2 | 1.280 | 64800.8 |
94 | 2019-10-15 16:54:10 | signpost | 1 | 82945 | 2 | 1.343 | 61761.0 |
93 | 2019-09-21 09:07:05 | signpost | 1 | 82945 | 2 | 1.436 | 57761.1 |
92 | 2019-06-09 09:03:10 | signpost | 1 | 82945 | 2 | 1.323 | 62694.6 |
91 | 2019-06-03 04:44:01 | signpost | 1 | 82945 | 2 | 1.506 | 55076.4 |
90 | 2019-05-31 02:34:06 | signpost | 1 | 82945 | 2 | 1.533 | 54106.3 |
89 | 2019-01-24 09:18:31 | signpost | 1 | 82945 | 2 | 3.016 | 27501.7 |
88 | 2019-01-09 01:08:12 | signpost | 1 | 82945 | 2 | 1.453 | 57085.3 |
87 | 2018-12-11 11:14:55 | signpost | 1 | 82945 | 2 | 1.416 | 58577.0 |
86 | 2018-09-06 16:00:47 | signpost | 1 | 82945 | 2 | 1.333 | 62224.3 |
85 | 2018-08-26 10:22:33 | signpost | 1 | 82945 | 2 | 1.423 | 58288.8 |
84 | 2018-07-27 23:46:27 | signpost | 1 | 82945 | 2 | 1.310 | 63316.8 |