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

219 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
ranger7392552(None) 
anger66225871_anger
banger94423631banger
danger83722821danger
ganger83721461ganger
granger93514211granger
hanger104023251hanger
manger94325001manger
range64728411range_
ranged84824311ranged
rangers83621041rangers
ranges73826921ranges
rangier83714351rangier
ranker105021901ranker
ranter63826821ranter
ringer74526061ringer
sanger74524561sanger
ager55935842_a_ger
agger76420892_agger
angel65019562_angel
angers75222542_angers
angler74017862_angler
arranger936872arranger
auger64922472_auger
badger105415082badger
bagger104619202bagger
bander93928222bander
banged104923722banged
bangers104020352bangers
banker124222732banker
banner84421502banner
banter84825332banter
binger94923452binger
bragger113810042bragger
brander103915822brander
branner94212372branner
bringer104213352bringer
cadger105013912cadger
cager85229222ca_ger
cancer104220922cancer
caner75334772can_er
canker124422522canker
canner84625982canner
canoer85121072canoer
canter85230112canter
changer134215542changer
clanger104113492clanger
conger95024272conger
cranker133612782cranker
cringer103514242cringer
dagger95017302dagger
dancer94817612dancer
dander811222992dander
danged94819482danged
dangers94818212dangers
dangler96912812dangler
danker114319662danker
deranger1037352deranger
dinger85323672dinger
dragger10309172dragger
eager65526972ea_ger
fanged114318222fanged
fanner94218182fanner
finger104920332finger
flanger113412622flanger
franker143510182franker
gager74726292ga_ger
gagger95016512gagger
gander84322762gander
ganged94619192ganged
gangers94418602gangers
gauger84714852gauger
ginger84920032ginger
grander93315872grander
grange83716202grange_
grangers103011972grangers
granges93516522granges
granter84117132granter
grunger9389782grunger
hander104526432hander
hangar104114512hangar
hanged114222392hanged
hangers113120812hangers
hanker134622092hanker
hinger104723332hinger
hunger104015202hunger
jaeger14397192jaeger
jager134318132ja_ger
jagger154016002jagger
jangler153811832jangler
laager74312782laager
lager65132862la_ger
lagger85919832lagger
lancer84319972lancer
lander74028482lander
langur7109302langur
lanker104123002lanker
lanner64920602lanner
larger74417512larger
linger75226002linger
longer75823202longer
lunger75720422lunger
manager103413582manager
mange84930192mange_
mangel94017532mangel
mangers103521262mangers
manges94628942manges
mangey123614522mangey
mangier104114062mangier
mangler103215642mangler
manner84020512manner
mauger93813482mauger
monger94418332monger
nagger84016122nagger
onager739662onager
orange74016322orange_
orangery12305542orangery
oranges84215332oranges
orangey11388832orangey
orangier947712orangier
pager84728202pa_ger
pander93725522pander
panged104722332panged
pangen94115912pangen
panier84425502panier
panner84224762panner
panzer174213232panzer
pinger94324092pinger
prancer113613382prancer
pranged114512552pranged
racer75233022ra_cer
racier85120972racier
racker124824552racker
rafter94517582rafter
rage55742352ra_ge_
raged74829452ra_ged
ragee65432662ra_gee
rages64539442ra_ges
ragged94620262ragged
raggee84217602raggee
raider74318742raider
railer64524932railer
rainier71614262rainier
raiser66620102raiser
raker94529792ra_ker
rammer103519652rammer
rance75028512rance_
rances84625442rances
rancher123013632rancher
rancor8810372rancor
randier83618472randier
ranee55438102ran_ee
ranees64623962ranees
rang56939162rang__
rangy95320382rang_y
ranked114620742ranked
rankers113217462rankers
ranted74324702ranted
ranters73323642ranters
raper74932752ra_per
rapier84019992rapier
rapper104621572rapper
rarer54731702ra_rer
raser55633412ra_ser
rasher95024122rasher
rasper83917332rasper
raster64731442raster
rater54943282ra_ter
rather94319742rather
ratter64326312ratter
ravager1136552ravager
raver85631492ra_ver
rawer84623732ra_wer
razer144824272ra_zer
render74024142render
reneger8299492reneger
renter64527412renter
rigger85616712rigger
ringed84623842ringed
ringers83922952ringers
rinser64317212rinser
roger64521412r_oger
rugger84414512rugger
runner63814462runner
sager65432052sa_ger
sagger84321072sagger
sander74828532sander
saner54334322san_er
sangar73617682sangar
sangers84421942sangers
sauger74316252sauger
singer74227312singer
stranger94715102stranger
tagger84017702tagger
tanager83010942tanager
tanged84622492tanged
tangier83013902tangier
tangler83515072tangler
tanker104521122tanker
tanner63722282tanner
tonger74719682tonger
twanger11327432twanger
vanner94215842vanner
wager95925052wa_ger
wagger113616012wagger
wander104423712wander
wangler113312652wangler
wanier93920682wanier
wanker134219972wanker
wanner94019622wanner
wanter94423052wanter
winger104125442winger
wrangler1245472wrangler
wringer113612452wringer
wronger11288822wronger
yager95616752ya_ger
zander163417112zander
zanier154314712zanier
zinger163816702zinger

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.360496363.9
2DLD Change Limit825512192.42334069.7
3Display Results2192190.0603650.0
 (SQL Overall)1786912192.84362853.0
 
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.