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

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

124 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
bendy11501725(None) 
bandy114824181bandy
beady114719921beady
bend76435261bend_
benday123810811benday
bends85628971bends
bendys12518381bendys
benny105217361benny
baddy125016022baddy
baldy115518932baldy
band76740912band_
banda85223102banda
bands85233422bands
banty106624002banty
bawdy147513282bawdy
bead75937922bead_
beads85429502beads
beaky146118022beaky
beamy126218572beamy
bed67950622be_d_
beds75937782be_ds
bedu75923692be_du
beedi8711662beedi
beefy135313832beefy
beery105220122beery
beigy111110582beigy
belady12489932belady
belay105021522belay
belly104625492belly
ben56554922ben__
bench125619502bench
bendays13327512bendays
bended105521232bended
bendee94121022bendee
bender95223302bender
bene66439492ben_e
benes75536232benes
benne76521122benne
benni74715362benni
bens65945702ben_s
bent67759912ben_t
bento75922952bento
bents76033692bents
benzyl2034162benzyl
berry104521772berry
bevy127115222be_vy
bey86645422be__y
biddy124612692biddy
bind76234512bind_
bindi85617012bindi
binds86627472binds
blend85317452blend_
blende95413442blende
blends96012882blends
blenny1156202blenny
body107425672b_ody
bond75334362bond_
bonds86126842bonds
boney105227312boney
bonny105816622bonny
bony96732082bon_y
boody115420402boody
brandy124712062brandy
bready124511182bready
buddy124812632buddy
bund75530662bund_
bunds85523542bunds
bundt85824852bundt
bunny104715802bunny
candy115119822candy
dandy104416702dandy
deedy104315892deedy
deny86027122den_y
eddy93912092_eddy
end46834352_end_
ends56528522_ends
envy10411252_envy
fend84832972fend_
fends96324972fends
fenny115115132fenny
handy125520872handy
heady125117262heady
henry114014472henry
jenny153811622jenny
kendo105113222kendo
leady95618602leady
lend56233672lend_
lends65326252lends
lindy96918312lindy
mend75334032mend_
mends84927692mends
neddy10479872neddy
needy94614692needy
nerdy95014702nerdy
pandy115021172pandy
pend75934532pend_
pends85527192pends
penny105119452penny
perdy115417322perdy
randy95022082randy
ready94821502ready
reedy910020282reedy
rend56136572rend_
rends65129952rends
rindy95717392rindy
sandy94221132sandy
seedy94821532seedy
send55237292send_
sends65528242sends
spendy124911142spendy
teddy10489492teddy
tend56433772tend_
tends65425582tends
tendu67216002tendu
tenty86121602tenty
trendy10469602trendy
undy85015162_undy
vend86626422vend_
vends95520892vends
weedy125115002weedy
wend85330452wend_
wends95822812wends
wenny114412462wenny
windy126118102windy

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001241.39038705.0
3Display Results1241240.0333757.6
 (SQL Overall)1786911241.516117870.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.