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

174 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
interage931449(None) 
integrate10911152integrate
interact10316472interact
interface14410172interface
interlace11311912interlace
intermale11712312intermale
interne73218152inter_ne
internee82718522internee
interrace11312552interrace
interstage1176402interstage
intertie8317612intertie
intervale12911602intervale
iterate71119112i_terate
meterage1147932meterage
underage101012272underage
waterage1248672waterage
amperage1347743amperage
antedate949693antedate
antirape10410113antirape
average1158853_average
beverage1445143beverage
coverage1438733coverage
deterge9118463deter_ge
enrage72715073en__rage
entera64216833entera__
enterable11312643enterable
enteral73516453entera_l
entourage1043923entourage
esterase849483esterase
fosterage1344663fosterage
immerge1244703immer_ge
incage93513623in__cage
increase1066453increase
increate10312203increate
indurate9311873indurate
inferable14411273inferable
ingrate8715123in_grate
inhere9313713inher__e
innage73011573in__nage
innervate1246613innervate
innerve1056753inner_ve
intake10510863int__ake
integer837993inte__ger
integrable1348403integrable
integral946793integra_l
integrals1046473integrals
integrand1145033integrand
integrant1049833integrant
integrated1289293integrated
integrates111010783integrates
intenerate1048753intenerate
intense72511903inte_nse
inter55028493inter___
interacted13411213interacted
interacts11312123interacts
interagency1754913interagency
interarch1446723interarch
interbank1547043interbank
interbed112413103interbed
interbred1248743interbred
intercaste1249283intercaste
intercede121210983intercede
interchange17104583interchange
intercom1248683intercom
intercut10411113intercut
interest8319183interest
interfaced1647953interfaced
interfaces15410413interfaces
interfere12410813interfere
interfile12411043interfile
interfuse1247433interfuse
intergang11117893intergang
intergrade1247363intergrade
interim9912873inter_im
interims101013073interims
interior8513113interior
interlaced1349243interlaced
interlaces12412053interlaces
interlaid1049353interlaid
interlap1048593interlap
interlaps1148233interlaps
interlard1048453interlard
interlay11310043interlay
interlayer1346923interlayer
interlays1248083interlays
interleave1347613interleave
interline91218013interline
interlope1149183interlope
interlude1047293interlude
intermat101114613intermat
intermats111412453intermats
intermit101213593intermit
intermix17156873intermix
intern64016543inter__n
internal8414093internal
internals9712733internals
interned93016653interned
internees93014843internees
internes82721233internes
internode1048763internode
interns73116773inter_ns
interphase1546003interphase
interpled1239603interpled
interpose11410463interpose
interpret11413363interpret
interred92615263interred
interreges1148843interreges
interrex15249823interrex
interrogee1147203interrogee
interrow1147143interrow
inters64328053inter__s
intersex15209733intersex
interspace1446153interspace
interstate10710973interstate
interties9320343interties
interval11710473interval
intervales131010513intervales
intervals12810153intervals
intervene12912253intervene
interview1547363interview
interwar1148263interwar
interweave1646253interweave
interwove1547143interwove
interzone1849363interzone
intestate9159873intestate
inthral10249463inthra_l
inthrall11247063inthrall
inthrals11258503inthrals
inthrone1179473inthrone
intimae9109753intima_e
intimate101013833intimate
intonate8310923intonate
intranet8418443int_ranet
intrant7318753int_rant
intreat7416303intrea_t
intreated10312663intreated
intreats8311553intreats
intrigue945233int_rigue
intrude837403int_rude
intubate1047533intubate
inverse10249643inver_se
invertase1245833invertase
inveterate1345253inveterate
inweave1344723inwe_ave
iterance1049523i_terance
iterant7317783i_terant
iterated91213833i_terated
iterates81317823i_terates
layerage1244963layerage
leverage1285393leverage
lighterage1552543lighterage
lineage878983lin_e_age
literate81216893literate
meterages1248183meterages
mintage101110123mint__age
niterie7313743niter_ie
nitrate72017013nit_rate
outrage82616893out_rage
overage11514053_overage
peerage1089803_peerage
pilferage1542603pilferage
porterage1245773porterage
sewerage1245513sewerage
steerage946833steerage
storage8310473_storage
tutelage944063tutelage
tutorage945743tutorage
unaverage1343553unaverage
underaged121011243underaged
underages11811083underages
underate9918603underate
vintage11128143vint__age
waterages1349393waterages
winterize2146923winterize

Search took 10 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.423422437.4
2DLD Change Limit1461621748.86016496.8
3Display Results1741740.0802175.0
 (SQL Overall)1786911749.36319084.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.