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

106 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
hotlinks157419(None) 
hotlines11811641hotlines
hotlink1476761hotlink_
hotline10712352hotlin_e
potlines10714212potlines
bethinks1765043bethinks
blinks124613573__blinks
bobolinks1742493bobolinks
boinks125211273bo__inks
bootlicks17103903bootlicks
bottlings12215293bottlings
botulins1047063botulin_s
botulinus1142753botulinus
bowlines133211623bowlines
bowlings14408753bowlings
catlings113712043catlings
catlins93818843catlin_s
chitlings15255903chitlings
chitlins13289393chitlin_s
cholines132214493cho_lines
clinks125815063__clinks
codlings123110103codlings
codlins104116243codlin_s
colins85229043co_lin_s
collins93419833collin_s
cowlicks1944663cowlicks
cowlings14359783cowlings
cutlines102413273cutlines
downlinks1742843downlinks
fatlings12359303fatlings
foulings12327943foulings
fowlings15377243fowlings
goblins1039243goblin_s
godlings11367493godlings
goslings10297553goslings
hatlike143311713hatli_ke
hatpins123410643hatpin_s
heelings12359753heelings
hemlines13310623hemlines
hijinks2132003h_ijinks
hiplines13310593hiplines
hoatzines2143823hoatzines
hoatzins2043843hoatzin_s
hoblike16158303hobli_ke
hoddins12289373hoddin_s
hoelike141411163hoeli_ke
hoglike15157733hogli_ke
hoicks15378283ho__icks
holdings13297743holdings
holies94630033ho_li_es
holiness112512503ho_liness
holing104025073ho_lin_g
holisms123811113ho_lisms
holists104413963ho_lists
holks124720563ho_l__ks
hollands12247273hollands
hollies103420813holli_es
homines123518643ho_mines
honks125124523ho___nks
hoodwinks2042073hoodwinks
hoplites13310543hoplites
hoppings16306523hoppings
hornings12238363hornings
hoteliers1245803hoteliers
hotties103016963hotti_es
hotting113116523hottin_g
housings12307483housings
howling143413163howlin_g
hurlings12388213hurlings
hutlike14349063hutli_ke
hyalines14169333hyalines
hyalins13229273hyalin_s
jottings16275193jottings
kitlings13318103kitlings
links96430193___links
methinks1775193methinks
moulins9312703moulin_s
nothings12266683nothings
oinks94819913_o__inks
oodlins83210513oodlin_s
outlines82418093outlines
plinks124913263__plinks
plotlines1146823plotlines
poplins11313153poplin_s
potlike13910123potli_ke
potline91015233potlin_e
potlucks1643303potlucks
ratfinks1542853ratfinks
ratlines83815293ratlines
ratlins73615583ratlin_s
relinks114510223_relinks
rethinks1576033rethinks
rollicks1444893rollicks
rollings9419953rollings
setlines8312743setlines
slinks104315153__slinks
stinks105616833_st_inks
thinks134613363__thinks
toolings9248473toolings
toplines102412563toplines
towlines112610343towlines
trotlines939103trotlines
unlinks11307403_unlinks
unthinks1574503unthinks
uplinks13345613_uplinks
witlings12328443witlings

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 Filter1786911461620.750238254.7
2DLD Change Limit1461621067.07620656.0
3Display Results1061060.0333212.1
 (SQL Overall)1786911067.85922737.1
 
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.