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

140 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
conin7623272(None) 
coin66645351co_in
colin76231691colin
coni65534801coni_
conic95329791conic
conine84528551conine
coning94331821coning
conins84327231conins
conn66229131con_n
covin105621121covin
boning94223292boning
cabin94820942cabin
cain65643912c_ain
canid85526342canid
canine83826702canine
caning94128622caning
canon74725302canon
chain105723672chain
chin96934742c_hin
chopin132712182chopin
clonic104914672clonic
cloning103215472cloning
cobia94117512cobia
cocain101315012cocain
cochin131313202cochin
codein94916712codein
coden86128542coden
coding104024792coding
codlin94516432codlin
codon86522852codon
coffin14339812coffin
cogon89120902cogon
coif96337912co_if
coign85013912coign
coil66439652co_il
coining103920542coining
coins75834552coins
coir66327242co_ir
cojoin1539492cojoin
coking134523882coking
colic95726172colic
colins85229042colins
colon78630192colon
comic114721812comic
coming114225452coming
comix163513192comix
con510268022co__n
conch124620072conch
condign1147732condign
condo85322592condo
cone67256962con_e
coned86040052coned
cones76457422cones
coney105932882coney
confine12315582confine
confit113316402confit
conga85419872conga
conge85227592conge
congii957362congii
congo85623132congo
conics103920592conics
conies84338592conies
coniine9316802coniine
conines93827792conines
conium10415312conium
conjoin1638192conjoin
conk106531442con_k
conking143618452conking
conks115525702conks
conky145818742conky
conning103718752conning
conns75024232conns
conoid9818882conoid
cons66057692con_s
consign1038772consign
contain9315822contain
conte76633202conte
conto76027172conto
conus76726532conus
cony96537832con_y
cooing94024922cooing
coon67248942co_on
copen94826432copen
coping113927662coping
coria75828302coria
coring94433962coring
corn69945812co_rn
corning103720122corning
cortin82423142cortin
cosie74728262cosie
cosign958782cosign
cosine83823512cosine
cotan71521782cotan
coting94629252coting
cousin8517152cousin
coven106925042coven
coving124321522coving
covins114618062covins
cowing124526322cowing
coxing164218862coxing
coying124021482coying
cozen165019702cozen
cozie163519122cozie
cumin94616972cumin
cutin75022772cutin
cyanin113911452cyanin
cynic124712422cynic
eonian6311832eonian
eosin55220922eosin
foin77231562fo_in
gonia64117532gonia
gonif94320922gonif
gonion73612832gonion
honan85319772honan
honing103421502honing
iconic10411592iconic
iodin64419352iodin
ionic74622662ionic
join116724832jo_in
kinin94917322kinin
linin58025522linin
login66025002login
loin46838722lo_in
monie75631652monie
onion54320972_onion
renin54830032renin
robin74820282robin
ronion63315642ronion
rosin55325312rosin
sonic75225282sonic
sozin14514522sozin
tonic74727652tonic
toning74025792toning
toxin124716712toxin
venin85118662venin
yogin98317742yogin
yoni77524392yoni_
yonic105920842yonic
yonis85020822yonis
zoning162914332zoning

Search took 2 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.0931921408.6
2DLD Change Limit538001401.65632487.9
3Display Results1401400.0334242.4
 (SQL Overall)1786911401.782100275.5
 
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.