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

176 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
rangers8362104(None) 
angers75222541_angers
bangers104020351bangers
dangers94818211dangers
gangers94418601gangers
grangers103011971grangers
hangers113120811hangers
mangers103521261mangers
ranger73925521ranger_
ranges73826921range_s
rankers113217461rankers
ranters73323641ranters
ringers83922941ringers
sangers84421941sangers
agers65027852_a_gers
aggers85817792_aggers
angels74416172_angels
anger66225872_anger_
anglers84014822_anglers
arrangers1045812arrangers
augers73818702_augers
badgers114812642badgers
baggers113915692baggers
banders104324562banders
banger94423632banger_
bankers133919092bankers
banners94018712banners
banters94623112banters
bingers104519982bingers
braggers12327902braggers
branders114313092branders
branners104010922branners
bringers112811072bringers
cadgers114711992cadgers
cagers95624182ca_gers
cancers114018582cancers
caners84629192can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827722canters
changers144313192changers
clangers114312342clangers
congers104223232congers
cringers112511872cringers
daggers103714912daggers
dancers103413092dancers
danders93921182danders
danger83722822danger_
danglers103610592danglers
derangers1136702derangers
dingers94321372dingers
draggers11357382draggers
eagers74523682ea_gers
fanners103914652fanners
fingers113418422fingers
flangers123311372flangers
frankers15348352frankers
gagers84021322ga_gers
gaggers103413662gaggers
ganders93521702ganders
ganger83721462ganger_
gaugers94211702gaugers
gingers94118632gingers
granger93514212granger_
granges93516522grange_s
granters93614132granters
grungers10298502grungers
handers114224332handers
hangars114313482hangars
hanger104023252hanger_
hankers144218132hankers
hingers113420192hingers
hungers114013302hungers
jaegers15307102jaegers
jagers144415722ja_gers
jaggers164012892jaggers
janglers16319372janglers
laagers83411252laagers
lagers74826142la_gers
laggers94216242laggers
lancers93616642lancers
landers84026212landers
langurs889102langurs
lanners73618322lanners
lingers84223292lingers
longers84819532longers
lungers83817082lungers
managers112911002managers
mangels103614492mangels
manger94325002manger_
manges94628942mange_s
manglers113311902manglers
manners93417832manners
mongers104217272mongers
naggers93812652naggers
onagers838102onagers
orangery12305542orangery
oranges84215332orange_s
pagers94423252pa_gers
panders103423732panders
pangens103112062pangens
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pingers104020732pingers
prancers123210332prancers
racers84725432ra_cers
rackers134320452rackers
rafters103715632rafters
ragees74618662ra_gees
rages64539442ra_ge_s
raggees93710912raggees
raiders84615142raiders
railers74420662railers
raisers73617392raisers
rakers104123572ra_kers
rammers113715042rammers
rances84625442rance_s
ranchers133311792ranchers
rancors9811372rancors
ranees64623962ran_ees
range64728412range__
ranged84824312range_d
rangier83714352rangier_
ranker105021902ranker_
ranter63826822ranter_
rapers84327182ra_pers
rapiers95012872rapiers
rappers113618442rappers
rasers64526782ra_sers
rashers104020902rashers
raspers94415912raspers
rasters74629022rasters
raters63936572ra_ters
ratters74422472ratters
ravagers1235572ravagers
ravers94628182ra_vers
razers154919612ra_zers
renders83821672renders
renegers9248792renegers
renters74224812renters
riggers93613832riggers
ringer74526052ringer_
rinsers73815742rinsers
rogers74517912r_ogers
ruggers94612312ruggers
runners74212452runners
saggers94017082saggers
sanders84025942sanders
sangars83116252sangars
sanger74524562sanger_
saugers83914052saugers
singers83824692singers
strangers104112152strangers
taggers93514192taggers
tanagers9259002tanagers
tanglers92911972tanglers
tankers113416912tankers
tanners74018392tanners
tongers84116012tongers
twangers12226062twangers
vanners103612842vanners
wagers105122202wa_gers
waggers124613082waggers
wanders114221332wanders
wanglers123310032wanglers
wankers144514712wankers
wanters104420092wanters
wingers113921472wingers
wranglers1344272wranglers
wringers123110072wringers
wrongers12327772wrongers
yagers105114532ya_gers
zanders173015792zanders
zingers173514842zingers

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 Filter1786911076710.233766914.2
2DLD Change Limit1076711763.48330913.3
3Display Results1761760.0632793.7
 (SQL Overall)1786911763.77947285.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.