History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canola"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1154 | 2024-05-10 09:18:20 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
1153 | 2024-04-26 05:16:30 | canola | 1 | 48755 | 3 | 1.110 | 43923.4 |
1152 | 2024-04-24 02:30:18 | canola | 1 | 48755 | 3 | 1.983 | 24586.5 |
1151 | 2024-04-24 02:29:25 | canola | 1 | 48755 | 3 | 2.533 | 19247.9 |
1150 | 2024-04-05 17:18:55 | canola | 3 | 112716 | 514 | 18.813 | 5991.4 |
1149 | 2024-04-05 15:36:11 | canola | 3 | 112716 | 514 | 13.080 | 8617.4 |
1148 | 2024-04-05 13:55:55 | canola | 2 | 82551 | 45 | 12.453 | 6629.0 |
1147 | 2024-04-04 03:44:12 | canola | 2 | 82551 | 45 | 2.686 | 30733.8 |
1146 | 2024-04-04 03:44:11 | canola | 1 | 48755 | 3 | 0.920 | 52994.6 |
1145 | 2024-04-04 03:43:46 | canola | 3 | 112716 | 514 | 6.983 | 16141.5 |
1144 | 2024-04-04 01:29:03 | canola | 3 | 112716 | 514 | 18.613 | 6055.8 |
1143 | 2024-02-07 06:09:25 | canola | 1 | 48755 | 3 | 0.923 | 52822.3 |
1142 | 2024-02-03 17:49:44 | canola | 1 | 48755 | 3 | 0.873 | 55847.7 |
1141 | 2024-02-03 10:55:55 | canola | 1 | 48755 | 3 | 0.750 | 65006.7 |
1140 | 2024-01-06 21:36:45 | canola | 3 | 112716 | 514 | 6.376 | 17678.2 |
1139 | 2024-01-06 21:36:44 | canola | 2 | 82551 | 45 | 2.716 | 30394.3 |
1138 | 2024-01-03 12:36:52 | canola | 3 | 112716 | 514 | 5.796 | 19447.2 |
1137 | 2024-01-03 12:36:53 | canola | 2 | 82551 | 45 | 2.920 | 28270.9 |
1136 | 2023-12-03 18:27:38 | canola | 3 | 112716 | 514 | 5.733 | 19660.9 |
1135 | 2023-12-03 18:27:31 | canola | 3 | 112716 | 514 | 5.890 | 19136.8 |
1134 | 2023-12-03 07:21:31 | canola | 3 | 112716 | 514 | 7.250 | 15547.0 |
1133 | 2023-12-02 21:06:37 | canola | 1 | 48755 | 3 | 0.763 | 63899.1 |
1132 | 2023-11-27 10:07:58 | canola | 1 | 48755 | 3 | 0.783 | 62266.9 |
1131 | 2023-11-14 17:19:31 | canola | 1 | 48755 | 3 | 0.800 | 60943.8 |
1130 | 2023-11-11 02:00:38 | canola | 1 | 48755 | 3 | 0.843 | 57835.1 |
1129 | 2023-10-31 14:55:44 | canola | 1 | 48755 | 3 | 0.826 | 59025.4 |
1128 | 2023-10-25 03:52:24 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
1127 | 2023-10-19 06:43:50 | canola | 1 | 48755 | 3 | 0.813 | 59969.2 |
1126 | 2023-10-11 13:55:17 | canola | 1 | 48755 | 3 | 0.923 | 52822.3 |
1125 | 2023-10-05 19:15:41 | canola | 1 | 48755 | 3 | 0.890 | 54780.9 |
1124 | 2023-09-24 11:25:13 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
1123 | 2023-09-12 17:00:12 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
1122 | 2023-09-12 05:37:24 | canola | 1 | 48755 | 3 | 0.783 | 62266.9 |
1121 | 2023-09-01 14:46:42 | canola | 3 | 112716 | 514 | 4.796 | 23502.1 |
1120 | 2023-08-16 22:57:33 | canola | 3 | 112716 | 514 | 4.986 | 22606.5 |
1119 | 2023-07-28 16:11:28 | canola | 3 | 112716 | 514 | 6.250 | 18034.6 |
1118 | 2023-07-26 18:06:01 | canola | 3 | 112716 | 514 | 6.000 | 18786.0 |
1117 | 2023-07-24 23:58:27 | canola | 3 | 112716 | 514 | 5.406 | 20850.2 |
1116 | 2023-07-21 10:19:15 | canola | 3 | 112716 | 514 | 5.826 | 19347.1 |
1115 | 2023-07-20 23:12:38 | canola | 3 | 112716 | 514 | 5.596 | 20142.2 |
1114 | 2023-07-19 22:59:24 | canola | 3 | 112716 | 514 | 5.533 | 20371.6 |
1113 | 2023-07-18 19:20:41 | canola | 3 | 112716 | 514 | 6.173 | 18259.5 |
1112 | 2023-07-15 15:10:21 | canola | 3 | 112716 | 514 | 5.000 | 22543.2 |
1111 | 2023-07-12 15:27:03 | canola | 3 | 112716 | 514 | 5.596 | 20142.2 |
1110 | 2023-07-11 21:03:01 | canola | 3 | 112716 | 514 | 5.736 | 19650.6 |
1109 | 2023-07-09 21:33:26 | canola | 1 | 48755 | 3 | 0.876 | 55656.4 |
1108 | 2023-06-26 09:54:54 | canola | 1 | 48755 | 3 | 0.810 | 60191.4 |
1107 | 2023-06-16 21:31:07 | canola | 3 | 112716 | 514 | 5.516 | 20434.4 |
1106 | 2023-05-18 21:28:04 | canola | 3 | 112716 | 514 | 4.920 | 22909.8 |
1105 | 2023-04-11 04:34:48 | canola | 3 | 112716 | 514 | 4.813 | 23419.1 |
1104 | 2023-04-07 18:55:02 | canola | 1 | 48755 | 3 | 0.826 | 59025.4 |
1103 | 2023-04-02 09:12:28 | canola | 1 | 48755 | 3 | 0.893 | 54596.9 |
1102 | 2023-02-24 01:14:21 | canola | 3 | 112716 | 514 | 4.763 | 23664.9 |
1101 | 2023-02-06 12:29:38 | canola | 1 | 48755 | 3 | 0.846 | 57630.0 |
1100 | 2022-12-28 04:23:44 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
1099 | 2022-12-21 03:51:44 | canola | 1 | 48755 | 3 | 0.763 | 63899.1 |
1098 | 2022-12-12 15:18:57 | canola | 3 | 112716 | 514 | 9.546 | 11807.7 |
1097 | 2022-12-06 16:02:24 | canola | 3 | 112716 | 514 | 4.796 | 23502.1 |
1096 | 2022-11-21 21:51:12 | canola | 1 | 48755 | 3 | 0.876 | 55656.4 |
1095 | 2022-11-14 07:19:20 | canola | 1 | 48755 | 3 | 0.766 | 63648.8 |
1094 | 2022-09-13 19:06:56 | canola | 1 | 48755 | 3 | 0.796 | 61250.0 |
1093 | 2022-05-29 04:20:12 | canola | 1 | 48755 | 3 | 0.906 | 53813.5 |
1092 | 2022-05-28 16:37:45 | canola | 1 | 48755 | 3 | 0.860 | 56691.9 |
1091 | 2022-04-17 21:35:40 | canola | 3 | 112716 | 514 | 5.593 | 20153.0 |
1090 | 2022-04-05 02:41:50 | canola | 3 | 112716 | 514 | 5.313 | 21215.1 |
1089 | 2022-04-02 08:37:59 | canola | 3 | 112716 | 514 | 4.830 | 23336.6 |
1088 | 2022-03-11 13:21:11 | canola | 3 | 112716 | 514 | 5.173 | 21789.3 |
1087 | 2022-02-14 23:14:00 | canola | 3 | 112716 | 514 | 5.250 | 21469.7 |
1086 | 2022-02-13 20:35:17 | canola | 1 | 48755 | 3 | 0.780 | 62506.4 |
1085 | 2022-02-12 23:38:33 | canola | 2 | 82551 | 45 | 2.686 | 30733.8 |
1084 | 2022-02-12 11:25:33 | canola | 2 | 82551 | 45 | 2.563 | 32208.7 |
1083 | 2022-02-11 19:27:22 | canola | 2 | 82551 | 45 | 2.576 | 32046.2 |
1082 | 2022-02-08 05:08:40 | canola | 1 | 48755 | 3 | 0.783 | 62266.9 |
1081 | 2022-02-06 21:32:25 | canola | 2 | 82551 | 45 | 2.330 | 35429.6 |
1080 | 2022-02-06 10:05:26 | canola | 3 | 112716 | 514 | 4.970 | 22679.3 |
1079 | 2022-02-06 09:14:28 | canola | 2 | 82551 | 45 | 2.203 | 37472.1 |
1078 | 2022-02-05 11:36:42 | canola | 2 | 82551 | 45 | 2.220 | 37185.1 |
1077 | 2022-02-04 12:56:44 | canola | 2 | 82551 | 45 | 2.500 | 33020.4 |
1076 | 2022-02-03 21:33:08 | canola | 2 | 82551 | 45 | 2.530 | 32628.9 |
1075 | 2022-02-03 10:16:44 | canola | 2 | 82551 | 45 | 2.420 | 34112.0 |
1074 | 2022-02-03 01:38:03 | canola | 2 | 82551 | 45 | 2.236 | 36919.1 |
1073 | 2022-02-02 09:23:30 | canola | 2 | 82551 | 45 | 2.466 | 33475.7 |
1072 | 2022-02-01 13:56:46 | canola | 2 | 82551 | 45 | 2.200 | 37523.2 |
1071 | 2022-02-01 02:31:23 | canola | 2 | 82551 | 45 | 2.563 | 32208.7 |
1070 | 2022-01-31 09:27:56 | canola | 2 | 82551 | 45 | 2.250 | 36689.3 |
1069 | 2022-01-31 01:33:51 | canola | 2 | 82551 | 45 | 2.266 | 36430.3 |
1068 | 2022-01-30 13:10:02 | canola | 2 | 82551 | 45 | 2.670 | 30918.0 |
1067 | 2022-01-29 14:50:33 | canola | 2 | 82551 | 45 | 2.813 | 29346.2 |
1066 | 2022-01-28 09:59:33 | canola | 2 | 82551 | 45 | 2.453 | 33653.1 |
1065 | 2022-01-27 23:23:21 | canola | 2 | 82551 | 45 | 2.266 | 36430.3 |
1064 | 2022-01-27 03:47:51 | canola | 2 | 82551 | 45 | 2.250 | 36689.3 |
1063 | 2022-01-26 20:32:08 | canola | 2 | 82551 | 45 | 2.656 | 31080.9 |
1062 | 2022-01-26 08:30:44 | canola | 2 | 82551 | 45 | 2.423 | 34069.7 |
1061 | 2022-01-25 15:42:00 | canola | 2 | 82551 | 45 | 2.236 | 36919.1 |
1060 | 2022-01-25 03:37:21 | canola | 2 | 82551 | 45 | 2.830 | 29170.0 |
1059 | 2022-01-24 11:04:52 | canola | 2 | 82551 | 45 | 2.343 | 35233.0 |
1058 | 2022-01-23 18:55:59 | canola | 2 | 82551 | 45 | 2.280 | 36206.6 |
1057 | 2022-01-23 08:58:38 | canola | 2 | 82551 | 45 | 2.656 | 31080.9 |
1056 | 2022-01-22 18:44:25 | canola | 2 | 82551 | 45 | 2.440 | 33832.4 |
1055 | 2022-01-21 17:04:20 | canola | 2 | 82551 | 45 | 3.250 | 25400.3 |