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

403 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
coerced123858(None) 
coerce10310401coerce_
coercer1138381coercer
coerces11311941coerces
amerced1256522amerced
cered85227442c_er_ed
clerked14326652clerked
coercers1237652coercers
coerect11913352coerect
coerected1447642coerected
cohered133514692coher_ed
commerced18125462commerced
corded105923352co_rded
cored85044222co_r_ed
corked135020782co_rked
corned95224522co_rned
coursed104113602coursed
courted103514922courted
covered133315292cover_ed
cowered133214652cower_ed
forced126316522fo_rced
pierced12347592pierced
sourced1038452sourced
tierced10347052tierced
uncoerced1445312uncoerced
acorned10238283aco_rned
aeried74221863_aeried
alerted82512223alerted
amerce10310513amerce_
amercer1146373amercer
amerces1149853amerces
arced88224163__arced
averred11237593averred
averted112211613averted
bermed115217723_bermed
boarded113910503boarded
bored85034303bo_r_ed
borked135117293bo_rked
bounced123610553bounced
bowered133113043bower_ed
cadenced1435523cadenced
cairned1037643cairned
capered123014043caper_ed
carcel105018673c_arcel
carded105424903c_arded
cared86050093c_ar_ed
caried94528693c_aried
carked134024823c_arked
carped115923763c_arped
carried103717153carried
carted98631443c_arted
carved124320853c_arved
catered103117773cater_ed
caverned1436163caverned
ceased94920783c_eased
ceded96118563c_e_ded
ceiled94114953c_eiled
celled94420323c_elled
censed94016323c_ensed
cerated103922473c_erated
cercal10314123c_ercal
cerci93716393c_erc_i
cercis104614493c_ercis
cercus105013153c_ercus
cere66741473c_er_e_
ceres75540013c_er_es
cermet10321153c_ermet
certes84623083c_ertes
cervid1239323c_ervid
cessed94615613c_essed
chanced154113213chanced
chared125423693char_ed
charged144614023charged
charked174814013charked
charmed154714253charmed
charred134614483charred
charted135116853charted
cheated134416343cheated
checked193710023checked
cheeked17399663cheeked
cheeped153410593cheeped
cheered133713293cheered
cheerled14105703cheerled
cheesed133910683cheesed
chefed155010563che_fed
cheffed19335863cheffed
chested133811673chested
chevied16357483chevied
chewed154415013che_wed
chirked173810333chirked
chirmed15379733chirmed
chirped15379783chirped
chirred133612123chirred
choired13349343choir_ed
chorded144710553chorded
chored125321883chor_ed
churched1934653churched
churned13358373churned
churred13409173churred
circled1237583c_ircled
cleaned103512003cleaned
cleared103612463cleared
cleated103417843cleated
cleaved134010483cleaved
cleeked14357733cleeked
clefted13326753clefted
clenched16257763clenched
cleped115114113cle_ped
clerid9312413cler_id
clewed1225113203cle_wed
cloured103111543clour_ed
clovered14187363clover_ed
coached153313843coached
coacted123611613coacted
coaled95022713co_aled
coalesced1444553coalesced
coapted123911503coapted
coarse84813903coarse_
coarsen93210323coarsen
coarser93211203coarser
coasted104015953coasted
coated94927043co_ated
coaxed165612513co_axed
cobbled143411633cobbled
coccid102910743co_ccid
cocked155022563co_cked
cockered17710213cocker_ed
cockled163710823cockled
codded114515303co_dded
coddled123410573coddled
coded95433183co__ded
coderived1644793coderived
codices12512583codices
coed77140543co___ed
coedited1237833coedited
coempted1535333coempted
coenacted1445803coenacted
coercing1349003coercing
coercion1246573coercion
coercive1545873coercive
coerects1258543coerects
coexerted1944763coexerted
coextend1842483coextend
coffered1737673coffer_ed
coffled16297363coffled
cogged116416613co_gged
coheaded1536603coheaded
cohere112716993coher_e_
coherer122912783coher_er
coheres122917693coher_es
coifed124113063co_ifed
coiffed1635413coiffed
coigned11418663coigned
coiled95123943co_iled
coined94523603co_ined
coked124730693co__ked
coled85540763co__led
coleseed1147403coleseed
collied103316673collied
colored10313473colored
combed135516543co_mbed
commenced18157133commenced
commerce16116323commerce_
commerces17147233commerces
comped135919873co_mped
compered153414923comper_ed
compted143813523compted
comrade12139213comrade
concede12310103co_ncede
concerned1438643concerned
concerted14312113concerted
conduced14136963conduced
coned86040053co__ned
conferred1537753conferred
congaed11399743congaed
congeed113212313congeed
conked135019113co_nked
conned95119703co_nned
conserved1538853conserved
converged1636973converged
conversed1538683conversed
converted15311563converted
cooed84534343co__oed
cooeed95917863co_oeed
cooeyed1346893cooeyed
cooked135921363co_oked
cooled95224593co_oled
cooped114821603co_oped
coopered133310933cooper_ed
coopted123710763coopted
coped105036843co__ped
copied114618563co_pied
copped135221253co_pped
coppered153410543copper_ed
coppiced1734823coppiced
corbel103715973co_rbel
cord76740923co_r__d
corder94322883co_rder
core67263113co_r_e_
corer75538873co_r_er
cores76361853co_r_es
corker124720853co_rker
cormel103815603co_rmel
cornea84018933co_rnea
cornel84020053co_rnel
corner84625623co_rner
cornered11311133corner_ed
cornet84436733co_rnet
cornfed1337383cornfed
corniced1368593corniced
corrade101111043corrade
corraded12128293corraded
correct11513983correct
corrected1438113corrected
corrie83621233corrie_
corries94026803corries
corrode101310573corrode
corroded12147513corroded
corse75036183co_rse_
corses84433463co_rses
corset85636223co_rset
cortex15311473co_rtex
corvee114320093co_rvee
corves115122523co_rves
corvet114626933co_rvet
corvid12310473co_rvid
coshed124217543co_shed
coshered14610293cosher_ed
cosied94819883co_sied
costed95623113co_sted
coted85033853co__ted
coterie9417403coterie_
coteries10422703coteries
cottered112511733cotter_ed
couched154115793couched
coughed143310903coughed
counted103815803counted
couped115019313co_uped
coupled124312673coupled
courier93617893courier
course85117783course_
courser94114803courser
courses94218893courses
courter94516483courter
covaried1448003covaried
coved115027373co__ved
coverer123113523cover_er
coverlet13413013coverlet
coverlid1445943coverlid
coveted133011523coveted
cowed115637853co__wed
cowled125218393co_wled
cowrie113814283cowrie_
cowries124218013cowries
cowshed1637773cowshed
coxed154322813co__xed
coyed114623803co__yed
cozened19349183cozened
cozied184112153co_zied
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323453created
cred76530883c__r_ed
creed85727393c__reed
creeled104012013creeled
creeped12329713creeped
creped114115703cre_ped
crested103416533crested
creviced1634453creviced
crewed125316563cre_wed
cried84624283c__ried
curbed114615873c_urbed
curded104217163c_urded
cured85932133c_ur_ed
curled95021653c_urled
curred94319263c_urred
curried103313653curried
cursed94321253c_ursed
curved124815223c_urved
deiced104214483_deiced
deuced104112123_deuced
dowered122811553dower_ed
emerged11158213emerged
emersed10138513emersed
erred65915673__erred
everted112711853everted
exerted152210053exerted
farced125216533_farced
fenced124412713_fenced
fierce11348913fierce_
fiercer12356953fiercer
fleeced13358153fleeced
force105324273fo_rce_
forcer114917343fo_rcer
forces114422133fo_rces
forded115020393fo_rded
forged115519323fo_rged
forked145217143fo_rked
formed125021173fo_rmed
gored75227083go_r_ed
gorged95016983go_rged
gormed105013833go_rmed
governed1335193governed
herbed123513453_herbed
herded114215643_herded
hoarded12368343hoarded
homered133212713homer_ed
horded115420483ho_rded
horned105718703ho_rned
horsed105321083ho_rsed
hovered143411573hover_ed
jeered143912793jeer_ed
jereed144012073_jereed
jerked18479593_jerked
jounced17337613jounced
kerbed13339703_kerbed
kerfed14358233_kerfed
kerned114112933_kerned
leered73816223leer_ed
lorded84916733lo_rded
loured74617403lour_ed
lowered112711913lower_ed
mercer105214203_mercer
merces105720743_merces
merged104214953_merged
moored93814173moor_ed
mourned1037763mourned
nerved104111683_nerved
normed95014543no_rmed
noticed1037863noticed
oared65030653_oar_ed
ochered132610283ocher_ed
ochred12328003ochr_ed
oersted839553_oersted
orbed85516193_o_rbed
overbed132811853overbed
overed102216623over_ed
overfed142510253overfed
peaced115818913_peaced
peered93819493peer_ed
perched154713243_perched
perked134617693_perked
permed115217353_permed
pieced113912103pie_ced
pierce104010393pierce_
piercer11337773piercer
pierces113411193pierces
policed123212233policed
ponced114314813po_nced
pored85234513po_r_ed
porked134717623po_rked
ported94223243po_rted
pounced123510623pounced
poured95116743pour_ed
powered132911643power_ed
queried1738683queried
roared75015393roar_ed
rogered939553roger_ed
sconced12359173sco_nced
scorched16187203sco_rched
scored94621133sco_r_ed
scorned10229953sco_rned
scoured103811153scour_ed
scourged1234573scourged
sered65737293_ser_ed
serged84118773_serged
served104616813_served
smerked14327283smerked
soared74324293soar_ed
sobered102912433sober_ed
solaced102911063solaced
sorbed94916523so_rbed
sored66141783so_r_ed
sorned74820043so_rned
sorted74523713so_rted
source8410673source_
sources9312173sources
soured74921863sour_ed
specced14266703specced
swerved1455703swerved
terce75721843_terce_
tercel83612993_tercel
terces83921413_terces
tercet83624913_tercet
termed94816703_termed
tierce8339843tierce_
tiercel9316203tiercel
tierces93710453tierces
tiered73613973tier_ed
torched133511363to_rched
toured74216153tour_ed
towered112911403tower_ed
veered103612743veer_ed
verged114815163_verged
versed104515513_versed
voiced123910113vo_iced
worded114316623wo_rded
worked145314703wo_rked
wormed124314303wo_rmed
worried11308693worried
yerked14509373_yerked
zeroed16409413_zeroed

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.403443402.0
2DLD Change Limit1340274037.06318975.9
3Display Results4034030.1402878.6
 (SQL Overall)1786914037.60623493.4
 
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.