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

274 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
contain931583(None) 
contains10316531contains
captain112111062captain
centai84814782centai_
certain92612212certain
cocain101315012co_cain
conation101420882conation
congaing1239822congaing
conin76232722con__in
conjoin1638202conjoin
constrain1149332constrain
contact1144020682contact
contagia1156772contagia
contagion1246992contagion
contained12310892contained
container11311072container
contemn1137802contemn
contrail10410982contrail
cortin82423152cort_in
cotan71521782co_ta_n
countian1048122countian
curtain9319792curtain
fountain1144922fountain
mountain1046112mountain
obtain839182_obtain
abstain947253abstain
attain6311753_attain
bobtail1146553bobtail
bonsai838463bonsai_
caftan111710123cafta_n
cain65643913c___ain
calpain11310413calpain
canakin131810833canakin
cancan10314103canca_n
canikin13189753canikin
cannabin1266433cannabin
cantal84122033canta_l
cantala94114673cantala
cantals93919573cantals
cantata93811813cantata
canteen9411083canteen
canthi11310973canthi_
cantic103920543cant_ic
cantina93417253cant_ina
canting104725903cant_ing
canton85722993cant_on
cantraip12326393cantraip
cantrip112910043cantrip
captains121810573captains
captan101613343capta_n
catkin123512383c_atkin
catlin83819083c_atlin
cattail939183cattail
cental84420963centa_l
centals94317053centals
centare93113703centare
centas85020703centa_s
centaur935783centaur
centavo1245103centavo
centric11312403centric
centring112112953centring
ceratin93020163ceratin
chain105723673c__hain
chitin113114963chit_in
chitlin12269283chitlin
cinerin9313823cinerin
cinquain1943513cinquain
citrin82615413c_itrin
coalbin1137533coalbin
coati75624643coat_i_
coating103525313coat_ing
coatis85122603coat_is
coattail1045313coattail
cocaine111315173co_caine
cocains111313923co_cains
cocaptain1543663cocaptain
cochair1446313cochair
cochin131313203co_chin
cocktail1645363cocktail
codein94916723co_dein
codlin94516443co_dlin
coffin14339813co_ffin
cognation12310753cognation
coin66645353co___in
coital84117053coita_l
coition9314313coition
cojoin1539503co_join
colicin11313743colicin
colin76231693co__lin
comatic131816943comatic
comatik15139723comatik
complain1448763complain
complin13312073complin
conations111318903conations
conative131214623conative
conatus9310463conatus
concave1439373concave
concaving1737353concaving
conceit113218073conceit
concern113011963concern
conchie143312683conchie
condemn1237113condemn
condign1147733condign
conduit10713083conduit
confab1347063confa_b
confabs1435393confabs
confine12315583con_fine
confit113316403con_fit
conga85419873conga__
congaed11399743congaed
congas94417033conga_s
congii957363con_gii
coni65534803con__i_
conic95329793con__ic
conidia1069303conidia
conidian1168383conidian
coniine9316803con_iine
conine84528553con__ine
coning94331823con__ing
conins84327233con__ins
conjoins1738133conjoins
conjoint17410373conjoint
conking143618453con_king
conn66229133con___n
connate9315753connate
connation11314263connation
conning103718753con_ning
conoid9818883con_oid
conquian1945733conquian
consign1038773consign
constant10515593constant
constrains1249723constrains
constraint12411133constraint
contacting15610073contacting
contacts123215213contacts
contagions1346603contagions
contagium1444383contagium
containers1249903containers
containing13410933containing
conte76633203cont__e
contemns1237403contemns
contend103511893contend
content94326153content
contes84432913cont_es
contest93523233contest
context163913433context
continua1047653cont_inua
continue10311123cont_inue
continuo1047353cont_inuo
conto76027173cont__o
contort91422343contort
contos84923233cont_os
contour939973contour
contra83314703cont_ra
contract122915633contract
contrails11410543contrails
contrarian1247933contrarian
contrary1347493contrary
contras93015623contras
contrast102614783contrast
contrite10318543contrite
contrive13311353contrive
control9310693control
contuse9311413contuse
contusing1239143contusing
contusion1147063contusion
cooncan1147233coonca_n
coonskin1444393coonskin
coontie9311423coont_ie
cootie84223093coot_ie
corban10314693corba_n
cordwain1444413cordwain
corsair937633corsair
cortina91915973cort_ina
cortins92421333cort_ins
costa75523733costa__
costae85319683costa_e
costal85419513costa_l
costar85518613costa_r
costard104113353costard
costars94218013costars
costate94019273costate
costing104323023cost_ing
cotans81317923co_tans
coting94629253co_t_ing
cotta75818573cotta__
cottae84615703cotta_e
cottage104210573cottage
cottar84613813cotta_r
cottars94412243cottars
cottas84615573cotta_s
cotton8312993co_tton
coumarin1247323coumarin
countians1147333countians
counting113115273count_ing
cousin8517163co_usin
couthie121810553couthie
covin105621123co__vin
cowman13910373cowma_n
cowskin1645553cowskin
coxswain2042393coxswain
creatin93618133creatin
cretin82917913cret_in
curtail9299663curtail
curtains10259703curtains
cutin75022783c_ut_in
cystein1246053cystein
dentin73919573dent_in
destain8412083destain
detain74617383_detain
distain8313783distain
domain9511323do_main
donating10311803donating
donation91513783donation
entail61114343_entail
entrain7313073_entrain
eonian6311833eonia_n
fantail10310233fantail
fontal9313143fonta_l
fontina1038633font_ina
fountains1245283fountains
foxtail1745383foxtail
gentian8310103gentian
hoatzin1943943hoatzin
honan85319773hon_a_n
horntail11105033horntail
longan75612363longa_n
maintain1077723maintain
montage101211713montage
montaging1346543montaging
montane91313623montane
mortmain1244573mortmain
mountains1146363mountains
mountainy1444013mountainy
muntin82915183munt_in
nonfan948293nonfa_n
nonman8412363nonma_n
nonpaid1048073nonpaid
nontax1348413nonta_x
obtains939163_obtains
octan71313483_octa_n
ontic74418573_ont_ic
ordain7810403_ordain
outgain81010743_outgain
outlain71212613_outlain
outsin63617563_outsin
oxtail1337653_oxtail
pertain92714963pertain
pintail9311183pintail
plantain1047903plantain
pontil8315463pont_il
pontine92419053pont_ine
ponton83217643pont_on
pontoon93010703pontoon
ponytail1344553ponytail
postin83521033post_in
quintain17316223quintain
reobtain1044623reobtain
retain64523283_retain
rontgen835173rontgen
sextain14257103sextain
sonatina849073sonatina
sonatine8313323sonatine
stain55727943__stain
suntan62613003sunta_n
sustain738773sustain
tain45548073___tain
tontine72316143tont_ine
ventail10310453ventail
voltaic1245453voltaic
wonting113214103wont_ing
wonton93410963wont_on
xanthin1747043xanthin
zonation171410723zonation

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272746.92319359.7
3Display Results2742740.1062584.9
 (SQL Overall)1786912747.41924085.6
 
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.