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

105 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
picolines133962(None) 
picholines1746301picholines
picoline12310851picoline_
picolins1239851picolin_s
isolines8312302_isolines
nicotines1148352nicotines
pemolines1348622pemolines
picholine1646642picholine_
picolin11310882picolin__
pipelines13178352pipelines
pisolites1149382pisolites
prolines102619692p_rolines
airlines8312793ai_rlines
arecolines1246503arecolines
bicornes12307253bico_rnes
cholines132214493_cholines
cicelies1269753ciceli_es
cipolins1238033cipolin_s
clines84926043__c_lines
colies84837053__coli_es
colins85229043__colin_s
colones96124433__colones
conines93827793__conines
cosines94122673__cosines
crinolines1246733crinolines
declines113315803dec_lines
diclinies1247833dic_linies
epibolies1345123epiboli_es
figulines1345043figulines
fishlines15246843fishlines
gasolines1047483gasolines
hiplines13310593hi_plines
icones84616383_ico__nes
idolises938763_idolises
idolizes1837553_idolizes
inclines10313143_inclines
inosines8312703_inosines
iodines83616633_i_odines
iolites73819483_i_olites
isoclines1146223_isoclines
isoline7314013_isoline_
kaolines1239293_kaolines
lanolines939983lanolines
licorices1346363licorices
lifelines12147053lifelines
microclines1746303microclines
midlines112613333mi_dlines
millines102718063mi_llines
necklines15115723necklines
niccolites1444133niccolites
nicotine1058473nicotine_
nicotins1058173nicotin_s
parvolines1585993parvolines
pecorinos1344033pecorinos
pectines121914683pec_tines
pemoline12310273pemoline_
percalines1449743percalines
picayunes1642053picayunes
pickiness1737623pic_kiness
pickings17359383pic_kings
pickles153215443pickl__es
pickling17239203picklin_g
picomoles1545913picomoles
picotees1247113pico_tees
picoting1338883picotin_g
picowaves19102893picowaves
picrites121811083pic_rites
pilings103313613pi__lings
pilotings1234353pilotings
pinoles93418703pinol__es
pinones94717073pino__nes
pipeline12149503pipeline_
pipelined14164853pipelined
piperines131610693piperines
pirogies1139423pirogi_es
pisolite10310373pisolite_
pisoliths1443643pisoliths
plotlines1146823plotlines
pocosins1258953pocosin_s
polices113118053p__olices
polies84034583p__oli_es
potlines10714213p_otlines
pralines102217723p_ralines
prickliness1943903prickliness
procaines13311523procaines
proclises1339543proclises
proline92321593p_roline_
promines123018803p_romines
propines122618933p_ropines
purlines103514053p_urlines
pyrolizes2347233pyrolizes
pyronines1458323pyronines
quinolines1964703quinolines
reclines103718543rec_lines
scolices1238733_scolices
sicklies14710013sickli_es
sickliness1645003sickliness
sidelines10109683sidelines
silkolines1443383silkolines
timelines1148443timelines
tricotines1247453tricotines
violins10311453vi_olin_s
violones1137383vi_olones
wicopies1545983wicopi_es
zibelines2045733zibelines

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411057.00021234.4
3Display Results1051050.0502100.0
 (SQL Overall)1786911057.47023921.2
 
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.