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

109 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
intermats11141245(None) 
intermat101114611intermat_
intermits111212201intermits
interacts11312122interacts
intercuts1148792intercuts
interests9312552interests
interlaps1148232interlaps
interlays1248082interlays
intermale11712312intermale
interments12716212interments
intermit101213592intermit_
internals9712732internals
intervals12810152intervals
intreats8311552int_reats
aftermath1743673aftermath
aftermaths1853003aftermaths
entreats839783ent_reats
entremets1147143entremets
inerts64517023in_er__ts
informants1544633informants
inherits11310103inher_its
innermost1144583innermost
innermosts1242933innermosts
innervate1246613innervate
innervates1346403innervates
inserts74013993inser__ts
integrals1046473integrals
integrants1146693integrants
integrate10911153integrate
integrates111010783integrates
intendants1145253intendants
intents72115703inte__nts
interact10316473inter_act
interage9314493inter_age
interbank1547043interbank
interbeds12238903interbeds
intercaste1249283intercaste
intercepts1448643intercepts
intercity14410003intercity
interclass1247003interclass
intercoms1349343intercoms
intercut10411113intercut_
interdicts1347083interdicts
interest8319183interest_
interface14410173interface
interfaces15410413interfaces
interfaith1645923interfaith
intergang11117893intergang
intergrafts1544413intergrafts
interims101013073inter_ims
interiors9513583interiors
interjects1947533interjects
interknits1456203interknits
interknots1455023interknots
interlace11311913interlace
interlaces12412053interlaces
interlaid1049353interlaid
interlap1048593interla_p
interlard1048453interlard
interlards1146813interlards
interlay11310043interla_y
interloans1048263interloans
intermarry1564153intermarry
intermatted1476303intermatted
interment11419223interment
intermesh1446703intermesh
intermix17156873interm_ix
intermixes1948393intermixes
intermont11513573intermont
internal8414093interna_l
internees93014843internees
internes82721233inter_nes
internist9414883internist
internists10410243internists
internments13510283internments
interns73116773inter__ns
interparty1546853interparty
interplants13116753interplants
interplays1545523interplays
interprets1249333interprets
interrace11312553interrace
interrupts1245743interrupts
inters64328053inter___s
intersects1249153intersects
interstate10710973interstate
interstates11710203interstates
interties9320343interties
interval11710473interva_l
intervale12911603intervale
intervales131010513intervales
interwar1148263interwa_r
intestate9159873intestate
intestates10159433intestates
inthrals11258503inthr_als
intimas9119583int_ima_s
intimate101013833int_imate
intimates111013313int_imates
intorts7310973intor__ts
intrants8312863int_rants
intreat7416303int_reat_
introits859713int_roits
intromits1166213intromits
intrusts837723int_rusts
inverts103211953inver__ts
iterate71119113i_ter_ate
iterates81317823i_ter_ates
littermate1243193littermate
littermates1352863littermates
undereats10310223undereats

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 Limit1486411097.42320024.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.89222642.0
 
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.