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 “intermat” 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
intermat10111461(None) 
intermats111412451intermats
intermit101213591intermit
interact10316472interact
intercut10411112intercut
interest8319182interest
interlap1048592interlap
interlay11310042interlay
intermale11712312intermale
interment11419222interment
intermits111212202intermits
intermix17156872intermix
intermont11513572intermont
internal8414092internal
interval11710472interval
interwar1148262interwar
intreat7416302int_reat
aftermath1743673aftermath
entera64216833enter_a_
enteral73516453enter_al
entreat7315263ent_reat
inerrant8412493in_errant
inert53234373in_er__t
infernal1186833infernal
informal1355643informal
informant1446473informant
inherent11412793inherent
inherit10312973inher_it
innermost1144583innermost
innervate1246613innervate
insert64325253inser__t
integral946793integral
integrant1049833integrant
integrate10911153integrate
intendant1047713intendant
intent63122773inte__nt
inter55028493inter___
interacts11312123interacts
interage9314493interage
interbank1547043interbank
interbed112413103interbed
intercaste1249283intercaste
intercept13410973intercept
intercity14410003intercity
interclan1148603interclan
intercom1248683intercom
intercuts1148793intercuts
interdict12410213interdict
interests9312553interests
interface14410173interface
interfaith1645923interfaith
intergang11117893intergang
intergraft1446173intergraft
interim9912873inter_im
interims101013073interims
interior8513113interior
interject1849603interject
interknit1358333interknit
interknot1356903interknot
interlace11311913interlace
interlaid1049353interlaid
interlaps1148233interlaps
interlard1048453interlard
interlays1248083interlays
interleaf1248043interleaf
interlent9416733interlent
interloan948773interloan
intermarry1564153intermarry
intermatted1476303intermatted
interments12716213interments
intermesh1446703intermesh
intermodal1346183intermodal
intern64016543inter__n
internals9712733internals
interne73218153inter_ne
interned93016653interned
internee82718523internee
internes82721233internes
internist9414883internist
internment12412253internment
interns73116773inter_ns
interparty1546853interparty
interplant12119573interplant
interplay1447163interplay
interpret11413363interpret
interrace11312553interrace
interred92615263interred
interrex15249823interrex
interrow1147143interrow
interrupt1147243interrupt
inters64328053inter__s
intersect11412113intersect
intersex15209733intersex
interstate10710973interstate
intertie8317613intertie
interunit959843interunit
intervale12911603intervale
intervals12810153intervals
intestate9159873intestate
inthral10249463inthr_al
intima81910033int_ima_
intimae9109753int_imae
intimal9109943int_imal
intimas9119583int_imas
intimate101013833int_imate
intort6418923intor__t
intrant7318753int_rant
intreats8311543int_reats
introit7414533int_roit
intromit1048743intromit
intrust7311493int_rust
invert94120083inver__t
iterant7317783i_terant
iterate71119113i_ter_ate
littermate1243193littermate
undereat9313903undereat
waterman1397283waterman

Search took 9 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.436409841.7
2DLD Change Limit1461621178.04618165.8
3Display Results1171170.0631857.1
 (SQL Overall)1786911178.54520911.8
 
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.