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

128 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
conic9532979(None) 
clonic104914671clonic
colic95726171colic
comic114721811comic
coni65534801coni_
conics103920591conics
conin76232721conin
cynic124712421cynic
iconic10411591iconic
ionic74622661ionic
sonic75225291sonic
tonic74727651tonic
yonic105920841yonic
acinic104713542acinic
acronic112814692acronic
aeonic83517042aeonic
agonic93515142agonic
amnic95516242amnic
atonic83420472atonic
axonic154312722axonic
azonic175513152azonic
bionic103614572bionic
boric98024222boric
canid85526342canid
canonic11312932canonic
cantic103920542cantic
ceric94023092ceric
chic115925202c_hic
choric133515902choric
chronic14311422chronic
civic123412542civic
clinic104312792clinic
cobia94117512cobia
cocci82812672cocci
coccic8298942coccic
codec107120342codec
cognac1157272cognac
coif96337912co_if
coil66439652co_il
coin66645352co_in
coins75834552coins
coir66327242co_ir
colics104219902colics
colin76231692colin
colonic115015712colonic
comics124015562comics
comix163513202comix
con510268022con__
conch124620072conch
condo85322592condo
cone67256962con_e
coned86040052coned
cones76457422cones
coney105932882coney
confit113316402confit
conga85419872conga
conge85227592conge
congii957362congii
congo85623132congo
conical11316202conical
conies84338592conies
conine84528552conine
coning94331822coning
conins84327232conins
conium10415312conium
conk106531442con_k
conks115525702conks
conky145818742conky
conn66229132con_n
conns75024232conns
conoid9818882conoid
cons66057692con_s
conte76633202conte
conto76027172conto
conus76726532conus
convict143410982convict
cony96537832con_y
coria75828322coria
cornice11612932cornice
cosec96320182cosec
cosie74728262cosie
cosmic12410342cosmic
covin105621122covin
cozie163519132cozie
cryonic1437832cryonic
cubic114313422cubic
cyanic133110772cyanic
cynics13377362cynics
domic104317242domic
exonic153211412exonic
folic105319322folic
genic85119392genic
gonia64117532gonia
gonif94320922gonif
iodic84816752iodic
ionics84214482ionics
ironic8313772ironic
kaonic1238762kaonic
laconic1139882laconic
logic88217832logic
lotic76420672lotic
manic94629442manic
monie75631652monie
muonic10410182muonic
obconic1346352obconic
odic74920572_odic
ontic74418572_ontic
otic66624822_otic
ovonic11288182ovonic
ozonic17308942ozonic
panic93923902panic
phonic133315212phonic
pionic103515952pionic
runic73615772runic
scenic10510512scenic
sodic84917492sodic
sonics84315632sonics
tonics83617862tonics
topic95721502topic
toric76529312toric
toxic145315622toxic
tunic74018222tunic
vinic10314972vinic
xenic144114642xenic
yogic116114932yogic
yoni77524392yoni_
yonis85020822yonis
zoic152316072zo_ic

Search took 3 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.640279204.7
2DLD Change Limit538001282.11025497.6
3Display Results1281280.0304266.7
 (SQL Overall)1786911282.78064277.3
 
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.