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

157 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
acmes9602065(None) 
aces67645091ac_es
aches106132291aches
acme86924321acme_
acnes75922621acnes
acres76327761acres
almes75126541almes
cames97047311cames
abbes96723522abbes
ables75935542ables
abyes105518532abyes
access1037682access
ace59656832ac_e_
aced79540882ac_ed
ache96829822ache_
ached119227832ached
acids87121002acids
ackee115825372ackee
ackees124914582ackees
acmic11312332acmic
acne66625872acne_
acned87520672acned
acre67330772acre_
acred87126352acred
acted88521732acted
acts66929862ac_ts
acumen1049012acumen
acumens1136952acumens
acutes83917722acutes
acyls104211522acyls
admen84516182admen
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agmas85919872agmas
agues64919052agues
aides65336602aides
aimed85626052aimed
aimer75926822aimer
aimers84621912aimers
aims67738182aim_s
akees96119242akees
ales47067102a_les
almas76629772almas
alme65832162alme_
almeh106214552almeh
almehs11619492almehs
alms65834922alm_s
aloes54933672aloes
amas67746292a_mas
amen66733152a_men
amens75624842a_mens
amies76837692amies
amis66445322a_mis
ammos94815822ammos
amps86230342a_mps
amus65529612a_mus
anes45255932a_nes
animes84719592animes
antes56334322antes
apes66047432a_pes
apres75426402apres
apses76823912apses
arames84622572arames
arches114822042arches
ares45871022a_res
arles56735742arles
armed86324432armed
armer76924442armer
armers85520272armers
armet76739452armet
armets84918352armets
armies85123692armies
arms66137492arm_s
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atmas75721012atmas
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
axmen145112272axmen
ayes76543512a_yes
baches135426942baches
caches137926912caches
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
camas96333522camas
came87648752came_
camel96822802camel
camels105217082camels
cameo95924992cameo
cameos105818002cameos
camos95927612camos
camps116330262camps
cams87047282cam_s
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951892cates
caves105639702caves
cees65941592_cees
comes97246992comes
cues65438982_cues
cymes1210118922cymes
daces85030682dac_es
dames85435852dames
demes86032692demes
dimes85833042dimes
domes85735562domes
eches106322162eches
emes65434662_emes
faces106439432fac_es
facies113921592facies
fames105735922fames
femes105626222femes
fumes105224702fumes
games86238552games
hames106138702hames
hemes105031082hemes
homes106938812homes
ices66129642ic_es
kames115024692kames
laces76141762lac_es
laches116528342laches
lames75445542lames
limes75636502limes
maces97139962mac_es
maches134827232maches
macles107023222macles
memes94927702memes
mimes95732022mimes
momes95134472momes
naches114622412naches
nacres85614452nacres
names74833362names
nomes74933122nomes
paces96741112pac_es
pomes94833932pomes
racemes1139092racemes
races74943242rac_es
rimes75634542rimes
semes75731582semes
taces76237802tac_es
taches114224172taches
tames75242012tames
times75630822times
tomes76037382tomes
wackes154717712wackes
wames106432802wames
zymes1924712942zymes

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.330541487.9
2DLD Change Limit538001571.48336277.8
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.85996122.1
 
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.