History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subthemes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
173 | 2024-04-26 05:30:54 | subthemes | 1 | 81242 | 2 | 1.610 | 50460.9 |
172 | 2024-04-17 14:30:20 | subthemes | 2 | 121436 | 2 | 16.033 | 7574.1 |
171 | 2024-04-17 13:17:38 | subthemes | 3 | 148641 | 28 | 13.580 | 10945.6 |
170 | 2024-04-17 13:17:32 | subthemes | 1 | 81242 | 2 | 2.656 | 30588.1 |
169 | 2024-03-28 15:14:01 | subthemes | 1 | 81242 | 2 | 1.406 | 57782.4 |
168 | 2024-03-26 13:50:19 | subthemes | 2 | 121436 | 2 | 12.623 | 9620.2 |
167 | 2024-03-26 12:29:29 | subthemes | 1 | 81242 | 2 | 1.500 | 54161.3 |
166 | 2024-03-26 06:41:14 | subthemes | 4 | 165329 | 292 | 19.270 | 8579.6 |
165 | 2024-03-26 04:03:03 | subthemes | 4 | 165329 | 292 | 28.660 | 5768.6 |
164 | 2024-03-23 10:35:36 | subthemes | 3 | 148641 | 28 | 28.033 | 5302.4 |
163 | 2024-03-23 10:35:33 | subthemes | 4 | 165329 | 292 | 28.860 | 5728.7 |
162 | 2024-03-22 12:48:53 | subthemes | 4 | 165329 | 292 | 40.063 | 4126.7 |
161 | 2024-03-22 12:48:53 | subthemes | 3 | 148641 | 28 | 18.936 | 7849.7 |
160 | 2024-03-22 12:48:53 | subthemes | 2 | 121436 | 2 | 4.466 | 27191.2 |
159 | 2024-03-22 10:28:49 | subthemes | 1 | 81242 | 2 | 1.453 | 55913.3 |
158 | 2024-02-27 09:41:42 | subthemes | 1 | 81242 | 2 | 1.266 | 64172.2 |
157 | 2024-02-17 00:54:18 | subthemes | 3 | 148641 | 28 | 9.280 | 16017.3 |
156 | 2024-02-17 00:54:16 | subthemes | 2 | 121436 | 2 | 8.233 | 14749.9 |
155 | 2024-02-16 22:45:39 | subthemes | 1 | 81242 | 2 | 1.500 | 54161.3 |
154 | 2024-02-15 21:16:17 | subthemes | 3 | 148641 | 28 | 26.283 | 5655.4 |
153 | 2024-02-15 21:15:31 | subthemes | 2 | 121436 | 2 | 5.936 | 20457.5 |
152 | 2024-02-15 20:20:01 | subthemes | 1 | 81242 | 2 | 1.343 | 60492.9 |
151 | 2024-02-06 10:35:13 | subthemes | 4 | 165329 | 292 | 11.626 | 14220.6 |
150 | 2024-02-06 00:59:15 | subthemes | 4 | 165329 | 292 | 31.706 | 5214.4 |
149 | 2024-02-06 00:59:19 | subthemes | 3 | 148641 | 28 | 18.703 | 7947.4 |
148 | 2024-02-06 00:59:22 | subthemes | 2 | 121436 | 2 | 8.313 | 14608.0 |
147 | 2024-02-06 00:48:54 | subthemes | 1 | 81242 | 2 | 1.406 | 57782.4 |
146 | 2024-01-27 09:59:03 | subthemes | 1 | 81242 | 2 | 1.420 | 57212.7 |
145 | 2024-01-17 21:18:58 | subthemes | 1 | 81242 | 2 | 1.403 | 57905.9 |
144 | 2023-11-12 13:35:16 | subthemes | 1 | 81242 | 2 | 1.233 | 65889.7 |
143 | 2023-10-30 16:28:27 | subthemes | 1 | 81242 | 2 | 1.453 | 55913.3 |
142 | 2023-10-09 11:49:18 | subthemes | 1 | 81242 | 2 | 1.236 | 65729.8 |
141 | 2023-09-14 07:32:08 | subthemes | 1 | 81242 | 2 | 1.406 | 57782.4 |
140 | 2023-08-18 11:07:44 | subthemes | 1 | 81242 | 2 | 1.266 | 64172.2 |
139 | 2023-06-21 23:38:48 | subthemes | 1 | 81242 | 2 | 1.296 | 62686.7 |
138 | 2023-03-06 13:45:21 | subthemes | 1 | 81242 | 2 | 1.250 | 64993.6 |
137 | 2022-10-13 04:26:11 | subthemes | 1 | 81242 | 2 | 1.423 | 57092.1 |
136 | 2022-05-19 23:12:17 | subthemes | 1 | 81242 | 2 | 1.296 | 62686.7 |
135 | 2022-05-12 02:15:33 | subthemes | 1 | 81242 | 2 | 2.000 | 40621.0 |
134 | 2021-12-29 03:22:53 | subthemes | 1 | 81242 | 2 | 1.280 | 63470.3 |
133 | 2021-08-26 23:37:28 | subthemes | 1 | 81242 | 2 | 1.390 | 58447.5 |
132 | 2021-08-23 16:31:36 | subthemes | 1 | 81242 | 2 | 1.250 | 64993.6 |
131 | 2021-05-02 18:03:04 | subthemes | 1 | 81242 | 2 | 1.516 | 53589.7 |
130 | 2021-03-13 03:36:05 | subthemes | 1 | 81242 | 2 | 1.343 | 60492.9 |
129 | 2021-01-04 09:20:32 | subthemes | 1 | 81242 | 2 | 1.326 | 61268.5 |
128 | 2020-11-01 18:09:02 | subthemes | 1 | 81242 | 2 | 1.280 | 63470.3 |
127 | 2020-10-26 15:08:31 | subthemes | 1 | 81242 | 2 | 1.436 | 56575.2 |
126 | 2020-10-21 21:43:55 | subthemes | 1 | 81242 | 2 | 1.313 | 61875.1 |
125 | 2020-10-09 07:24:52 | subthemes | 1 | 81242 | 2 | 1.343 | 60492.9 |
124 | 2020-09-28 11:57:03 | subthemes | 1 | 81242 | 2 | 1.250 | 64993.6 |
123 | 2020-06-01 01:42:34 | subthemes | 1 | 81242 | 2 | 1.343 | 60492.9 |
122 | 2020-03-23 09:09:49 | subthemes | 1 | 81242 | 2 | 1.483 | 54782.2 |
121 | 2020-02-28 07:00:25 | subthemes | 1 | 81242 | 2 | 3.736 | 21745.7 |
120 | 2020-02-24 09:05:04 | subthemes | 1 | 81242 | 2 | 1.423 | 57092.1 |
119 | 2020-02-23 18:55:59 | subthemes | 1 | 81242 | 2 | 1.516 | 53589.7 |
118 | 2020-02-16 21:09:36 | subthemes | 1 | 81242 | 2 | 1.376 | 59042.2 |
117 | 2020-02-09 19:03:05 | subthemes | 1 | 81242 | 2 | 1.640 | 49537.8 |
116 | 2020-02-04 10:22:16 | subthemes | 1 | 81242 | 2 | 2.593 | 31331.3 |
115 | 2020-01-29 03:49:51 | subthemes | 1 | 81242 | 2 | 1.610 | 50460.9 |
114 | 2020-01-26 22:00:25 | subthemes | 1 | 81242 | 2 | 2.563 | 31698.0 |
113 | 2020-01-25 09:00:38 | subthemes | 1 | 81242 | 2 | 1.483 | 54782.2 |
112 | 2020-01-18 13:40:16 | subthemes | 1 | 81242 | 2 | 3.140 | 25873.2 |
111 | 2020-01-15 05:16:36 | subthemes | 1 | 81242 | 2 | 1.610 | 50460.9 |
110 | 2020-01-03 12:55:10 | subthemes | 1 | 81242 | 2 | 1.483 | 54782.2 |
109 | 2019-12-31 17:13:26 | subthemes | 1 | 81242 | 2 | 1.436 | 56575.2 |
108 | 2019-11-17 05:52:52 | subthemes | 1 | 81242 | 2 | 1.436 | 56575.2 |
107 | 2019-10-06 04:56:14 | subthemes | 1 | 81242 | 2 | 1.200 | 67701.7 |
106 | 2019-10-02 06:48:12 | subthemes | 1 | 81242 | 2 | 1.146 | 70891.8 |
105 | 2019-09-26 03:13:46 | subthemes | 1 | 81242 | 2 | 1.293 | 62832.2 |
104 | 2019-09-22 02:20:52 | subthemes | 1 | 81242 | 2 | 1.303 | 62350.0 |
103 | 2019-09-11 17:11:23 | subthemes | 1 | 81242 | 2 | 1.170 | 69437.6 |
102 | 2019-09-05 15:20:32 | subthemes | 1 | 81242 | 2 | 1.186 | 68500.8 |
101 | 2019-09-02 23:42:18 | subthemes | 1 | 81242 | 2 | 1.163 | 69855.5 |
100 | 2019-08-26 08:43:58 | subthemes | 1 | 81242 | 2 | 1.440 | 56418.1 |
99 | 2019-08-18 09:06:17 | subthemes | 1 | 81242 | 2 | 1.170 | 69437.6 |
98 | 2019-08-15 17:39:46 | subthemes | 1 | 81242 | 2 | 1.396 | 58196.3 |
97 | 2019-08-14 04:59:56 | subthemes | 1 | 81242 | 2 | 1.180 | 68849.2 |
96 | 2019-08-09 15:02:21 | subthemes | 1 | 81242 | 2 | 1.190 | 68270.6 |
95 | 2019-04-26 23:37:53 | subthemes | 1 | 81242 | 2 | 1.360 | 59736.8 |
94 | 2019-03-12 08:06:13 | subthemes | 1 | 81242 | 2 | 1.576 | 51549.5 |
93 | 2019-02-19 18:16:41 | subthemes | 1 | 81242 | 2 | 1.370 | 59300.7 |
92 | 2019-02-15 05:47:36 | subthemes | 1 | 81242 | 2 | 1.450 | 56029.0 |
91 | 2019-02-02 05:56:36 | subthemes | 1 | 81242 | 2 | 1.270 | 63970.1 |
90 | 2019-01-28 01:46:00 | subthemes | 1 | 81242 | 2 | 1.223 | 66428.5 |
89 | 2019-01-14 08:52:47 | subthemes | 1 | 81242 | 2 | 1.266 | 64172.2 |
88 | 2018-12-24 23:26:01 | subthemes | 1 | 81242 | 2 | 1.406 | 57782.4 |
87 | 2018-11-29 18:25:59 | subthemes | 1 | 81242 | 2 | 1.236 | 65729.8 |
86 | 2018-10-22 15:20:05 | subthemes | 1 | 81242 | 2 | 1.333 | 60946.7 |
85 | 2018-09-02 23:55:00 | subthemes | 1 | 81242 | 2 | 1.366 | 59474.4 |
84 | 2018-08-01 16:54:11 | subthemes | 1 | 81242 | 2 | 1.430 | 56812.6 |
83 | 2017-10-29 11:44:13 | subthemes | 1 | 81242 | 2 | 2.096 | 38760.5 |
82 | 2017-08-28 10:34:15 | subthemes | 1 | 81242 | 2 | 3.486 | 23305.2 |
81 | 2017-08-27 13:48:10 | subthemes | 1 | 81242 | 2 | 2.063 | 39380.5 |
80 | 2017-03-10 03:57:39 | subthemes | 4 | 165329 | 292 | 15.683 | 10541.9 |
79 | 2017-01-15 19:48:12 | subthemes | 1 | 81242 | 2 | 1.573 | 51647.8 |
78 | 2016-10-04 14:09:55 | subthemes | 1 | 81242 | 2 | 1.750 | 46424.0 |
77 | 2016-09-21 17:31:09 | subthemes | 1 | 81242 | 2 | 1.756 | 46265.4 |
76 | 2016-09-06 10:49:45 | subthemes | 3 | 148641 | 28 | 9.366 | 15870.3 |
75 | 2016-09-01 10:51:29 | subthemes | 2 | 121436 | 2 | 5.853 | 20747.7 |
74 | 2016-08-28 18:42:49 | subthemes | 1 | 81242 | 2 | 2.660 | 30542.1 |