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

164 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
interline9121800(None) 
interlined111211261interlined
interliner101311151interliner
interlines101116451interlines
interlink131310661interlink
centerline1247042centerline
interfile12411042interfile
interlace11311902interlace
interlend10310112interlend
interlent9416732interlent
interlinear11145692interlinear
interliners11138692interliners
interlinked1644842interlinked
interlinks14137502interlinks
interlope1149182interlope
interlude1047292interlude
interne73218142inter__ne
interning10315252interning
interring10315422interring
intertie8317612interti_e
intertwine1347612intertwine
intervene12912242intervene
interzone1849352interzone
intestine9411852intestine
underline101714672underline
waterline1249652waterline
afterlife1543183afterlife
anserine8313083anser_ine
anticline11410703anticline
berline93716853__berline
centerlines1346993centerlines
dateline9810353date_line
determine1249033determine
entering91920053enter_ing
extermine1848283extermine
fingerlike1842943fingerlike
fingerling1544833fingerling
hinterland1443473hinterland
incline9314643in__cline
induline939493in_duline
inertiae8411473in_ertiae
inferring1338613inferring
infertile1248673infertile
inhering12913713inher_ing
innerving1346493innerving
inquiline1844753inquiline
inserting10914233inserting
inshrine1147483inshr_ine
intending1139983intending
intensive1248403intensive
interage9314483inter_age
interbank1547033interbank
intercede121210983intercede
intercity14410003intercity
interclan1148603interclan_
interdict12410213interdict
interface14410163interface
interfere12410813interfere
interfiber1545803interfiber
interfiled1447653interfiled
interfiles1349993interfiles
interfiling1546953interfiling
interfirm1446443interfirm
interfluve1643873interfluve
interfuse1247433interfuse
intergang11117883intergang
interim9912873inter_i_m
interims101013073inter_ims
interior8513093inter_ior
interjoin1647893interjoin_
interjoined1944943interjoined
interjoins1747953interjoins
interknit1358333interknit
interlaced1349223interlaced
interlaces12412043interlaces
interlacing1449053interlacing
interlaid1049353interlaid
interlap1048593interl_ap
interlaps1148233interlaps
interlard1048453interlard
interlay11310043interl_ay
interlayer1346923interlayer
interlaying1547573interlaying
interlays1248083interlays
interleaf1248043interleaf
interleave1347613interleave
interlends1148603interlends
interlinears12144583interlinears
interlining1249133interlining
interloan948773interloan
interloans1048263interloans
interlock1546233interlock
interloop1145833interloop
interloped1347633interloped
interloper1247473interloper
interlopes1249273interlopes
interloping1446963interloping
interludes1147393interludes
interlunar1045433interlunar
intermale11712293intermale
interment11419223interment
intermingle1445763intermingle
intermit101213593intermi_t
intermits111212203intermits
intermix17156873intermi_x
intermixed2046103intermixed
intermixes1948393intermixes
intermont11513573intermont
intern64016543inter__n_
internalise111510553internalise
internalize20149593internalize
internecine1367873internecine
interned93016653inter__ned
internee82718513inter_nee
internes82721233inter__nes
internist9414883internist
internode1048763internode
interns73116773inter__ns
interplant12119573interplant
interpoint12411883interpoint
interpose11410463interpose
interrace11312543interrace
interstice1249593interstice
interties9320333interties
intertill9410423intertill
intertwined1544593intertwined
intertwines1446643intertwines
interunit959833interunit
intervale12911583intervale
intervened14109053intervened
intervener13109013intervener
intervenes131012643intervenes
interview1547363interview
interwove1547143interwove
intestines10410253intestines
inthrone1179473inthr_one
intine61021983int___ine
intitling1037213intitling
intorting10311413intorting
intwine1038513int__wine
inversing1389623inversing
inversive1557193inversive
invertin11910233invertin_
inverting131013223inverting
invertins12911023invertins
nervine102510623_n_ervine
niterie7313743niter_i_e
pincerlike1843003pincerlike
sintering101014803sinter_ing
sterling93615553_sterling
terrine72517573__terrine
timberline1473833timberline
underlie91413123underli_e
underlined121610213underlined
underlines111512113underlines
underling111514613underling
undermine122012233undermine
uterine7315193_uter_ine
vitelline1285853vitelline
waterlines1348953waterlines
wintering13412363winter_ing
winterize2146923winter_ize
wintertide1444453wintertide
wintertime1543813wintertime

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.1561145455.1
2DLD Change Limit1486411647.56319653.7
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.79522923.8
 
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.