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

129 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
interlines10111645(None) 
interline91218011interline_
interlined111211261interlined
interliner101311151interliner
interliners11138691interliners
interlinks14137501interlinks
centerlines1346992centerlines
interfiles1349992interfiles
interlaces12412052interlaces
interlends1148602interlends
interlinear11145692interlinear
interlinears12144582interlinears
interlink131310662interlin_k
interlinked1644842interlinked
interlopes1249272interlopes
interludes1147392interludes
intermixes1948392intermixes
internes82721232inter__nes
interties9320332interti_es
intertwines1446642intertwines
intervenes131012652intervenes
intestines10410252intestines
underlines111512112underlines
waterlines1348952waterlines
afterlifes1643183afterlifes
afterlives1643553afterlives
anserines9411293anser_ines
anticlines1249363anticlines
berlines102315453__berlines
centerline1247043centerline_
datelines1088853date_lines
determines1358433determines
extermines1947783extermines
fingerlings1642893fingerlings
gingerliness1452793gingerliness
hinterlands1553003hinterlands
inclines10313143in__clines
indulines1057763in_dulines
inquilines1944373inquilines
inshrines1246533inshr_ines
intensives1347393intensives
intercedes131610433intercedes
interdicts1347083interdicts
interfaces15410413interfaces
interferes1349983interferes
interfiber1545803interfiber
interfile12411043interfile_
interfiled1447653interfiled
interfluves1743853interfluves
interfuses1347683interfuses
interims101013073inter_i_ms
interiors9513563inter_iors
interjoined1944943interjoined
interjoins1747953interjoin_s
interknits1456203interknits
interlace11311913interlace_
interlaced1349233interlaced
interlaps1148233interl_aps
interlards1146813interlards
interlayer1346923interlayer
interlayers1445333interlayers
interlays1248083interl_ays
interleaves1447053interleaves
interlend10310113interlen_d
interlent9416733interlen_t
interlining1249133interlining
interlinings1355063interlinings
interloans1048263interloans
interlocks1645973interlocks
interloops1245483interloops
interlope1149183interlope_
interloped1347633interloped
interloper1247473interloper
interlopers1346193interlopers
interlude1047293interlude_
interlunar1045433interlunar
interments12716213interments
intermingles1574393intermingles
intermits111212203intermi_ts
intermixed2046103intermixed
internalises12149113internalises
internalizes21138693internalizes
interne73218153inter__ne_
interned93016653inter__ned
internee82718523inter__nee
internees93014843inter_nees
interning10315253internin_g
internists10410243internists
internodes1148673internodes
interns73116773inter__n_s
interplants13116753interplants
interposes12410563interposes
interreges1148843interreges
interring10315423interrin_g
intersexes1747913intersexes
interstices1348523interstices
intertie8317613interti_e_
intertills1048223intertills
intertwine1347613intertwine_
intertwined1544593intertwined
intervales131010513intervales
intervene12912253intervene_
intervened14109063intervened
intervener13109023intervener
interveners14107303interveners
interview1547363intervi_ew
interviews1645263interviews
interzone1849363interzone_
intestine9411853intestine_
inthrones1299673inthr_ones
intines7921113int___ines
intwines1138043int__wines
invertins12911023invertin_s
nervines112310463_n_ervines
niteries8318383niter_i_es
painterliness1572433painterliness
sterlings10308753_sterlings
terrines82117553__terrines
timberlines1583283timberlines
underlies101414203underli_es
underline101714673underline_
underlined121610213underlined
underlings12178143underlings
undermines131710663undermines
vitellines1394733vitellines
waterline1249653waterline_
winterizes2247143winter_izes
wintertides1544463wintertides
wintertimes1643903wintertimes

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031296.39022003.6
3Display Results1291290.0632047.6
 (SQL Overall)1786911296.85926052.0
 
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.