History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guesstimate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
170 | 2024-04-15 18:02:09 | guesstimate | 4 | 148819 | 24 | 15.690 | 9485.0 |
169 | 2024-04-15 08:02:15 | guesstimate | 3 | 121633 | 7 | 20.140 | 6039.4 |
168 | 2024-04-15 08:02:21 | guesstimate | 2 | 86808 | 3 | 11.453 | 7579.5 |
167 | 2024-04-15 08:00:52 | guesstimate | 1 | 49908 | 3 | 1.200 | 41590.0 |
166 | 2024-04-14 05:22:36 | guesstimate | 4 | 148819 | 24 | 26.126 | 5696.2 |
165 | 2024-04-14 05:20:05 | guesstimate | 4 | 148819 | 24 | 27.656 | 5381.1 |
164 | 2024-04-08 17:03:30 | guesstimate | 5 | 164607 | 140 | 49.033 | 3357.1 |
163 | 2024-04-08 00:11:09 | guesstimate | 5 | 164607 | 140 | 30.860 | 5334.0 |
162 | 2024-04-07 21:52:01 | guesstimate | 4 | 148819 | 24 | 19.890 | 7482.1 |
161 | 2024-04-07 07:45:22 | guesstimate | 5 | 164607 | 140 | 63.926 | 2575.0 |
160 | 2024-04-07 07:45:33 | guesstimate | 4 | 148819 | 24 | 44.986 | 3308.1 |
159 | 2024-04-07 07:45:40 | guesstimate | 3 | 121633 | 7 | 18.766 | 6481.6 |
158 | 2024-04-07 07:45:42 | guesstimate | 2 | 86808 | 3 | 6.080 | 14277.6 |
157 | 2024-04-07 07:23:18 | guesstimate | 1 | 49908 | 3 | 0.906 | 55086.1 |
156 | 2024-04-06 22:16:29 | guesstimate | 5 | 164607 | 140 | 45.363 | 3628.7 |
155 | 2024-04-06 22:16:25 | guesstimate | 4 | 148819 | 24 | 29.376 | 5066.0 |
154 | 2024-04-06 22:16:18 | guesstimate | 2 | 86808 | 3 | 7.670 | 11317.9 |
153 | 2024-04-06 22:16:18 | guesstimate | 3 | 121633 | 7 | 6.016 | 20218.3 |
152 | 2024-04-06 22:12:07 | guesstimate | 1 | 49908 | 3 | 1.000 | 49908.0 |
151 | 2024-04-03 03:20:01 | guesstimate | 1 | 49908 | 3 | 0.920 | 54247.8 |
150 | 2024-03-05 07:19:35 | guesstimate | 5 | 164607 | 140 | 49.550 | 3322.0 |
149 | 2024-03-05 07:19:22 | guesstimate | 4 | 148819 | 24 | 11.283 | 13189.7 |
148 | 2024-03-05 00:22:15 | guesstimate | 5 | 164607 | 140 | 35.300 | 4663.1 |
147 | 2024-03-04 21:10:31 | guesstimate | 5 | 164607 | 140 | 19.186 | 8579.5 |
146 | 2024-03-03 23:41:09 | guesstimate | 4 | 148819 | 24 | 18.330 | 8118.9 |
145 | 2024-03-03 11:10:51 | guesstimate | 5 | 164607 | 140 | 34.863 | 4721.5 |
144 | 2024-03-03 11:10:41 | guesstimate | 4 | 148819 | 24 | 33.643 | 4423.5 |
143 | 2024-03-03 11:10:39 | guesstimate | 3 | 121633 | 7 | 10.233 | 11886.3 |
142 | 2024-03-03 11:10:38 | guesstimate | 2 | 86808 | 3 | 3.000 | 28936.0 |
141 | 2024-03-03 11:09:59 | guesstimate | 1 | 49908 | 3 | 0.826 | 60421.3 |
140 | 2024-01-31 06:11:46 | guesstimate | 1 | 49908 | 3 | 0.750 | 66544.0 |
139 | 2024-01-25 20:02:09 | guesstimate | 1 | 49908 | 3 | 0.826 | 60421.3 |
138 | 2023-12-26 20:06:53 | guesstimate | 1 | 49908 | 3 | 0.720 | 69316.7 |
137 | 2023-12-19 18:17:01 | guesstimate | 1 | 49908 | 3 | 0.720 | 69316.7 |
136 | 2023-11-22 18:51:35 | guesstimate | 1 | 49908 | 3 | 0.716 | 69703.9 |
135 | 2023-11-19 13:23:21 | guesstimate | 1 | 49908 | 3 | 0.733 | 68087.3 |
134 | 2023-11-19 13:01:16 | guesstimate | 1 | 49908 | 3 | 0.873 | 57168.4 |
133 | 2023-09-08 17:08:09 | guesstimate | 1 | 49908 | 3 | 0.780 | 63984.6 |
132 | 2023-06-16 07:15:40 | guesstimate | 1 | 49908 | 3 | 0.736 | 67809.8 |
131 | 2023-06-12 14:09:55 | guesstimate | 1 | 49908 | 3 | 0.763 | 65410.2 |
130 | 2023-06-09 07:01:57 | guesstimate | 1 | 49908 | 3 | 0.716 | 69703.9 |
129 | 2023-04-02 05:28:25 | guesstimate | 1 | 49908 | 3 | 0.703 | 70992.9 |
128 | 2023-01-20 11:05:37 | guesstimate | 1 | 49908 | 3 | 0.733 | 68087.3 |
127 | 2023-01-16 20:03:42 | guesstimate | 1 | 49908 | 3 | 0.703 | 70992.9 |
126 | 2022-11-13 15:31:12 | guesstimate | 1 | 49908 | 3 | 0.720 | 69316.7 |
125 | 2022-11-08 02:44:47 | guesstimate | 5 | 164607 | 140 | 12.673 | 12988.8 |
124 | 2022-11-08 02:44:39 | guesstimate | 4 | 148819 | 24 | 7.893 | 18854.6 |
123 | 2022-11-08 02:44:34 | guesstimate | 3 | 121633 | 7 | 4.640 | 26214.0 |
122 | 2022-11-08 02:44:32 | guesstimate | 2 | 86808 | 3 | 1.983 | 43776.1 |
121 | 2022-11-08 02:07:52 | guesstimate | 1 | 49908 | 3 | 0.796 | 62698.5 |
120 | 2022-08-11 14:00:20 | guesstimate | 1 | 49908 | 3 | 0.750 | 66544.0 |
119 | 2022-07-04 15:31:46 | guesstimate | 1 | 49908 | 3 | 0.733 | 68087.3 |
118 | 2022-07-02 10:51:30 | guesstimate | 1 | 49908 | 3 | 0.716 | 69703.9 |
117 | 2022-03-03 19:49:54 | guesstimate | 1 | 49908 | 3 | 0.826 | 60421.3 |
116 | 2021-10-08 06:39:55 | guesstimate | 1 | 49908 | 3 | 0.720 | 69316.7 |
115 | 2021-10-05 01:41:12 | guesstimate | 1 | 49908 | 3 | 0.783 | 63739.5 |
114 | 2021-06-01 19:42:53 | guesstimate | 1 | 49908 | 3 | 0.780 | 63984.6 |
113 | 2021-03-16 15:43:38 | guesstimate | 1 | 49908 | 3 | 1.373 | 36349.6 |
112 | 2021-01-21 07:42:02 | guesstimate | 1 | 49908 | 3 | 0.793 | 62935.7 |
111 | 2020-11-27 08:51:46 | guesstimate | 1 | 49908 | 3 | 0.716 | 69703.9 |
110 | 2020-11-01 06:38:53 | guesstimate | 1 | 49908 | 3 | 0.720 | 69316.7 |
109 | 2020-10-30 23:01:39 | guesstimate | 1 | 49908 | 3 | 0.876 | 56972.6 |
108 | 2020-07-24 04:30:59 | guesstimate | 1 | 49908 | 3 | 0.750 | 66544.0 |
107 | 2020-07-20 21:27:25 | guesstimate | 1 | 49908 | 3 | 0.860 | 58032.6 |
106 | 2020-04-06 10:19:26 | guesstimate | 1 | 49908 | 3 | 0.736 | 67809.8 |
105 | 2020-03-27 03:57:47 | guesstimate | 5 | 164607 | 140 | 28.800 | 5715.5 |
104 | 2020-03-26 23:22:04 | guesstimate | 1 | 49908 | 3 | 0.843 | 59202.8 |
103 | 2020-02-21 03:33:44 | guesstimate | 5 | 164607 | 140 | 31.890 | 5161.7 |
102 | 2020-02-21 02:09:13 | guesstimate | 1 | 49908 | 3 | 0.860 | 58032.6 |
101 | 2020-02-12 20:31:21 | guesstimate | 1 | 49908 | 3 | 1.906 | 26184.7 |
100 | 2020-02-10 15:34:18 | guesstimate | 5 | 164607 | 140 | 21.766 | 7562.6 |
99 | 2020-02-09 17:42:34 | guesstimate | 5 | 164607 | 140 | 40.126 | 4102.3 |
98 | 2020-02-05 23:07:18 | guesstimate | 5 | 164607 | 140 | 27.080 | 6078.5 |
97 | 2020-02-05 00:13:29 | guesstimate | 1 | 49908 | 3 | 0.873 | 57168.4 |
96 | 2020-01-25 08:57:48 | guesstimate | 1 | 49908 | 3 | 1.013 | 49267.5 |
95 | 2020-01-22 06:51:27 | guesstimate | 1 | 49908 | 3 | 0.860 | 58032.6 |
94 | 2020-01-18 22:29:20 | guesstimate | 5 | 164607 | 140 | 18.236 | 9026.5 |
93 | 2020-01-14 19:17:45 | guesstimate | 5 | 164607 | 140 | 31.843 | 5169.3 |
92 | 2020-01-14 19:17:46 | guesstimate | 3 | 121633 | 7 | 11.690 | 10404.9 |
91 | 2020-01-14 19:17:21 | guesstimate | 4 | 148819 | 24 | 18.220 | 8167.9 |
90 | 2020-01-14 19:17:29 | guesstimate | 2 | 86808 | 3 | 8.156 | 10643.5 |
89 | 2020-01-14 18:27:10 | guesstimate | 1 | 49908 | 3 | 0.826 | 60421.3 |
88 | 2019-12-05 19:00:56 | guesstimate | 1 | 49908 | 3 | 0.843 | 59202.8 |
87 | 2019-09-03 15:53:28 | guesstimate | 1 | 49908 | 3 | 0.736 | 67809.8 |
86 | 2019-05-16 06:59:29 | guesstimate | 1 | 49908 | 3 | 0.726 | 68743.8 |
85 | 2019-01-08 23:50:04 | guesstimate | 1 | 49908 | 3 | 0.786 | 63496.2 |
84 | 2019-01-04 09:19:15 | guesstimate | 1 | 49908 | 3 | 0.760 | 65668.4 |
83 | 2019-01-01 01:10:26 | guesstimate | 1 | 49908 | 3 | 0.810 | 61614.8 |
82 | 2018-08-15 20:58:11 | guesstimate | 4 | 148819 | 24 | 8.573 | 17359.0 |
81 | 2018-08-13 20:03:22 | guesstimate | 5 | 164607 | 140 | 14.313 | 11500.5 |
80 | 2018-08-12 12:58:43 | guesstimate | 3 | 121633 | 7 | 5.496 | 22131.2 |
79 | 2018-08-10 14:18:03 | guesstimate | 2 | 86808 | 3 | 2.043 | 42490.5 |
78 | 2018-08-10 11:11:32 | guesstimate | 2 | 86808 | 3 | 2.133 | 40697.6 |
77 | 2018-08-08 01:49:01 | guesstimate | 1 | 49908 | 3 | 0.810 | 61614.8 |
76 | 2018-08-05 00:30:21 | guesstimate | 1 | 49908 | 3 | 0.846 | 58992.9 |
75 | 2018-07-11 00:05:41 | guesstimate | 1 | 49908 | 3 | 0.760 | 65668.4 |
74 | 2018-04-07 11:35:54 | guesstimate | 1 | 49908 | 3 | 0.940 | 53093.6 |
73 | 2018-01-04 05:32:27 | guesstimate | 1 | 49908 | 3 | 1.033 | 48313.6 |
72 | 2017-11-10 19:03:20 | guesstimate | 1 | 49908 | 3 | 1.013 | 49267.5 |
71 | 2017-03-19 01:08:43 | guesstimate | 1 | 49908 | 3 | 0.993 | 50259.8 |