History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pianofortes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
157 | 2024-04-30 13:20:24 | pianofortes | 2 | 86808 | 2 | 4.110 | 21121.2 |
156 | 2024-04-26 19:58:03 | pianofortes | 4 | 148819 | 11 | 13.066 | 11389.8 |
155 | 2024-04-17 08:38:47 | pianofortes | 1 | 49908 | 2 | 0.923 | 54071.5 |
154 | 2024-04-13 11:08:17 | pianofortes | 1 | 49908 | 2 | 0.920 | 54247.8 |
153 | 2024-04-13 10:59:37 | pianofortes | 1 | 49908 | 2 | 0.830 | 60130.1 |
152 | 2024-04-10 14:07:02 | pianofortes | 4 | 148819 | 11 | 39.986 | 3721.8 |
151 | 2024-04-10 14:07:06 | pianofortes | 3 | 121633 | 3 | 19.706 | 6172.4 |
150 | 2024-04-10 14:07:09 | pianofortes | 2 | 86808 | 2 | 4.450 | 19507.4 |
149 | 2024-04-10 13:04:26 | pianofortes | 1 | 49908 | 2 | 0.856 | 58303.7 |
148 | 2024-04-08 16:29:26 | pianofortes | 1 | 49908 | 2 | 2.300 | 21699.1 |
147 | 2024-03-22 13:00:34 | pianofortes | 4 | 148819 | 11 | 31.266 | 4759.8 |
146 | 2024-03-22 13:00:32 | pianofortes | 3 | 121633 | 3 | 6.453 | 18849.1 |
145 | 2024-03-22 13:00:29 | pianofortes | 2 | 86808 | 2 | 4.826 | 17987.6 |
144 | 2024-03-22 11:49:51 | pianofortes | 1 | 49908 | 2 | 0.846 | 58992.9 |
143 | 2024-03-16 13:28:29 | pianofortes | 5 | 164607 | 165 | 40.690 | 4045.4 |
142 | 2024-03-15 13:16:45 | pianofortes | 4 | 148819 | 11 | 24.346 | 6112.7 |
141 | 2024-03-15 13:16:34 | pianofortes | 3 | 121633 | 3 | 13.220 | 9200.7 |
140 | 2024-03-15 13:16:33 | pianofortes | 2 | 86808 | 2 | 8.686 | 9994.0 |
139 | 2024-03-15 12:03:48 | pianofortes | 1 | 49908 | 2 | 0.860 | 58032.6 |
138 | 2024-03-11 19:18:19 | pianofortes | 4 | 148819 | 11 | 12.953 | 11489.2 |
137 | 2024-03-11 16:12:41 | pianofortes | 5 | 164607 | 165 | 69.333 | 2374.2 |
136 | 2024-03-11 16:12:46 | pianofortes | 4 | 148819 | 11 | 34.113 | 4362.5 |
135 | 2024-03-11 16:12:57 | pianofortes | 3 | 121633 | 3 | 13.000 | 9356.4 |
134 | 2024-03-11 16:12:52 | pianofortes | 2 | 86808 | 2 | 10.533 | 8241.5 |
133 | 2024-03-11 16:12:00 | pianofortes | 3 | 121633 | 3 | 11.643 | 10446.9 |
132 | 2024-03-11 16:11:22 | pianofortes | 4 | 148819 | 11 | 24.063 | 6184.6 |
131 | 2024-03-11 16:11:34 | pianofortes | 2 | 86808 | 2 | 7.643 | 11357.8 |
130 | 2024-03-11 16:11:07 | pianofortes | 5 | 164607 | 165 | 28.940 | 5687.9 |
129 | 2024-03-11 16:10:54 | pianofortes | 1 | 49908 | 2 | 2.860 | 17450.3 |
128 | 2024-03-11 16:10:48 | pianofortes | 1 | 49908 | 2 | 2.846 | 17536.2 |
127 | 2024-02-12 01:43:19 | pianofortes | 1 | 49908 | 2 | 2.030 | 24585.2 |
126 | 2024-02-06 09:32:58 | pianofortes | 1 | 49908 | 2 | 0.763 | 65410.2 |
125 | 2024-02-06 09:32:50 | pianofortes | 1 | 49908 | 2 | 0.843 | 59202.8 |
124 | 2024-01-26 22:26:15 | pianofortes | 1 | 49908 | 2 | 0.860 | 58032.6 |
123 | 2024-01-02 05:04:35 | pianofortes | 1 | 49908 | 2 | 0.780 | 63984.6 |
122 | 2023-12-27 22:17:17 | pianofortes | 1 | 49908 | 2 | 0.873 | 57168.4 |
121 | 2023-12-15 08:13:17 | pianofortes | 4 | 148819 | 11 | 9.030 | 16480.5 |
120 | 2023-11-06 10:06:18 | pianofortes | 1 | 49908 | 2 | 0.860 | 58032.6 |
119 | 2023-10-16 16:47:24 | pianofortes | 1 | 49908 | 2 | 0.766 | 65154.0 |
118 | 2023-09-15 02:24:46 | pianofortes | 4 | 148819 | 11 | 8.063 | 18457.0 |
117 | 2023-08-11 10:30:44 | pianofortes | 1 | 49908 | 2 | 0.813 | 61387.5 |
116 | 2023-06-17 14:03:37 | pianofortes | 4 | 148819 | 11 | 8.203 | 18142.0 |
115 | 2023-05-12 09:23:55 | pianofortes | 1 | 49908 | 2 | 0.766 | 65154.0 |
114 | 2023-03-15 16:15:27 | pianofortes | 4 | 148819 | 11 | 8.110 | 18350.1 |
113 | 2023-03-08 11:22:42 | pianofortes | 1 | 49908 | 2 | 0.856 | 58303.7 |
112 | 2022-12-31 11:58:56 | pianofortes | 1 | 49908 | 2 | 0.750 | 66544.0 |
111 | 2022-12-18 22:43:22 | pianofortes | 4 | 148819 | 11 | 8.906 | 16710.0 |
110 | 2022-09-21 13:02:56 | pianofortes | 1 | 49908 | 2 | 0.736 | 67809.8 |
109 | 2022-08-13 10:16:44 | pianofortes | 4 | 148819 | 11 | 8.173 | 18208.6 |
108 | 2022-07-18 14:06:01 | pianofortes | 1 | 49908 | 2 | 0.750 | 66544.0 |
107 | 2022-07-16 06:59:47 | pianofortes | 1 | 49908 | 2 | 0.750 | 66544.0 |
106 | 2021-02-15 12:25:28 | pianofortes | 1 | 49908 | 2 | 0.750 | 66544.0 |
105 | 2021-01-16 22:28:05 | pianofortes | 5 | 164607 | 165 | 13.516 | 12178.7 |
104 | 2020-11-07 16:47:01 | pianofortes | 1 | 49908 | 2 | 0.780 | 63984.6 |
103 | 2020-11-01 10:16:16 | pianofortes | 4 | 148819 | 11 | 9.580 | 15534.3 |
102 | 2020-10-28 06:45:33 | pianofortes | 5 | 164607 | 165 | 16.393 | 10041.3 |
101 | 2020-08-31 01:24:07 | pianofortes | 4 | 148819 | 11 | 8.453 | 17605.5 |
100 | 2020-08-28 02:55:00 | pianofortes | 4 | 148819 | 11 | 8.783 | 16944.0 |
99 | 2020-07-24 23:35:11 | pianofortes | 1 | 49908 | 2 | 0.843 | 59202.8 |
98 | 2020-05-06 04:36:52 | pianofortes | 4 | 148819 | 11 | 8.436 | 17640.9 |
97 | 2020-04-29 23:36:53 | pianofortes | 1 | 49908 | 2 | 0.733 | 68087.3 |
96 | 2020-04-03 16:05:17 | pianofortes | 1 | 49908 | 2 | 0.796 | 62698.5 |
95 | 2020-03-27 18:19:15 | pianofortes | 1 | 49908 | 2 | 0.890 | 56076.4 |
94 | 2020-02-29 04:54:38 | pianofortes | 5 | 164607 | 165 | 33.376 | 4931.9 |
93 | 2020-02-28 07:38:48 | pianofortes | 5 | 164607 | 165 | 19.593 | 8401.3 |
92 | 2020-02-23 08:24:05 | pianofortes | 1 | 49908 | 2 | 0.860 | 58032.6 |
91 | 2020-02-22 13:27:48 | pianofortes | 1 | 49908 | 2 | 1.923 | 25953.2 |
90 | 2020-02-21 08:00:58 | pianofortes | 1 | 49908 | 2 | 0.890 | 56076.4 |
89 | 2020-02-18 16:22:45 | pianofortes | 1 | 49908 | 2 | 0.940 | 53093.6 |
88 | 2020-02-11 15:23:39 | pianofortes | 5 | 164607 | 165 | 20.376 | 8078.5 |
87 | 2020-02-10 22:12:41 | pianofortes | 1 | 49908 | 2 | 0.843 | 59202.8 |
86 | 2020-02-09 21:10:09 | pianofortes | 5 | 164607 | 165 | 16.860 | 9763.2 |
85 | 2020-02-07 13:30:43 | pianofortes | 5 | 164607 | 165 | 27.640 | 5955.4 |
84 | 2020-02-04 15:50:32 | pianofortes | 5 | 164607 | 165 | 24.113 | 6826.5 |
83 | 2020-02-04 15:37:06 | pianofortes | 3 | 121633 | 3 | 5.470 | 22236.4 |
82 | 2020-02-04 15:35:35 | pianofortes | 4 | 148819 | 11 | 13.580 | 10958.7 |
81 | 2020-02-04 15:12:12 | pianofortes | 2 | 86808 | 2 | 5.360 | 16195.5 |
80 | 2020-01-20 16:07:58 | pianofortes | 1 | 49908 | 2 | 0.936 | 53320.5 |
79 | 2020-01-19 09:13:27 | pianofortes | 1 | 49908 | 2 | 2.690 | 18553.2 |
78 | 2020-01-12 04:10:43 | pianofortes | 5 | 164607 | 165 | 19.453 | 8461.8 |
77 | 2020-01-11 23:49:24 | pianofortes | 5 | 164607 | 165 | 23.063 | 7137.3 |
76 | 2020-01-11 19:33:21 | pianofortes | 5 | 164607 | 165 | 16.033 | 10266.8 |
75 | 2020-01-11 19:33:28 | pianofortes | 3 | 121633 | 3 | 5.500 | 22115.1 |
74 | 2020-01-11 19:33:20 | pianofortes | 2 | 86808 | 2 | 2.530 | 34311.5 |
73 | 2020-01-11 17:44:07 | pianofortes | 4 | 148819 | 11 | 15.156 | 9819.1 |
72 | 2020-01-11 15:36:59 | pianofortes | 1 | 49908 | 2 | 1.780 | 28038.2 |
71 | 2020-01-11 14:18:37 | pianofortes | 1 | 49908 | 2 | 0.906 | 55086.1 |
70 | 2020-01-09 19:25:33 | pianofortes | 1 | 49908 | 2 | 0.856 | 58303.7 |
69 | 2019-12-26 04:19:48 | pianofortes | 4 | 148819 | 11 | 11.720 | 12697.9 |
68 | 2019-12-03 08:00:12 | pianofortes | 1 | 49908 | 2 | 0.876 | 56972.6 |
67 | 2019-12-01 23:42:48 | pianofortes | 1 | 49908 | 2 | 0.736 | 67809.8 |
66 | 2019-10-11 09:23:06 | pianofortes | 4 | 148819 | 11 | 8.233 | 18075.9 |
65 | 2019-10-10 07:24:07 | pianofortes | 1 | 49908 | 2 | 0.873 | 57168.4 |
64 | 2019-09-30 21:20:08 | pianofortes | 1 | 49908 | 2 | 0.686 | 72752.2 |
63 | 2019-09-21 14:30:30 | pianofortes | 1 | 49908 | 2 | 0.696 | 71706.9 |
62 | 2019-09-13 01:48:38 | pianofortes | 4 | 148819 | 11 | 9.653 | 15416.9 |
61 | 2019-09-04 14:39:21 | pianofortes | 1 | 49908 | 2 | 0.810 | 61614.8 |
60 | 2019-08-27 01:47:49 | pianofortes | 1 | 49908 | 2 | 0.713 | 69997.2 |
59 | 2019-01-09 23:32:51 | pianofortes | 1 | 49908 | 2 | 0.793 | 62935.7 |
58 | 2019-01-08 01:06:48 | pianofortes | 1 | 49908 | 2 | 0.760 | 65668.4 |