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

183 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
compony161301191(None) 
company1619711141company
compone136517191compone
campong14318122campong
colony115417272co_lony
common12310802common_
commonly1744962commonly
commons13311042commons
compend144010302compend
comping143518592comping
comply152810382comp_ly
compo115318572compo__
comport133616842comport
compos124818802compo_s
compose135716662compose
compost134515352compost
compote135616462compote
compound1555992compound
cottony1237252cottony
coupon102810992coupon_
coupons112710562coupons
pompon1238942pompon_
pompons1338552pompons
accompany2052083accompany
camion103917193camion_
camions113916133camions
campily1638273campily
camping143118973camping
campion133011413campion_
campions143511293campions
campo115219763campo__
campongs15356123campongs
campos125217953campo_s
campout13412853campout
campy145116183camp__y
capon95221873c_apon_
capons104119503c_apons
chomping18339883chomping
ciphony1744973ciphony
clomping15329653clomping
cocoon10312263cocoon_
cocoons11310563cocoons
codon86522853co_don_
codons96119463co_dons
coembody1842493coembody
coemploy1743323coemploy
cogon89120903co_gon_
cogons96818113co_gons
colon78630193co_lon_
colone85425003co_lone
coloni85619203co_loni
colons86028683co_lons
colophony1944613colophony
combine133014723combine
combing143714733combing
combo114519433combo__
combos125316613combo_s
comedy14378233com_edy
comely134213733com_ely
comfort143611693comfort
comfrey1734683comfrey
comfy153710213com__fy
coming114225453com_ing
comity13312713com_ity
command14399213command
commend144010183commend
comment1310317703comment
commode1438123commode
commoner142710633commoner
commove1635963commove
commune13329363commune
commy144712643com__my
comose105016843com_ose
comous10816503com_ous
comp106731253comp___
compact153712213compact
compare135814993compare
compart134016003compart
compas125817063comp_as
compass13379563compass
comped135919873comp_ed
compeer133811553compeer
compel124412893comp_el
compels133210883compels
compends15378253compends
compere134616623compere
compete134716553compete
compile13312443compile
complex2037243complex
complin13312073complin
compline14313553compline
complins14313113complins
complot13310683complot
complots1438163complots
component15411083component
comports143411983comports
composed154612063composed
composer145012953composer
composes145017113composes
composing16179843composing
composts144210913composts
compotes144716513compotes
compounds1654503compounds
comps115526053comp__s
compt116328223comp__t
compted143813523compted
compting153013603compting
compts125216653comp_ts
compute134513663compute
condone102616293condone
convoy14348543convo_y
cony96537833c___ony
cooey105828223co__oey
cooky145321363co__oky
cooly105525423co__oly
coon67248943co__on_
coons76737283co__ons
coopery143910273coopery
cooping123918933cooping
copay126516313co_p_ay
copen94826433co_pen_
copens106119963co_pens
coping113927663co_ping
copout10418783co_pout
coppery16409393coppery
copping143918593copping
copy116229803co_p__y
cordon95017293cordon_
cordons104415763cordons
cornpone1246933cornpone
corny106023273co__rny
corody12149703co_rody
corona83817403co_rona
corpora1139353corpora
corrody13136143corrody
cosmogony1752313cosmogony
cotton8312993cotton_
cottons9312193cottons
couping124317023couping
cowboy1637063cowbo_y
cowpoke1835103cowpoke
cowpox2035003cowpo_x
coypou13268403coypo_u
coypous14248813coypous
crampon1336943crampon_
crampons1436643crampons
crepon1039943crepon_
crepons1139323crepons
crony105918673c__rony
gobony1236913go_bony
goony95519783go__ony
hominy144511483hom_iny
homogony1745043homogony
homonym1745253hom_onym
homophony2244773homophony
impone103011863_impone
jomon14610083jom_on_
kampong16294933kampong
lemony11419553lem_ony
loony86918963lo__ony
mony96830013__m_ony
moony104818273__moony
oniony9369703_oniony
pompano1345203pompano
pompom1436493pompo_m
pompoms1535333pompoms
pompous1338063pompous
pony96434053___pony
romping123113033romping
scammony1743023scammony
simony1137903sim_ony
someone938813someone
somoni8310743som_oni
symphony2144503symphony
tampon102911233tampon_
tampons112711563tampons
tomboy1358213tombo_y
tompion11247103tompion_
tompions12267003tompions
toponym1445163to_ponym
tympany17254603tympany
youpon11366003youpon_
youpons12265983youpons

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.393454684.5
2DLD Change Limit1340271836.90319415.8
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.35924282.0
 
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.