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

121 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
plotline103764(None) 
plotlines1146821plotlines
potline91015231p_otline
flatline11298922flatline
hotline10712352_hotline
plotting113011012plotting
plotzing20276152plotzing
potlike13910122p_otlike
potlines10714212p_otlines
proline92321592pro_line
trotline8310022trotline
alkaline12168283alkaline
beltline1036943beltline
blondine1137153blondine
bloodline1245173bloodline
blotting113910433blotting
blueline1036873blueline
boltlike1436313boltlike
bowline123613113_bowline
buntline10198063buntline
bustline10208843bustline
choline122915383cho_line
clothing14278783clothing
clothlike1842663clothlike
clotting113110643clotting
cutline92914543_cutline
flatlined13275003flatlined
flatliner12285383flatliner
flatlines12268433flatlines
flatling123410013flatling
footlike1537253footlike
footling12239923footling
frontline1245053frontline
frostline1245883frostline
gantline9410903gantline
halocline1445343halocline
hotlines11811643_hotlines
hotlink1476763_hotlink
isocline1047293isocline
isoline7314013iso_line
kaoline11310143kao_line
knotlike1143993knotlike
latrine7715123_latrine
lobeline1039963_lobeline
loftlike1534393_loftlike
lolling83415773_lolling
longline938763_longline
lotting82917753_lotting
lowlife1335143_lowlife
moline84422033_mo_line
online6315843__online
outline72321333_outline
palatine10316063palat_ine
patine85328123p_at_ine
pemoline12310273pemoline
peopling1338353peopling
pestling111010253pestling
petaline10314883petaline
pettling1168213pettling
phocine1438833pho_cine
photoing1439073photoing
picoline12310853picoline
piloting1139693pilot_ing
pipeline12149503pipeline
plantlike1544943plantlike
platane93112303plat_ane
platelike1546143platelike
platina94413643plat_ina
plating103823073plat_ing
platting114813033platting
playlike1735613playlike
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plosive1236673plo_sive
plotless10256793plotless
plottage1144433plottage
plottier10327263plottier
plotties103111413plotties
plowing133111723plo_wing
plowland1442743plowland
ploying132811573plo_ying
plumlike1643793plumlike
podlike14108553p_odlike
poetlike1436733poetlike
police102918563p_o_lice
poling93526503p_o_ling
polite83625073p_o_lite
polling102920383p_olling
pontine92419053p_ontine
pooling103219093p_ooling
poplin10413483p_oplin_
poplins11313153p_oplins
porcine11312843p_orcine
potpie103412433p_otpi_e
potsie83916033p_otsi_e
potting103720893p_otting
poutine93316823p_outine
praline93019743p_raline
procaine12312273procaine
prolines102619693pro_lines
promine112819443pro_mine
propine113020213pro_pine
protamine131310913protamine
proteide11239723proteide
protein92414733protein_
proteins102114283proteins
prowling1449993prowling
ptomaine1245533ptomaine
purline93516533p_urline
ratline74517803_ratline
roofline1136193roofline
rootlike1236613rootlike
rootling9269953rootling
setline7313923_setline
slitlike1235303slitlike
slotting92612613slotting
tootling9279523tootling
topline92313183_topline
towline102911543_towline
trotlines939103trotlines

Search took 7 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.1531167915.0
2DLD Change Limit1461621216.33023090.4
3Display Results1211210.0631920.6
 (SQL Overall)1786911216.54627297.7
 
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.