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 “bubaline” 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.

97 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
bubaline124716(None) 
bubale104014622bubal__e
bubalis11359902bubali_s
bubalises1346322bubalises
bubbling12248222bubbling
buntline10198062buntline
bustline10208842bustline
subalpine1343552subalpine
subline9316892sub_line
abalone938903_abalone
aline57243153___aline
alkaline12168283alkaline
babbling12228693babbling
baculine1238983baculine
baling94829693__baling
balkline1437973balkline
banalize191010933banalize
basaltine1144713basaltine
baseline10310753baseline
beeline93314723b_eeline
beltline1036943beltline
bengaline1245633bengaline
berline93716853b_erline
beryline1337083beryline
betaine9413783beta_ine
biblike1536893bib_like
blueline1036873blueline
bobbling12238643bobbling
bobolink1644493bobolink
bombazine2462683bombazine
bowline123613113b_owline
breadline1246273breadline
brutalise1175693brutalise
brutalize2075883brutalize
bubal94218213bubal___
bubales113513343bubal_es
bubals103513843bubal__s
bubble94016593bubbl__e
bubblier1184473bubblier
bubblies1166773bubblies
buckling17259113buckling
budlike14257873bu_dlike
bugbane1255863bugba__ne
bugling113615343bu_gling
bulling104324793bu_lling
bumbling15249763bumbling
bundling12219703bundling
bungling12269543bungling
buntlines11207153buntlines
burbling13249423burbling
burgling12239303burgling
burling104421133bu_rling
bushlike1734963bushlike
bustlines11207353bustlines
bustling112110063bustling
butadiene1242153butadiene
butane8313653buta__ne
butanone1044963butanone
butling103516813bu_tling
butylene1344403butylene
byline11311643__byline
cobaltine13135613cobaltine
curarine10610713curarine
cutline92914543cu_tline
dualize1759763du_alize
eucaine939243euca_ine
guanine8810543gu_anine
gumline102810113gu_mline
guyline11258173gu_yline
hyaline132310723_hyaline
lobeline1039963lobeline
maline84529093__maline
opaline9412483_opaline
outline72321333ou_tline
petaline10314883petaline
praline93019743_praline
purline93516533pu_rline
rubbling13238073rubbling
rubylike1753353rubylike
ruralise839643ruralise
ruralite848963ruralite
ruralize1739233ruralize
saline65132703__saline
sepaline10311343sepaline
sublime11310363sub_lime
sublines10315783sub_lines
submarine1347843submarine
tubelike1436093tubelike
tublike1337083tub_like
tubulin9116433tubulin_
tubulins10106293tubulins
tumpline1237113tumpline
unalike11311533_unalike
unbaling11310683unbaling
uralite71714103_uralite
valine94623093__valine
zibeline1946363zibeline

Search took 8 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.423422437.4
2DLD Change Limit146162976.72021750.3
3Display Results97970.0432255.8
 (SQL Overall)178691977.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.