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

104 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
container1131107(None) 
contained12310891contained
containers1249901containers
certainer1146192certainer
confiner13311192con_finer
conjoiner1855932conjoiner
contain9315822contain__
contains10316532contain_s
contemner1347182contemner
continuer1148712cont_inuer
contriver1448332contriver
obtainer1045792_obtainer
abstainer1144403abstainer
attainer8116913_attainer
captained1446193captained
centner946853cent__ner
cocaine111315173co_caine_
cocaines121314443co_caines
coiner84323783co___iner
combiner14259723co_mbiner
complainer1645693complainer
conative131214623conative_
conceiver1657413conceiver
conciser12310243con_ciser
condemner1445763condemner
condoner112913393con_doner
confider1438123con_fider
confine12315583con_fine_
confined14310403con_fined
confiners1439953con_finers
confines13315653con_fines
congaing1239823congain_g
congener112412193con_gener
conifer123212643con__ifer
coniine9316803con_iine_
coniines10415363con_iines
conine84528553con__ine_
conines93827793con__ines
conjoined1965463conjoined
conjoiners1955403conjoiners
conner84423963con___ner
conniver1337493con_niver
conominee1348153conominee
consider11310393con_sider
consigner1246633consigner
conspirer1355293conspirer
constrained1445343constrained
contacted14139093contacted
contactee13149313contactee
contactor1348423contactor
containerise1453973containerise
containerize2363063containerize
containing13410923containing
containment1557443containment
contemned1446793contemned
contemners1447073contemners
contemnor1344643contemnor
contender1239563contender
contester11311183contester
continent11415633cont_inent
continua1047653cont_inua
continue10311123cont_inue
continued1248483cont_inued
continuers1247943cont_inuers
continues11310993cont_inues
continuo1047353cont_inuo
contravener1653423contravener
contrite10318523contrite_
contrive13311343contrive_
contrived1547993contrived
contrivers1547243contrivers
contrives14311703contrives
convener132913163con_vener
convincer1645833con_vincer
cordwainer1652693cordwainer
costlier1038523costli_er
cottager11306803cotta_ger
cottier93814173co_tti_er
couthier13218903couthi_er
curtailer1143823curtailer
curtained1265503curtained
detainer92910793_detainer
entailer877833_entailer
entrainer968583_entrainer
fontanel1145553fonta_nel
fountained1443323fountained
maintainer1243503maintainer
montane91313623monta_ne_
montanes101114523monta_nes
mountaineer13112623mountaineer
nonjoiner1665333nonjoiner
nontalker1344263nontalker
obtained1136533_obtained
obtainers1144853_obtainers
ordainer945203_ordainer
outliner82412103_outliner
pontine92419053pont_ine_
pontonier1146373pontonier
retainer82913813_retainer
sonatine8313323sonatine_
stainer73614923__stainer
sustainer944783sustainer
tontine72316143tont_ine_
tontines82114733tont_ines

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.1561145455.1
2DLD Change Limit1486411048.15618224.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.35821379.6
 
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.