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

117 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
colicines1331120(None) 
colicine12312991colicine_
colicins12312851colicin_s
culicines1347011culicines
calcines12314752cal_cines
colchicines1752742colchicines
colicin11313742colicin__
colitises11311742colitises
coniines10415362coni_ines
cotinines11410072cotinines
culicine1248342culicine_
olivines1137472_olivines
policies122415662polici_es
salicines11310002salicines
tolidines1046882tolidines
allicins1049653allicin_s
calamines13312223calamines
calcimines1674683calcimines
calcine11315273cal_cine_
calcined1338743cal_cined
calcites12313003cal_cites
calices114321693calic__es
caliches153812273calic_hes
calicles123811433calic_les
calicoes123911603calic_oes
calycine1546963calycine_
chicanes1559373c_hicanes
chlorines142512353chlorines
cholines132214493chol__ines
cilices113814023cilic__es
cliches144213743c_lic_hes
clines84926043c_l__ines
clonidines1374553clonidines
coalifies1439113coalifi_es
cocaines121314443co_caines
codeines113114523co_deines
codices12512583codic__es
codicils1346043codici_ls
codifies1439643codifi_es
coignes103912153co_i_gnes
coincides1446433coincides
colchicine1653323colchicine_
colickier1743513colickier
colickiest1843523colickiest
colics104219903colic___s
colicweed1742153colicweed
colicweeds1851303colicweeds
colies84837053col__i_es
colins85229043col__in_s
colistins1149223colistin_s
colitis92617353coliti__s
collides113214473col_lides
collies94326583col_li_es
collins93419833col_lin_s
collinses1138283col_linses
colocates13312853colocates
colognes11310603col_ognes
colones96124433col__ones
colonies103620013coloni_es
colonises112814013colonises
colonizes202613183colonizes
colorings1247683colorings
colorizes203014523colorizes
colpitises1445743colpitises
columbines1643763columbines
combines142814623co_mbines
comities12317793comiti_es
complines15312833complines
confines13315653co_nfines
conicities14412633conicities
coniine9316803coni_ine_
conines93827793co__nines
cosines94122673co__sines
cotinine10311493cotinine_
coxitides1945113coxitides
cuisines1049373c_uisines
culices113713123culic__es
culicids1345623culici_ds
cyclizines2652513cyclizines
cylices14359283cylic__es
cytidines1544803cytidines
domiciles1445423domiciles
eolipiles1144483eolipiles
filicides1545943filicides
folacins1337203folacin_s
glycines1445083_glycines
heliclines1544043heliclines
homicides1745853homicides
logicises1256203logicises
logicizes2145933logicizes
medicines1447903medicines
olefines1137323_olefines
oleines7313393_ol_eines
olivine1038843_olivine_
oscines9310363_o_scines
ovicides1445463_ovicides
polices113118053polic__es
policing13311673policin_g
polities102722343politi_es
pulicides1446283pulicides
salicine10311703salicine_
salicins10310933salicin_s
scolecites1445193scolecites
scolices1238733scolic__es
silicides1247073silicides
silicones11106553silicones
solanines9310083solanines
solecises1189103solecises
solecizes2087863solecizes
solicited1247973solicited
solicits10311023solici_ts
soricine10710883soricine_
tolidine948193tolidine_
tolidins948023tolidin_s
toluidines1143453toluidines
voicings14274613vo_icings
xylidines2042993xylidines

Search took 9 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 Filter1786911486410.516346300.4
2DLD Change Limit1486411178.25018017.1
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.81220278.1
 
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.