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 “ranges” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

209 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
ranges7382693(None) 
granges93516521granges
manges94628951manges
oranges84215331oranges
rages64539441ra_ges
rances84625441rances
ranees64623961ranees
range64728421range_
ranged84824321ranged
ranger73925531ranger
rangers83621041rangers
ages55844592_a_ges
anes45255932_an_es
angas65827992_angas
angel65019572_angel
angels74416172_angels
anger66225882_anger
angers75222542_angers
angles74426702_angles
antes56334322_antes
arranges939412arranges
badges103917372badges
banes74945582ban_es
banged104923732banged
banger94423642banger
bangers104020352bangers
bangles103617412bangles
bangs85627782bang_s
barges94528252barges
binges93923122binges
cadges104716712cadges
cages85936012ca_ges
canes75350372can_es
cangues10611822cangues
canoes84725882canoes
changes134517582changes
conges94928172conges
cranes84330752cran_es
cringes103215502cringes
dances95120652dances
danged94819492danged
danger83722832danger
dangers94818212dangers
dangles93618422dangles
dangs75623212dang_s
deranges1039972deranges
dinges83825422dinges
fadges114814032fadges
fanes84639892fan_es
fangas105017202fangas
fanged114318232fanged
fangs96224082fang_s
flanges113413272flanges
fringes113514102fringes
gages74529972ga_ges
ganged94619202ganged
ganger83721472ganger
gangers94418602gangers
gangs76222582gang_s
gangues9149752gangues
gauges85915992gauges
grange83716202grange_
granger93514212granger
grangers103011972grangers
grunges93310402grunges
hances115621282hances
hanged114222402hanged
hanger104023262hanger
hangers113120812hangers
hangs95726732hang_s
hanses95022632hanses
henges104516462henges
hinges105121032hinges
janes124928122jan_es
jangles154015682jangles
kanes95529372kan_es
lances84824102lances
lanes54946792lan_es
langues81211912langues
larges74824232larges
longes75925572longes
lunges76123422lunges
mages85036022ma_ges
manages103418962manages
maneges103612142maneges
manes76648962man_es
mangas94122932mangas
mange84930202mange_
mangel94017542mangel
mangels103614492mangels
manger94325012manger
mangers103521262mangers
mangey123614532mangey
mangles104021462mangles
mangoes104316132mangoes
mangos94319342mangos
manses84225512manses
mantes84430782mantes
marges94525712marges
nances83618642nances
orange74016322orange_
orangey11388832orangey
orangs74116032orang_s
pages85235072pa_ges
panes76148692pan_es
pangas99921112pangas
panged104722342panged
pangen94115922pangen
pangens103112072pangens
pangs84628672pang_s
pannes85522852pannes
parges94529542parges
prances113618782prances
pranged114512552pranged
prangs94816232prang_s
rabies85226022rabies
races74943242ra_ces
ragas65326062ra_gas
rage55742352ra_ge_
raged74829452ra_ged
ragee65432662ra_gee
ragees74618662ragees
ragged94620262ragged
raggee84217602raggee
raggees93710912raggees
raggies93214732raggies
raggles93813282raggles
raggs75216472ra_ggs
ragis66325602ra_gis
rags55448372ra_g_s
raises64826542raises
rajes125022782ra_jes
rakees104516972rakees
rakes94440352ra_kes
rales54947492ra_les
ramees84620892ramees
ramies84630462ramies
rance75028512rance_
ranches123620112ranches
randies84225662randies
rands65930452ran_ds
ranee55438102ran_ee
rang56939172rang__
rangier83714352rangier
rangiest93115982rangiest
rangy95320392rang_y
ranids75118702ranids
ranis55235842ran_is
ranked114620742ranked
ranker105021902ranker
rankers113217462rankers
rankest112713812rankest
rankles113114552rankles
ranks95225732ran_ks
ranted74324702ranted
ranter63826822ranter
ranters73323642ranters
rants55935342ran_ts
rapes75740722ra_pes
raphes115117452raphes
rares55247442ra_res
rases55447212ra_ses
rashes95330152rashes
rates55352012ra_tes
ravages1139402ravages
raves85441972ra_ves
raxes124729392ra_xes
razees154314762razees
razes145032702ra_zes
razzes144910072razzes
reges65628792r_eges
reneges82513592reneges
rentes65431192rentes
ridges85817012ridges
ringed84623842ringed
ringer74526062ringer
ringers83922952ringers
rings65029172ring_s
rinses64720382rinses
rouges76022382rouges
runes55530222run_es
rungs611819402rung_s
sages65339062sa_ges
sanes55649072san_es
sangas75222662sangas
sanger74524572sanger
sangers84421942sangers
sanghs105312072sanghs
sanies63031952sanies
sarges75128592sarges
singes74326852singes
stranges94516762stranges
tanged84622512tanged
tangles83920052tangles
tangos74216322tangos
tangs65028362tang_s
targes74524602targes
tinges74722342tinges
trances93919642trances
vanes85130982van_es
vangs96319602vang_s
venges104015152venges
wages95330932wa_ges
wanes85040882wan_es
wangles113416932wangles
wrangles1237472wrangles
wrangs104611912wrang_s
yangs95618702yang_s
zanies153219672zanies

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit825512092.87328733.4
3Display Results2092090.0633317.5
 (SQL Overall)1786912093.31253952.6
 
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.