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 “amoks” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
amoks1141355(None) 
amok10217401amok_
abos67734412abo_s
ados57633512ado_s
aeons57624652aeons
agons66423782agons
aloes54933672aloes
amahs107819062amahs
amas67746292am_as
amass77119682amass
ambos95321252ambos
amens75624842amens
amias75831472amias
amids85627522amids
amies76837692amies
amins75534322amins
amirs75924922amirs
amis66445322am_is
amiss75823072amiss
ammos94815822ammos
amole75724592amole
amoles84122192amoles
among85813302among
amort75832202amort
amour75014852amour
amours83512662amours
amps86230342am_ps
amucks1466002amucks
amus65529612am_us
amyls104512692amyls
anoas57226492anoas
apods86316342apods
apos65433822apo_s
araks94820882araks
arks85936872a_rks
armors85017812armors
askos95011772askos
asks85721212a_sks
atoms76817562atoms
auks85525262a_uks
avos77227012avo_s
avows114910982avows
awmous1157712awmous
awoke124912002awoke
awols84713522awols
axons125517932axons
azons146518252azons
books115729712books
camos95927612camo_s
cooks115429142cooks
famous11412392famous
gooks105422882gooks
groks105716122groks
hooks125027122hooks
kamiks11387912kamiks
kapoks11347262kapoks
kooks85217262kooks
looks95124862looks
macks135127602macks
makos116518362makos
marks115933482marks
masks115320532masks
moas65545342_moas
mobs85737372_mobs
mocks135023822_mocks
mocs85834902_mocs
mods77945062_mods
mogs75439332_mogs
moke106234222_moke
mokes114631032_mokes
mols65948572_mols
moms86539482_moms
monks116123392_monks
mons68152262_mons
moos66051302_moos
mops85940132_mops
mors65950062_mors
mos57067122_mo_s
mosk105622442_mosk
mosks116117002_mosks
moss67641032_moss
mots66853162_mots
mows96340832_mows
nooks95420392nooks
ramous8417112ramous
rooks95325042rooks
sameks12409322sameks
smocks145710012smocks
smogs85112162smogs
smoke115015822smoke
smokes124814342smokes
smoky14388682smoky
sooks94425452sooks
taroks106115282taroks
woks116224902_woks
yapoks15346782yapoks
yoks116223742_yoks
zooks184716942zooks

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.296603685.8
2DLD Change Limit53800981.56334421.0
3Display Results98980.0137538.5
 (SQL Overall)178691981.87295454.6
 
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.