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

319 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
taker9522900(None) 
baker115629541baker
faker124824591faker
laker95432871laker
maker114127811maker
raker94529791raker
saker95132021saker
taber73825821taber
tacker124224501tacker
take84739261take_
taken94819141taken
takers103923741takers
takes94437791takes
taler56034871taler
talker103916221talker
tamer75230101tamer
tanker104521131tanker
taper74829771taper
tater54138611tater
tawer85223441tawer
taxer125019361taxer
toker95924911toker
waker125526601waker
ager55935842_ager
akee85936812_akee
aper66336232_aper
asker96418782asker
aver75931882_aver
backer144525532backer
bake105637512bake_
baked126130772baked
bakers125323452bakers
bakery155911002bakery
bakes117035372bakes
baler75635282baler
balker124519162balker
banker124222732banker
barer74535802barer
barker124822862barker
baser74828922baser
beaker125520692beaker
biker116022562biker
caber95126832caber
cager85229222cager
cake105439962cake_
caked126128622caked
cakes116037672cakes
cakey145517272cakey
cakier123115242cakier
calker124917082calker
caner75334772caner
canker124422522canker
caper94831622caper
carer74942332carer
cater74840722cater
caver105629062caver
dacker134920752dacker
daiker115113032daiker
danker114319662danker
darer65230792darer
darker114718692darker
dater65332312dater
diker105524552diker
eager65526972eager
eater54639842eater
esker94412982esker
facer105525052facer
fader94421512fader
fake115534942fake_
faked135225482faked
fakeer13378742fakeer
fakers134219532fakers
fakery16509262fakery
fakes126032482fakes
fakey155515422fakey
fakir125111492fakir
farer86733142farer
flaker134916172flaker
gager74726292gager
gamer84928942gamer
gaper86125122gaper
gater64533652gater
gawker14559352gawker
gayer94519192gayer
gazer155720072gazer
hacker154822692hacker
hake115637842hake_
hakes126034302hakes
haler85033532haler
hanker134622092hanker
hater85034752hater
haver115124462haver
hawker164812662hawker
hayer114620242hayer
hazer174820232hazer
hiker125119392hiker
icker114018442icker
inker94421092inker
jacker194417582jacker
jager134318132jager
jake155925772jake_
jakes165023642jakes
japer146218882japer
joker165715892joker
lacer75833752lacer
lacker125325622lacker
lader65633722lader
lager65132862lager
lake85741602lake_
laked105731122laked
lakers105225152lakers
lakes95737652lakes
lakier104716272lakier
lamer75233702lamer
lanker104123002lanker
larker104519242larker
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leaker104620072leaker
liker95627062liker
macer912126942macer
makar115614972makar
make105537892make_
makers123921732makers
makes115336852makes
marker124420392marker
maser75029972maser
masker124416102masker
mater74438862mater
mazer165722422mazer
naked105320852naked
namer75622102namer
oaken95814382oaken
oakier104011392oakier
oater55433732oater
ocker113915752ocker
pacer96131612pacer
packer144223402packer
pager84728202pager
paler75436942paler
paper95128662paper
parer75839902parer
parker124121372parker
pater74740732pater
paver104225832paver
pawer104422972pawer
payer105125722payer
piker115622842piker
poker115122882poker
quaker193811622quaker
racer75233022racer
racker124824552racker
rake84841572rake_
raked105831422raked
rakee96031172rakee
rakers104123572rakers
rakes94440352rakes
ranker105021902ranker
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
retaker113714312retaker
saber75330242saber
sacker125124842sacker
safer84721812safer
sager65432052sager
sake85244962sake_
sakers104125432sakers
sakes95540752sakes
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
shaker134319462shaker
siker95326032siker
slaker104219272slaker
soaker105717532soaker
stacker134416262stacker
stager74821342stager
stake95927532stake_
staked114621942staked
stakes103927292stakes
staler64025822staler
stalker113912252stalker
starer64027362starer
starker114114692starker
stater64427562stater
stayer94516482stayer
stoker104417622stoker
tabers84621572tabers
tabes76033922tabes
tabor75518392tabor
tace65342512tace_
taces76237802taces
tacet75840022tacet
tacked134723942tacked
tackers134319622tackers
tacket124627492tacket
tackey154613082tackey
tackier133712522tackier
tackler134013322tackler
tae38267052ta_e_
tael46030712ta_el
tagger84017712tagger
tahr75217152ta_hr
tailer63823732tailer
tajes124920692tajes
taka87623592tak_a
takas95520682takas
takeup1234582takeup
takin94921302takin
talar56225382talar
tale46154162tale_
talers64628152talers
tales55451372tales
talked114015402talked
talkers113513212talkers
talkier114011842talkier
taller63721962taller
tame66343662tame_
tamed85528512tamed
tamers84224032tamers
tames75242012tames
tamper104618512tamper
tanked113919302tanked
tankers113416912tankers
tanner63722292tanner
tape64538152tape_
taped85327422taped
tapers84025812tapers
tapes75838602tapes
tapir75917062tapir
tapper104419612tapper
tar37570692ta__r
tare45957622tare_
tared69340052tared
tares57456562tares
tarre55825632tarre
tarter64023562tarter
tasked114714642tasked
taster64930572taster
tatar56122062tatar
tate44748602tate_
taters64932202taters
tates55444982tates
tatter64024572tatter
tauter64318022tauter
tavern9428932tavern
tawed95926192tawed
tawers94118602tawers
taxed135620292taxed
taxers134015282taxers
taxes124730822taxes
tearer64822902tearer
teaser65421522teaser
thaler94613102thaler
thanker14309592thanker
thawer12489342thawer
ticker124321502ticker
tier44936152t_ier
tiger65718632tiger
tike85534492tike_
tikes95628902tikes
tiler56131022tiler
timer75626042timer
tinker103619922tinker
titer55430612titer
toke86738492toke_
toked105626492toked
token95419312token
tokers104818892tokers
tokes95234972tokes
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
tracer84820232tracer
tracker133515172tracker
trader75218762trader
trier54328532trier
truer54916642truer
tsked105910032tsked
tuber75420682tuber
tucker124316952tucker
tuner56022682tuner
tusker104212192tusker
tuyer85414292tuyer
twier84713292twier
twyer11558522twyer
tyer75323392t_yer
tyke115720502tyke_
tykes125817062tykes
wacker154920122wacker
wader95325372wader
wafer114417652wafer
wager95925062wager
wake114935702wake_
waked135626752waked
waken124818472waken
wakers134822502wakers
wakes126633652wakes
waler84229292waler
walker133914002walker
wanker134219972wanker
water84733322water
waver115025712waver
waxer154317492waxer
weaker134015442weaker
yager95616752yager
yakker12405532yakker
yarer84321572yarer

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 Filter178691538000.343520965.0
2DLD Change Limit538003191.76630464.3
3Display Results3193190.0933430.1
 (SQL Overall)1786913192.20281149.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.