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

262 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
contains1031653(None) 
contain9315831contain_
captains121810572captains
cocains111313922co_cains
conations111318902conations
congaing1239822congaing
conins84327232con__ins
conjoins1738132conjoins
constrains1249722constrains
contacts123215212contacts
contagions1346602contagions
contained12310892contained
container11311072container
containers1249902containers
contemns1237402contemns
contrails11410542contrails
cortins92421332cort_ins
cotans81317922co_ta_ns
countians1147332countians
curtains10259702curtains
fountains1245282fountains
mountains1146362mountains
obtains939162_obtains
abstains1047323abstains
attains7310983_attains
bobtails1245193bobtails
caftans12179443cafta_ns
cains75334303c___ains
calpains1239763calpains
canakins142010463canakins
cancans11311873canca_ns
canikins14219163canikins
cannabins1365783cannabins
cantalas104013523cantalas
cantals93919573canta_ls
cantatas103410093cantatas
canteens1038573canteens
cantina93417253cant_ina
cantinas102713773cant_inas
canting104725903cant_ing
cantons95221203cant_ons
cantraips13255273cantraips
cantrips12318933cantrips
captain112111063captain_
captans111612053capta_ns
catkins133012563c_atkins
catlins93818843c_atlins
cattails1038553cattails
centai84814783centai__
centals94317053centa_ls
centares102913893centares
centas85020703centa__s
centaurs1035733centaurs
centavos1344783centavos
centring112112953centring
centrings12227603centrings
ceratins102818733ceratins
certain92612213certain_
chains114819703c__hains
chitins122713793chit_ins
chitlins13289393chitlins
cinerins10414103cinerins
cinquains2043413cinquains
citrins92614363c_itrins
coalbins1237083coalbins
coating103525313coat_ing
coatings113811843coat_ings
coatis85122603coat_i_s
coattails1144853coattails
cocain101315013co_cain_
cocaine111315173co_caine
cocaines121314443co_caines
cocaptains1643863cocaptains
cochairs1545903cochairs
cochins141413103co_chins
cocktails1744933cocktails
codeins103715483co_deins
codlins104116243co_dlins
coffins153110193co_ffins
cognations1339593cognations
coins75834553co___ins
coitions10312853coitions
cojoins1638993co_joins
colicins12312853colicins
colins85229043co__lins
collins93419833co_llins
comatiks16148043comatiks
complains1549193complains
complins14313113complins
conation101420883conation
conative131214623conative
conatus9310463con_atus
concaves1538913concaves
concaving1737353concaving
conceits122813613conceits
concerns122710833concerns
conchies153214853conchies
condemns1336293condemns
conduits111210063conduits
confabs1435393confa_bs
confine12315583con_fine
confines13315653con_fines
confits122811423con_fits
congas94417033conga__s
congius103210073con_gius
conics103920593con__ics
conies84338593con__ies
coniine9316803con_iine
coniines10415363con_iines
conin76232723con__in_
conine84528553con__ine
conines93827793con__ines
coning94331823con__ing
conjoin1638203conjoin_
conjoint17410373conjoint
conking143618453con_king
connations12312943connations
conning103718753con_ning
conns75024233con___ns
conoids10813883con_oids
conquians2045183conquians
consigns1137533consigns
constant10515593consta_nt
constants11410913constants
constrain1149333constrain_
constraint12411133constraint
constraints1346203constraints
contact1144020683conta_ct
contacting15610073contacting
contagia1156773contagia
contagion1246993contagion
contagious1345353contagious
contagium1444383contagium
containing13410933containing
contemn1137803contemn_
contend103511893cont_end
contends112810573contends
content94326153cont_ent
contents104018213contents
contes84432913cont__es
contests103413383contests
contexts17378653contexts
continua1047653cont_inua
continue10311123cont_inue
continues11310993cont_inues
continuo1047353cont_inuo
continuos1147003cont_inuos
contorts101112643contorts
contos84923233cont__os
contours1039653contours
contracts132212013contracts
contrail10410983contrai_l
contrarians1346353contrarians
contraries12711933contraries
contras93015623cont_ras
contrasts112211043contrasts
contrite10318543contrite
contrive13311353contrive
contrives14311703contrives
controls10311393controls
contuses10413453contuses
contusing1239143contusing
contusions1246993contusions
cooncans1246273coonca_ns
coonskins1544183coonskins
coonties10513803coont_ies
cooties93725733coot_ies
corbans11313173corba_ns
cordwains1544153cordwains
corsairs1046873corsairs
cortin82423153cort_in_
cortina91915973cort_ina
cortinas102212443cort_inas
costards113510793costards
costars94218013costa_rs
costing104323023cost_ing
cotan71521783co_ta_n_
coting94629253co_t_ing
cottages113310493cottages
cottars94412243cotta_rs
cottas84615573cotta__s
cottons9312193co_ttons
coumarins1347023coumarins
countian1048123countian_
counties10316283count_ies
counting113115273count_ing
countries11313613countries
cousins9516003co_usins
covins114618063co__vins
cowskins1745263cowskins
coxswains2142463coxswains
creatins103617513creatins
cremains1238693cremains
cretins93216423cret_ins
curtails10318243curtails
curtain9319793curtain_
cutins83919983c_ut_ins
cysteins1355733cysteins
dentins83419223dent_ins
destains9311813destains
detains83716093_detains
distains9413603distains
domains10510873do_mains
donating10311803donating
donations101112353donations
entails7912823_entails
entrains8312963_entrains
fantails1139693fantails
fontina1038633font_ina
fontinas1136853font_inas
fountain1144923fountain_
foxtails1844583foxtails
gentians937563gentians
hoatzins2043843hoatzins
honans94814503hon_a_ns
horntails12124823horntails
longans84510813longa_ns
maintains1167103maintains
montages111412183montages
montaging1346543montaging
montane91313623monta_ne
montanes101114523montanes
mortmains1344493mortmains
mountain1046113mountain_
mountainy1444013mountainy
muntins92715133munt_ins
nonfans1037533nonfa_ns
nontaxes1537853nontaxes
obtain839183_obtain_
octans81411143_octa_ns
ordains879653_ordains
outgains9810163_outgains
outsins73417863_outsins
oxtails1436383_oxtails
pertains102113423pertains
pintails10310163pintails
plantains1147493plantains
pontils9312213pont_ils
pontine92419053pont_ine
pontons93315553pont_ons
pontoons10279313pontoons
ponytails1443653ponytails
postins93721203post_ins
quintains18306033quintains
reobtains1144433reobtains
retains74522253_retains
rontgens944683rontgens
sextains15246813sextains
sonatina849073sonatina
sonatinas945683sonatinas
sonatine8313323sonatine
stains64923653__stains
suntans72111733sunta_ns
sustains838553sustains
tains54936323___tains
tontine72316143tont_ine
tontines82114733tont_ines
ventails1139823ventails
wonting113214103wont_ing
wontons103310533wont_ons
xanthins1846943xanthins
zonations18139313zonations

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.420425454.8
2DLD Change Limit1461622627.11020557.2
3Display Results2622620.1102381.8
 (SQL Overall)1786912627.64023388.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.