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

311 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
concent11442251(None) 
conceit113218071conceit
concents122516601concents
concept133314441concept
concert113325221concert
consent93723111consent
content94326151content
convent123919411convent
candent10417362candent
coagent10313982coagent
cogent9321002co_gent
coinvent1348182coinvent
comment1310317702comment
conceal113313022conceal
concede12310102concede
conceits122813612conceits
concenter13312212concenter
concepti14328272concepti
concepts143110302concepts
concern113011962concern
concerns122710832concerns
concerti122912602concerti
concerto123311612concerto
concerts123016062concerts
concoct10312902concoct
confect143614272confect
congest104618772congest
connect113515742connect
consents102715892consents
contend103511892contend
contents104018212contents
contest93523232contest
context163913432context
convect143114482convect
convene123314322convene
convents132614602convents
convert123721472convert
docent92918682do_cent
incent83320722_incent
nocent83217412no_cent
oncet74626542_once_t
ponent82821592pon_ent
accent105116273_accent
acescent1248013acescent
ancient9514733_ancient
anent54931843_an_ent
ascent84519653_ascent
boniest93318993boniest
bonnet85524633bonne_t
cadent94120363c_adent
cancan10314103cancan_
cancans11311873cancans
cancel105316683cance_l
cancels114113313cancels
cancer104220923cance_r
cancers114018583cancers
canescent13118763canescent
cement103321673c_ement
cent67451013___cent
chicest14209943chicest
choicest15226453choicest
cholent12313253cholent
clement11313773clement
client8316343c_lient
coact96130583coac__t
coagents1138453coagents
coconut11511473co_conut
coden86128543co_den_
codens94821013co_dens
coerect11913353coerect
coexert16312363coexert
coherent13412473coherent
coincident1554563coincident
coinfect15276843coinfect
coinvents1445663coinvents
coldest102514763coldest
collect113314593collect
collet84030363colle_t
comet95946073co_me_t
commend144010183commend
comments142913883comments
compend144010303compend
concave1439373concave
conceals123111033conceals
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceding1559343conceding
conceited14310423conceited
conceive1539233conceive
concenters14410593concenters
concentric1346133concentric
conceptus15295873conceptus
concerned1438643concerned
concerted14312113concerted
concertos132711133concertos
conch124620073conc__h
concha134213283conc_ha
conchae143911643conchae
conchal144211593conchal
conchas144013313conchas
conches144019813conches
conchie143312683conchie
concho134414263conc_ho
conchos144313963conchos
conchs134714903conc_hs
conchy163710223conc_hy
concise11314473concise
concisest1348253concisest
concocts1138633concocts
concord12510343concord
concrete12411083concrete
concur10411103conc_ur
concurrent1446313concurrent
concurs11311473concurs
concuss1138063concuss
condemn1237113condemn
condemns1336293condemns
condense1179613condense
condiment14410853condiment
condolent1249833condolent
condone102616293condone
conduct121411593conduct
conduit10713083conduit
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confects153110873confects
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confident1549383confident
confine12315583confine
confit113316403con_fit
confluent1446913confluent
confront13411603confront
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
congener112412203congener
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
congruent1247413congruent
conies84338593conie_s
coniine9316803coniine
conin76232723con_in_
conine84528553con_ine
conines93827793conines
coning94331833con_ing
conins84327233con_ins
conjoint17410373conjoint
conjunct1945483conjunct
conjunto1744653conjunto
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conking143618453conking
conn66229133con__n_
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conning103718763conning
connivent1447723connivent
conns75024233con__ns
conodont11411153conodont
conquest1939553conquest
consented12311943consented
consenter11312493consenter
consist9316033consist
consort91319903consort
constant10515593constant
consult92513633consult
contact1144020683contact
conte76633203conte__
contemn1137803contemn
contemns1237403contemns
contempt1447473contempt
contends112810573contends
contented12313043contented
contes84432913conte_s
contests103413383contests
contexts17378653contexts
continent11415633continent
contort91422343contort
convects153410993convects
convened143412223convened
convener132913163convener
convenes132916913convenes
convenor13307613convenor
convented15410753convented
converts133213553converts
convex18367743conve_x
convey144610223conve_y
conveys15308223conveys
convict143410983convict
coolant9316463coolant
coolest9318643coolest
cooncan1147233cooncan_
cooncans1246273cooncans
coparent12412253coparent
copen94826433co_pen_
copens106119963co_pens
coquet174318013coque_t
cornet84436733corne_t
corniest102117303corniest
coronet94227173coronet
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
cosecant12410683cosecant
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
cotangent1246833cotangent
couchant1549053couchant
count74932053co__unt
courant9317973courant
covalent1349223covalent
coven106925043co_ven_
covens114919263co_vens
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
cowmen13810923cowmen_
coyest11316053co_yest
cozen165019703co_zen_
cozens176314923co_zens
coziest184014353coziest
credent10313973credent
crescent12711053crescent
current9313693current
decent94023703_decent
descent102616293descent
docents102810803do_cents
donnert82815533donnert
eocene8311613eo_cene
foment113718303fo_ment
fondant11311143fondant
fondest11312403fondest
fornent10312933fornent
forwent13310533forwent
honest94822423hon_est
horrent10313553horrent
incant82418513_incant
incents92414533_incents
incept102712763_incept
incest82918743_incest
indent73021243_indent
innocent1048163innocent
intent63122773_intent
invent93316363_invent
lancet84223573lance_t
lenient7313843lenient
loment84021473lo_ment
longest84114953longest
lucent8313823_lucent
moment103319683mo_ment
monument1289903monument
mordent10313993mordent
nascent9610523nascent
nonce75719823nonce__
nonces84418833nonce_s
nonet54540843non_e_t
nonevent11410163nonevent
nonmeat9312773nonmeat
nonmen8412833nonmen_
once65423083_once__
onset54730173_onse_t
orient6322533_orient
pendent10314723pendent
percent113520603percent
ponce95222513ponce__
ponced114314813ponce_d
ponces104720843ponce_s
poncing122913583poncing
portent93619643portent
potent84223353po_tent
precent113520263precent
pungent10311233pungent
recent83630853_recent
ringent8315153ringent
rodent7519243ro_dent
scandent1148493scandent
scent75831623__scent
sconce104711723sconce__
sconced12359173sconce_d
sconces113811453sconce_s
sconcing1338263sconcing
solvent10310833solvent
sonant6621953son_ant
sonnet65923503sonne_t
sorbent92915243sorbent
tangent8315003tangent
toniest73218903toniest
tonlet62924703tonle_t
torment9316173torment
torrent7313413torrent
unbent83216593_unbent
unkent103116053_unkent
unpent83117373_unpent
unrent63219783_unrent
unsent63820963_unsent

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 Limit1340273116.68620045.9
3Display Results3113110.1102827.3
 (SQL Overall)1786913117.18924856.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.