Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “baculums” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

49 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
baculums144372(None) 
baculum1345701baculum_
pabulums1443002pabulums
vacuums1443402vacu_ums
vasculums1642142vasculums
aciculums1542783aciculums
aculeus937513_aculeus
alums75720603_a__lums
amylums1473613_amylums
asylums1243633_asylums
aurums849383_a_urums
babuls105413643babul__s
bacalaos1245863bacalaos
bacillus1245153bacillus
backless162910633backless
backlogs1746633backlogs
backouts1698643backouts
backups1736173bac_kups
bacula103112673bacul__a
baculine1238983baculine
balms95723923ba__l_ms
bariums1139143ba_riums
bascules1236683bascul_es
baulks12429373ba_ul_ks
becalms1335743becal_ms
blackgums2042543blackgums
blellums1242833blellums
calculus1255333calculu_s
coagulums1441973coagulums
culms95314193__cul_ms
famulus1235043famulu_s
hamulus1235323hamulu_s
haulms11558503ha_ul_ms
inoculums1342683inoculums
loculus9296973loculu_s
maculas113114023macul_as
macules114015133macul_es
oculus8178393_oculu_s
osculum1143833osculum_
pablums1345123pa_blums
pabulum1344473pabulum_
sacculus1244813sacculu_s
sacrums11388043sac_rums
speculums1562903speculums
tenaculums1451683tenaculums
vacuous1237023vacuou_s
vacuum1334833vacu_um_
vasculum1542983vasculum_
vinculums1642073vinculums

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.420425454.8
2DLD Change Limit146162496.50322476.1
3Display Results49490.0133769.2
 (SQL Overall)178691496.93625762.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.