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

151 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
masker12441610(None) 
asker96418781_asker
maker114127811ma_ker
marker124420391marker
maser75029971mas_er
masher114123201masher
masked134316521masked
maskeg13388691maskeg
maskers133913841maskers
master84831341master
amasser9418732amasser
asked106919312_asked
askers105915402_askers
askew12529412_askew
asper75520432_asper
aster55434892_aster
backer144525522backer
baker115629542ba_ker
balker124519162balker
banker124222732banker
barker124822862barker
baser74828922bas_er
basher115123812basher
basked135218602basked
basket125722912basket
baster85333592baster
bosker123813652bosker
busker125517832busker
calker124917082calker
canker124422522canker
casked134815512casked
casket124820992casket
caster85232572caster
dacker134920752dacker
daiker115113032daiker
danker114319662danker
darker114718692darker
dasher104318982dasher
easier64218462easier
easter65027982easter
esker94412982_esker
faker124824592fa_ker
faster94625772faster
gasher104320372gasher
gasket114417252gasket
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gawker14559352gawker
hacker154822692hacker
hanker134622092hanker
hawker164812662hawker
husker134212702husker
jacker194417582jacker
jasper154610382jasper
kasher134915032kasher
lacker125325622lacker
laker95432872la_ker
lanker104123002lanker
larker104519242larker
laser54633322las_er
lasher94824532lasher
laster64830632laster
macer912126942ma_cer
madder103515592madder
mailer84724182mailer
maimer104514592maimer
makar115614972ma_kar
make105537892ma_ke_
makers123921732ma_kers
makes115336852ma_kes
mammer94218862mammer
mamzer19459832mamzer
manger94325012manger
manner84020512manner
mapper124516092mapper
marked133921622marked
markers133516102markers
market123226042market
marrer83716672marrer
masers84623452mas_ers
mashed125325042mashed
mashers124621052mashers
mashes115030002mashes
mask105227362mask__
maskegs14375412maskegs
masks115320532mask_s
masquer18266462masquer
masse75125292masse_
massed94421322massed
masses85028712masses
masseur935702masseur
massier93615222massier
masted94025802masted
masters94628922masters
mastery124214322mastery
mater74438862ma_ter
matier84321522matier
matter84325342matter
mauger93813482mauger
mauler84416712mauler
mazer165722422ma_zer
mazier175013062mazier
meeker12359982meeker
milker124814322milker
mirker123712692mirker
miser75430402mis_er
mister84728562mister
mocker143315442mocker
mosher114719792mosher
mosser84618272mosser
mucker143816392mucker
murker123715242murker
muser76024122mus_er
musher113820572musher
muskeg13338182muskeg
musket122818202musket
muskier134312732muskier
muster84724522muster
packer144223402packer
parker124121372parker
passer84721032passer
paster85734372paster
racker124824552racker
raker94529792ra_ker
ranker105021902ranker
raser55633412ras_er
rasher95024122rasher
rasper83917332rasper
raster64731442raster
risker105414492risker
sacker125124842sacker
saker95132022sa_ker
smacker153410582smacker
smasher123911022smasher
tacker124224502tacker
taker95229002ta_ker
talker103916222talker
tanker104521132tanker
tasked114714642tasked
taster64930572taster
tusker104212192tusker
unmasker14245022unmasker
vaster94521022vaster
wacker154920122wacker
waker125526592wa_ker
walker133913992walker
wanker134219972wanker
washer124720392washer
waster95228942waster
yakker12405532yakker

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 Filter178691825510.343520965.0
2DLD Change Limit825511512.67330883.3
3Display Results1511510.0463282.6
 (SQL Overall)1786911513.06258357.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.