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

168 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
hangers11312081(None) 
angers75222541_angers
bangers104020351bangers
changers144313201changers
dangers94818211dangers
gangers94418601gangers
handers114224331handers
hangars114313491hangars
hanger104023261hanger_
hankers144218131hankers
hingers113420211hingers
hungers114013301hungers
mangers103521261mangers
rangers83621041rangers
sangers84421941sangers
agers65027852_a_gers
aggers85817792_aggers
angels74416172_angels
anger66225882_anger_
anglers84014822_anglers
augers73818702_augers
badgers114812652badgers
baggers113915692baggers
banders104324562banders
banger94423642banger_
bankers133919092bankers
banners94018712banners
banters94623112banters
bingers104519992bingers
cadgers114712002cadgers
cagers95624192ca_gers
cancers114018582cancers
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
chancers154313492chancers
changer134215542changer_
changes134517582change_s
chanters134016742chanters
chargers144011322chargers
clangers114312342clangers
congers104223232congers
daggers103714912daggers
dancers103413092dancers
danders93921182danders
danger83722832danger_
danglers103610592danglers
dingers94321382dingers
eagers74523682ea_gers
fanners103914652fanners
fingers113418432fingers
flangers123311372flangers
gagers84021332ga_gers
gaggers103413662gaggers
ganders93521702ganders
ganger83721472ganger_
gaugers94211712gaugers
gingers94118642gingers
grangers103011972grangers
hackers164619042hackers
hafters134614332hafters
hagglers13326622hagglers
hailers104017262hailers
halers94926912ha_lers
halters104619802halters
halvers133311422halvers
hammers144216062hammers
hampers143616952hampers
hanapers1346962hanapers
hances115621282hance_s
hander104526432hander_
handlers124014142handlers
hangar104114522hangar_
hanged114222402hange_d
hangovers16144162hangovers
hangs95726732hang__s
hangups1364822hangups
hanker134622092hanker_
hansels104011662hansels
hanses95022632hanse_s
harmers124116592harmers
harpers124916202harpers
haters94930402ha_ters
hatters104221522hatters
haulers104012442haulers
haunters11329542haunters
havers124721482ha_vers
hawkers174210332hawkers
hawsers13409482hawsers
hayers124415942ha_yers
hazers184615952ha_zers
hedgers124310262hedgers
henges104516462henge_s
hinders113718502hinders
hinger104723332hinger_
hinges105121032hinge_s
hinters103719582hinters
hoggers124512482hoggers
honers94324972hon_ers
honkers143315232honkers
huggers124211592huggers
hunger104015202hunger_
hunkers143314332hunkers
hunters103915732hunters
jaegers15307102jaegers
jagers144415722ja_gers
jaggers164012892jaggers
janglers16319372janglers
laagers83411252laagers
lagers74826142la_gers
laggers94216242laggers
lancers93616642lancers
landers84026212landers
langurs889102langurs
lanners73618332lanners
lingers84223302lingers
longers84819542longers
lungers83817092lungers
managers112911002managers
mangels103614492mangels
manger94325012manger_
manges94628952mange_s
manglers113311902manglers
manners93417832manners
mongers104217272mongers
naggers93812652naggers
onagers838102onagers
pagers94423252pa_gers
panders103423732panders
pangens103112062pangens
paniers94717332paniers
panners93621272panners
panzers184012012panzers
pingers104020742pingers
ranger73925532ranger_
ranges73826932range_s
rankers113217462rankers
ranters73323642ranters
ringers83922952ringers
saggers94017082saggers
sanders84025942sanders
sangars83116252sangars
sanger74524572sanger_
saugers83914052saugers
singers83824702singers
taggers93514192taggers
tanagers9259002tanagers
tanglers92911972tanglers
tankers113416912tankers
tanners74018392tanners
thankers15297832thankers
tongers84116012tongers
twangers12226062twangers
vanners103612842vanners
wagers105122202wa_gers
waggers124613082waggers
wanders114221332wanders
wanglers123310032wanglers
wankers144514712wankers
wanters104420092wanters
whangees15275062whangees
whingers15358722whingers
wingers113921482wingers
yagers105114532ya_gers
zanders173015792zanders
zingers173514852zingers

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.376475242.0
2DLD Change Limit1076711683.34332207.9
3Display Results1681680.0632666.7
 (SQL Overall)1786911683.78247247.8
 
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.