History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sixpenny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
151 | 2024-05-30 05:33:43 | sixpenny | 1 | 82945 | 1 | 5.796 | 14310.7 |
150 | 2024-05-14 13:31:23 | sixpenny | 1 | 82945 | 1 | 1.563 | 53067.8 |
149 | 2024-05-14 13:31:16 | sixpenny | 2 | 121059 | 2 | 4.483 | 27004.0 |
148 | 2024-05-13 18:24:50 | sixpenny | 3 | 146162 | 13 | 17.563 | 8322.2 |
147 | 2024-05-13 18:23:29 | sixpenny | 4 | 161609 | 178 | 44.736 | 3612.5 |
146 | 2024-05-12 23:31:50 | sixpenny | 1 | 82945 | 1 | 1.563 | 53067.8 |
145 | 2024-05-12 23:31:50 | sixpenny | 1 | 82945 | 1 | 1.516 | 54713.1 |
144 | 2024-05-12 23:31:41 | sixpenny | 3 | 146162 | 13 | 7.890 | 18525.0 |
143 | 2024-05-12 23:31:40 | sixpenny | 2 | 121059 | 2 | 3.970 | 30493.5 |
142 | 2024-05-12 23:31:41 | sixpenny | 1 | 82945 | 1 | 1.593 | 52068.4 |
141 | 2024-05-12 23:31:25 | sixpenny | 4 | 161609 | 178 | 15.190 | 10639.2 |
140 | 2024-05-06 19:18:11 | sixpenny | 4 | 161609 | 178 | 19.986 | 8086.1 |
139 | 2024-05-05 06:05:16 | sixpenny | 4 | 161609 | 178 | 13.813 | 11699.8 |
138 | 2024-05-04 17:39:16 | sixpenny | 4 | 161609 | 178 | 23.280 | 6942.0 |
137 | 2024-05-04 05:36:03 | sixpenny | 4 | 161609 | 178 | 15.830 | 10209.0 |
136 | 2024-04-29 18:33:14 | sixpenny | 3 | 146162 | 13 | 13.253 | 11028.6 |
135 | 2024-04-29 18:33:10 | sixpenny | 2 | 121059 | 2 | 4.156 | 29128.7 |
134 | 2024-04-25 13:24:23 | sixpenny | 1 | 82945 | 1 | 5.046 | 16437.8 |
133 | 2024-04-25 13:14:25 | sixpenny | 3 | 146162 | 13 | 8.466 | 17264.6 |
132 | 2024-04-25 13:14:23 | sixpenny | 2 | 121059 | 2 | 4.373 | 27683.3 |
131 | 2024-04-12 17:15:52 | sixpenny | 3 | 146162 | 13 | 9.860 | 14823.7 |
130 | 2024-04-11 01:36:44 | sixpenny | 3 | 146162 | 13 | 8.766 | 16673.7 |
129 | 2024-04-10 08:16:18 | sixpenny | 4 | 161609 | 178 | 28.393 | 5691.9 |
128 | 2024-04-10 08:14:40 | sixpenny | 3 | 146162 | 13 | 12.000 | 12180.2 |
127 | 2024-04-10 08:14:42 | sixpenny | 2 | 121059 | 2 | 4.440 | 27265.5 |
126 | 2024-04-10 08:14:38 | sixpenny | 1 | 82945 | 1 | 1.500 | 55296.7 |
125 | 2024-04-03 16:37:08 | sixpenny | 4 | 161609 | 178 | 15.643 | 10331.1 |
124 | 2024-04-01 06:13:55 | sixpenny | 4 | 161609 | 178 | 39.533 | 4088.0 |
123 | 2024-03-31 16:43:04 | sixpenny | 1 | 82945 | 1 | 3.596 | 23065.9 |
122 | 2024-03-31 09:07:58 | sixpenny | 4 | 161609 | 178 | 22.250 | 7263.3 |
121 | 2024-03-31 04:55:31 | sixpenny | 4 | 161609 | 178 | 21.186 | 7628.1 |
120 | 2024-03-31 04:55:34 | sixpenny | 2 | 121059 | 2 | 8.626 | 14034.2 |
119 | 2024-03-31 04:55:27 | sixpenny | 3 | 146162 | 13 | 14.673 | 9961.3 |
118 | 2024-03-31 04:36:43 | sixpenny | 1 | 82945 | 1 | 4.376 | 18954.5 |
117 | 2024-03-31 03:57:24 | sixpenny | 1 | 82945 | 1 | 1.343 | 61761.0 |
116 | 2024-03-10 22:06:26 | sixpenny | 2 | 121059 | 2 | 3.530 | 34294.3 |
115 | 2024-03-10 22:06:16 | sixpenny | 1 | 82945 | 1 | 2.906 | 28542.7 |
114 | 2024-03-09 19:44:08 | sixpenny | 4 | 161609 | 178 | 28.236 | 5723.5 |
113 | 2024-03-09 19:43:43 | sixpenny | 3 | 146162 | 13 | 17.640 | 8285.8 |
112 | 2024-03-08 23:17:15 | sixpenny | 2 | 121059 | 2 | 4.000 | 30264.8 |
111 | 2024-03-08 23:17:00 | sixpenny | 3 | 146162 | 13 | 7.206 | 20283.4 |
110 | 2024-03-08 04:41:59 | sixpenny | 3 | 146162 | 13 | 28.046 | 5211.5 |
109 | 2024-03-07 22:32:37 | sixpenny | 3 | 146162 | 13 | 8.236 | 17746.7 |
108 | 2024-03-07 22:32:32 | sixpenny | 2 | 121059 | 2 | 4.936 | 24525.7 |
107 | 2024-03-07 03:11:28 | sixpenny | 1 | 82945 | 1 | 1.703 | 48705.2 |
106 | 2024-03-02 02:57:33 | sixpenny | 4 | 161609 | 178 | 36.160 | 4469.3 |
105 | 2024-02-29 18:16:30 | sixpenny | 1 | 82945 | 1 | 1.466 | 56579.1 |
104 | 2024-02-28 20:36:27 | sixpenny | 4 | 161609 | 178 | 10.890 | 14840.1 |
103 | 2024-02-28 01:09:33 | sixpenny | 1 | 82945 | 1 | 1.593 | 52068.4 |
102 | 2024-02-27 00:45:06 | sixpenny | 4 | 161609 | 178 | 13.203 | 12240.3 |
101 | 2024-02-27 00:44:57 | sixpenny | 1 | 82945 | 1 | 2.013 | 41204.7 |
100 | 2024-02-08 09:18:34 | sixpenny | 3 | 146162 | 13 | 11.266 | 12973.7 |
99 | 2024-02-08 09:18:33 | sixpenny | 2 | 121059 | 2 | 6.640 | 18231.8 |
98 | 2024-02-08 08:58:01 | sixpenny | 1 | 82945 | 1 | 1.596 | 51970.6 |
97 | 2024-02-05 03:46:55 | sixpenny | 4 | 161609 | 178 | 16.453 | 9822.5 |
96 | 2024-01-29 17:07:52 | sixpenny | 2 | 121059 | 2 | 6.906 | 17529.5 |
95 | 2024-01-29 17:07:40 | sixpenny | 3 | 146162 | 13 | 7.656 | 19091.2 |
94 | 2024-01-29 17:06:57 | sixpenny | 3 | 146162 | 13 | 7.140 | 20470.9 |
93 | 2024-01-29 12:17:56 | sixpenny | 4 | 161609 | 178 | 15.563 | 10384.2 |
92 | 2024-01-26 17:56:15 | sixpenny | 4 | 161609 | 178 | 10.830 | 14922.3 |
91 | 2024-01-26 17:56:11 | sixpenny | 3 | 146162 | 13 | 6.470 | 22590.7 |
90 | 2024-01-26 17:56:07 | sixpenny | 2 | 121059 | 2 | 3.390 | 35710.6 |
89 | 2023-12-15 13:19:52 | sixpenny | 1 | 82945 | 1 | 1.360 | 60989.0 |
88 | 2023-12-10 11:31:25 | sixpenny | 1 | 82945 | 1 | 1.280 | 64800.8 |
87 | 2023-11-25 12:17:34 | sixpenny | 1 | 82945 | 1 | 1.533 | 54106.3 |
86 | 2023-10-08 12:54:34 | sixpenny | 1 | 82945 | 1 | 1.296 | 64000.8 |
85 | 2023-09-24 11:37:14 | sixpenny | 1 | 82945 | 1 | 1.420 | 58412.0 |
84 | 2023-07-17 00:29:27 | sixpenny | 1 | 82945 | 1 | 1.376 | 60279.8 |
83 | 2023-04-18 10:12:53 | sixpenny | 1 | 82945 | 1 | 1.403 | 59119.7 |
82 | 2023-04-13 09:32:01 | sixpenny | 1 | 82945 | 1 | 1.280 | 64800.8 |
81 | 2023-04-09 19:29:16 | sixpenny | 1 | 82945 | 1 | 1.280 | 64800.8 |
80 | 2023-02-10 14:18:09 | sixpenny | 1 | 82945 | 1 | 1.263 | 65673.0 |
79 | 2022-12-06 22:25:49 | sixpenny | 1 | 82945 | 1 | 1.283 | 64649.3 |
78 | 2022-10-27 03:24:34 | sixpenny | 1 | 82945 | 1 | 1.313 | 63172.1 |
77 | 2022-08-05 18:05:32 | sixpenny | 1 | 82945 | 1 | 1.313 | 63172.1 |
76 | 2022-03-20 00:49:14 | sixpenny | 1 | 82945 | 1 | 1.513 | 54821.5 |
75 | 2022-03-16 14:27:28 | sixpenny | 1 | 82945 | 1 | 1.530 | 54212.4 |
74 | 2021-09-21 13:37:43 | sixpenny | 1 | 82945 | 1 | 1.483 | 55930.5 |
73 | 2021-05-22 10:39:41 | sixpenny | 1 | 82945 | 1 | 1.483 | 55930.5 |
72 | 2021-01-16 12:03:35 | sixpenny | 1 | 82945 | 1 | 2.606 | 31828.5 |
71 | 2020-12-26 10:10:02 | sixpenny | 2 | 121059 | 2 | 3.140 | 38553.8 |
70 | 2020-10-04 04:42:18 | sixpenny | 1 | 82945 | 1 | 1.263 | 65673.0 |
69 | 2020-09-16 01:22:18 | sixpenny | 1 | 82945 | 1 | 1.296 | 64000.8 |
68 | 2020-04-18 02:51:23 | sixpenny | 1 | 82945 | 1 | 1.390 | 59672.7 |
67 | 2020-03-03 17:13:54 | sixpenny | 1 | 82945 | 1 | 1.280 | 64800.8 |
66 | 2020-02-14 06:51:36 | sixpenny | 1 | 82945 | 1 | 1.580 | 52496.8 |
65 | 2020-02-11 20:54:10 | sixpenny | 1 | 82945 | 1 | 1.563 | 53067.8 |
64 | 2020-02-10 23:17:16 | sixpenny | 1 | 82945 | 1 | 1.593 | 52068.4 |
63 | 2020-02-03 20:01:16 | sixpenny | 1 | 82945 | 1 | 6.406 | 12948.0 |
62 | 2020-01-24 06:59:52 | sixpenny | 3 | 146162 | 13 | 23.940 | 6105.3 |
61 | 2020-01-24 02:27:11 | sixpenny | 1 | 82945 | 1 | 1.813 | 45750.1 |
60 | 2020-01-15 11:57:26 | sixpenny | 3 | 146162 | 13 | 8.800 | 16609.3 |
59 | 2020-01-15 06:25:27 | sixpenny | 1 | 82945 | 1 | 1.653 | 50178.5 |
58 | 2020-01-03 04:46:26 | sixpenny | 1 | 82945 | 1 | 1.610 | 51518.6 |
57 | 2019-12-07 23:40:31 | sixpenny | 1 | 82945 | 1 | 1.283 | 64649.3 |
56 | 2019-08-27 06:01:31 | sixpenny | 1 | 82945 | 1 | 1.256 | 66039.0 |
55 | 2018-08-16 06:28:55 | sixpenny | 1 | 82945 | 1 | 1.290 | 64298.4 |
54 | 2018-05-16 20:16:20 | sixpenny | 1 | 82945 | 1 | 1.376 | 60279.8 |
53 | 2018-05-16 03:41:17 | sixpenny | 1 | 82945 | 1 | 1.306 | 63510.7 |
52 | 2018-05-13 22:35:35 | sixpenny | 1 | 82945 | 1 | 1.566 | 52966.2 |