History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smokehouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
163 | 2024-04-19 07:49:20 | smokehouse | 1 | 67641 | 2 | 1.250 | 54112.8 |
162 | 2024-04-10 15:42:17 | smokehouse | 3 | 140603 | 11 | 15.373 | 9146.1 |
161 | 2024-04-08 12:43:15 | smokehouse | 2 | 108824 | 3 | 7.750 | 14041.8 |
160 | 2024-04-08 12:32:01 | smokehouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
159 | 2024-04-07 00:47:38 | smokehouse | 4 | 161450 | 60 | 36.550 | 4417.2 |
158 | 2024-04-06 23:16:23 | smokehouse | 4 | 161450 | 60 | 39.706 | 4066.1 |
157 | 2024-04-04 21:42:49 | smokehouse | 4 | 161450 | 60 | 26.706 | 6045.5 |
156 | 2024-04-04 21:42:51 | smokehouse | 3 | 140603 | 11 | 8.610 | 16330.2 |
155 | 2024-04-04 21:42:46 | smokehouse | 2 | 108824 | 3 | 7.376 | 14753.8 |
154 | 2024-04-04 21:40:47 | smokehouse | 1 | 67641 | 2 | 1.250 | 54112.8 |
153 | 2024-04-01 18:15:33 | smokehouse | 5 | 173545 | 287 | 48.036 | 3612.8 |
152 | 2024-04-01 03:57:13 | smokehouse | 5 | 173545 | 287 | 55.410 | 3132.0 |
151 | 2024-03-31 22:50:10 | smokehouse | 5 | 173545 | 287 | 36.750 | 4722.3 |
150 | 2024-03-11 13:02:41 | smokehouse | 3 | 140603 | 11 | 13.953 | 10076.9 |
149 | 2024-03-11 11:57:00 | smokehouse | 3 | 140603 | 11 | 15.500 | 9071.2 |
148 | 2024-03-06 06:47:01 | smokehouse | 4 | 161450 | 60 | 18.550 | 8703.5 |
147 | 2024-03-04 21:36:48 | smokehouse | 4 | 161450 | 60 | 38.283 | 4217.3 |
146 | 2024-03-04 21:36:47 | smokehouse | 3 | 140603 | 11 | 16.610 | 8465.0 |
145 | 2024-03-04 21:36:47 | smokehouse | 2 | 108824 | 3 | 10.813 | 10064.2 |
144 | 2024-03-04 21:21:12 | smokehouse | 4 | 161450 | 60 | 29.673 | 5441.0 |
143 | 2024-03-04 21:21:09 | smokehouse | 4 | 161450 | 60 | 26.956 | 5989.4 |
142 | 2024-03-04 21:21:09 | smokehouse | 3 | 140603 | 11 | 23.016 | 6108.9 |
141 | 2024-03-04 21:21:07 | smokehouse | 2 | 108824 | 3 | 10.546 | 10319.0 |
140 | 2024-03-04 21:16:53 | smokehouse | 1 | 67641 | 2 | 1.296 | 52192.1 |
139 | 2024-03-04 21:16:44 | smokehouse | 1 | 67641 | 2 | 2.546 | 26567.6 |
138 | 2024-02-16 01:17:33 | smokehouse | 1 | 67641 | 2 | 2.530 | 26735.6 |
137 | 2024-02-14 04:36:49 | smokehouse | 4 | 161450 | 60 | 41.380 | 3901.6 |
136 | 2024-02-11 07:33:16 | smokehouse | 3 | 140603 | 11 | 16.190 | 8684.6 |
135 | 2024-02-11 07:16:25 | smokehouse | 5 | 173545 | 287 | 38.906 | 4460.6 |
134 | 2024-02-11 07:13:30 | smokehouse | 4 | 161450 | 60 | 20.813 | 7757.2 |
133 | 2024-02-10 06:58:24 | smokehouse | 5 | 173545 | 287 | 34.830 | 4982.6 |
132 | 2024-02-10 06:58:23 | smokehouse | 4 | 161450 | 60 | 31.970 | 5050.0 |
131 | 2024-02-10 06:58:22 | smokehouse | 3 | 140603 | 11 | 18.750 | 7498.8 |
130 | 2024-02-10 06:58:23 | smokehouse | 2 | 108824 | 3 | 10.673 | 10196.2 |
129 | 2024-02-10 06:37:20 | smokehouse | 1 | 67641 | 2 | 1.143 | 59178.5 |
128 | 2024-02-01 10:14:04 | smokehouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
127 | 2024-02-01 10:14:00 | smokehouse | 1 | 67641 | 2 | 1.080 | 62630.6 |
126 | 2024-01-07 08:25:15 | smokehouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
125 | 2023-12-07 22:05:47 | smokehouse | 1 | 67641 | 2 | 1.170 | 57812.8 |
124 | 2023-12-05 14:13:03 | smokehouse | 5 | 173545 | 287 | 15.753 | 11016.6 |
123 | 2023-10-27 01:20:50 | smokehouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
122 | 2023-09-27 19:23:24 | smokehouse | 5 | 173545 | 287 | 19.343 | 8972.0 |
121 | 2023-09-27 19:23:13 | smokehouse | 4 | 161450 | 60 | 12.376 | 13045.4 |
120 | 2023-09-27 19:23:12 | smokehouse | 3 | 140603 | 11 | 7.156 | 19648.3 |
119 | 2023-09-27 19:23:14 | smokehouse | 2 | 108824 | 3 | 3.373 | 32263.3 |
118 | 2023-09-19 18:42:43 | smokehouse | 1 | 67641 | 2 | 1.156 | 58513.0 |
117 | 2023-09-01 19:30:42 | smokehouse | 5 | 173545 | 287 | 15.360 | 11298.5 |
116 | 2023-08-22 01:38:56 | smokehouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
115 | 2023-05-22 09:17:18 | smokehouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
114 | 2023-05-18 16:09:25 | smokehouse | 5 | 173545 | 287 | 14.406 | 12046.7 |
113 | 2023-03-02 12:29:32 | smokehouse | 1 | 67641 | 2 | 0.983 | 68810.8 |
112 | 2023-02-25 16:29:19 | smokehouse | 5 | 173545 | 287 | 16.050 | 10812.8 |
111 | 2023-02-12 13:11:52 | smokehouse | 5 | 173545 | 287 | 15.890 | 10921.6 |
110 | 2023-01-12 21:15:38 | smokehouse | 5 | 173545 | 287 | 14.623 | 11867.9 |
109 | 2022-12-26 21:13:49 | smokehouse | 1 | 67641 | 2 | 1.096 | 61716.2 |
108 | 2022-12-06 13:17:57 | smokehouse | 5 | 173545 | 287 | 15.750 | 11018.7 |
107 | 2022-08-18 10:50:31 | smokehouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
106 | 2022-07-12 09:21:01 | smokehouse | 3 | 140603 | 11 | 5.283 | 26614.2 |
105 | 2022-04-10 01:55:55 | smokehouse | 5 | 173545 | 287 | 14.486 | 11980.2 |
104 | 2022-04-09 03:14:59 | smokehouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
103 | 2022-01-23 13:15:18 | smokehouse | 1 | 67641 | 2 | 1.030 | 65670.9 |
102 | 2021-07-11 07:21:36 | smokehouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
101 | 2020-10-16 13:13:08 | smokehouse | 1 | 67641 | 2 | 1.046 | 64666.3 |
100 | 2020-03-27 18:56:24 | smokehouse | 1 | 67641 | 2 | 1.250 | 54112.8 |
99 | 2020-02-29 09:56:52 | smokehouse | 1 | 67641 | 2 | 1.203 | 56226.9 |
98 | 2020-02-29 08:24:34 | smokehouse | 1 | 67641 | 2 | 1.300 | 52031.5 |
97 | 2020-02-24 09:20:36 | smokehouse | 1 | 67641 | 2 | 1.110 | 60937.8 |
96 | 2020-02-23 09:01:04 | smokehouse | 4 | 161450 | 60 | 22.300 | 7239.9 |
95 | 2020-02-22 07:54:01 | smokehouse | 5 | 173545 | 287 | 32.266 | 5378.6 |
94 | 2020-02-17 11:12:15 | smokehouse | 5 | 173545 | 287 | 34.770 | 4991.2 |
93 | 2020-02-16 19:02:26 | smokehouse | 1 | 67641 | 2 | 1.330 | 50857.9 |
92 | 2020-02-14 10:37:46 | smokehouse | 2 | 108824 | 3 | 4.580 | 23760.7 |
91 | 2020-02-14 10:36:12 | smokehouse | 3 | 140603 | 11 | 14.470 | 9716.9 |
90 | 2020-02-13 22:12:30 | smokehouse | 1 | 67641 | 2 | 2.610 | 25916.1 |
89 | 2020-02-13 22:03:50 | smokehouse | 4 | 161450 | 60 | 12.750 | 12662.7 |
88 | 2020-02-12 19:10:54 | smokehouse | 4 | 161450 | 60 | 22.453 | 7190.6 |
87 | 2020-02-09 11:53:32 | smokehouse | 5 | 173545 | 287 | 20.890 | 8307.6 |
86 | 2020-02-01 09:11:02 | smokehouse | 5 | 173545 | 287 | 44.626 | 3888.9 |
85 | 2020-02-01 01:18:17 | smokehouse | 4 | 161450 | 60 | 12.033 | 13417.3 |
84 | 2020-01-29 21:05:36 | smokehouse | 4 | 161450 | 60 | 27.453 | 5881.0 |
83 | 2020-01-25 15:51:21 | smokehouse | 5 | 173545 | 287 | 35.113 | 4942.5 |
82 | 2020-01-25 14:10:50 | smokehouse | 2 | 108824 | 3 | 5.236 | 20783.8 |
81 | 2020-01-25 13:09:16 | smokehouse | 5 | 173545 | 287 | 21.283 | 8154.2 |
80 | 2020-01-25 11:40:40 | smokehouse | 5 | 173545 | 287 | 50.033 | 3468.6 |
79 | 2020-01-25 05:34:28 | smokehouse | 4 | 161450 | 60 | 11.673 | 13831.1 |
78 | 2020-01-25 05:31:28 | smokehouse | 5 | 173545 | 287 | 18.360 | 9452.3 |
77 | 2020-01-25 05:28:37 | smokehouse | 3 | 140603 | 11 | 6.516 | 21578.1 |
76 | 2020-01-24 22:34:16 | smokehouse | 1 | 67641 | 2 | 1.283 | 52721.0 |
75 | 2020-01-18 13:13:55 | smokehouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
74 | 2020-01-08 21:57:27 | smokehouse | 1 | 67641 | 2 | 2.750 | 24596.7 |
73 | 2019-11-15 17:53:18 | smokehouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
72 | 2018-06-22 16:28:35 | smokehouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
71 | 2018-01-04 01:26:48 | smokehouse | 1 | 67641 | 2 | 1.873 | 36113.7 |
70 | 2017-11-10 18:23:32 | smokehouse | 1 | 67641 | 2 | 1.456 | 46456.7 |
69 | 2016-11-26 03:25:39 | smokehouse | 1 | 67641 | 2 | 1.516 | 44618.1 |
68 | 2016-09-07 14:14:30 | smokehouse | 1 | 67641 | 2 | 1.420 | 47634.5 |
67 | 2016-08-24 19:38:39 | smokehouse | 1 | 67641 | 2 | 1.573 | 43001.3 |
66 | 2016-07-27 23:37:55 | smokehouse | 1 | 67641 | 2 | 1.823 | 37104.2 |
65 | 2016-07-07 15:00:29 | smokehouse | 3 | 140603 | 11 | 12.736 | 11039.8 |
64 | 2016-07-07 08:56:37 | smokehouse | 2 | 108824 | 3 | 7.936 | 13712.7 |