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

413 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
churred1340917(None) 
charred134614491charred
chirred133612121chirred
churned13358371churned
curred94319261c_urred
blurred10427802blurred
burred95820722_burred
chaired134211242chaired
chared125423692ch_ared
charged144614022charged
charked174814012charked
charmed154714252charmed
charted135116852charted
cheered133713302cheered
chirked173810332chirked
chirmed15379732chirmed
chirped15379782chirped
chirre114111852chirre_
chirren12388742chirren
chirres123812252chirres
choired13349342choired
chorded144710552chorded
chored125321882ch_ored
chucked19469732chucked
chuffed19316642chuffed
chugged1584822chugged
chummed17396442chummed
chumped17379492chumped
chunked17428212chunked
churched1934652churched
churner12298342churner
churr104512852churr__
churro11448352churr_o
churros12427582churros
churrs115111512churr_s
chuted124611842chu_ted
coursed104113602coursed
courted103514922courted
curbed114615872c_urbed
curded104217162c_urded
cured85932132c_u_red
curled95021652c_urled
curried103313652c_urried
cursed94321252c_ursed
curved124815222c_urved
furred104514432_furred
hurled104617452_hurled
hurried113511042_hurried
occurred1343482occurred
purred94218072_purred
shirred113710502shirred
slurred8359192slurred
spurred103610622spurred
whirred14386942whirred
abhorred1443503abhorred
accursed1354633accursed
acquired2044043acquired
averred11237593averred
barred95725803_barred
birred94713203_birred
blurbed12337613blurbed
blurted10399783blurted
bourree91311343bourree
buried94822373_buried
burked135220883_burked
burled94825383_burled
burned95818963_burned
burped116215503_burped
burrer83718473_burrer
cairned1037643cairned
capered123014043capered
carded105424903c_arded
cared86050093c__ared
caried94528693c_aried
carked134024823c_arked
carped115923763c_arped
carrel84718633c_arrel
carried103717153carried
carted98631443c_arted
carved124320853c_arved
catered103117783catered
caulked14486673caulked
caused95117043cau_sed
centred103411683centred
cered85227443c__ered
chafed154813913ch_afed
chaffed19387703chaffed
chained133812693chained
chalked17449863chalked
champed174111483champed
chanced154113213chanced
changed144214143changed
chanted134015953chanted
chapped172711443chapped
charade13129913charade
chard116124743ch_ar_d
chare105231983ch_are_
chares115631803ch_ares
charge125114213charge_
charger133914063charger
charges134615983charges
charier124317903charier
charley15118273charley
charmer144913663charmer
charnel124010053charnel
charr104821783charr__
charrier1378693charrier
charro114212963charr_o
charros124312153charros
charrs115219193charr_s
charry145012113charr_y
charter123918303charter
chartered15158403chartered
chased125019293ch_ased
chasmed154710173chasmed
chassed134712133chassed
chatted133411893chatted
chaunted1485603chaunted
chawed155214603ch_awed
cheated134416343cheated
checked193710023checked
cheeked17399663cheeked
cheeped153410593cheeped
cheerer123511763cheerer
cheerled14105713cheerled
cheesed133910683cheesed
chefed155010563ch_efed
cheffed19335863cheffed
chequered2442613chequered
cherries131812993cherries
cherry144810763cherr_y
chested133811673chested
chevied16357483chevied
chevre14318313chevre_
chevres15379793chevres
chevret153310633chevret
chewed154415013ch_ewed
chided135113963ch_ided
chilled133310933chilled
chimed145814833ch_imed
chined125620063ch_ined
chinked174011023chinked
chinned134810503chinned
chipped174110813chipped
chirker16429323chirker
chirper14359963chirper
chirr105015903chirr__
chirrs114514983chirr_s
chirrup14123833chirrup
chirruped1742163chirruped
chivied16368383chivied
chlorid133211843chlorid
chocked194411613chocked
choked164914793ch_oked
chomped17329773chomped
chopped174511013chopped
chord115917263ch_or_d
chore105126763ch_ore_
chorea115216093ch_orea
chores114828023ch_ores
choroid13311803choroid
chorten122811303chorten
chortled14326613chortled
chorused1446133chorused
choused135012473choused
chowed154914653ch_owed
chowsed16478623chowsed
chromed153510923chromed
chuckled2045163chuckled
chudder14245943chudder
chuffer18337143chuffer
chugger1445373chugger
chukker1543833chukker
chunnel12395313chunnel
chunter123911483chunter
chuntered1536663chuntered
church1636483chu_rch
churches1846433churches
churchy2044183churchy
churl105913883chu_r_l
churls115411073chu_rls
churn105113103chu_r_n
churners13316893churners
churns114910233chu_rns
churring14298653churring
chute104316463chu_te_
chutes114615773chu_tes
chutnee1246833chutnee
chutney1533823chutney
chytrid1645733chytrid
cleared103612463cleared
clerked14326653clerked
cloured103111543cloured
clubbed14307453clubbed
clucked163810133clucked
clued84917683clu__ed
clumped143610663clumped
clunked14439573clunked
coerced1238583coerced
cohered133514693cohered
colored10313473colored
concurred1445673concurred
corded105923353c_orded
cored85044223c__ored
corked135020783c_orked
corned95224523c_orned
couched154115793couched
coughed143310903coughed
counted103815803counted
couped115019313cou_ped
coupled124312673coupled
courier93617893courier
course85117783course_
courser94114803courser
courses94218893courses
courter94516483courter
covered133315293covered
cowered133214653cowered
cred76530883c___red
creed85727393c__reed
cried84624293c__ried
crudded1235733crudded
cruised103710223cruised
crumbed14378473crumbed
crumped144311223crumped
crushed134111973crushed
crusted103712763crusted
cubed105519703c_u_bed
cued76329563c_u__ed
cuffed154311213c_uffed
culled94022473c_ulled
culmed114610593c_ulmed
cupped134413983c_upped
curare84916953c_urare_
curares94916853c_urares
curated104717583c_urated
curber104517053c_urber
curd77634983c_u_r_d
curdled113910663c_urdled
cure66149123c_u_re_
curer75030753c_u_rer
curers84923193c_urers
cures75645433c_u_res
curet75447643c_u_ret
curfew14426743c_urfew
curie74533043c_urie_
curies84934023c_uries
curler85221323c_urler
curlew114010903c_urlew
curr65429653c_urr__
curran8312023c_urran
current9313693c_urrent
currie84317263c_urrie
currier93316703c_urrier
curries93723163c_urries
currs75624393c_urr_s
curry105920343c_urr_y
curse75829143c_urse_
curser84721473c_urser
curses85328273c_urses
curter85320083c_urter
curve104920023c_urve_
curves114619283c_urves
curvet114720243c_urvet
curvey144111843c_urvey
cusped114312043c_usped
cussed94917123c_ussed
demurred1234933demurred
dhurrie1153953dhurrie
dhurries1255583dhurries
dured75025403_du_red
durned84113173_durned
enured73315333enu_red
erred65915673__erred
flurried12235283flurried
furled104717053_furled
garred85217413_garred
gnarred9327013gnarred
gurged95513363_gurged
hachured1744393hachu_red
haired105117173_haired
hared95742183_h_ared
harked145422553_harked
harmed125218833_harmed
harped124418403_harped
harried113815543_harried
hatred104814333_hatred
heired103813043_heired
herbed123513453_herbed
herded114215643_herded
herried113514473_herried
hired95226263_h_ired
horded115420483_horded
horned105718703_horned
horrid10311563_horrid
horsed105321083_horsed
hued86925853_hu__ed
huffed163710153_huffed
hugged124113643_hugged
hulked144611303_hulked
hulled103920013_hulled
hummed144812673_hummed
humored1336723_humored
humped144015243_humped
hundred1237143_hundred
hunted104417013_hunted
hurdled12379833_hurdled
hurler94717223_hurler
hurley125012523_hurley
hurrah12369183_hurrah
hurrahed1543473_hurrahed
hurray12459913_hurray
hurrayed1543053_hurrayed
hurrier103412943_hurrier
hurries103919653_hurries
hurry114917183_hurr_y
hurter93915853_hurter
hurtled11339593_hurtled
hushed134416673_hushed
husked144212223_husked
hutted104616333_hutted
incurred1136493incurred
inured73114813inu_red
inurned8328053inurned
jarred144613253_jarred
juried144212443_juried
knarred12266003knarred
knurled1244653knurled
loured74617403lou_red
louvred11354663louvred
lured65427493_lu_red
lurked114511973_lurked
marred95421043_marred
mourned1037763mourned
mured85726703_mu_red
murre74821073_murre_
murres85019043_murres
murrey114312263_murrey
nurled74016233_nurled
nursed74514673_nursed
ochered132610283och_ered
ochred12328003och__red
parred95024073_parred
poured95116743pou_red
pureed95017813_pureed
purged104918263_purged
purled94520753_purled
pursed95220883_pursed
quired163711953_quired
recurred1137093recurred
scarred104512633scarred
schussed1443053schussed
scoured103811153scou_red
scourged1234573scourged
scurried11267053scurried
shared105829063sh_ared
sharked153613913sharked
sharped134112053sharped
sheared114516013sheared
sheered113515463sheered
shirked153710463shirked
shored105723653sh_ored
shorted113614403shorted
shred98125613sh__red
shucked17389833shucked
shunned11417843shunned
shunted11339783shunted
shushed14348493shushed
shuted103913173shu_ted
skirred12347083skirred
slurped10368753slurped
slurried9285943slurried
sourced1038453sourced
soured74921863sou_red
sparred104512863sparred
spurned10339263spurned
spurrer93710223spurrer
spurrey12307813spurrey
spurted103111973spurted
squared173610563squared
squired173710063squired
starred85013453starred
stirred8359703stirred
surfed103814463_surfed
surged84118883_surged
surrey94414583_surrey
tarred74720283_tarred
thirled11328093thirled
thorned11479403thorned
thudded1333433thudded
thumbed15336173thumbed
thumped15387413thumped
thunked15386853thunked
toured74216153tou_red
turfed103110963_turfed
turned73914473_turned
turret63121853_turret
uncharred1536103uncharred
unhurried1343293unhurried
unurged939143unurged
urged75316033__urged
urped84615283__urped
usurped1035153usurped
warred104019853_warred
wharfed1734423wharfed
wherried15175023wherried
whirled14368043whirled
whirried15154113whirried
whored135512123wh_ored
whorled14366903whorled
whumped18335633whumped
whupped18365413whupped
yirred10426963_yirred

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 Filter1786911340270.390458182.1
2DLD Change Limit1340274136.50020619.5
3Display Results4134130.1432888.1
 (SQL Overall)1786914137.03325407.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.