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

124 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
contained1231089(None) 
container11311071container
captained1446192captained
confined14310402con_fined
conjoined1965462conjoined
constrained1445352constrained
contacted14139092contacted
contain9315832contain__
containers1249902containers
contains10316532contain_s
contemned1446792contemned
continued1248482cont_inued
contrived1547992contrived
curtained1265502curtained
fountained1443332fountained
obtained1136532_obtained
abstained1245053abstained
attained997353_attained
bobtailed1443193bobtailed
caftaned1445093cafta_ned
cantoned111411523cant_oned
certainer1146193certainer
chained133812693c__hained
cocaine111315173co_caine_
cocaines121314443co_caines
cocaptained1851943cocaptained
cochaired1743883cochaired
cocktailed1942743cocktailed
coffined1735993co_ffined
coined94523603co___ined
cojoined1856293co_joined
combined15269183co_mbined
companied1648023companied
complained17175793complained
conative131214623conative_
concaved1636223conca_ved
conceited14310423conceited
conceived1746713conceived
concerned1438643concerned
condemned1545103condemned
condoned122612023con_doned
confabbed1942463confabbed
confided1537453con_fided
confine12315583con_fine_
confiner13311193con_finer
confines13315653con_fines
congaed11399743conga__ed
congaing1239823congain_g
coniine9316803con_iine_
coniines10415363con_iines
conine84528553con__ine_
conines93827793con__ines
conjoiner1855933conjoiner
conned95119703con___ned
connived1436433con_nived
conominee1348163conominee
consigned1346323consigned
conspired1445663conspired
constringed1543593constringed
contactee13149313contactee
containing13410933containing
containment1557443containment
contaminated1755273contaminated
contemner1347183contemner
contend103511893cont_en_d
contended1339273contended
contented12313043contented
contested12310693contested
continent11415633cont_inent
continua1047653cont_inua
continue10311123cont_inue
continuer1148713cont_inuer
continues11310993cont_inues
continuo1047353cont_inuo
contorted1239473contorted
contoured1237303contoured
contracted1549823contracted
contrasted1348573contrasted
contravened1753553contravened
contrite10318543contrite_
contrive13311353contrive_
contriver1448343contriver
contrives14311703contrives
contused1138443cont_used
convened143412223con_vened
convinced1745363con_vinced
costarred1244703costarred
cottoned1138033co_ttoned
coxswained2351423coxswained
curtailed1244113curtailed
destained1158253destained
detained103111643_detained
distained1139603distained
entailed989523_entailed
entrained1089413_entrained
entwined1235843_entwined
fantailed1345563fantailed
fontanel1145553fonta_nel
intwined1235463_intwined
maintained1343853maintained
montaged12107763monta_ged
montane91313623monta_ne_
montanes101114523monta_nes
obtainer1045793_obtainer
ordained1035183_ordained
outgained1137223_outgained
outlined92512953_outlined
pertained1238503pertained
pintailed1245553pintailed
pontine92419053pont_ine_
ponytailed1652283ponytailed
reobtained1343393reobtained
retained93016093_retained
sonatine8313323sonatine_
stained84215343__stained
suntanned1044013suntanned
sustained1045383sustained
tontine72316143tont_ine_
tontines82114733tont_ines
unstained1038683unstained
untainted1038423_untainted
untanned9279963_untanned
untrained10510993_untrained
untwined1237063_untwined

Search took 9 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 Filter1786911486410.876203985.2
2DLD Change Limit1486411247.81319024.8
3Display Results1241240.0602066.7
 (SQL Overall)1786911248.74920424.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.