History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sumptuary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
166 | 2024-05-09 12:28:19 | sumptuary | 4 | 165329 | 67 | 44.706 | 3698.1 |
165 | 2024-05-08 20:08:53 | sumptuary | 4 | 165329 | 67 | 27.813 | 5944.3 |
164 | 2024-05-08 14:04:08 | sumptuary | 4 | 165329 | 67 | 28.873 | 5726.1 |
163 | 2024-05-01 00:01:26 | sumptuary | 1 | 81242 | 1 | 1.486 | 54671.6 |
162 | 2024-04-30 14:00:15 | sumptuary | 4 | 165329 | 67 | 28.126 | 5878.2 |
161 | 2024-04-17 06:11:21 | sumptuary | 4 | 165329 | 67 | 15.876 | 10413.8 |
160 | 2024-04-11 05:48:11 | sumptuary | 1 | 81242 | 1 | 3.110 | 26122.8 |
159 | 2024-04-10 15:34:27 | sumptuary | 4 | 165329 | 67 | 47.020 | 3516.1 |
158 | 2024-04-10 14:59:27 | sumptuary | 4 | 165329 | 67 | 35.063 | 4715.2 |
157 | 2024-04-10 14:59:28 | sumptuary | 2 | 121436 | 1 | 6.753 | 17982.5 |
156 | 2024-04-10 14:58:14 | sumptuary | 3 | 148641 | 9 | 9.516 | 15620.1 |
155 | 2024-04-10 14:58:01 | sumptuary | 1 | 81242 | 1 | 1.703 | 47705.2 |
154 | 2024-04-07 13:11:26 | sumptuary | 4 | 165329 | 67 | 32.656 | 5062.7 |
153 | 2024-04-06 14:29:06 | sumptuary | 1 | 81242 | 1 | 1.546 | 52549.8 |
152 | 2024-04-05 14:25:32 | sumptuary | 4 | 165329 | 67 | 28.266 | 5849.0 |
151 | 2024-04-04 16:35:48 | sumptuary | 4 | 165329 | 67 | 15.813 | 10455.3 |
150 | 2024-04-04 06:42:12 | sumptuary | 4 | 165329 | 67 | 27.783 | 5950.7 |
149 | 2024-04-03 16:51:35 | sumptuary | 4 | 165329 | 67 | 32.970 | 5014.5 |
148 | 2024-04-03 16:48:44 | sumptuary | 4 | 165329 | 67 | 31.813 | 5196.9 |
147 | 2024-03-30 13:34:09 | sumptuary | 1 | 81242 | 1 | 1.483 | 54782.2 |
146 | 2024-03-05 18:19:38 | sumptuary | 4 | 165329 | 67 | 45.940 | 3598.8 |
145 | 2024-03-02 15:18:46 | sumptuary | 5 | 174418 | 732 | 52.846 | 3300.5 |
144 | 2024-03-02 00:11:29 | sumptuary | 5 | 174418 | 732 | 57.033 | 3058.2 |
143 | 2024-03-02 00:11:31 | sumptuary | 4 | 165329 | 67 | 25.033 | 6604.4 |
142 | 2024-03-02 00:11:32 | sumptuary | 3 | 148641 | 9 | 16.670 | 8916.7 |
141 | 2024-03-02 00:11:30 | sumptuary | 2 | 121436 | 1 | 8.450 | 14371.1 |
140 | 2024-03-02 00:11:11 | sumptuary | 1 | 81242 | 1 | 1.563 | 51978.2 |
139 | 2024-03-02 00:11:04 | sumptuary | 1 | 81242 | 1 | 2.466 | 32944.8 |
138 | 2024-02-20 17:44:34 | sumptuary | 1 | 81242 | 1 | 3.123 | 26014.1 |
137 | 2024-02-05 02:17:20 | sumptuary | 1 | 81242 | 1 | 1.560 | 52078.2 |
136 | 2024-01-31 23:49:28 | sumptuary | 1 | 81242 | 1 | 1.546 | 52549.8 |
135 | 2024-01-30 12:43:23 | sumptuary | 1 | 81242 | 1 | 1.423 | 57092.1 |
134 | 2024-01-19 03:20:26 | sumptuary | 1 | 81242 | 1 | 1.266 | 64172.2 |
133 | 2024-01-16 08:39:46 | sumptuary | 1 | 81242 | 1 | 1.390 | 58447.5 |
132 | 2023-12-24 22:01:57 | sumptuary | 1 | 81242 | 1 | 1.453 | 55913.3 |
131 | 2023-11-19 20:50:07 | sumptuary | 1 | 81242 | 1 | 1.563 | 51978.2 |
130 | 2023-10-11 06:38:51 | sumptuary | 1 | 81242 | 1 | 1.373 | 59171.2 |
129 | 2023-09-26 00:56:35 | sumptuary | 1 | 81242 | 1 | 1.313 | 61875.1 |
128 | 2023-09-24 03:00:08 | sumptuary | 1 | 81242 | 1 | 1.610 | 50460.9 |
127 | 2023-08-09 01:54:33 | sumptuary | 1 | 81242 | 1 | 1.280 | 63470.3 |
126 | 2023-05-06 23:15:17 | sumptuary | 1 | 81242 | 1 | 1.233 | 65889.7 |
125 | 2023-03-27 23:38:52 | sumptuary | 1 | 81242 | 1 | 1.250 | 64993.6 |
124 | 2023-02-28 08:39:38 | sumptuary | 1 | 81242 | 1 | 1.283 | 63321.9 |
123 | 2022-12-24 16:14:07 | sumptuary | 1 | 81242 | 1 | 1.250 | 64993.6 |
122 | 2022-09-30 04:26:37 | sumptuary | 1 | 81242 | 1 | 1.233 | 65889.7 |
121 | 2022-09-02 00:39:01 | sumptuary | 1 | 81242 | 1 | 1.406 | 57782.4 |
120 | 2022-02-15 20:52:46 | sumptuary | 1 | 81242 | 1 | 1.250 | 64993.6 |
119 | 2021-09-10 11:22:43 | sumptuary | 1 | 81242 | 1 | 1.220 | 66591.8 |
118 | 2021-05-10 21:36:35 | sumptuary | 1 | 81242 | 1 | 1.436 | 56575.2 |
117 | 2021-02-26 09:45:40 | sumptuary | 3 | 148641 | 9 | 6.170 | 24090.9 |
116 | 2021-02-23 14:34:44 | sumptuary | 4 | 165329 | 67 | 13.016 | 12702.0 |
115 | 2020-12-25 18:58:03 | sumptuary | 1 | 81242 | 1 | 1.343 | 60492.9 |
114 | 2020-12-22 05:42:53 | sumptuary | 1 | 81242 | 1 | 1.360 | 59736.8 |
113 | 2020-10-18 11:30:56 | sumptuary | 1 | 81242 | 1 | 1.436 | 56575.2 |
112 | 2020-08-12 23:52:09 | sumptuary | 1 | 81242 | 1 | 1.516 | 53589.7 |
111 | 2020-04-10 17:22:37 | sumptuary | 1 | 81242 | 1 | 1.296 | 62686.7 |
110 | 2020-03-28 13:33:30 | sumptuary | 1 | 81242 | 1 | 1.546 | 52549.8 |
109 | 2020-03-01 01:01:47 | sumptuary | 1 | 81242 | 1 | 2.063 | 39380.5 |
108 | 2020-02-14 12:16:20 | sumptuary | 1 | 81242 | 1 | 1.423 | 57092.1 |
107 | 2020-01-24 00:48:21 | sumptuary | 1 | 81242 | 1 | 3.220 | 25230.4 |
106 | 2020-01-23 23:25:20 | sumptuary | 1 | 81242 | 1 | 1.580 | 51419.0 |
105 | 2020-01-17 20:03:05 | sumptuary | 1 | 81242 | 1 | 1.530 | 53099.3 |
104 | 2020-01-08 03:27:55 | sumptuary | 1 | 81242 | 1 | 5.030 | 16151.5 |
103 | 2019-12-03 19:26:55 | sumptuary | 1 | 81242 | 1 | 1.250 | 64993.6 |
102 | 2019-07-17 07:32:03 | sumptuary | 1 | 81242 | 1 | 1.186 | 68500.8 |
101 | 2019-06-12 18:05:35 | sumptuary | 1 | 81242 | 1 | 1.263 | 64324.6 |
100 | 2019-06-04 14:25:46 | sumptuary | 1 | 81242 | 1 | 1.273 | 63819.3 |
99 | 2019-05-29 04:49:32 | sumptuary | 1 | 81242 | 1 | 1.430 | 56812.6 |
98 | 2019-01-04 04:23:12 | sumptuary | 1 | 81242 | 1 | 1.286 | 63174.2 |
97 | 2018-11-28 16:55:49 | sumptuary | 1 | 81242 | 1 | 1.173 | 69260.0 |
96 | 2018-11-25 01:41:40 | sumptuary | 1 | 81242 | 1 | 1.363 | 59605.3 |
95 | 2018-06-24 08:53:10 | sumptuary | 1 | 81242 | 1 | 1.380 | 58871.0 |
94 | 2018-06-15 09:26:09 | sumptuary | 1 | 81242 | 1 | 1.386 | 58616.2 |
93 | 2018-03-25 10:08:36 | sumptuary | 1 | 81242 | 1 | 1.650 | 49237.6 |
92 | 2018-01-29 01:39:35 | sumptuary | 1 | 81242 | 1 | 1.720 | 47233.7 |
91 | 2018-01-03 13:56:57 | sumptuary | 1 | 81242 | 1 | 2.440 | 33295.9 |
90 | 2017-11-09 11:44:17 | sumptuary | 1 | 81242 | 1 | 1.840 | 44153.3 |
89 | 2016-12-03 21:20:21 | sumptuary | 1 | 81242 | 1 | 1.790 | 45386.6 |
88 | 2016-12-01 11:41:08 | sumptuary | 1 | 81242 | 1 | 1.660 | 48941.0 |
87 | 2016-12-01 11:37:03 | sumptuary | 1 | 81242 | 1 | 2.566 | 31661.0 |
86 | 2016-11-22 14:57:02 | sumptuary | 1 | 81242 | 1 | 1.966 | 41323.5 |
85 | 2016-09-19 15:35:44 | sumptuary | 1 | 81242 | 1 | 2.020 | 40218.8 |
84 | 2016-08-01 04:14:02 | sumptuary | 1 | 81242 | 1 | 1.580 | 51419.0 |
83 | 2016-07-18 16:16:02 | sumptuary | 1 | 81242 | 1 | 2.436 | 33350.6 |
82 | 2016-06-21 07:51:45 | sumptuary | 1 | 81242 | 1 | 2.376 | 34192.8 |
81 | 2016-06-20 08:45:01 | sumptuary | 1 | 81242 | 1 | 4.786 | 16974.9 |
80 | 2016-06-16 14:00:14 | sumptuary | 1 | 81242 | 1 | 2.290 | 35476.9 |
79 | 2016-06-12 07:58:06 | sumptuary | 1 | 81242 | 1 | 4.723 | 17201.4 |
78 | 2016-06-07 07:25:25 | sumptuary | 1 | 81242 | 1 | 2.276 | 35695.1 |
77 | 2016-06-05 06:45:38 | sumptuary | 1 | 81242 | 1 | 1.410 | 57618.4 |
76 | 2016-06-01 18:40:52 | sumptuary | 1 | 81242 | 1 | 1.443 | 56300.8 |
75 | 2016-05-31 07:50:26 | sumptuary | 1 | 81242 | 1 | 3.996 | 20330.8 |
74 | 2016-05-27 07:59:46 | sumptuary | 1 | 81242 | 1 | 1.440 | 56418.1 |
73 | 2016-05-27 03:50:24 | sumptuary | 1 | 81242 | 1 | 2.466 | 32944.8 |
72 | 2016-05-23 14:33:35 | sumptuary | 1 | 81242 | 1 | 4.126 | 19690.3 |
71 | 2016-05-19 12:11:37 | sumptuary | 1 | 81242 | 1 | 1.783 | 45564.8 |
70 | 2016-05-18 17:05:04 | sumptuary | 1 | 81242 | 1 | 1.480 | 54893.2 |
69 | 2016-05-11 07:38:33 | sumptuary | 1 | 81242 | 1 | 4.073 | 19946.5 |
68 | 2016-05-08 19:03:34 | sumptuary | 3 | 148641 | 9 | 14.753 | 10075.3 |
67 | 2016-05-08 18:57:25 | sumptuary | 1 | 81242 | 1 | 1.513 | 53696.0 |