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 “plotlines” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
plotlines114682(None) 
plotline1037641plotline_
potlines10714211p_otlines
flatlines12268432flatlines
hotlines11811642_hotlines
plotties103111412plotti_es
potline91015232p_otline_
prolines102619692pro_lines
trotlines939102trotlines
beltlines1135963beltlines
blondines1246153blondines
bloodlines1344183bloodlines
bluelines1145833bluelines
bowlines133211623_bowlines
buntlines11207153buntlines
bustlines11207353bustlines
cholines132214493cho_lines
clothings15264433clothings
cutlines102413273_cutlines
flatline11298923flatline_
flatlined13275003flatlined
flatliner12285383flatliner
flatliners13254073flatliners
flatlings13315823flatlings
frontlines1345193frontlines
frostlines1345193frostlines
gantlines1039333gantlines
glottides1163833glottides
glottises1084953glottises
haloclines1544213haloclines
hotline10712353_hotline_
hotlinks1574193_hotlinks
isoclines1146223isoclines
isolines8312303iso_lines
kaolines1239293kao_lines
latrines8515003_latrines
lobelines1138563_lobelines
lollies73116923_lolli_es
longlines1047983_longlines
lowlifes1434333_lowlifes
lowliness1236403_lowliness
lowlives1434573_lowlives
outlines82418093_outlines
palatines11313033palat_ines
patines95225763p_at_ines
pectines121914683pect_ines
pemolines1348623pemolines
picolines1339623picolines
pilotings1234353pilot_ings
pipelines13178353pipelines
platanes102711883plat_anes
platies93722543plat_i_es
platinas103610313plat_inas
platings113611363plat_ings
ploidies1138173ploidi_es
plosives1335893plo_sives
plotless10256793plotl_ess
plottages1244243plottages
plottier10327263plotti_er
plottiest11287833plotti_est
plotting113011013plottin_g
plotzes18317703plot__zes
plotzing20276153plotzin_g
plowlands1542583plowlands
polices113118053p_o_lices
polies84034583p_o_li_es
pollices12410753p_ollices
poplins11313153p_oplin_s
portliness1246833portliness
potlike13910123p_otlike_
potpies113116173p_otpi_es
potsies93019483p_otsi_es
potties93723543p_otti_es
pottiness1179703p_ottiness
poutines102415103p_outines
pralines102217723p_ralines
procaines13311523procaines
proclises1339543proclises
proline92321593pro_line_
promines123018803pro_mines
propines122618933pro_pines
protamines14149803protamines
proteides12238783proteides
proteins102114283protein_s
ptomaines1345533ptomaines
purlines103514053p_urlines
ratlines83815293_ratlines
rooflines1245373rooflines
setlines8312743_setlines
toplines102412563_toplines
towlines112610343_towlines
trotline8310023trotline_
zloties1639913zlot_i_es

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 Filter1786911486410.186960704.3
2DLD Change Limit148641936.29623608.8
3Display Results93930.0332818.2
 (SQL Overall)178691936.51527427.6
 
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.