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

119 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
lunkers11341460(None) 
bunkers133715951bunkers
clunkers14327551clunkers
dunkers123512191dunkers
flunkers15347531flunkers
funkers143712061funkers
hunkers143314331hunkers
junkers184010861junkers
linkers114317711linkers
lungers83817091lungers
lunker104718341lunker_
lurkers113910081lurkers
plunkers14328331plunkers
punkers133714851punkers
bankers133919092bankers
blinkers14388502blinkers
blunders113911342blunders
blungers11469842blungers
bonkers134015302bonkers
buckers153517452buckers
bunker124519372bunker_
bunters94717122bunters
burkers133716622burkers
buskers133414092buskers
cankers134418752cankers
clinkers14339832clinkers
clunker13419452clunker_
conkers133721042conkers
cunners93913472cunners
duckers143214712duckers
duikers12369382duikers
dunker113616462dunker_
flankers15349302flankers
flunker14389362flunker_
flunkeys18263172flunkeys
fuckers163611592fuckers
funders113813932funders
funker133915762funker_
gunners83111732gunners
hankers144218132hankers
honkers143315232honkers
hungers114013302hungers
hunker133917672hunker_
hunkeys17386192hunkeys
hunters103915732hunters
huskers143510042huskers
inkers104018832_inkers
jinkers183511812jinkers
junker174213652junker_
junkets18377622junkets
lackers134120542lackers
lakers105225152l_akers
lancers93616642lancers
landers84026212landers
lanker104123002lanker_
lanners73618332lanners
larkers113014512larkers
launders9358742launders
leakers113415422leakers
lenders84419642lenders
lickers134118252lickers
likers104620912l_ikers
liners65428852lin_ers
lingers84223302lingers
linker104321472linker_
linters73822632linters
lockers133516922lockers
loners64225812lon_ers
longers84819542longers
lookers114014072lookers
loungers9449002loungers
lubbers113913722lubbers
lugers74617022lu_gers
luggers93713482luggers
lullers73213352lullers
lumbers113815912lumbers
lumpers113514482lumpers
lunars65012812lun_ars
lunchers13349562lunchers
lunes55337772lun_e_s
lunets66914762lun_ets
lungees84412142lungees
lunger75720422lunger_
lunges76123422lunge_s
lunier64617602lunier_
lunies64723012lunie_s
lunks94822452lunk__s
lurers64217492lu_rers
lurker103613292lurker_
lusters73921442lusters
muckers153612802muckers
pinkers134118602pinkers
plinkers14309392plinkers
pluckers16316552pluckers
plunders11329832plunders
plungers11379402plungers
plunker133910652plunker_
puckers153514672puckers
punker123718822punker_
punkeys16366492punkeys
punners94114232punners
punters93617042punters
quakers20309692quakers
rankers113217462rankers
runners74212452runners
sinkers113618542sinkers
suckers133717622suckers
sulkers113613342sulkers
sunders84120052sunders
sunkets113511282sunkets
tankers113416912tankers
tinkers113517142tinkers
tuckers134014352tuckers
tuners64417342tun_ers
tuskers113710042tuskers
wankers144514712wankers
winkers143517112winkers
yonkers14379822yonkers
younkers15295762younkers

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 Limit1076711192.79638508.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911193.21855528.6
 
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.