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
ranges7382692(None) 
granges93516521granges
manges94628941manges
oranges84215331oranges
rages64539441ra_ges
rances84625441rances
ranees64623961ranees
range64728411range_
ranged84824311ranged
ranger73925521ranger
rangers83621041rangers
ages55844592_a_ges
anes45255932_an_es
angas65827982_angas
angel65019562_angel
angels74416172_angels
anger66225872_anger
angers75222542_angers
angles74426702_angles
antes56334322_antes
arranges939412arranges
badges103917372badges
banes74945582ban_es
banged104923722banged
banger94423632banger
bangers104020352bangers
bangles103617412bangles
bangs85627772bang_s
barges94528252barges
binges93923122binges
cadges104716712cadges
cages85936012ca_ges
canes75350372can_es
cangues10611822cangues
canoes84725882canoes
changes134517582changes
conges94928172conges
cranes84330752cran_es
cringes103215502cringes
dances95120652dances
danged94819482danged
danger83722822danger
dangers94818212dangers
dangles93618422dangles
dangs75623202dang_s
deranges1039972deranges
dinges83825422dinges
fadges114814032fadges
fanes84639892fan_es
fangas105017192fangas
fanged114318222fanged
fangs96224072fang_s
flanges113413272flanges
fringes113514102fringes
gages74529972ga_ges
ganged94619192ganged
ganger83721462ganger
gangers94418602gangers
gangs76222572gang_s
gangues9149752gangues
gauges85915992gauges
grange83716202grange_
granger93514212granger
grangers103011972grangers
grunges93310402grunges
hances115621282hances
hanged114222392hanged
hanger104023252hanger
hangers113120812hangers
hangs95726722hang_s
hanses95022632hanses
henges104516462henges
hinges105121032hinges
janes124928122jan_es
jangles154015682jangles
kanes95529372kan_es
lances84824102lances
lanes54946792lan_es
langues81211912langues
larges74824232larges
longes75925572longes
lunges76123422lunges
mages85036022ma_ges
manages103418962manages
maneges103612142maneges
manes76648962man_es
mangas94122922mangas
mange84930192mange_
mangel94017532mangel
mangels103614492mangels
manger94325002manger
mangers103521262mangers
mangey123614522mangey
mangles104021462mangles
mangoes104316132mangoes
mangos94319332mangos
manses84225512manses
mantes84430782mantes
marges94525712marges
nances83618642nances
orange74016322orange_
orangey11388832orangey
orangs74116032orang_s
pages85235072pa_ges
panes76148692pan_es
pangas99921102pangas
panged104722332panged
pangen94115912pangen
pangens103112062pangens
pangs84628662pang_s
pannes85522852pannes
parges94529542parges
prances113618772prances
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
rang56939162rang__
rangier83714352rangier
rangiest93115982rangiest
rangy95320382rang_y
ranids75118702ranids
ranis55235832ran_is
ranked114620742ranked
ranker105021902ranker
rankers113217462rankers
rankest112713812rankest
rankles113114542rankles
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
sangas75222652sangas
sanger74524562sanger
sangers84421942sangers
sanghs105312062sanghs
sanies63031952sanies
sarges75128592sarges
singes74326852singes
stranges94516762stranges
tanged84622492tanged
tangles83920042tangles
tangos74216302tangos
tangs65028342tang_s
targes74524592targes
tinges74722332tinges
trances93919642trances
vanes85130972van_es
vangs96319582vang_s
venges104015152venges
wages95330932wa_ges
wanes85040882wan_es
wangles113416932wangles
wrangles1237462wrangles
wrangs104611912wrang_s
yangs95618692yang_s
zanies153219672zanies

Search took 3 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.343520965.0
2DLD Change Limit825512092.33035429.6
3Display Results2092090.0603483.3
 (SQL Overall)1786912092.73365382.7
 
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.