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

434 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
cholla11391102(None) 
challa114014191challa
chola104718031cho_la
chollas123811351chollas
holla84918491_holla
abolla8410192abolla
acholia1239972acholia
calla74827072c_alla
cella75420312c_ella
challah15458322challah
challas124414122challas
chally144314292chally
chela103916802ch_ela
chill105619872chill_
chilli114312772chilli
chills114717702chills
chilly144113222chilly
chimla1337592chimla
choana1138442choana
cholas114818002cholas
choler113717152choler
cholera12409092cholera
cholo105217972cho_lo
cholos114716852cholos
choral115118492choral
chorea115216082chorea
coala77521122c_oala
cola66541392c_o_la
collar83816172c_ollar
colly104926772c_olly
colza165112982c_olza
coolly114811392coolly
corolla938622corolla
hollas94616902_hollas
hollo84822162_hollo
holloa94914822_holloa
holly114824432_holly
olla44821172__olla
scholia1237832scholia
wholly15366572wholly
abollae936943abollae
achillea1344103achillea
acholias1349573acholias
ahold94714253aho_ld
aholds10469483aholds
ahull84010313ahull_
apollo837183apollo
atoll57913923atoll_
atolls65511353atolls
axilla13289573axilla
bola66035563_bo_la
boll65634753_boll_
bolls75531313_bolls
boyla102912363_boyla
brolly114510853brolly
bulla74620563_bulla
cabala103516913cabala
call66838673c_all_
callan83619603c_allan
callas84526753c_allas
calls75634733c_alls
canella9310793canella
canola8313623canola
canula8312963canula
cavalla1257883cavalla
cedilla1036343cedilla
cedula977643cedula
cell65031723c_ell_
cellae84915933c_ellae
cellar84514983c_ellar
celli76717693c_elli
cello74919583c_ello
cells75428063c_ells
ceorl7410913ceorl_
ceorls848163ceorls
chacma1537903chacma
chaeta11310683chaeta
chakra15437533chakra
chalah143511663chalah
chalaza2145733chalaza
chaleh143711993chaleh
chalet113825993chalet
chalk144814603ch_alk
chalks155412143chalks
chalky18468773chalky
challahs16377563challahs
challie124012853challie
challis124613463challis
challot123613263challot
chalot113020133chalot
chalupa1444473chalupa
charka154011703charka
chelae113614603chelae
chelas113817203chelas
chia96026623ch__ia
chica125818263ch_ica
chicle134312543chicle
chicly16429203chicly
chiel104918973chiel_
chield124610213chield
chiels115115933chiels
child114516223ch_ild
childe124711213childe
childly1644803childly
chile105626893ch_ile
chiles115425303chiles
chili106218483ch_ili
chiliad1337563chiliad
chilis115517873chilis
chilled133310933chilled
chiller124112183chiller
chillis124411603chillis
chillum1435443chillum
chimlas1437453chimlas
china105022483ch_ina
chiral114614413chiral
chital114313883chital
chloral12169983chloral
chlorella1493663chlorella
choanae1236863choanae
chock164316613cho_ck
chocks174815313chocks
choice132010523choice
choir105313603cho_ir
choirs114911883choirs
choke145118023cho_ke
choked164914793choked
choker154314373choker
chokes154917383chokes
chokey184811713chokey
choky175711223cho_ky
cholate122114933cholate
cholent12313253cholent
choleras13289043choleras
cholers124215203cholers
choline122915383choline
chomp144815663cho_mp
chomps155112223chomps
chon96627793cho__n
chook146015043cho_ok
chooks155312793chooks
choose115116143choose
choosy14459103choosy
chop116024923cho__p
chopin132712193chopin
choppy18376293choppy
chops125019873cho_ps
chorale124313353chorale
chorally1638103chorally
chorals124614113chorals
chord115917263cho_rd
chordal13449883chordal
chords125214633chords
chore105126763cho_re
choreal124412223choreal
choreas124414203choreas
chored125321883chored
chores114828023chores
chorial124214143chorial
choric133515903choric
chortle124210443chortle
chorus115014773chorus
chose105925403cho_se
chosen116014133chosen
choses115825133choses
chott103923933cho_tt
chotts113610993chotts
chough15699243chough
chouse116017563chouse
choush14549063choush
chow125820993cho__w
chowed154914653chowed
chows135618203cho_ws
chowse144711753chowse
chroma132912473chroma
chufa13489113ch_ufa
chukka1433013chukka
chuppa1543973chuppa
churl105913883churl_
churls115411073churls
chyle134913483ch_yle
chyles144813283chyles
cicala10310053cicala
cilia73016763c_ilia
citola838393citola
cloaca1037263cloaca
clonal8310913clonal
coal66939253c_oal_
coalas87418963c_oalas
coals76129603c_oals
coaly105521593c_oaly
cobia94117513c_obia
coble94823173c_oble
cobra95214403c_obra
coca88030643c_o_ca
cocoa98517883c_ocoa
coda77029343c_o_da
coil66439653c_oil_
coils75030083c_oils
col59360353c_o_l_
colas75436773c_olas
colby124415063c_olby
cold77338773c_o_ld
coldly12459953c_oldly
colds85726973c_olds
cole66956113c_o_le
colead94114643c_olead
coled85540763c_oled
coles76055063c_oles
colic95726173c_olic
colin76231693c_olin
collage102813763c_ollage
collard103712923c_ollard
collars93816573c_ollars
collate92919683c_ollate
collet84030363c_ollet
collie83621993c_ollie
collop107312313c_ollop
colog86619933c_olog
colon78630193c_olon
color76123743c_olor
cols66553083c_o_ls
colt67158243c_o_lt
colts76633293c_olts
coly96940533c_o_ly
colzas174010513c_olzas
coma87134853c_o_ma
comal95125133c_omal
comma114514793c_omma
conga85419873c_onga
cool66940493c_ool_
cooled95224593cooled
cooler84824713cooler
coolie83821603coolie
cools75632633c_ools
coolth1139513coolth
cooly105525423c_ooly
copal95621783c_opal
copra98115463c_opra
copula102812043copula
coral76033453c_oral
coria75828323c_oria
corollas1039213corollas
costa75523733c_osta
cotta75818573c_otta
could86517713c_ould
cowl97530813c_owl_
cowls106922213c_owls
coxa136922963c_o_xa
coxal146116673c_oxal
coyly135614893c_oyly
criollo943953criollo
cull65929643c_ull_
cullay113910173c_ullay
culls75425813c_ulls
cully105520463c_ully
culpa93610963c_ulpa
cupola10317693cupola
cupula10328433cupula
dhole95215363dho_le
dholes104914793dholes
dhooly13457143dhooly
dhoora1035653dhoora
dobla84913643_dobla
doll56632493_doll_
dollar74110983_dollar
dolls66126923_dolls
dolly96125203_dolly
dolma86214173_dolma
doula65717773_doula
droll65415403droll_
drolls75312393drolls
drolly105411673drolly
echelle1246623echelle
echolalia1463533echolalia
fella84918653_fella
folia83618933_folia
folly115022603_folly
ghoul959053ghoul_
ghouls1036043ghouls
ghyll1246323ghyll_
ghylls1335143ghylls
golly95121103_golly
halal85623593_halal
halala94715093_halala
hall75741163_hall_
hallah124115403_hallah
hallal94415563_hallal
hallo85127553_hallo
halloa94918123_halloa
halls85633783_halls
halma108219253_halma
halva115414433_halva
hell75637893_hell_
hello86522983_hello
hells85032043_hells
hila76228353_h_ila
hill76439493_hill_
hillo84721653_hillo
hilloa94713033_hilloa
hills85431353_hills
hilly114422163_hilly
hold86235063_ho_ld
holds94623243_holds
hole77553393_ho_le
holed95634133_holed
holes84748653_holes
holey115626903_holey
holily123612953_holily
holk116027943_ho_lk
holks124720563_holks
hollaed11359853_hollaed
holland11349473_holland
holler93520613_holler
holloas103814943_holloas
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
holm95628113_ho_lm
holms105117803_holms
holp95727553_ho_lp
hols76946293_ho_ls
holt77852583_ho_lt
holts85627913_holts
holy106333433_ho_ly
honda9414983_honda
hooka125513903_hooka
hooly115022223_hooly
hoopla1147633hoopla
hora76136563_ho_ra
horal86328683_horal
hosta85917833_hosta
hotly115815483_hotly
howl107625693_howl_
howls116219223_howls
hoya107418373_ho_ya
hoyle11314413_hoyle
hula74923753_h_ula
hull75428783_hull_
hullo84417453_hullo
hulloa95011183_hulloa
hulls84923563_hulls
hyla106716513_h_yla
jolly154517513_jolly
knoll9389603knoll_
knolls10367413knolls
knolly13336133knolly
koala95112213_koala
kola85124963_ko_la
loll46128383_loll_
lolls512121733_lolls
lolly85120663_lolly
mola66035633_mo_la
molal75120343_molal
moll66735703_moll_
mollah11319453_mollah
molls75129783_molls
molly105222493_molly
moola75117033_moola
mulla74317113_mulla
olea46532723__olea
ollas54218283__ollas
paella8410913paella
phalli1148263phalli
phobia13278603phobia
phonal11310383phonal
phyla13469183ph_yla
phyllo1435873phyllo
polka11310413_polka
poll66332133_poll_
polls74627723_polls
psylla1133953psylla
quoll14379493quoll_
quolls15327303quolls
rachilla1345713rachilla
roll46331653_roll_
rolls55326233_rolls
scholar1236953scholar
school11410723school_
schools1249113schools
schorl1179803schorl_
schorls1248353schorls
scilla8310943scilla
scroll8310163scroll_
scrolls938063scrolls
shall85024053shall_
sheila969843sheila
shell84424123shell_
shellac1236693shellac
shells94319523shells
shelly124414473shelly
shelta93111793shelta
shill85325333shill_
shills94519613shills
shoal83920273shoal_
shoals94215793shoals
shoaly124010773shoaly
sholom11910113sholom
shool84523153shool_
shools94919013shools
shorl84720253shorl_
shorls94516203shorls
should1038033should
sola45541863_so_la
stella63612973stella
thalli958923thalli
thill85918733thill_
thills95515383thills
thole85620843tho_le
tholed105113873tholed
tholes94919783tholes
tholoi9339233tholoi
tholos94213003tholos
thoria93012893thoria
thulia936113thulia
tola45236333_to_la
toll45535263_toll_
tolls54728433_tolls
troll54416533troll_
trolls64613943trolls
trolly94012363trolly
villa85321233_villa
viola85915543vio_la
voila84813943_voila
volta85215623_volta
volva11399003_volva
walla85321033_walla
whoa106615203who__a
whole114418093who_le
wholes124616773wholes
whoopla1542633whoopla
whorl114612453whorl_
whorls124410163whorls
woolly12408513woolly

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164346.61017052.3
3Display Results4344340.1403100.0
 (SQL Overall)1786914346.89025934.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.