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

137 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
coffined173599(None) 
confined14310401confined
affined1436412_affined
coffered1737672coffered
coffin14339812coffin__
coffing163811252coffin_g
coffins153110192coffin_s
coffled16297362coff_led
coined94523602co__ined
cojoined1856292cojoined
combined15269182combined
confided1537452confided
confine12315582confine_
confiner13311192confiner
confines13315652confines
tiffined1543402tiffined
uncoffined1942422uncoffined
affine12310503_affine_
affines1339483_affines
affixed2134123_affixed
boffed15369483boff__ed
boffin14359053boffin__
boffing16339983boffin_g
boffins15329073boffin_s
cabined1239993c_abined
caffeine1644513caffeine_
caffeines1743913caffeines
caftaned1445093caftaned
calcined1338743calcined
chained133812693c_hained
chined125620063c__hined
cocaine111315173cocaine_
cocaines121314443cocaines
cocooned1337293cocooned
codeine103815033codeine_
codeines113114523codeines
codified1537403codified
coedited1237833coedited
coffee144113743coff__ee
coffees15329573coff_ees
coffer144112863coff__er
coffining1845483coffining
coffle14359043coff_le_
coffles152610003coff_les
coffling1736483cofflin_g
coffret15310073coff_ret
cofound1335513cofoun_d
cofounded1643463cofounded
cognised1256313cognised
cognized2136293cognized
coifed124113063co__ifed
coiffed1635413coif_fed
coiffing1755933coiffin_g
coiffured1842613coiffured
coifing133213893coifin_g
coigned11418663co_igned
coiled95123943co__iled
coiner84323783co__iner
collided12309803collided
collied103316673colli_ed
cologned1237153cologned
columned1334923columned
combine133014723combine_
combineds16255283combineds
combiner14259723combiner
combines142814623combines
comfier1439163comfi_er
comfiness1646953comfiness
commixed2264743commixed
communed15338213communed
compiled1537813compiled
condoned122612023condoned
coned86040053co___ned
confide13310203confide_
confider1438123confider
confides14310573confides
confiners1439953confiners
confirmed1745563confirmed
confused1437033confused
confuted1437683confuted
coniine9316803coniine_
coniines10415363coniines
conine84528553co_nine_
conines93827793co_nines
conjoined1965463conjoined
conned95119703co__nned
connived1436433connived
consigned1346323consigned
contained12310893contained
continued1248483continued
convened143412223convened
convinced1745363convinced
copied114618563co_pi_ed
coppiced1734823coppiced
cordoned12229613cordoned
corned95224523co__rned
corniced1368593corniced
corvine122113643corvine_
cosied94819883co_si_ed
cosigned1235723cosigned
cosine83823513co_sine_
cosines94122673co_sines
cottoned1138033cottoned
cowbind1536613cowbin_d
cowhided1843753cowhided
cozened19349183co_zened
cozied184112153co_zi_ed
cuffed154311213cuff__ed
cuffing163210253cuffin_g
defined123813823_defined
doffed14428503doff__ed
doffing15357793doffin_g
fined94930503___fined
foined105915013__foined
goffered1634523goffered
joined144613073jo__ined
offed12359163_off__ed
offend13365663_offen_d
offended1643653_offended
offered1436143_offered
office1435693_office_
officer1534213_officer
offices1536243_offices
offing13368643_offin_g
offings14285833_offings
offline1345783_offline_
opined95113853_o_pined
reconfined1645683reconfined
refined114720003_refined
rosined84911903ro_sined
scoffed16266183scoff__ed
scoffing17275943scoffin_g
softened1235663softened
sufficed17205663sufficed
suffixed22214343suffixed
toffies133210213toffi_es
unconfined1644433unconfined

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621376.61022112.3
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.05925313.9
 
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.