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

193 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
coffered173767(None) 
goffered1634521goffered
offered1436141_offered
buffered1764992buffered
chaffered21154482chaffered
cockered17710212cockered
coffee144113742coffe_e_
coffees15329572coffe_es
coffer144112862coffer__
coffers154112692coffer_s
coffined1735992coffined
coffled16297362coff_led
coffret15310072coff_ret
cohered133514692co_hered
coiffured1842612coiffured
compered153414922compered
conferee13613722conferee
conferred1537752conferred
coopered133310932coopered
coppered153410542coppered
cornered11311132cornered
coshered14610292coshered
cottered112511732cottered
covered133315292co_vered
cowered133214642co_wered
differed1635522differed
niffered1544142niffered
offerer1335542_offerer
proffered1843432proffered
reoffered1643312reoffered
suffered1536732suffered
unoffered1643362unoffered
boffed15369483boff__ed
bordered1248933bordered
bothered142110393bothered
bowered133113043bo_wered
buffeted1753733buffeted
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043c_apered
careered1139493careered
catered103117773c_atered
centered112513523centered
cered85227443c___ered
chafferer20133923chafferer
chamfered20165063chamfered
cheered133713293c_heered
choppered1964883choppered
chowdered1944003chowdered
cindered1239793cindered
ciphered1637053ciphered
clavered14187633clavered
clobbered16164103clobbered
clovered14187363clovered
cockerel16107113cockerel
cockeyed2096123cockeyed
coerced1238583co__erced
coexerted1944763coexerted
cofferdam2051893cofferdam
coffering1838043coffering
coffle14359043coff_le_
coffles152610003coff_les
coffrets1645363coffrets
cohere112716993co_here_
coherer122912783co_herer
coheres122917693co_heres
coifed124113063coif__ed
coiffed1635413coif_fed
coiffure1643123coiffure_
coiffures1743213coiffures
coinferred1643893coinferred
coinhered1536593coinhered
collared113211143collared
colleted113011653colleted
colored10313473co_lored
coloured1148313coloured
comforted17315963comforted
comfrey1734683comf_rey
commerced18125463commerced
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
conceded1438283conceded
concerned1438643concerned
concerted14312113concerted
confected1739073confected
confer114018683confer__
conferees14610623conferees
conferree1447783conferree
conferrer1447063conferrer
confers124120093confer_s
conferva1644433conferva
confessed1546053confessed
confided1537453confided
confined14310403confined
confirmed1745563confirmed
conformed1767463conformed
confrere1347563confrere_
confreres1448033confreres
confused1437033confused
confuted1437683confuted
congeed113212313conge_ed
conjured18117903conjured
conquered2145463conquered
conserved1538853conserved
convened143412223convened
converged1636963converged
conversed1538683conversed
converted15311563converted
conveyed17247923conveyed
cooeed95917863co_oe_ed
cooeyed1346893co_oeyed
corbeled1338373corbeled
cored85044223co___red
corseted11311473corseted
cosseted1178343cosseted
countered12313003countered
coverer123113523co_verer
coveted133011523co_veted
cowherd1636953cowher_d
cozened19349183co_zened
cratered1149683cratered
cuffed154311213cuff__ed
cumbered15157963cumbered
cyphered1934653cyphered
doddered1234943doddered
doffed14428503doff__ed
doffer133911353doffer__
doffers14359853doffer_s
donnered10307753donnered
dormered1255673dormered
dowered122811553do_wered
foddered1434553foddered
fostered122210453fostered
gauffered1741873gauffered
goffer13409513goffer__
goffers14409213goffer_s
hollered1237603hollered
homered133212713ho_mered
hoovered15195413hoovered
hovered143411573ho_vered
koshered1636063koshered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913lo_wered
moldered1237173moldered
mongered1238953mongered
mothered142310103mothered
mufflered1842123mufflered
ochered132610283_ochered
offed12359163_off__ed
offend13365663_offe_nd
offended1643653_offended
offer114311383_offer__
offerers1434933_offerers
offeror1342943_offeror
offers12349963_offer_s
officered1841913_officered
ordered9108533_ordered
osiered837123_osiered
overed102216623_o_vered
pilfered1435853pilfered
pondered126411293pondered
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
profferer1742933profferer
raftered1237663raftered
rogered939553ro_gered
scoffed16266183scoff__ed
scoffer15317023scoffer__
scoffers16286133scoffer_s
scowdered1643733scowdered
sobered102912433so_bered
softened1235663softened
soldered1038153soldered
sufferer1436063sufferer
tafferel1443123tafferel
telfered1234883telfered
tochered1437913tochered
toffee123311013toffe_e_
toffees13327083toffe_es
tottered9208703tottered
towered112911403to_wered
wafered14288433_wafered
wondered13239943wondered

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621936.36022981.4
3Display Results1931930.0802412.5
 (SQL Overall)1786911936.61327021.2
 
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.