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

117 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
interlent941673(None) 
interlend10310111interlend
interment11419221interment
inherent11412792inher_ent
intellect1147442intellect
intercept13410962intercept
interest8319182inter_est
interject1849602interject
interleaf1248042interleaf
interlends1148602interlends
interline91218012interline
interlink131310662interlink
interments12716212interments
intermont11513572intermont
internment12412252internment
interplant12119572interplant
intersect11412112intersect
intervene12912252intervene
detergent11129573detergent
determent121312903determent
deterrent10128943deterrent
hinterland1443473hinterland
impellent1346443impellent
increment13411683increment
incurrent1147123incurrent
indecent11411273inde_cent
indolent91311683in_dolent
inerrant8412493in_errant
insolent81311553in_solent
insurgent1046543insurgent
integrant1049833integrant
integument1355803integument
intellects1245213intellects
intelligent1254763intelligent
intendant1047713intendant
intendment1347173intendment
intensest949103intensest
intent63122773int___ent
interact10316473inter_act
interbank1547043interbank
interbed112413103interbe_d
interbeds12238903interbeds
intercede121210983intercede
intercell1148163intercell
intercepts1448633intercepts
interclan1148603interclan_
intercut10411113inter_cut
interdental1258413interdental
interdict12410213interdict
interests9312553inter_ests
interfere12410813interfere
intergang11117893intergang
interjects1947533interjects
interknit1358333interknit
interknot1356903interknot
interlace11311913interlace
interlaid1049353interlaid
interlap1048593interl_ap
interlaps1148233interlaps
interlard1048453interlard
interlay11310043interl_ay
interlays1248083interlays
interleave1347613interleave
interlined111211263interlined
interliner101311153interliner
interlines101116453interlines
interlinks14137503interlinks
interloan948773interloan
interloans1048263interloans
interlock1546233interlock
interloop1145833interloop
interlope1149183interlope
interlude1047293interlude
interlunar1045433interlunar
intermat101114613inter_mat
intermesh1446703intermesh
intermit101213593inter_mit
intern64016543inter__n_
interne73218153inter__ne
interned93016653interne_d
internee82718523interne_e
internees93014843internees
internes82721233interne_s
interning10315253interning
internist9414883internist
internments13510283internments
interns73116773inter__ns
interplants13116753interplants
interplead1345603interplead
interpled1239603interple_d
interpoint12411883interpoint
interpret11413363interpret
interred92615263interre_d
interregna1155073interregna
interrenal1049813interrenal
interrex15249823interre_x
interring10315423interring
interrupt1147243interrupt
intersects1249153intersects
intersex15209733interse_x
interterm1148813interterm
interunit959833interunit
intervened14109063intervened
intervener13109023intervener
intervenes131012653intervenes
intervenor13106063intervenor
interzone1849363interzone
intranet8418443int_ranet
intrant7318753int_r_ant
intreat7416303int_r_eat
inurement11410513inurement
iterant7317783i_ter_ant
overlent112715293_overlent
sterlet71318473_sterle_t
underlet91516213underle_t
underwent1349053underwent
winteriest1348813winteriest

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.423422437.4
2DLD Change Limit1486411176.67022285.0
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.15624970.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.