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

245 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
compotes14471651(None) 
competes144117241competes
composes145017111composes
compote135616461compote_
computes143914551computes
capotes11314642c_apotes
comates114123642com_ates
commodes1539092commodes
commoves1736962commoves
commutes143011892commutes
compares143816432compares
comperes143217972comperes
compete134716552compete_
competed154113592competed
compiles14311982compiles
completes153212922completes
complies14314522complies
complots1438162complot_s
compone136517192compone_
comported16319532comported
comports143411982comports
compos124818802compo__s
compose135716662compose_
composed154612062composed
composer145012952composer
composers153910622composers
composites1648902composites
composted16378812composted
composter15369562composter
composters16388322composters
composts144210912composts
compted143813522comp_ted
compts125216652comp_t_s
compute134513662compute_
computed154110952computed
computer144511512computer
computers15339752computers
comtes106222812com__tes
connotes10311452connotes
cowpokes1944572cowpokes
cowpoxes2244512cowpoxes
coyotes12410702co_yotes
bowpots1446023bowpot_s
campongs15356123campongs
camporee1449343camporee
camporees1546103camporees
campos125217953campo__s
campouts1436823campouts
campsites1546473campsites
campuses1437773campuses
capote10315733c_apote_
cenotes92814543c_enotes
chayotes1636503chayotes
chipotles1643793chipotles
clodpates1444103clodpates
clodpoles1443243clodpoles
coapted123911503coap_ted
coapts104614013coap_t_s
cocottes1238303cocottes
coelomes1239293coelomes
coempted1535333coemp_ted
coempts1335683coemp_t_s
coesites101313093coesites
cognates11311583cognates
cojones163512103co_jones
collates103019143collates
colones96124433co_lones
colpitis1247503colpitis
comakes154413643com_akes
comate104124843com_ate_
comatose1247823comatose
combated1539823combated
combater1439383combater
combaters1538113combaters
combats13311683combat_s
combes125321733com__bes
combines142814623combines
combos125316613combo__s
comedies13311843comedies
comedones1446933comedones
comes97246993com___es
comets105823583com_et_s
comfits14328743comfit_s
comforted17315963comforted
comforter16255983comforter
comforters17275193comforters
comforts15347323comforts
comities12317793comities
commies133718453com_mies
commits133812383commit_s
commixes2177353commixes
commode1438123commode_
commoner142710633commoner
commoners15339783commoners
commonest1549253commonest
commons13311043commo_ns
commove1635963commove_
commoved1844763commoved
communes143411243communes
commute134310443commute_
commuted15288983commuted
commuter143010153commuter
commuters15378913commuters
comose105016843com_ose_
comous10816503com_o_us
compacted18297363compacted
compacter17257883compacter
compacters18247023compacters
compactest1845043compactest
compacts16368903compacts
compadres16266413compadres
companies15311803companies
compare135814993compare_
compared153811823compared
comparer143611363comparer
comparers15319393comparers
comparted16338423comparted
comparts144210833comparts
compas125817063comp__as
compass13379563comp_ass
compasses1547393compasses
comped135919873comp__ed
compeer133811553comp_eer
compeers143410013compeers
compel124412893comp__el
compels133210883comp_els
compends15378253compends
compere134616623compere_
compered153414923compered
competent15411253competent
compile13312443compile_
compiled1537813compiled
compiler1438373compiler
compilers1537053compilers
complete143412053complete
completed162810263completed
completer153310413completer
completers16298323completers
completest16297873completest
complex2037243comp_lex
complexes22308093complexes
complices1739253complices
complied1539673complied
complier14310253complier
compliers1538293compliers
complines15312833complines
complins14313113complins
complot13310683complot__
complotted1743733complotted
compo115318573compo___
component15411083component
components1646943components
compony1613011913compo_ny
comport133616843compo_rt
composite15410153composite_
composited1756003composited
compost134515353compo_st
composures1645133composures
compound1555993compound
compounds1654503compounds
compress1439053compress
comprise14310813comprise
comprises15510943comprises
comprizes2468943comprizes
comps115526053comp___s
compt116328223comp_t__
computist1547323computist
comrades13149773comrades
comte96125473com__te_
condoes104319203condo_es
condoles113015803condoles
condones112817393condones
condores113315643condores
conepates13912283conepates
confutes1339843confutes
congoes103617303congo_es
conioses10313313conioses
connote9311613connote_
connoted1138863connoted
consoles103216153consoles
contes84432913co__ntes
convokes17247703convokes
cooees85621893co__oees
coopted123710763coop_ted
coopts105814583coop_t_s
cooter85128613co__oter
cooters94525723co__oters
cooties93725733co__oties
coots75636843co__ot_s
copes97747103co_p__es
copies104130303co_p_ies
coplots11511593coplot_s
copouts11311083co_pouts
coppices1638243coppices
copses104922473co_p_ses
copter109822013co_p_ter
copters113621283co_p_ters
cordites11314623cordites
cornpones1347113cornpones
corporates14410733corporates
corpses113913803corp_ses
corpuses12310063corpuses
corrodes111310333corrodes
cosmoses1239703cosmoses
cotes76347843c___otes
coupes105022523coup__es
couples115317053coup_les
couplets12389873couplets
coupons112710563coupo_ns
cowpats1437713cowpat_s
cowpies143314283cowp_ies
cowpoke1835103cowpoke_
cowrites133011593cowrites
cowrote12289673cowrote_
coyote11411783co_yote_
coypous14248813coypo_us
decomposes1745193decomposes
demotes104717673dem_otes
emotes84620283_em_otes
fomites123613203fom_ites
gemotes103712143gem_otes
gomphoses1745833gomphoses
hommoses1538153hommoses
hoopoes121212483hoopo_es
impones112712253_impones
imposes113213683_imposes
imputes1138083_imputes
locomotes1346333locom_otes
mopokes1536693mo_pokes
motes75944003__m_otes
oospores1049533oospores
opposes1149243_opposes
pompoms1535333pompo_ms
pompons1338553pompo_ns
pompous1338063pompo_us
promotes12314123prom_otes
rampoles1238893rampoles
recomposes1646063recomposes
recomputes1644873recomputes
remotes94521613rem_otes
sapotes9313943_sapotes
someones1039063someones
somites94219123som_ites
sopites93817173so_pites
tomatoes1038613tomatoes

Search took 7 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.1561145455.1
2DLD Change Limit1461622456.70321805.5
3Display Results2452450.1102227.3
 (SQL Overall)1786912456.96925640.8
 
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.