History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"obsoleting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
163 | 2024-04-28 00:43:34 | obsoleting | 2 | 108824 | 2 | 4.283 | 25408.4 |
162 | 2024-04-27 23:17:00 | obsoleting | 3 | 140603 | 14 | 9.986 | 14080.0 |
161 | 2024-04-27 14:52:13 | obsoleting | 4 | 161450 | 168 | 25.096 | 6433.3 |
160 | 2024-04-27 11:35:03 | obsoleting | 4 | 161450 | 168 | 15.766 | 10240.4 |
159 | 2024-04-26 18:44:12 | obsoleting | 1 | 67641 | 1 | 1.126 | 60071.9 |
158 | 2024-04-12 17:59:56 | obsoleting | 1 | 67641 | 1 | 1.186 | 57032.9 |
157 | 2024-04-04 17:27:44 | obsoleting | 3 | 140603 | 14 | 27.796 | 5058.4 |
156 | 2024-04-02 13:59:42 | obsoleting | 1 | 67641 | 1 | 2.780 | 24331.3 |
155 | 2024-04-02 13:42:07 | obsoleting | 3 | 140603 | 14 | 7.423 | 18941.5 |
154 | 2024-04-02 13:42:06 | obsoleting | 2 | 108824 | 2 | 3.703 | 29388.1 |
153 | 2024-04-02 13:40:40 | obsoleting | 1 | 67641 | 1 | 2.296 | 29460.4 |
152 | 2024-03-28 09:42:40 | obsoleting | 1 | 67641 | 1 | 2.343 | 28869.4 |
151 | 2024-03-23 04:01:48 | obsoleting | 4 | 161450 | 168 | 18.970 | 8510.8 |
150 | 2024-03-22 09:23:04 | obsoleting | 4 | 161450 | 168 | 16.283 | 9915.2 |
149 | 2024-03-21 23:49:35 | obsoleting | 3 | 140603 | 14 | 26.640 | 5277.9 |
148 | 2024-03-21 23:49:33 | obsoleting | 4 | 161450 | 168 | 24.410 | 6614.1 |
147 | 2024-03-21 23:49:35 | obsoleting | 2 | 108824 | 2 | 7.330 | 14846.4 |
146 | 2024-03-21 22:49:15 | obsoleting | 1 | 67641 | 1 | 1.063 | 63632.2 |
145 | 2024-03-02 15:34:18 | obsoleting | 2 | 108824 | 2 | 7.030 | 15479.9 |
144 | 2024-03-02 14:02:35 | obsoleting | 1 | 67641 | 1 | 2.203 | 30704.0 |
143 | 2024-02-29 09:57:51 | obsoleting | 1 | 67641 | 1 | 2.156 | 31373.4 |
142 | 2024-02-29 09:57:46 | obsoleting | 1 | 67641 | 1 | 3.170 | 21337.9 |
141 | 2024-02-21 13:58:21 | obsoleting | 3 | 140603 | 14 | 19.173 | 7333.4 |
140 | 2024-02-18 23:40:40 | obsoleting | 4 | 161450 | 168 | 56.113 | 2877.2 |
139 | 2024-02-18 15:04:55 | obsoleting | 4 | 161450 | 168 | 26.343 | 6128.8 |
138 | 2024-02-18 15:04:53 | obsoleting | 3 | 140603 | 14 | 14.110 | 9964.8 |
137 | 2024-02-18 15:04:57 | obsoleting | 2 | 108824 | 2 | 3.360 | 32388.1 |
136 | 2024-02-18 12:35:13 | obsoleting | 1 | 67641 | 1 | 2.233 | 30291.5 |
135 | 2024-02-11 23:29:40 | obsoleting | 1 | 67641 | 1 | 1.310 | 51634.4 |
134 | 2024-02-06 11:04:02 | obsoleting | 1 | 67641 | 1 | 2.390 | 28301.7 |
133 | 2024-01-28 08:12:08 | obsoleting | 1 | 67641 | 1 | 1.046 | 64666.3 |
132 | 2024-01-19 09:32:40 | obsoleting | 1 | 67641 | 1 | 0.983 | 68810.8 |
131 | 2024-01-17 17:33:06 | obsoleting | 1 | 67641 | 1 | 1.186 | 57032.9 |
130 | 2024-01-03 08:06:14 | obsoleting | 1 | 67641 | 1 | 1.106 | 61158.2 |
129 | 2023-11-13 04:50:11 | obsoleting | 1 | 67641 | 1 | 1.093 | 61885.6 |
128 | 2023-09-23 16:25:08 | obsoleting | 1 | 67641 | 1 | 1.080 | 62630.6 |
127 | 2023-09-07 22:01:20 | obsoleting | 1 | 67641 | 1 | 1.093 | 61885.6 |
126 | 2023-09-02 15:03:20 | obsoleting | 1 | 67641 | 1 | 1.046 | 64666.3 |
125 | 2023-06-08 10:35:54 | obsoleting | 1 | 67641 | 1 | 0.966 | 70021.7 |
124 | 2023-03-30 06:42:19 | obsoleting | 1 | 67641 | 1 | 0.970 | 69733.0 |
123 | 2023-01-29 07:59:13 | obsoleting | 1 | 67641 | 1 | 1.110 | 60937.8 |
122 | 2023-01-12 22:56:28 | obsoleting | 1 | 67641 | 1 | 1.096 | 61716.2 |
121 | 2022-10-31 02:34:14 | obsoleting | 1 | 67641 | 1 | 0.970 | 69733.0 |
120 | 2022-09-12 12:40:49 | obsoleting | 1 | 67641 | 1 | 0.966 | 70021.7 |
119 | 2022-06-20 01:14:38 | obsoleting | 1 | 67641 | 1 | 0.966 | 70021.7 |
118 | 2022-06-16 16:17:01 | obsoleting | 1 | 67641 | 1 | 0.970 | 69733.0 |
117 | 2022-05-02 16:28:50 | obsoleting | 1 | 67641 | 1 | 1.343 | 50365.6 |
116 | 2022-04-18 22:39:54 | obsoleting | 1 | 67641 | 1 | 1.123 | 60232.4 |
115 | 2021-12-14 19:11:08 | obsoleting | 1 | 67641 | 1 | 1.030 | 65670.9 |
114 | 2021-08-15 08:01:36 | obsoleting | 1 | 67641 | 1 | 0.970 | 69733.0 |
113 | 2021-08-11 23:36:29 | obsoleting | 1 | 67641 | 1 | 1.000 | 67641.0 |
112 | 2021-04-19 20:39:20 | obsoleting | 1 | 67641 | 1 | 1.156 | 58513.0 |
111 | 2020-12-22 14:42:03 | obsoleting | 1 | 67641 | 1 | 1.016 | 66575.8 |
110 | 2020-11-17 13:51:36 | obsoleting | 1 | 67641 | 1 | 1.016 | 66575.8 |
109 | 2020-10-19 06:12:04 | obsoleting | 1 | 67641 | 1 | 1.063 | 63632.2 |
108 | 2020-10-03 06:11:59 | obsoleting | 1 | 67641 | 1 | 1.140 | 59334.2 |
107 | 2020-09-14 19:32:33 | obsoleting | 1 | 67641 | 1 | 1.016 | 66575.8 |
106 | 2020-05-21 10:24:31 | obsoleting | 1 | 67641 | 1 | 1.080 | 62630.6 |
105 | 2020-03-27 08:01:54 | obsoleting | 1 | 67641 | 1 | 1.140 | 59334.2 |
104 | 2020-02-18 00:34:23 | obsoleting | 1 | 67641 | 1 | 2.466 | 27429.4 |
103 | 2020-02-15 04:23:38 | obsoleting | 1 | 67641 | 1 | 2.390 | 28301.7 |
102 | 2020-02-12 11:51:09 | obsoleting | 1 | 67641 | 1 | 2.563 | 26391.3 |
101 | 2020-02-09 16:48:10 | obsoleting | 1 | 67641 | 1 | 3.173 | 21317.7 |
100 | 2020-02-03 20:53:04 | obsoleting | 1 | 67641 | 1 | 2.560 | 26422.3 |
99 | 2020-02-03 16:17:10 | obsoleting | 1 | 67641 | 1 | 1.156 | 58513.0 |
98 | 2020-01-31 17:16:55 | obsoleting | 1 | 67641 | 1 | 1.110 | 60937.8 |
97 | 2020-01-27 02:25:01 | obsoleting | 1 | 67641 | 1 | 2.796 | 24192.1 |
96 | 2020-01-26 23:48:25 | obsoleting | 1 | 67641 | 1 | 0.983 | 68810.8 |
95 | 2020-01-17 22:20:20 | obsoleting | 1 | 67641 | 1 | 1.063 | 63632.2 |
94 | 2020-01-13 14:48:37 | obsoleting | 1 | 67641 | 1 | 3.580 | 18894.1 |
93 | 2020-01-05 04:49:38 | obsoleting | 1 | 67641 | 1 | 2.560 | 26422.3 |
92 | 2019-10-24 06:32:08 | obsoleting | 1 | 67641 | 1 | 1.063 | 63632.2 |
91 | 2019-07-10 11:34:46 | obsoleting | 1 | 67641 | 1 | 1.060 | 63812.3 |
90 | 2019-04-04 07:51:15 | obsoleting | 1 | 67641 | 1 | 0.973 | 69518.0 |
89 | 2019-04-04 06:50:50 | obsoleting | 1 | 67641 | 1 | 1.116 | 60610.2 |
88 | 2019-04-04 05:50:50 | obsoleting | 1 | 67641 | 1 | 0.963 | 70239.9 |
87 | 2019-03-11 10:36:34 | obsoleting | 1 | 67641 | 1 | 1.046 | 64666.3 |
86 | 2019-02-16 19:18:06 | obsoleting | 1 | 67641 | 1 | 1.053 | 64236.5 |
85 | 2019-01-23 09:56:59 | obsoleting | 1 | 67641 | 1 | 1.073 | 63039.1 |
84 | 2018-11-13 05:36:49 | obsoleting | 1 | 67641 | 1 | 1.156 | 58513.0 |
83 | 2018-07-25 02:07:46 | obsoleting | 1 | 67641 | 1 | 1.063 | 63632.2 |
82 | 2018-01-06 20:49:39 | obsoleting | 3 | 140603 | 14 | 7.323 | 19200.2 |
81 | 2017-06-29 22:04:20 | obsoleting | 2 | 108824 | 2 | 3.523 | 30889.6 |
80 | 2017-03-26 16:31:01 | obsoleting | 1 | 67641 | 1 | 1.600 | 42275.6 |
79 | 2017-01-26 16:48:17 | obsoleting | 1 | 67641 | 1 | 1.316 | 51398.9 |
78 | 2017-01-03 03:00:05 | obsoleting | 1 | 67641 | 1 | 1.460 | 46329.5 |
77 | 2017-01-01 00:38:36 | obsoleting | 1 | 67641 | 1 | 1.213 | 55763.4 |
76 | 2016-11-27 02:02:18 | obsoleting | 1 | 67641 | 1 | 1.486 | 45518.8 |
75 | 2016-11-24 23:38:19 | obsoleting | 1 | 67641 | 1 | 1.393 | 48557.8 |
74 | 2016-11-16 00:06:26 | obsoleting | 1 | 67641 | 1 | 1.390 | 48662.6 |
73 | 2016-11-02 08:42:15 | obsoleting | 1 | 67641 | 1 | 1.523 | 44413.0 |
72 | 2016-10-18 11:09:53 | obsoleting | 1 | 67641 | 1 | 1.750 | 38652.0 |
71 | 2016-10-01 17:30:25 | obsoleting | 1 | 67641 | 1 | 1.656 | 40846.0 |
70 | 2016-09-28 04:08:30 | obsoleting | 1 | 67641 | 1 | 1.536 | 44037.1 |
69 | 2016-09-21 15:20:10 | obsoleting | 1 | 67641 | 1 | 1.670 | 40503.6 |
68 | 2016-09-19 01:44:44 | obsoleting | 1 | 67641 | 1 | 1.446 | 46778.0 |
67 | 2016-09-18 22:31:12 | obsoleting | 1 | 67641 | 1 | 1.413 | 47870.5 |
66 | 2016-09-08 15:20:37 | obsoleting | 1 | 67641 | 1 | 1.316 | 51398.9 |
65 | 2016-08-30 11:40:35 | obsoleting | 1 | 67641 | 1 | 1.376 | 49157.7 |
64 | 2016-08-25 00:46:58 | obsoleting | 1 | 67641 | 1 | 1.276 | 53010.2 |