History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tootsy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1145 | 2024-04-27 16:56:21 | tootsy | 1 | 48755 | 4 | 1.236 | 39445.8 |
1144 | 2024-04-16 18:03:27 | tootsy | 3 | 112716 | 551 | 14.190 | 7943.3 |
1143 | 2024-04-08 07:58:57 | tootsy | 2 | 82551 | 39 | 2.516 | 32810.4 |
1142 | 2024-04-08 07:58:31 | tootsy | 3 | 112716 | 551 | 6.203 | 18171.2 |
1141 | 2024-04-04 03:39:54 | tootsy | 3 | 112716 | 551 | 13.860 | 8132.5 |
1140 | 2024-04-03 09:52:04 | tootsy | 1 | 48755 | 4 | 2.640 | 18467.8 |
1139 | 2024-04-03 09:33:10 | tootsy | 2 | 82551 | 39 | 2.936 | 28116.8 |
1138 | 2024-04-03 09:00:47 | tootsy | 2 | 82551 | 39 | 2.953 | 27955.0 |
1137 | 2024-04-03 09:00:46 | tootsy | 1 | 48755 | 4 | 1.953 | 24964.2 |
1136 | 2024-04-03 09:00:26 | tootsy | 3 | 112716 | 551 | 6.143 | 18348.7 |
1135 | 2024-04-02 18:51:17 | tootsy | 3 | 112716 | 551 | 17.016 | 6624.1 |
1134 | 2024-04-02 10:14:35 | tootsy | 3 | 112716 | 551 | 4.610 | 24450.3 |
1133 | 2024-03-30 13:08:41 | tootsy | 1 | 48755 | 4 | 1.013 | 48129.3 |
1132 | 2024-03-18 20:13:42 | tootsy | 1 | 48755 | 4 | 0.860 | 56691.9 |
1131 | 2024-03-04 03:30:27 | tootsy | 1 | 48755 | 4 | 1.250 | 39004.0 |
1130 | 2024-02-27 23:32:35 | tootsy | 1 | 48755 | 4 | 1.030 | 47335.0 |
1129 | 2024-01-31 22:07:36 | tootsy | 2 | 82551 | 39 | 2.440 | 33832.4 |
1128 | 2024-01-31 22:07:14 | tootsy | 3 | 112716 | 551 | 6.156 | 18309.9 |
1127 | 2024-01-31 01:06:27 | tootsy | 2 | 82551 | 39 | 2.653 | 31116.1 |
1126 | 2024-01-31 01:06:03 | tootsy | 3 | 112716 | 551 | 5.406 | 20850.2 |
1125 | 2024-01-15 19:24:06 | tootsy | 3 | 112716 | 551 | 5.123 | 22002.0 |
1124 | 2024-01-15 19:24:08 | tootsy | 2 | 82551 | 39 | 2.546 | 32423.8 |
1123 | 2024-01-13 05:00:35 | tootsy | 3 | 112716 | 551 | 5.440 | 20719.9 |
1122 | 2024-01-13 05:00:37 | tootsy | 2 | 82551 | 39 | 2.640 | 31269.3 |
1121 | 2023-12-21 20:28:30 | tootsy | 2 | 82551 | 39 | 2.500 | 33020.4 |
1120 | 2023-12-17 10:54:45 | tootsy | 1 | 48755 | 4 | 0.843 | 57835.1 |
1119 | 2023-12-07 20:52:50 | tootsy | 3 | 112716 | 551 | 5.410 | 20834.8 |
1118 | 2023-12-07 20:52:44 | tootsy | 3 | 112716 | 551 | 5.170 | 21801.9 |
1117 | 2023-12-06 10:45:34 | tootsy | 3 | 112716 | 551 | 9.126 | 12351.1 |
1116 | 2023-12-04 00:45:16 | tootsy | 3 | 112716 | 551 | 5.453 | 20670.5 |
1115 | 2023-12-04 00:45:09 | tootsy | 3 | 112716 | 551 | 5.810 | 19400.3 |
1114 | 2023-12-02 18:38:40 | tootsy | 3 | 112716 | 551 | 5.576 | 20214.5 |
1113 | 2023-11-21 03:54:01 | tootsy | 1 | 48755 | 4 | 0.796 | 61250.0 |
1112 | 2023-11-18 02:36:15 | tootsy | 1 | 48755 | 4 | 0.733 | 66514.3 |
1111 | 2023-11-16 07:24:52 | tootsy | 1 | 48755 | 4 | 0.796 | 61250.0 |
1110 | 2023-11-07 09:23:08 | tootsy | 1 | 48755 | 4 | 2.826 | 17252.3 |
1109 | 2023-10-30 03:52:43 | tootsy | 1 | 48755 | 4 | 0.766 | 63648.8 |
1108 | 2023-10-27 17:21:32 | tootsy | 3 | 112716 | 551 | 5.110 | 22057.9 |
1107 | 2023-10-23 10:59:45 | tootsy | 1 | 48755 | 4 | 0.813 | 59969.2 |
1106 | 2023-10-11 14:39:45 | tootsy | 1 | 48755 | 4 | 0.750 | 65006.7 |
1105 | 2023-10-03 08:24:14 | tootsy | 1 | 48755 | 4 | 0.843 | 57835.1 |
1104 | 2023-09-27 03:23:42 | tootsy | 3 | 112716 | 551 | 4.716 | 23900.8 |
1103 | 2023-09-25 22:30:54 | tootsy | 1 | 48755 | 4 | 0.813 | 59969.2 |
1102 | 2023-09-21 03:00:19 | tootsy | 2 | 82551 | 39 | 2.110 | 39123.7 |
1101 | 2023-09-13 13:25:14 | tootsy | 1 | 48755 | 4 | 0.890 | 54780.9 |
1100 | 2023-09-11 03:18:30 | tootsy | 3 | 112716 | 551 | 13.000 | 8670.5 |
1099 | 2023-09-03 21:11:36 | tootsy | 3 | 112716 | 551 | 5.000 | 22543.2 |
1098 | 2023-09-03 04:16:12 | tootsy | 3 | 112716 | 551 | 5.373 | 20978.2 |
1097 | 2023-08-26 10:42:42 | tootsy | 2 | 82551 | 39 | 2.423 | 34069.7 |
1096 | 2023-07-30 09:05:09 | tootsy | 1 | 48755 | 4 | 0.826 | 59025.4 |
1095 | 2023-06-23 14:06:14 | tootsy | 1 | 48755 | 4 | 1.060 | 45995.3 |
1094 | 2023-06-19 06:53:15 | tootsy | 2 | 82551 | 39 | 2.140 | 38575.2 |
1093 | 2023-05-23 22:10:35 | tootsy | 3 | 112716 | 551 | 6.783 | 16617.4 |
1092 | 2023-04-24 14:11:04 | tootsy | 1 | 48755 | 4 | 1.720 | 28345.9 |
1091 | 2023-03-18 22:05:57 | tootsy | 3 | 112716 | 551 | 4.563 | 24702.2 |
1090 | 2023-03-17 10:05:27 | tootsy | 2 | 82551 | 39 | 2.266 | 36430.3 |
1089 | 2023-03-01 09:35:51 | tootsy | 3 | 112716 | 551 | 4.593 | 24540.8 |
1088 | 2023-02-14 17:25:08 | tootsy | 1 | 48755 | 4 | 0.826 | 59025.4 |
1087 | 2023-02-10 05:56:29 | tootsy | 3 | 112716 | 551 | 5.550 | 20309.2 |
1086 | 2023-02-08 17:55:17 | tootsy | 1 | 48755 | 4 | 0.720 | 67715.3 |
1085 | 2022-12-31 03:59:47 | tootsy | 3 | 112716 | 551 | 4.593 | 24540.8 |
1084 | 2022-12-22 18:29:52 | tootsy | 3 | 112716 | 551 | 5.000 | 22543.2 |
1083 | 2022-12-19 23:20:44 | tootsy | 2 | 82551 | 39 | 2.126 | 38829.3 |
1082 | 2022-12-12 19:32:17 | tootsy | 1 | 48755 | 4 | 0.733 | 66514.3 |
1081 | 2022-12-10 11:12:50 | tootsy | 3 | 112716 | 551 | 7.703 | 14632.7 |
1080 | 2022-11-22 17:47:46 | tootsy | 2 | 82551 | 39 | 2.453 | 33653.1 |
1079 | 2022-11-17 17:54:01 | tootsy | 3 | 112716 | 551 | 4.873 | 23130.7 |
1078 | 2022-11-09 08:31:24 | tootsy | 3 | 112716 | 551 | 4.983 | 22620.1 |
1077 | 2022-11-05 19:05:31 | tootsy | 3 | 112716 | 551 | 6.560 | 17182.3 |
1076 | 2022-11-02 11:11:53 | tootsy | 3 | 112716 | 551 | 4.610 | 24450.3 |
1075 | 2022-11-01 06:13:46 | tootsy | 3 | 112716 | 551 | 5.546 | 20323.8 |
1074 | 2022-10-11 02:47:48 | tootsy | 2 | 82551 | 39 | 2.140 | 38575.2 |
1073 | 2022-09-30 10:21:46 | tootsy | 1 | 48755 | 4 | 0.843 | 57835.1 |
1072 | 2022-09-22 00:30:34 | tootsy | 3 | 112716 | 551 | 4.690 | 24033.3 |
1071 | 2022-09-15 08:38:27 | tootsy | 2 | 82551 | 39 | 2.140 | 38575.2 |
1070 | 2022-09-04 20:41:41 | tootsy | 3 | 112716 | 551 | 4.843 | 23274.0 |
1069 | 2022-08-28 17:56:07 | tootsy | 3 | 112716 | 551 | 5.266 | 21404.5 |
1068 | 2022-08-27 14:29:12 | tootsy | 3 | 112716 | 551 | 5.173 | 21789.3 |
1067 | 2022-08-20 04:01:12 | tootsy | 1 | 48755 | 4 | 0.766 | 63648.8 |
1066 | 2022-08-17 22:09:31 | tootsy | 3 | 112716 | 551 | 5.390 | 20912.1 |
1065 | 2022-08-15 23:30:01 | tootsy | 2 | 82551 | 39 | 2.170 | 38041.9 |
1064 | 2022-08-06 10:38:02 | tootsy | 3 | 112716 | 551 | 4.656 | 24208.8 |
1063 | 2022-07-30 19:33:44 | tootsy | 3 | 112716 | 551 | 4.906 | 22975.1 |
1062 | 2022-07-28 19:55:53 | tootsy | 3 | 112716 | 551 | 4.750 | 23729.7 |
1061 | 2022-07-24 02:43:49 | tootsy | 3 | 112716 | 551 | 4.826 | 23356.0 |
1060 | 2022-05-20 16:40:00 | tootsy | 3 | 112716 | 551 | 5.300 | 21267.2 |
1059 | 2022-05-06 18:56:54 | tootsy | 1 | 48755 | 4 | 0.856 | 56956.8 |
1058 | 2022-04-12 00:55:33 | tootsy | 1 | 48755 | 4 | 0.906 | 53813.5 |
1057 | 2022-03-01 21:31:56 | tootsy | 3 | 112716 | 551 | 5.843 | 19290.8 |
1056 | 2022-01-10 01:19:51 | tootsy | 1 | 48755 | 4 | 0.796 | 61250.0 |
1055 | 2022-01-07 20:51:20 | tootsy | 1 | 48755 | 4 | 0.826 | 59025.4 |
1054 | 2021-12-27 15:28:32 | tootsy | 3 | 112716 | 551 | 7.436 | 15158.1 |
1053 | 2021-12-26 16:47:23 | tootsy | 3 | 112716 | 551 | 9.720 | 11596.3 |
1052 | 2021-12-24 07:36:13 | tootsy | 1 | 48755 | 4 | 0.876 | 55656.4 |
1051 | 2021-11-23 17:34:57 | tootsy | 3 | 112716 | 551 | 4.686 | 24053.8 |
1050 | 2021-11-18 17:20:46 | tootsy | 1 | 48755 | 4 | 0.890 | 54780.9 |
1049 | 2021-11-10 07:41:45 | tootsy | 2 | 82551 | 39 | 2.530 | 32628.9 |
1048 | 2021-11-10 05:58:55 | tootsy | 1 | 48755 | 4 | 0.856 | 56956.8 |
1047 | 2021-11-08 14:40:18 | tootsy | 2 | 82551 | 39 | 2.220 | 37185.1 |
1046 | 2021-11-08 05:05:27 | tootsy | 3 | 112716 | 551 | 5.406 | 20850.2 |