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

117 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
decker13521599(None) 
dacker134920751dacker
decked145217621decked
deckel134911041deckel
deckers144413831deckers
dicker134521401dicker
docker134417651docker
ducker134317991ducker
necker124012791necker
pecker144615361pecker
backer144525522backer
beaker125520692beaker
becked155417762becked
becket144619882becket
bicker144819172bicker
bucker145420462bucker
checker18329532checker
cocker144320392cocker
dackers143417042dackers
daiker115113032daiker
danker114319662danker
darker114718692darker
deader84220472deader
deafer104114812deafer
dealer74122142dealer
dearer74822802dearer
decare93919152decare
decayer13339352decayer
decern91310952dec_ern
decider114213182decider
deck115827752deck__
deckels14367362deckels
deckle1312012452deckle
deckles143312802deckles
decks124822192deck_s
decoder113712292decoder
decor84717572dec_or
decoyer13348682decoyer
decree93117782decree
decreer10269122decreer
decrier102713552decrier
deeper93613502deeper
deer56739022de__er
defer94619752de_fer
deffer134411302deffer
defier105118652defier
defter104215922defter
deicer94114412deicer
deke95228762de_ke_
deked115718532de_ked
dekes105224452de_kes
delver104913492delver
denier74420692denier
denser74115192denser
deter65028042de_ter
deticker1545282deticker
dewier104013462dewier
dexter143810892dexter
dicer85426422dic_er
dicier94416232dicier
dicked144920862dicked
dickers144117662dickers
dickey165913522dickey
dickier143512452dickier
diker105524552d_iker
docked145018332docked
dockers143715002dockers
docket134721172docket
ducked144718012ducked
duckers143214712duckers
duckier143911792duckier
duiker114110592duiker
dunker113616462dunker
esker94412982_esker
fucker153414422fucker
gecked146911932gecked
hacker154822692hacker
heckler16278572heckler
hocker155118562hocker
icker114018442_icker
jacker194417582jacker
jerker17369042jerker
kecked125113172kecked
kicker114116182kicker
lacker125325622lacker
leaker104620072leaker
lecher113415852lecher
licker125222042licker
locker124019422locker
meeker12359982meeker
mocker143315442mocker
mucker143816392mucker
necked134715062necked
neckers134210462neckers
nicker123818702nicker
ocker113915752_ocker
packer144223402packer
pecked155019102pecked
peckers153312672peckers
peckier153910522peckier
picker144422172picker
pucker143817632pucker
racker124824552racker
recked134821802recked
reeker103715592reeker
rocker124319572rocker
sacker125124842sacker
seeker103615362seeker
sicker124023902sicker
sucker124120662sucker
tacker124224502tacker
ticker124321502ticker
tucker124316952tucker
wacker154920122wacker
weaker134015442weaker
wicker154518672wicker
wrecker16367602wrecker

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 Filter178691825510.360496363.9
2DLD Change Limit825511172.47033421.5
3Display Results1171170.0303900.0
 (SQL Overall)1786911172.86062479.4
 
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.