History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"obligor"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1055 | 2025-10-24 19:18:17 | obligor | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 1054 | 2025-10-21 22:42:19 | obligor | 1 | 69583 | 3 | 5.373 | 12950.5 |
| 1053 | 2025-10-21 22:42:16 | obligor | 1 | 69583 | 3 | 5.563 | 12508.2 |
| 1052 | 2025-10-21 22:42:13 | obligor | 1 | 69583 | 3 | 3.080 | 22591.9 |
| 1051 | 2025-10-21 22:42:09 | obligor | 1 | 69583 | 3 | 2.940 | 23667.7 |
| 1050 | 2025-10-21 19:46:25 | obligor | 4 | 151207 | 560 | 48.423 | 3122.6 |
| 1049 | 2025-10-21 19:46:06 | obligor | 4 | 151207 | 560 | 31.470 | 4804.8 |
| 1048 | 2025-10-21 19:45:45 | obligor | 4 | 151207 | 560 | 50.610 | 2987.7 |
| 1047 | 2025-10-21 19:45:36 | obligor | 4 | 151207 | 560 | 42.503 | 3557.6 |
| 1046 | 2025-10-21 09:24:50 | obligor | 4 | 151207 | 560 | 73.566 | 2055.4 |
| 1045 | 2025-10-20 11:09:14 | obligor | 1 | 69583 | 3 | 2.923 | 23805.3 |
| 1044 | 2025-09-06 20:47:17 | obligor | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 1043 | 2025-09-05 05:38:34 | obligor | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 1042 | 2025-09-03 13:58:30 | obligor | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 1041 | 2025-08-28 10:14:29 | obligor | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 1040 | 2025-08-26 20:42:43 | obligor | 1 | 69583 | 3 | 2.733 | 25460.3 |
| 1039 | 2025-08-17 14:38:44 | obligor | 1 | 69583 | 3 | 5.736 | 12130.9 |
| 1038 | 2025-08-15 22:49:08 | obligor | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 1037 | 2025-08-10 03:55:22 | obligor | 1 | 69583 | 3 | 5.843 | 11908.8 |
| 1036 | 2025-07-27 18:08:22 | obligor | 1 | 69583 | 3 | 3.533 | 19695.2 |
| 1035 | 2025-07-27 09:28:34 | obligor | 1 | 69583 | 3 | 3.343 | 20814.5 |
| 1034 | 2025-07-26 18:19:08 | obligor | 1 | 69583 | 3 | 4.626 | 15041.7 |
| 1033 | 2025-07-24 23:59:30 | obligor | 1 | 69583 | 3 | 3.220 | 21609.6 |
| 1032 | 2025-07-08 08:06:04 | obligor | 1 | 69583 | 3 | 5.453 | 12760.5 |
| 1031 | 2025-07-04 01:09:39 | obligor | 2 | 107671 | 9 | 8.326 | 12931.9 |
| 1030 | 2025-07-02 03:41:31 | obligor | 1 | 69583 | 3 | 6.126 | 11358.6 |
| 1029 | 2025-06-25 11:00:04 | obligor | 1 | 69583 | 3 | 2.780 | 25029.9 |
| 1028 | 2025-06-16 08:28:13 | obligor | 1 | 69583 | 3 | 4.623 | 15051.5 |
| 1027 | 2025-06-13 06:56:38 | obligor | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 1026 | 2025-05-29 22:04:54 | obligor | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 1025 | 2025-05-21 20:49:16 | obligor | 4 | 151207 | 560 | 31.880 | 4743.0 |
| 1024 | 2025-05-20 02:48:30 | obligor | 1 | 69583 | 3 | 6.063 | 11476.7 |
| 1023 | 2025-05-11 15:11:28 | obligor | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 1022 | 2025-05-05 18:42:10 | obligor | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 1021 | 2025-05-03 11:35:10 | obligor | 4 | 151207 | 560 | 11.640 | 12990.3 |
| 1020 | 2025-05-02 18:28:47 | obligor | 1 | 69583 | 3 | 1.936 | 35941.6 |
| 1019 | 2025-05-01 22:08:16 | obligor | 3 | 134027 | 38 | 19.406 | 6906.5 |
| 1018 | 2025-04-21 03:30:13 | obligor | 3 | 134027 | 38 | 39.080 | 3429.6 |
| 1017 | 2025-04-20 10:30:43 | obligor | 4 | 151207 | 560 | 12.296 | 12297.3 |
| 1016 | 2025-04-16 15:02:25 | obligor | 3 | 134027 | 38 | 24.313 | 5512.6 |
| 1015 | 2025-04-16 11:45:20 | obligor | 4 | 151207 | 560 | 38.813 | 3895.8 |
| 1014 | 2025-04-16 06:50:06 | obligor | 2 | 107671 | 9 | 15.046 | 7156.1 |
| 1013 | 2025-04-15 07:59:55 | obligor | 1 | 69583 | 3 | 7.013 | 9922.0 |
| 1012 | 2025-03-20 03:37:58 | obligor | 1 | 69583 | 3 | 6.423 | 10833.4 |
| 1011 | 2025-03-19 22:05:09 | obligor | 1 | 69583 | 3 | 4.563 | 15249.4 |
| 1010 | 2025-03-19 07:29:01 | obligor | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 1009 | 2025-03-16 09:02:37 | obligor | 1 | 69583 | 3 | 4.190 | 16606.9 |
| 1008 | 2025-03-16 07:05:06 | obligor | 4 | 151207 | 560 | 70.490 | 2145.1 |
| 1007 | 2025-03-16 06:56:31 | obligor | 4 | 151207 | 560 | 48.550 | 3114.5 |
| 1006 | 2025-03-15 23:22:06 | obligor | 4 | 151207 | 560 | 41.766 | 3620.3 |
| 1005 | 2025-03-15 21:05:56 | obligor | 4 | 151207 | 560 | 59.256 | 2551.8 |
| 1004 | 2025-03-15 17:11:33 | obligor | 4 | 151207 | 560 | 32.266 | 4686.3 |
| 1003 | 2025-02-27 10:56:04 | obligor | 3 | 134027 | 38 | 28.036 | 4780.5 |
| 1002 | 2025-02-22 11:09:49 | obligor | 3 | 134027 | 38 | 35.093 | 3819.2 |
| 1001 | 2025-02-17 04:55:50 | obligor | 3 | 134027 | 38 | 31.020 | 4320.7 |
| 1000 | 2025-02-17 04:55:46 | obligor | 2 | 107671 | 9 | 16.110 | 6683.5 |
| 999 | 2025-02-14 16:01:59 | obligor | 1 | 69583 | 3 | 5.623 | 12374.7 |
| 998 | 2025-02-12 13:57:29 | obligor | 4 | 151207 | 560 | 48.130 | 3141.6 |
| 997 | 2025-02-12 08:26:37 | obligor | 1 | 69583 | 3 | 4.683 | 14858.6 |
| 996 | 2025-02-12 08:21:22 | obligor | 4 | 151207 | 560 | 33.763 | 4478.5 |
| 995 | 2025-02-12 08:20:58 | obligor | 2 | 107671 | 9 | 19.093 | 5639.3 |
| 994 | 2025-02-12 08:18:41 | obligor | 3 | 134027 | 38 | 6.816 | 19663.6 |
| 993 | 2025-02-12 07:13:53 | obligor | 3 | 134027 | 38 | 43.296 | 3095.6 |
| 992 | 2025-02-12 06:52:00 | obligor | 4 | 151207 | 560 | 63.590 | 2377.8 |
| 991 | 2025-02-12 06:51:40 | obligor | 3 | 134027 | 38 | 36.643 | 3657.6 |
| 990 | 2025-02-12 06:51:38 | obligor | 2 | 107671 | 9 | 10.190 | 10566.3 |
| 989 | 2025-02-12 06:50:24 | obligor | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 988 | 2025-02-11 03:14:15 | obligor | 1 | 69583 | 3 | 7.156 | 9723.7 |
| 987 | 2025-01-11 18:27:37 | obligor | 4 | 151207 | 560 | 58.443 | 2587.3 |
| 986 | 2025-01-09 22:59:54 | obligor | 1 | 69583 | 3 | 5.660 | 12293.8 |
| 985 | 2025-01-09 16:31:57 | obligor | 4 | 151207 | 560 | 41.723 | 3624.1 |
| 984 | 2025-01-09 16:31:33 | obligor | 3 | 134027 | 38 | 7.983 | 16789.1 |
| 983 | 2025-01-05 18:23:20 | obligor | 3 | 134027 | 38 | 31.000 | 4323.5 |
| 982 | 2025-01-05 13:36:34 | obligor | 2 | 107671 | 9 | 12.703 | 8476.0 |
| 981 | 2025-01-05 04:53:04 | obligor | 3 | 134027 | 38 | 33.893 | 3954.4 |
| 980 | 2025-01-05 04:53:07 | obligor | 2 | 107671 | 9 | 18.360 | 5864.4 |
| 979 | 2025-01-05 04:47:51 | obligor | 3 | 134027 | 38 | 32.796 | 4086.7 |
| 978 | 2025-01-05 04:26:43 | obligor | 3 | 134027 | 38 | 34.206 | 3918.2 |
| 977 | 2025-01-04 19:01:00 | obligor | 3 | 134027 | 38 | 33.470 | 4004.4 |
| 976 | 2024-12-30 18:55:16 | obligor | 1 | 69583 | 3 | 6.873 | 10124.1 |
| 975 | 2024-12-13 21:37:22 | obligor | 3 | 134027 | 38 | 48.786 | 2747.2 |
| 974 | 2024-12-13 21:37:31 | obligor | 2 | 107671 | 9 | 14.640 | 7354.6 |
| 973 | 2024-12-12 11:55:22 | obligor | 4 | 151207 | 560 | 50.753 | 2979.3 |
| 972 | 2024-12-11 10:33:37 | obligor | 2 | 107671 | 9 | 10.190 | 10566.3 |
| 971 | 2024-12-09 09:22:52 | obligor | 3 | 134027 | 38 | 27.563 | 4862.6 |
| 970 | 2024-12-05 22:43:49 | obligor | 3 | 134027 | 38 | 31.063 | 4314.7 |
| 969 | 2024-12-05 22:28:54 | obligor | 3 | 134027 | 38 | 39.190 | 3419.9 |
| 968 | 2024-12-05 22:28:55 | obligor | 2 | 107671 | 9 | 23.733 | 4536.8 |
| 967 | 2024-12-05 22:16:38 | obligor | 3 | 134027 | 38 | 6.626 | 20227.4 |
| 966 | 2024-12-05 11:24:23 | obligor | 4 | 151207 | 560 | 59.003 | 2562.7 |
| 965 | 2024-12-05 11:24:44 | obligor | 3 | 134027 | 38 | 33.893 | 3954.4 |
| 964 | 2024-12-05 11:24:52 | obligor | 2 | 107671 | 9 | 18.656 | 5771.4 |
| 963 | 2024-12-05 11:24:13 | obligor | 1 | 69583 | 3 | 2.140 | 32515.4 |
| 962 | 2024-11-30 05:40:31 | obligor | 1 | 69583 | 3 | 7.890 | 8819.1 |
| 961 | 2024-11-29 04:40:09 | obligor | 1 | 69583 | 3 | 3.983 | 17470.0 |
| 960 | 2024-10-29 00:40:32 | obligor | 1 | 69583 | 3 | 3.330 | 20895.8 |
| 959 | 2024-10-21 05:34:24 | obligor | 1 | 69583 | 3 | 5.733 | 12137.3 |
| 958 | 2024-10-20 09:46:11 | obligor | 3 | 134027 | 38 | 17.470 | 7671.8 |
| 957 | 2024-10-10 18:58:02 | obligor | 3 | 134027 | 38 | 30.626 | 4376.2 |
| 956 | 2024-10-08 12:44:15 | obligor | 3 | 134027 | 38 | 49.456 | 2710.0 |