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 “buddha” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
buddha133317(None) 
buddhas1463261buddhas
budded113912332budded
budder104314812budder
buddle104313082buddle
buddy124812632budd_y
bugsha1233822bugsha
buqsha2032792buqsha
badder103817513badder
baddie104114033baddie
baddy125016023badd_y
banda85223103band_a
bedded115114073bedded
bedder104215793bedder
bertha11429173bertha
bidden104010793bidden
bidder104114863bidder
biddy124612693bidd_y
bodega1034933bodega
bubba84311803bu_bba
buckra1436753buckra
bud67041273bu_d__
budders113812103budders
buddied12388003buddied
buddies113914353buddies
budding123712403budding
buddleia1242233buddleia
buddles113913073buddles
budge94619883bu_dge
budged114517243budged
budger104617713budger
budges104820133budges
budget104618123budget
budgie104310343budgie
buds75235173bu_d_s
bugshas1334513bugshas
buhl95518223bu__hl
buhr95315383bu__hr
bulla74620563bu_lla
bumph144911983bumph_
bumphs15467103bumphs
buna64730723bu__na
bunch125118603bunch_
bunchy16437463bunchy
bund75530663bund__
bundle94315573bundle
bunds85523543bund_s
bundt85824853bund_t
bundts95010843bundts
bunya103810093bu_nya
buqshas2143573buqshas
bura66139533bu__ra
burd75534263burd__
burden9412473burden
burdie93615023burdie
burds84626063burd_s
burgh115216033burgh_
burghal1335073burghal
burghs12519923burghs
burka114617693bu_rka
burqa165013093bu_rqa
bursa74921523bu_rsa
bush96630713bu_sh_
bushwa14105143bushwa
bushy135416683bu_shy
butch125416543butch_
chuddah17263253chuddah
cuddie104011173cuddie
cuddle104414533cuddle
cuddly13388413cuddly
cuddy125111973cudd_y
duddie9348863duddie
duddy114911033dudd_y
fuddle113312103fuddle
fuddy135211153fudd_y
huddle113712993huddle
judder15439423judder
judoka18102583judoka
keddah1534273keddah
mudded114511383mudded
mudder104413493mudder
muddle103414633muddle
muddly13418603muddly
muddy123812233mudd_y
mudra83912433mu_dra
murrha11366453murrha
nucha10229793nu_cha
nudzh1835133nudzh_
puddle103914153puddle
puddly13438133puddly
purda82914693purd_a
purdah12288753purdah
quotha18365113quotha
rudd65917473rudd__
rudder83812803rudder
ruddle83414203ruddle
rudds74811703rudd_s
ruddy104511753rudd_y
saddhu1133413saddhu
sraddha1242083sraddha
sradha1085333sradha
sudd64719773sudd__
sudden83310833sudden
sudds75513593sudd_s
sulpha1135403sulpha
tundra736423tundra
udder76314283_udder

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 Filter1786911127160.580308087.9
2DLD Change Limit1127161077.17315713.9
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.78322959.1
 
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.