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

180 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
akees9611924(None) 
ackees124914571ackees
akee85936811akee_
akenes104817341akenes
rakees104516971rakees
skees95023121skees
abbes96723522abbes
abeles84719392abeles
abets75621672abets
ables75935542ables
abyes105518532abyes
aces67645092a_ces
aches106132292aches
ackee115825362ackee_
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adeem8311802adeem
adeems946332adeems
adzes155913802adzes
aedes64625142aedes
agee56241492agee_
agenes74720252agenes
agers65027852agers
ages55844592a_ges
agrees74915322agrees
agues64919052agues
aides65336602aides
ajee115928232ajee_
akela9311342akela
akelas10311192akelas
akene95818662akene
alecs76620732alecs
alee46652322alee_
alefs87319662alefs
ales47067102a_les
alkenes114212752alkenes
alkies104518092alkies
allees64521482allees
almes75126542almes
aloes54933672aloes
ameer75618982ameer
ameers84015572ameers
amens75624842amens
amies76837682amies
aneles64626292aneles
anes45255932a_nes
ankles104818382ankles
antes56334322antes
apeek114711872apeek
apers76629132apers
apes66047432a_pes
apexes1539132apexes
apres75426402apres
apses76823912apses
areas55935772areas
arenes64928392arenes
ares45871022a_res
aretes64425352aretes
arles56735742arles
arses55733872arses
ashes86230612ashes
askers105915402askers
askeses1136462askeses
asses55629282asses
ates45047922a_tes
aures55137092aures
avens86419332avens
avers85127312avers
aves76142602a_ves
awee76336642awee_
awes76037552a_wes
axels126313632axels
axes117337852a_xes
axles125219472axles
ayes76543512a_yes
bakers125323452bakers
bakes117035372bak_es
bees65453382_bees
brees75632552brees
cakes116037672cak_es
cees65941592_cees
dees56356632_dees
dekes105224452dekes
drees65628522drees
ekes86726602ek_es
epees75219832epees
fakeer13378742fakeer
fakeers14446672fakeers
fakers134219532fakers
fakes126032482fak_es
fees76450602_fees
flees85828752flees
frees86131392frees
gees55647882_gees
ghees95215552ghees
glees65027592glees
grees65132472grees
hackees165014102hackees
hakeem15407382hakeem
hakeems16394802hakeems
hakes126034302hak_es
jakes165023642jak_es
jees115938542_jees
kaes85734062_kaes
kales95730982kales
kames115024692kames
kanes95529372kanes
keas86337092_keas
keef115829992_keef
keefs125116282_keefs
keek75624962_keek
keeks84717252_keeks
keel85729462_keel
keels94622412_keels
keen84830402_keen
keens95721182_keens
keep106329812_keep
keeps116020282_keeps
keet85347332_keet
keets95123482_keets
kefs115922742_kefs
kegs95824012_kegs
kens85435232_kens
keps106027302_keps
kexes166216812_kexes
keys116322162_keys
knees95114872knees
kues86426772_kues
kyes115124932_kyes
lakers105225152lakers
lakes95737652lak_es
larees65323112larees
lees45455882_lees
makers123921732makers
makes115336852mak_es
ogees65119142ogees
okehs12477462okehs
okes84936342ok_es
payees114812902payees
pees65257372_pees
pekes114623562pekes
prees75937172prees
ragees74618662ragees
rakee96031172rakee_
rakers104123572rakers
rakes94440352rak_es
ramees84620892ramees
ranees64623962ranees
razees154314762razees
rees45364192_rees
sakers104125432sakers
sakes95540752sak_es
sarees65329942sarees
sees45361052_sees
skee85431472skee_
skeed105018982skeed
skeen94817402skeen
skeens103912912skeens
skeet95429182skeet
skeets104513252skeets
skegs105011232skegs
skenes104616632skenes
skeps115614252skeps
skews125413802skews
skies95026832skies
takers103923742takers
takes94437792tak_es
tees45353582_tees
trees55835762trees
tyees86019452tyees
ukes86122812uk_es
vakeel1335192vakeel
vakeels14113732vakeels
vees75439432_vees
wakens135012042wakens
wakers134822492wakers
wakes126633652wak_es
wees76249122_wees
zees136331892_zees

Search took 2 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.0931921408.6
2DLD Change Limit538001801.81329674.6
3Display Results1801800.0463913.0
 (SQL Overall)1786911801.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.