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

268 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
fond8633095(None) 
bond75334361bond
fend84832971fend
find87532601find
fold86528941fold
fon66352271fon_
fonds95824821fonds
fondu96013971fondu
fons76943891fons
font77143751font
food86830571food
ford86835491ford
found94917841found
frond95316341frond
fund85624981fund
pond75530491pond
yond86122311yond
and47244172_and
band76740912band
bend76435262bend
bind76234512bind
blond85618372blond
bod67055542bo_d
bold75432812bold
bonds86126842bonds
bone65949322bone
boned85133242boned
bong75633412bong
bonk105531712bonk
bony96732082bony
bound84819582bound
bund75530662bund
cod69660122co_d
coed77140542coed
cold77338772cold
con510268022con_
condo85322592condo
cone67256962cone
coned86040052coned
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
cony96537832cony
cord76740922cord
don46757652don_
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
end46834352_end
eon36052082eon_
eons46638712eons
fad77452412f_ad
fan67158862fan_
fane75343572fane
fang85432552fang
fano75831692fano
fans76247372fans
fard85639062fard
fed76548352f_ed
feed84538902feed
fen66851352fen_
fends96324972fends
fens76139762fens
feod815523002feod
feud86523022feud
fid76847682f_id
fiend95312982fiend
fin66458032fin_
finds95424822finds
fine75147952fine
fined94930502fined
fink117532122fink
fino76034692fino
fins75849092fins
fiord94313342fiord
fjord16477022fjord
fled85429772fled
flong95815682flong
flood95215602flood
foal76630922foal
foam97127172foam
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foes76543442foes
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohn106116552fohn
fohns117310782fohns
foil76433912foil
foin77231562foin
foined105915012foined
foins85523382foins
folds95221692folds
folk116021542folk
fonded115717042fonded
fonder104120062fonder
fondle104412942fondle
fondly13299042fondly
fondue104510492fondue
fondus105210942fondus
fonts86124752fonts
foods95924162foods
fool75330592fool
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
fordo97218652fordo
fords95328182fords
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
foss76431642foss
fou66743782fo_u
foul77027582foul
founds104814192founds
fount84727032fount
four76226862four
fowl105723632fowl
fox136737862fo_x
foxed165115212foxed
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
fronds106412342fronds
frons86124042frons
front85029222front
fud76335152f_ud
fun66841142fun_
fundi96814912fundi
funds94119252funds
funk115825622funk
funs75235732funs
goad66830982goad
god57449792go_d
gold65430162gold
gonad75216052gonad
gone55639042gone
gong66827192gong
good66531802good
gowd96519982gowd
hand86833712hand
hind85529752hind
hod76852462ho_d
hoed87837982hoed
hold86235062hold
hon67759382hon_
honda9414982honda
hone77549322hone
honed95332262honed
hong85833952hong
honk116931192honk
hons77350782hons
hood85132332hood
hound95016482hound
ion36051022ion_
ions46737852ions
kind96128552kind
konk79320612konk
land56337312land
lend56233672lend
load56730602load
loid55531492loid
lone45849132lone
long56933342long
lord55032082lord
loud55228042loud
mend75334032mend
mind75434382mind
mod69054402mo_d
mold76034332mold
mon57561582mon_
monad85519472monad
monde85723142monde
mondo85721232mondo
monk105928522monk
mono66036722mono
mons68152262mons
mony96830012mony
mood76332062mood
mound83918312mound
nod47549562no_d
nona46929062nona
none45743172none
od39255242_o_d
odd57725452_odd
old47033462_old
on28057182_on_
one37050912_one
ono36838032_ono
ons36148512_ons
oud47439072_oud
pend75934532pend
pod66351482po_d
poind84217912poind
ponds85323402ponds
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
pood75934322pood
pound84417862pound
rand55839572rand
rend56136572rend
rind56535602rind
road56332112road
rod47953892ro_d
rondo65218372rondo
rood56733002rood
round64318432round
rynd86414102rynd
sand55338472sand
send55237292send
sod46053702so_d
sold54837412sold
son37761952son_
sonde64622832sonde
sone46649982sone
song55133672song
sons46049552sons
sord56237202sord
sound64420022sound
tend56433772tend
toad55830182toad
tod49457072to_d
toed56137042toed
told56132202told
ton310265102ton_
tondi65716142tondi
tondo69718682tondo
tone46953742tone
toned65435342toned
tong56434352tong
tons46553052tons
tony75635152tony
unfond10149112unfond
vend86626422vend
void86220562void
wand85833882wand
wend85330452wend
wind85533852wind
woad85523942woad
wold85429072wold
won66252062won_
wonk116125302wonk
wons74942042wons
wont75842502wont
wood85329382wood
word89832002word
wound94414212wound
wynd116114462wynd
yod77545502yo_d
yon67348952yon_
yoni77524392yoni
zona136321962zona
zone135231082zone
zoned154020262zoned
zonk175018622zonk

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 Filter178691298720.0632836365.1
2DLD Change Limit298722680.86034734.9
3Display Results2682680.0763526.3
 (SQL Overall)1786912680.999178869.9
 
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.