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

112 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
trotlines93910(None) 
trotline8310021trotline_
frontlines1345192frontlines
frostlines1345192frostlines
hotlines11811642_hotlines
plotlines1146822plotlines
potlines10714212_potlines
prolines102619692pro_lines
ratlines83815302_ratlines
toplines102412562t_oplines
towlines112610342t_owlines
tramlines1139842tramlines
traplines11310372traplines
troilites948432troilites
trollies8310232trolli_es
trollings10286692trollings
tropines102214922tro_pines
atropines1148883atro_pines
beltlines1135963beltlines
bowlines133211623_bowlines
brollies1039533brolli_es
bromines122514253bro_mines
buntlines11207153buntlines
bustlines11207353bustlines
cholines132214493cho_lines
croceines1347733croceines
cutlines102413273_cutlines
draglines1145993draglines
erotizes17311213erot_izes
flatlines12268433flatlines
frontline1245053frontline_
frostline1245883frostline_
frothiness1645723frothiness
gantlines1039333gantlines
graplines1237353graplines
growliness1494083growliness
hotline10712353_hotline_
hotlinks1574193_hotlinks
isoclines1146223isoclines
isolines8312303iso_lines
kaolines1239303kao_lines
outlines82418093_outlines
plotline1037643plotline_
portliness1246833portliness
potline91015233_potline_
pralines102217743pr_alines
procaines13311523procaines
proclises1339543proclises
proline92321593pro_line_
promines123018803pro_mines
propines122618933pro_pines
protamines14149803protamines
proteides12238793proteides
proteins102114283protein_s
ratines75328583_rat_ines
ratline74517813_ratline_
ratlins73615583_ratlin_s
reclines103718543_reclines
redlines93916083_redlines
relines75331323_r_elines
retines75134673_ret_ines
rollings9419953_rollings
romaines10512523_romaines
rooflines1245373rooflines
routines82214363_routines
serotines9312073serot_ines
setlines8312743_setlines
taglines92210843t_aglines
tapelines1138463tapelines
timelines1148443timelines
tolanes74216313t_o_lanes
tontines82114733t_ontines
toolings9248473t_oolings
tootles72915603tootl__es
tootling9279523tootlin_g
tootsies848613tootsi_es
topline92313183t_opline_
tortoises947183tortoises
tortrixes1644153tortrixes
totalises9311783t_otalises
totalizes18311053t_otalizes
towline102911543t_owline_
toxines142912263t_o_xines
tramline10311383tramline_
trapline10411863trapline_
trellises947023trellises
trephines1448483trephines
triazines1847543triazines
tricotines1247463tricot_ines
triflings13235983triflings
trines64132563tr___ines
triplanes1148803triplanes
triplites1148283triplites
trithings13246603trithings
tritones83413443trit_ones
troilisms1146413troilisms
troilite849543troilite_
troiluses944553troiluses
trolands936423tro_lands
trollied935903trolli_ed
trolling93212493trollin_g
trombones1345363trombones
trones65629283tro___nes
trophies13413683trophi_es
tropine93116653tro_pine_
tropins93116313tro_pin_s
trothing122410843trothin_g
trotting92510913trottin_g
trucklines1644293trucklines
tumplines1346023tumplines
turtlings10184873turtlings
tyrosines1246863tyro_sines

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.420425454.8
2DLD Change Limit1486411126.33023482.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.79626293.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.