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

400 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
coherer12291278(None) 
cohere112716991cohere_
cohered133514691cohered
coherers132310731coherers
coheres122917691coheres
coverer123113521coverer
adherer1137562adherer
caperer113013402caperer
caterer92815932caterer
cheder125113492c_heder
cheer105420382c_he_er
cheerer123511752cheerer
chewer145512612c_hewer
cipherer1545572cipherer
coercer1138382co_ercer
coheir1137582cohe_ir
coherent13412472coherent
colorer9312522colorer
corer75538872co__rer
coshered14610292coshered
covered133315292covered
coverers132712122coverers
coveter122912062coveter
cowered133214642cowered
cozener18328952cozener
hoverer13319822hoverer
ochered132610282ochered
soberer93110352soberer
adhere10310333adhere_
adhered1239233adhered
adherers1296913adherers
adheres11310163adheres
alterer72713993alterer
boneyer1237403boneyer
borderer1168103borderer
borer75131273bo__rer
bothered142110393bothered
bowered133113043bowered
cahier113615773cah_ier
capered123014043capered
caperers122611723caperers
career85822243care_er
careerer1038583careerer
carer74942333c__arer
catered103117763catered
caterers102814393caterers
catheter1338153catheter
ceder85322233c__eder
cere66741473c__ere_
cered85227443c__ered
ceres75540013c__eres
chafer144714573c_hafer
chare105231983c_hare_
chared125423693c_hared
chares115631803c_hares
charger133914063c_harger
charier124317903c_harier
charmer144913663c_harmer
charr104821783c_har_r
charter123918303c_harter
chaser114918383c_haser
chawer144314413c_hawer
cheaper144010583c_heaper
cheater124816953c_heater
chebec1536963c_hebec
checker18329533c_hecker
cheders134512393c_heders
cheek145115713c_he_ek
cheep125416503c_he_ep
cheeper143610743cheeper
cheered133713293cheered
cheerers13319543cheerers
cheerier1348003cheerier
cheero114712933c_heero
cheers114518913c_heers
cheery144913153c_heery
chefed155010563c_hefed
chequer2135153c_hequer
cherry144810763c_herry
chert105232103c_her_t
chertier1387873c_hertier
cherts115617233c_herts
cherty144612473c_herty
cherub1337263c_herub
chevre14318313c_hevre_
chevres15379793c_hevres
chevret153310633c_hevret
chewed154415013c_hewed
chewers154111133c_hewers
chewier1537583c_hewier
chicer134513603c_hicer
chider125116053c_hider
chiefer1536863chiefer
chimer135517203c_himer
chirker16429323c_hirker
chirper14359963c_hirper
chirr105015903c_hir_r
chirre114111853c_hirre
choicer14197893choicer
choired13349343choired
choker154314373c_hoker
chokier1638043chokier
choler113717153c_holer
chomper163810073chomper
chooser124412963chooser
chopper163611893chopper
chore105126763c_hore_
chorea115216083c_horea
chored125321883c_hored
chores114828023c_hores
chouser125212943chouser
chowder16387803chowder
churner12298343c_hurner
churr104512853c_hur_r
ciphered1637053ciphered
cipherers1644883cipherers
clearer93710823clearer
clever114611533c_lever
cleverer1334563cleverer
clovered14187363clovered
coacher143714113coacher
coaler84121703co_aler
coalier93416173coalier
coarser93211193coarser
coaster94219033coaster
coater84329553co_ater
coaxer153912783co_axer
cobber124116843co_bber
cobbier133410163cobbier
cobbler133311823cobbler
cocker144320393co_cker
cockered17710213cockered
cockerel16107113cockerel
cockier154013623cockier
codder104416333co_dder
coddler113710823coddler
coder86134213co__der
coders95426973coder_s
codger105814843co_dger
coerce10310403co_erce
coerced1238583co_erced
coercers1237653co_ercers
coerces11311943co_erces
coerect11913353co_erect
coexert16312363co_exert
coffer144112863co_ffer
coffered1737673coffered
coffret15310073coffret
cohead123811123cohe_ad
coheaded1536603coheaded
coheads13289233coheads
coheiress1443353coheiress
coheirs1236753coheirs
coherence1676933coherence
coherency1974553coherency
cohering142413833cohering
coholder1436063coholder
cohort1110720263cohor_t
cohorts123411103cohorts
cohune1189423cohune_
cohunes1249713cohunes
coiler84421593co_iler
coiner84323783co_iner
coinfer12419393coinfer
coinhere1337133coinhere_
coinhered1536593coinhered
coinheres1447633coinheres
cointer93616723cointer
colder95121833co_lder
coleader1139173coleader
colleger11227923colleger
collier93618153collier
colored10313473colored
colorers10312183colorers
colourer1037553colourer
colter84625093co_lter
colure8314153colure_
colures9315133colures
comaker153410603comaker
comber125118503co_mber
comelier12310653comelier
comember1644163comember
comer95832693co__mer
comers105328083comer_s
comether1537253comether
comfier1439163comfier
comfrey1734683comfrey
comparer143611363comparer
compeer133811553compeer
compere134616623compere_
compered153414923compered
comperes143217973comperes
conceder1338733conceder
confer114018683co_nfer
conferee13613723conferee
conferrer1447063conferrer
confrere1347563confrere
congener112412193congener
conger95024273co_nger
conifer123212643conifer
conjurer17117673conjurer
conker124721553co_nker
conner84423963co_nner
conquer1838613conquer
conquerer2044713conquerer
conserver1448723conserver
convener132913163convener
converser1438093converser
converter14311013converter
conveyer16278143conveyer
cooee74531023cooe_e_
cooeed95917863cooe_ed
cooees85621893cooe_es
cooer74831013co__oer
cooers84324563cooer_s
cooeyed1346893cooeyed
cooker124722453co_oker
cooler84824713co_oler
cooper104221123co_oper
coopered133310933coopered
cooter85128613co_oter
coper95336093co__per
copers104629843coper_s
copier103722893co_pier
copper124321893co_pper
coppered153410543coppered
copter109822013co_pter
corder94322873co_rder
core67263113co__re_
cored85044223co__red
corers85231073corer_s
cores76361853co__res
corker124720853co_rker
corkier133114303corkier
corner84625623co_rner
cornered11311133cornered
cornier93017083cornier
coroner94218203coroner
coruler9311713coruler
cosher114819903co_sher
coshers123618173cosher_s
cosier84423753co_sier
coster84331293co_ster
costrel9310363costrel
coterie9417393coterie
coteries10422703coteries
cotter84926673co_tter
cottered112511733cottered
cottier93814173cottier
coucher144515853coucher
cougher133711733cougher
coulter94115593coulter
counter94220143counter
coupler114713013coupler
courier93617873courier
courser94114803courser
courter94516463courter
couter84930203co_uter
couther123914623couther
cover105430773co__ver
coverlet13413013coverlet
covers114627963cover_s
covert114925503cover_t
coverts124813813coverts
coverup1434623coverup
coveted133011523coveted
coveters132411073coveters
cower104531773co__wer
cowers114625533cower_s
cowherb1735103cowher_b
cowherbs1833543cowherbs
cowherd1636953cowher_d
cowherds1735423cowherds
cowier113616163co_wier
coworker1744683coworker
coyer105222843co__yer
cozened19349183cozened
cozeners19297783cozeners
cozier173315143co_zier
creeper11339973creeper
crocheter1645563crocheter
crueler939023crueler
cumberer14266993cumberer
cupeler1177483cupeler
curer75030753c__urer
cyphered1934653cyphered
ditherer12187763ditherer
dodderer1144203dodderer
dourer74215273do_urer
dowered122811553dowered
eagerer8248823eagerer
enterer72015633enterer
flowerer1435453flowerer
forever1338953forever
fosterer11239513fosterer
fuehrer1332973fuehrer
fuhrer1235033fuh_rer
gatherer12147903gatherer
gomerel1036393gomerel
hearer94323643__hearer
heder95623633__heder
herder104516463__herder
here76447103__here_
heres86245903__heres
hewer115719933__hewer
hexer155116683__hexer
hirer85423123__hirer
homered133212713homered
honorer1039673honorer
hovered143411573hovered
hoverers14289023hoverers
however1634513however
inhere9313713inhere_
inhered11313163inhered
inheres10315173inheres
jeerer13389933_jeerer
koshered1636063koshered
latherer111310443latherer
loiterer837083loiterer
lowered112711913lowered
merer75126233__merer
miterer92511333miterer
modeler1039293modeler
moderner1145523moderner
moneyer1237903moneyer
mothered142310103mothered
nowhere1337203nowhere_
nowheres1437493nowheres
obeyer1135893_obeyer
ocher104516103och__er
ochers113915303ocher_s
ochery14319443ocher_y
ochre103411593och_re_
ochrea11316643och_rea
ochred12328003och_red
ochres113510833och_res
offerer1335543offerer
onerier7311613_onerier
opener83910993_opener
orderer8127943orderer
overed102216623_overed
paperer113111903paperer
ponderer112410193ponderer
poorer82613993po_orer
pothered142311043pothered
potterer102310263potterer
pourer84516043po_urer
powderer14245593powderer
powered132911643powered
properer1259203properer
queerer16106503queerer
recoverer14134973recoverer
reverer103815833reverer
roarer63914333ro_arer
rogered939553rogered
schemer1477953schemer
scorer84818253sco__rer
scourer93910433sco_urer
serer55935503__serer
severer103511563severer
sharer95025483_sharer
shearer104414683_shearer
sheer84726893_she_er
sheerer103813843sheerer
shewer124515103_shewer
showerer1436163showerer
smotherer1444633smotherer
sneerer73512313sneerer
soarer64522243so_arer
sobered102912433sobered
soever94412093so_ever
solderer947183solderer
soleret7321233soleret
sorcerer1036433sorcerer
sorer56236573so__rer
sourer63620213so_urer
sphere113313653sphere_
sphered133512313sphered
spheres123114353spheres
spherier1337783spherier
steerer73113633steerer
taperer92511793taperer
there87527393_there_
theres96525473_theres
tochered1437913tochered
totterer8217793totterer
tourer64115073to_urer
towered112911403towered
towerier1137123towerier
ushered1139153ushered
utterer71910463utterer
wagerer11328493wagerer
waterer103314073waterer
waverer13319523waverer
where117019423_where_
wheres125917433_wheres
whoever1634103whoever
witherer14187953witherer
wonderer12249183wonderer
yodeler1136343yodeler

Search took 10 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.1561145455.1
2DLD Change Limit1340274008.93614998.5
3Display Results4004000.1562564.1
 (SQL Overall)1786914009.24819322.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.