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

123 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
picoline1231085(None) 
picholine1646641picholine
picolin11310881picolin_
picolines1339621picolines
picolins1239851picolins
isoline7314012_isoline
nicotine1058472nicotine
pemoline12310272pemoline
picholines1746302picholines
pickling17239202pickling
picoting1338882picoting
pipeline12149502pipeline
pisolite10310372pisolite
proline92321592p_roline
airline7315033ai_rline
arecoline1147103arecoline
baculine1238983baculine
bicorne11297553bico_rne
choline122915383_choline
cipolin1148783cipolin_
cipolins1238033cipolins
cline76428533__c_line
colin76231693__colin_
colins85229043__colins
colone85425003__colone
conine84528553__conine
cosine83823513__cosine
crinoline1147773crinoline
decline103716613dec_line
dicliny1337673dic_liny
epiclike1644143epic_like
figuline1256033figuline
fishline14237583fishline
gasoline938523gasoline
hipline12311423hi_pline
icelike1337173_icelike
idolise839293_idolise
idolize1737783_idolize
incline9314643_incline
inosine7314283_inosine
iodine74618653_i_odine
iolite63221983_i_olite
isocline1047293_isocline
isolines8312303_isolines
kaoline11310143_kaoline
lanoline8311953lanoline
licorice1246133licorice
lifeline11167663lifeline
microcline1647063microcline
midline102315103mi_dline
milline92519113mi_lline
moline84422033__moline
neckline1496363neckline
niccolite1354413niccolite
nickling15278703nickling
nicoise937923nico_ise
nicotin948383nicotin_
nicotines1148353nicotines
nicotins1058173nicotins
paroling113316213paroling
parvoline1477173parvoline
pavonine1346663pavonine
pecorini1246553pecorini
pecorino1246633pecorino
pemolines1348623pemolines
percaline13410953percaline
petaline10314883petaline
phocine1438833p_hocine
picayune1542013picayune
picking163418333pic_king
pickle144215653pickl__e
picomole1445723picomole
picotee11311473pico_tee
picowave18102793picowave
picrite111911313pic_rite
piddling13208953piddling
piffling1745133piffling
piglike14157313pi_glike
piling95025593pi__ling
pilling103722563pi_lling
piloting1139693piloting
pindling122110983pindling
pinelike14188613pinelike
pinole83218783pinol__e
pipelike16166693pipelike
pipelined14164853pipelined
pipelines13178353pipelines
piperine122011833piperine
piscine11610973pi_scine
pisolites1149383pisolites
pisolith1346553pisolith
pistoling1268493pistoling
pivoting1436183pivoting
plotline1037643plotline
pocosin1169643pocosin_
pocosins1258953pocosins
police102918563p__olice
poling93526503p__oling
polite83625073p__olite
pooling103219093p_ooling
potline91015233p_otline
praline93019743p_raline
prickling1836533prickling
procaine12312273procaine
prolines102619693p_rolines
promine112819443p_romine
propine113020213p_ropine
purline93516533p_urline
pyrolize2248133pyrolize
pyronine1349513pyronine
quinoline1845123quinoline
recline94020493rec_line
sickling152910333sickling
sideline91011093sideline
silkoline1343653silkoline
tickling15309433tickling
timeline1039243timeline
tricotine1148253tricotine
violin9311983vi_olin_
violins10311453vi_olins
violone1037153vi_olone
vituline1147093vituline
zibeline1946363zibeline

Search took 10 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621238.51617163.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.98219894.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.