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

277 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
comment131031770(None) 
commend144010181commend
comments142913871comments
cement103321662c_ement
clement11313772clement
coagent10313972coagent
cogent9321002co_gent
comet95946072co_me_t
command14399212command
commence16149102commence
commends15308462commends
commented16129602commented
commenter151410682commenter
commit124016702comm_it
commixt20357622commixt
common12310802common_
commons13311042commons
commune13329352commune
compend144010302compend
concent114422512concent
consent93723112consent
content94326152content
convent123919412convent
cowmen13810922cowmen_
foment113718302fo_ment
loment84021472lo_ment
moment103319682mo_ment
torment9316172torment
ailment9314233ailment
aliment9316703aliment
ament76036543__ament
armament1249633armament
augment10910203augment
bodement13410123bodement
bowmen1399853bowmen_
bummest13298623bummest
cabmen123610653cabmen_
cadent94120353c_adent
calmest11312343calmest
camlet104426583camle_t
candent10417363candent
carmen104019343carmen_
casement12311953casement
catmint11314463catmint
cementa112810533c_ementa
cements112714223c_ements
cent67451013c___ent
cerement12315133cerement
cermet10321153cerme_t
cholent12313253cholent
clamant11312433clamant
client8316343c_lient
coagents1138443coagents
coaming123818323coaming
coden86128543co_den_
codens94821013co_dens
coempt12311033coem_pt
coerect11913353coerect
coexert16312363coexert
coherent13412473coherent
coinvent1348183coinvent
coldest102514753coldest
collect113314593collect
collet84030363colle_t
comae97128423comae__
combat12316753co_mbat
combe116223543combe__
combed135516543combe_d
comber125118503combe_r
combers134516613combers
combes125321733combe_s
combine133014723combine
combing143714733combing
combust1338353combust
come87547703co_me__
comedo11359603co_medo
comedy14378233co_medy
comely134213733co_mely
comer95832693co_me_r
comers105328083co_mers
comes97246993co_me_s
cometh134811683co_meth
comets105823583co_mets
comfiest1539133comfiest
comfit133112423co_mfit
comfort143611693comfort
coming114225453co_ming
comma114514793comm__a
commando15275753commando
commands15318813commands
commas124814573comm_as
commata1338483commata
commenced18157133commenced
commencer17147803commencer
commences17139573commences
commendam1544953commendam
commended17137013commended
commender16167923commender
commensal1546013commensal
commentary1945753commentary
commentate16108173commentate
commenters16139473commenters
commenting1749153commenting
commerce16116323commerce
commie124215523comm_ie
commies133718443commies
comminute1596143comminute
commitment1555173commitment
commits133812373commits
commix19407753comm_ix
commode1438123commode
commoner142710633commoner
commonest1549253commonest
commonly1744963commonly
commove1635963commove
communal1446353communal
communed15338203communed
communer14349293communer
communes143411233communes
communist1548083communist
community1846193community
commute134310423commute
commy144712643comm__y
compact153712213compact
company1619711143company
compart134016003compart
comped135919873compe_d
compeer133811553compeer
compel124412893compe_l
compels133210883compels
compends15378253compends
compere134616623compere
compete134716553compete
competent15411253competent
comping143518593comping
compleat14710153compleat
complect1659013complect
complement18510103complement
compliment1848403compliment
complot13310683complot
compone136517193compone
component15411083component
compony1613011913compony
comport133616843comport
compost134515353compost
compt116328223co_m_pt
comte96125473comte__
comtes106222813comte_s
conceit113218073conceit
concents122516603concents
concept133314443concept
concert113325223concert
condiment14410853condiment
confect143614273confect
congest104618773congest
connect113515743connect
consents102715893consents
contend103511893contend
contents104018213contents
contest93523233contest
context163913433context
convect143114483convect
convene123314323convene
convents132614603convents
convert123721473convert
coolant9316463coolant
coolest9318643coolest
coparent12412253coparent
copayment1845893copayment
copen94826433co_pen_
copens106119963co_pens
coquet174318013coque_t
cormel103815603corme_l
cormels113813373cormels
cornet84436733corne_t
coronet94227173coronet
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
coset75748843co_se_t
cosiest93819853cosiest
cosmist11311333cosmist
cosset84125863cosse_t
count74932053co__unt
courant9317973courant
covalent1349223covalent
coven106925043co_ven_
covens114919263co_vens
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
cowman13910373cowman_
coyest11316053co_yest
cozen165019703co_zen_
cozens176314923co_zens
coziest184014353coziest
credent10313973credent
cummer124414593cumme_r
cummers133713473cummers
cummin1288783cummin_
cummins1358963cummins
current9313693current
cymene1377393c_ymene
dement93825143_dement
dimmest1249253dimmest
docent92918683do_cent
document1348663document
dolmen93911373dolmen_
dolmens10388693dolmens
dormant102814373dormant
dormient1148453dormient
element9317803element
emmet94221383_emme_t
ferment12315573ferment
figment1379743figment
fitment12710303fitment
foemen11310523foemen_
foments122912053fo_ments
formant123416003formant
fornent10312933fornent
forwent13310533forwent
garment10315233garment
grommet12268453gromme_t
homiest124116633homiest
horrent10313553horrent
hutment1239173hutment
lambent113711303lambent
lament85024943_lament
lodgment1245983lodgment
lomenta92710133lo_menta
loments93413473lo_ments
mammet94319253mamme_t
momenta11299853mo_menta
momento11348903mo_mento
moments113113123mo_ments
monument1289903monument
mordent10313993mordent
movement1549433movement
nocent83217413no_cent
nomen75621623no_men_
nonmeat9312773nonmeat
nonmen8412833nonmen_
noumena945633noumena
oddment1145923oddment
omen66828183_o_men_
omens75618963_o_mens
omenta83411723_o_menta
orient6322533_orient
payment14310703payment
pigment12510733pigment
pommee122813283pomme_e
pommel12277453pomme_l
pommels13235783pommels
ponent82821593po_nent
portent93619643portent
potent84223353po_tent
potmen102713093potmen_
raiment9315413raiment
recommend1664323recommend
rodent7519243ro_dent
rodmen939713rodmen_
romaunt947803romaunt
rummest11279833rummest
sarment9318763sarment
segment10312563segment
socmen1039193socmen_
solvent10310833solvent
sorbent92915233sorbent
tomenta9319833to_menta
tommed113310143tomme_d
tomming12359243tomming
torments10310453torments
torrent7313413torrent
towmont1277633towmont
varment12313243varment
women104619253wo_men_
wommera14144063wommera

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.1401276364.3
2DLD Change Limit1340272777.25018486.5
3Display Results2772770.0932978.5
 (SQL Overall)1786912777.48323879.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.