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

232 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
conceit11321807(None) 
conceits122813611conceits
concent114422511concent
concept133314441concept
concert113325221concert
conceal113313022conceal
concede12310102concede
conceited14310422conceited
conceive1539232conceive
concents122516602concents
concepti14328272concepti
concepts143110302concepts
concern113011962concern
concerti122912602concerti
concerto123311612concerto
concerts123016062concerts
conchie143312682conchie
concoct10312902concoct
conduit10713082conduit
confect143614272confect
confit113316402con_fit
congest104618772congest
connect113515742connect
consent93723112consent
content94326152content
contest93523232contest
context163913432context
convect143114482convect
convent123919412convent
convert123721472convert
oncet74626542_once_t
boniest93318993boniest
bonnet85524633bonne_t
cancel105316683cance_l
cancels114113313cancels
cancer104220923cance_r
cancers114018583cancers
candent10417363candent
canoeist10310693canoeist
chicest14209943chicest
choicest15226453choicest
circuit1148833circuit
coact96130583coac__t
coadmit1247833coadmit
coagent10313983coagent
coalpit1148513coalpit
cocain101315013co_cain
cocci82812673co_cci_
coccic8298943co_ccic
coccid102910743co_ccid
coccoid11299283coccoid
cochin131313203co_chin
cockpit1747993cockpit
codeia94112193co_deia
codein94916723co_dein
coedit9316243co_edit
coerect11913353coerect
coexert16312363coexert
cogent9321003co_gent
cognovit1444633cognovit
cohabit1449563cohabit
coheir1137583co_heir
coinfect15276843coinfect
coinvent1348183coinvent
coldest102514763coldest
collect113314593collect
collet84030363colle_t
comet95946073co_me_t
comfit133112423co_mfit
comment1310317703comment
commit124016703co_mmit
concave1439373concave
concavity1944623concavity
conceals123111033conceals
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceding1559343conceding
conceiting15311773conceiting
conceived1746713conceived
conceiver1657413conceiver
conceives1639233conceives
concenter13312213concenter
conceptus15295873conceptus
concerns122710833concerns
concerted14312113concerted
concertos132711133concertos
conch124620073conc__h
concha134213283conc_ha
conchae143911643conchae
conchal144211593conchal
conchas144013313conchas
conches144019813conches
conchies153214853conchies
concho134414263conc_ho
conchoid1688043conchoid
conchos144313963conchos
conchs134714903conc_hs
conchy163710223conc_hy
concise11314473concise
concisest1348253concisest
concocts1138633concocts
concord12510343concord
concrete12411083concrete
concretist1448193concretist
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
condemn1237113condemn
conduct121411593conduct
conduits111210063conduits
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confects153110873confects
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confits122811423con_fits
conflict1547753conflict
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
congii957363con_gii
coni65534803con__i_
conic95329793con__ic
conicity15411093conicity
conidia1069303conidia
conies84338593conie_s
conin76232723con__in
conjoin1638203conjoin
conjoint17410373conjoint
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conoid9818883con_oid
conquest1939553conquest
conscript1547123conscript
consents102715893consents
consist9316033consist
consort91319903consort
consult92513633consult
contact1144020683contact
contain9315833contain
conte76633203conte__
contemn1137803contemn
contempt1447473contempt
contend103511893contend
contents104018213contents
contes84432913conte_s
contests103413383contests
contexts17378653contexts
contort91422343contort
contrite10318543contrite
convects153410993convects
convene123314323convene
convents132614603convents
converts133213553converts
convex18367743conve_x
convexity2443313convexity
convey144610223conve_y
conveys15308223conveys
convict143410983convict
coolest9318643coolest
copyedit1644353copyedit
coquet174318013coque_t
corbeil11859213corbeil
corncrib1443903corncrib
cornet84436733corne_t
corniest102117303corniest
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
coscript1456633coscript
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
council1137473counc_il
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
coyest11316053co_yest
coziest184014353coziest
crocein1138073crocein
deceit93018213_deceit
docent92918683do_cent
donnert82815533donnert
fondest11312403fondest
forfeit1339203forfeit
honest94822423hon_est
howbeit1545663howbeit
incent83320723_incent
incept102712763_incept
incest82918743_incest
lancet84223573lance_t
longest84114953longest
monteith1375793monteith
nocent83217413no_cent
nonce75719823nonce__
nonces84418833nonce_s
noncredit1265573noncredit
nonet54540843non_e_t
nonmeat9312773nonmeat
nonsuit7811343nonsuit
once65423083_once__
onset54730173_onse_t
orcein838183_orcein
ponce95222513ponce__
ponced114314813ponce_d
ponces104720843ponce_s
ponent82821593pon_ent
sconce104711723sconce__
sconced12359173sconce_d
sconces113811453sconce_s
sobeit8315363so_beit
sonnet65923503sonne_t
toniest73218903toniest
tonlet62924703tonle_t

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.423422437.4
2DLD Change Limit1340272326.59320328.7
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.10925135.9
 
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.