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 “conte” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
conte7663320(None) 
comte96125471comte
cone67256961con_e
conge85227591conge
contes84432911contes
conto76027171conto
cote66648731co_te
monte75829771monte
aconite9315472aconite
ante46538902_ante
boite74426322boite
bone65949322bon_e
bonne75124712bonne
bonze165119352bonze
cane66653122can_e
canoe75627252canoe
cant66362032cant_
canted94825782canted
canter85230112canter
cantle84522152cantle
canto74931012canto
cants77036942cants
canty105226802canty
carte75940422carte
caste75932362caste
cate66254602c_ate
cenote83715842cenote
cense75121402cense
cent67451012cent_
center84421412center
cento76625172cento
centre84316642centre
cents74730332cents
centu76119412centu
cete64934782c_ete
chute104316462chute
cine66242942cin_e
cite65640342c_ite
clone75728162clon_e
coat67558352coat_
coated94927042coated
coatee84327222coatee
coater84329572coater
coati75624642coati
coats75635002coats
coble94823172coble
code77347732co_de
coft97939682coft_
cognate10312202cognate
cointer93616722cointer
coke107038382co_ke
cole66956112co_le
colt67158242colt_
colter84625092colter
colts76633292colts
comae97128422comae
comate104124842comate
combe116223542combe
come87547702co_me
comet95946072comet
comtes106222812comtes
con510268022con__
conch124620072conch
condo85322592condo
coned86040052coned
cones76457422cones
coney105932882coney
confer114018682confer
confute1239262confute
conga85419872conga
congee96024472congee
conger95024272conger
conges94928172conges
congo85623132congo
coni65534802con_i
conic95329792conic
conies84338592conies
conin76232722conin
conine84528552conine
conk106531442con_k
conked135019112conked
conker124721552conker
conks115525702conks
conky145818742conky
conn66229132con_n
connate9315752connate
conned95119702conned
conner84423962conner
connote9311612connote
conns75024232conns
cons66057692con_s
contemn1137802contemn
contend103511892contend
content94326152content
contest93523232contest
context163913432context
contos84923232contos
contra83314702contra
contuse9311412contuse
conus76726532conus
convex18367742convex
convey144610222convey
cony96537832con_y
cooee74531022cooee
coontie9311422coontie
coot67860382coot_
cooter85128612cooter
cootie84223092cootie
coots75636842coots
cope86847382co_pe
copse95623922copse
copter109822012copter
core67263112co_re
cornet84436732cornet
cornute939642cornute
corse75036182corse
cortex15311472cortex
coset75748842coset
cosie74728262cosie
cost68057942cost_
costa75523732costa
costae85319682costae
costed95623112costed
coster84331292coster
costs77231142costs
cot510483222co_t_
coted85033852co_ted
cotes76347842co_tes
cots68054842co_ts
cotta75818572cotta
cottae84615702cottae
cotter84926672cotter
coude85022632coude
count74932052count_
counted103815802counted
counter94220152counter
counts84618272counts
county114313322county
coupe96023482coupe
couter84930222couter
couth106122492couth
cove95837072co_ve
covet105638942covet
coxae146115182coxae
coyote11411782coyote
cozie163519132cozie
crate76537402crate
crone75231332cron_e
croute84617272croute
cunt66243672cunt_
cunts76125122cunts
cute66440452c_ute
donate73619502donate
done55747912don_e
donee66931012donee
donne65520462donne
dote55442882do_te
font77143752font_
fonts86124752fonts
forte86131462forte
gone55639042gon_e
hone77549322hon_e
kente95821072kente
lone45849132lon_e
longe66626462longe
lotte54923852lotte
monde85723142monde
monie75631652monie
montes84226932montes
month104818422month
moste75925082moste
mote67048082mo_te
motte75526972motte
nonce75719822nonce
none45743172non_e
nonet54540842nonet
note46239962no_te
once65423082_once
one37050912_on_e
onto46127662_onto
pointe84619312pointe
ponce95222512ponce
pone65747532pon_e
pontes83627852pontes
rente54733782rente
rote46249022ro_te
rotte54625932rotte
route55132072route
sconce104711722sconce
scone74621832scon_e
sente56432882sente
sonde64622832sonde
sone46649982son_e
tone46953742ton_e
tonne54921432tonne
torte55431702torte
tote46643672to_te
volte85321302volte
vote74728622vo_te
wont75842502wont_
wonted103213282wonted
wonts87621542wonts
yente86220042yente
zonae145116442zonae
zonate154114922zonate
zone135231082zon_e

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538002061.75030742.9
3Display Results2062060.0603433.3
 (SQL Overall)1786912062.14083500.5
 
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.