History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stopgap"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
174 | 2024-05-14 19:11:23 | stopgap | 1 | 69583 | 2 | 1.423 | 48898.8 |
173 | 2024-05-08 12:03:47 | stopgap | 1 | 69583 | 2 | 2.716 | 25619.7 |
172 | 2024-04-28 02:56:37 | stopgap | 1 | 69583 | 2 | 2.876 | 24194.4 |
171 | 2024-04-27 07:17:27 | stopgap | 1 | 69583 | 2 | 6.280 | 11080.1 |
170 | 2024-03-30 23:31:41 | stopgap | 1 | 69583 | 2 | 4.000 | 17395.8 |
169 | 2024-03-24 04:45:39 | stopgap | 1 | 69583 | 2 | 1.326 | 52475.9 |
168 | 2024-02-28 22:02:10 | stopgap | 1 | 69583 | 2 | 1.250 | 55666.4 |
167 | 2024-01-22 18:44:10 | stopgap | 4 | 151207 | 721 | 40.533 | 3730.5 |
166 | 2024-01-22 18:14:15 | stopgap | 4 | 151207 | 721 | 26.016 | 5812.1 |
165 | 2024-01-19 22:12:07 | stopgap | 3 | 134027 | 63 | 12.953 | 10347.2 |
164 | 2024-01-19 22:11:54 | stopgap | 4 | 151207 | 721 | 21.486 | 7037.5 |
163 | 2023-12-31 10:37:09 | stopgap | 4 | 151207 | 721 | 11.406 | 13256.8 |
162 | 2023-12-31 10:37:12 | stopgap | 3 | 134027 | 63 | 8.080 | 16587.5 |
161 | 2023-12-31 10:37:10 | stopgap | 2 | 107671 | 2 | 5.016 | 21465.5 |
160 | 2023-12-14 15:01:06 | stopgap | 3 | 134027 | 63 | 6.830 | 19623.3 |
159 | 2023-12-14 15:01:05 | stopgap | 2 | 107671 | 2 | 3.216 | 33479.8 |
158 | 2023-12-12 14:49:59 | stopgap | 4 | 151207 | 721 | 12.546 | 12052.2 |
157 | 2023-11-14 16:25:21 | stopgap | 1 | 69583 | 2 | 1.220 | 57035.2 |
156 | 2023-11-11 10:39:29 | stopgap | 1 | 69583 | 2 | 1.220 | 57035.2 |
155 | 2023-11-02 13:59:19 | stopgap | 4 | 151207 | 721 | 12.970 | 11658.2 |
154 | 2023-11-02 13:59:20 | stopgap | 3 | 134027 | 63 | 12.063 | 11110.6 |
153 | 2023-11-02 13:59:17 | stopgap | 2 | 107671 | 2 | 4.313 | 24964.3 |
152 | 2023-10-20 22:29:39 | stopgap | 1 | 69583 | 2 | 1.186 | 58670.3 |
151 | 2023-10-18 05:13:58 | stopgap | 1 | 69583 | 2 | 1.310 | 53116.8 |
150 | 2023-10-12 08:07:02 | stopgap | 1 | 69583 | 2 | 1.110 | 62687.4 |
149 | 2023-10-04 13:21:39 | stopgap | 1 | 69583 | 2 | 1.090 | 63837.6 |
148 | 2023-09-23 12:23:54 | stopgap | 1 | 69583 | 2 | 1.063 | 65459.1 |
147 | 2023-09-12 06:47:17 | stopgap | 1 | 69583 | 2 | 1.250 | 55666.4 |
146 | 2023-07-16 18:45:49 | stopgap | 4 | 151207 | 721 | 11.953 | 12650.1 |
145 | 2023-07-16 18:45:47 | stopgap | 3 | 134027 | 63 | 6.206 | 21596.4 |
144 | 2023-07-16 18:45:42 | stopgap | 2 | 107671 | 2 | 2.813 | 38276.2 |
143 | 2023-07-16 17:59:25 | stopgap | 1 | 69583 | 2 | 1.356 | 51314.9 |
142 | 2023-05-01 02:25:17 | stopgap | 1 | 69583 | 2 | 1.186 | 58670.3 |
141 | 2023-04-03 00:00:17 | stopgap | 1 | 69583 | 2 | 2.123 | 32775.8 |
140 | 2022-11-17 05:32:08 | stopgap | 1 | 69583 | 2 | 1.190 | 58473.1 |
139 | 2022-09-17 06:24:08 | stopgap | 1 | 69583 | 2 | 1.173 | 59320.5 |
138 | 2021-02-16 07:33:51 | stopgap | 1 | 69583 | 2 | 1.093 | 63662.4 |
137 | 2020-12-25 03:16:29 | stopgap | 1 | 69583 | 2 | 1.110 | 62687.4 |
136 | 2020-11-15 05:24:00 | stopgap | 1 | 69583 | 2 | 1.763 | 39468.5 |
135 | 2020-10-31 15:14:40 | stopgap | 1 | 69583 | 2 | 2.186 | 31831.2 |
134 | 2020-03-28 21:45:21 | stopgap | 1 | 69583 | 2 | 1.326 | 52475.9 |
133 | 2020-03-27 19:26:29 | stopgap | 1 | 69583 | 2 | 2.470 | 28171.3 |
132 | 2020-03-21 21:57:55 | stopgap | 1 | 69583 | 2 | 1.390 | 50059.7 |
131 | 2020-02-27 10:46:07 | stopgap | 1 | 69583 | 2 | 1.233 | 56433.9 |
130 | 2020-02-27 06:18:23 | stopgap | 1 | 69583 | 2 | 2.623 | 26528.0 |
129 | 2020-02-21 14:48:27 | stopgap | 1 | 69583 | 2 | 1.360 | 51164.0 |
128 | 2020-02-19 09:12:10 | stopgap | 4 | 151207 | 721 | 20.550 | 7358.0 |
127 | 2020-02-18 20:41:57 | stopgap | 4 | 151207 | 721 | 27.613 | 5475.9 |
126 | 2020-02-17 05:44:17 | stopgap | 4 | 151207 | 721 | 31.080 | 4865.1 |
125 | 2020-02-17 03:03:16 | stopgap | 4 | 151207 | 721 | 25.156 | 6010.8 |
124 | 2020-02-14 09:08:44 | stopgap | 4 | 151207 | 721 | 24.080 | 6279.4 |
123 | 2020-02-12 15:17:36 | stopgap | 4 | 151207 | 721 | 22.736 | 6650.6 |
122 | 2020-02-10 17:33:58 | stopgap | 4 | 151207 | 721 | 27.876 | 5424.3 |
121 | 2020-02-01 13:26:56 | stopgap | 1 | 69583 | 2 | 2.500 | 27833.2 |
120 | 2020-01-28 05:08:12 | stopgap | 1 | 69583 | 2 | 2.796 | 24886.6 |
119 | 2020-01-27 14:36:40 | stopgap | 1 | 69583 | 2 | 1.420 | 49002.1 |
118 | 2020-01-25 13:30:09 | stopgap | 1 | 69583 | 2 | 1.203 | 57841.2 |
117 | 2020-01-25 05:53:54 | stopgap | 1 | 69583 | 2 | 1.326 | 52475.9 |
116 | 2020-01-21 16:40:18 | stopgap | 4 | 151207 | 721 | 10.483 | 14424.0 |
115 | 2020-01-21 03:16:38 | stopgap | 4 | 151207 | 721 | 16.080 | 9403.4 |
114 | 2020-01-20 23:08:51 | stopgap | 4 | 151207 | 721 | 19.610 | 7710.7 |
113 | 2020-01-19 07:57:53 | stopgap | 4 | 151207 | 721 | 15.263 | 9906.8 |
112 | 2020-01-19 05:26:35 | stopgap | 4 | 151207 | 721 | 12.406 | 12188.2 |
111 | 2020-01-19 01:19:42 | stopgap | 2 | 107671 | 2 | 3.876 | 27778.9 |
110 | 2020-01-19 01:19:16 | stopgap | 4 | 151207 | 721 | 15.453 | 9785.0 |
109 | 2020-01-19 01:18:44 | stopgap | 3 | 134027 | 63 | 12.123 | 11055.6 |
108 | 2020-01-18 22:06:53 | stopgap | 1 | 69583 | 2 | 1.266 | 54962.9 |
107 | 2020-01-12 03:59:57 | stopgap | 1 | 69583 | 2 | 4.046 | 17198.0 |
106 | 2020-01-01 06:52:35 | stopgap | 1 | 69583 | 2 | 2.610 | 26660.2 |
105 | 2019-12-30 21:40:50 | stopgap | 1 | 69583 | 2 | 1.110 | 62687.4 |
104 | 2019-11-28 10:09:09 | stopgap | 1 | 69583 | 2 | 1.220 | 57035.2 |
103 | 2019-08-26 18:54:48 | stopgap | 1 | 69583 | 2 | 1.046 | 66522.9 |
102 | 2019-05-05 02:12:52 | stopgap | 1 | 69583 | 2 | 1.136 | 61252.6 |
101 | 2019-02-17 13:48:20 | stopgap | 4 | 151207 | 721 | 12.703 | 11903.3 |
100 | 2019-02-16 11:00:59 | stopgap | 1 | 69583 | 2 | 1.153 | 60349.5 |
99 | 2019-01-07 12:06:24 | stopgap | 1 | 69583 | 2 | 1.080 | 64428.7 |
98 | 2018-12-30 07:00:33 | stopgap | 1 | 69583 | 2 | 1.226 | 56756.1 |
97 | 2018-10-04 11:24:12 | stopgap | 1 | 69583 | 2 | 1.270 | 54789.8 |
96 | 2018-08-15 21:08:13 | stopgap | 1 | 69583 | 2 | 1.100 | 63257.3 |
95 | 2018-08-12 12:38:55 | stopgap | 1 | 69583 | 2 | 1.260 | 55224.6 |
94 | 2018-07-18 15:27:48 | stopgap | 1 | 69583 | 2 | 1.396 | 49844.6 |
93 | 2018-06-27 22:27:41 | stopgap | 1 | 69583 | 2 | 1.086 | 64072.7 |
92 | 2018-06-26 01:10:54 | stopgap | 1 | 69583 | 2 | 1.063 | 65459.1 |
91 | 2018-06-25 22:49:06 | stopgap | 1 | 69583 | 2 | 1.286 | 54108.1 |
90 | 2018-06-25 21:18:53 | stopgap | 1 | 69583 | 2 | 1.356 | 51314.9 |
89 | 2018-04-17 05:22:56 | stopgap | 1 | 69583 | 2 | 1.090 | 63837.6 |
88 | 2018-04-01 00:15:12 | stopgap | 1 | 69583 | 2 | 1.973 | 35267.6 |
87 | 2018-03-12 20:15:21 | stopgap | 1 | 69583 | 2 | 1.566 | 44433.6 |
86 | 2018-02-25 07:21:05 | stopgap | 1 | 69583 | 2 | 1.696 | 41027.7 |
85 | 2017-11-02 01:42:47 | stopgap | 1 | 69583 | 2 | 1.683 | 41344.6 |
84 | 2017-09-14 09:29:08 | stopgap | 1 | 69583 | 2 | 1.606 | 43326.9 |
83 | 2017-08-01 01:00:58 | stopgap | 1 | 69583 | 2 | 1.426 | 48795.9 |
82 | 2017-05-22 22:22:02 | stopgap | 1 | 69583 | 2 | 1.870 | 37210.2 |
81 | 2017-03-02 12:20:17 | stopgap | 1 | 69583 | 2 | 1.500 | 46388.7 |
80 | 2016-12-13 23:26:16 | stopgap | 1 | 69583 | 2 | 1.560 | 44604.5 |
79 | 2016-12-03 15:48:13 | stopgap | 1 | 69583 | 2 | 1.636 | 42532.4 |
78 | 2016-11-19 13:33:32 | stopgap | 1 | 69583 | 2 | 1.763 | 39468.5 |
77 | 2016-10-16 19:16:55 | stopgap | 1 | 69583 | 2 | 1.766 | 39401.5 |
76 | 2016-09-11 23:44:58 | stopgap | 1 | 69583 | 2 | 1.906 | 36507.3 |
75 | 2016-09-11 09:14:57 | stopgap | 1 | 69583 | 2 | 1.793 | 38808.1 |