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

229 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
almes7512654(None) 
acmes96020651acmes
ales47067101al_es
almas76629781almas
alme65832161alme_
almeh106214551almeh
almehs11619491almehs
alms65834921alm_s
aloes54933671aloes
lames75445541lames
abbes96723532abbes
ables75935542ables
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acme86924322acme_
acnes75922622acnes
acres76327762acres
admen84516182admen
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agmas85919882agmas
agues64919052agues
aides65336612aides
aimed85626052aimed
aimer75926822aimer
aimers84621912aimers
aims67738192aim_s
akees96119242akees
alae45643752alae_
alamos8415002alamos
alans55636172alans
alas46358122al_as
alates64833972alates
albas75925392albas
albs68628572al_bs
alder65421912alder
alders74218422alders
ale36572342al_e_
alec66430062al_ec
alecs76620732alecs
alee46652322al_ee
alef76340692al_ef
alefs87319662alefs
alfas87219042alfas
algas65624932algas
alias55834602alias
alien56425582alien
aliens65619212aliens
alifs86121262alifs
alines65735232alines
alkies104518092alkies
allee54932122allee
allees64521482allees
alley85721672alley
alleys95113302alleys
allies63827672allies
alls46740922al_ls
alma66333032alm_a
almah106917262almah
almahs118611612almahs
almner85710722almner
almners9399562almners
almost81014432almost
almuces11316822almuces
almud84012182almud
almudes10418262almudes
almuds9378772almuds
almug8429302almug
almugs9396422almugs
aloe45540192aloe_
alps65529242al_ps
als36663022al__s
alter54828502alter
alters64924222alters
altos55822952altos
alts46639902al_ts
alums75720602alums
amas67746302a_mas
amen66733152a_men
amens75624842a_mens
amies76837692amies
amis66445322a_mis
ammos94815822ammos
amps86230342a_mps
amus65529612a_mus
anes45255932a_nes
animes84719592animes
antes56334322antes
apes66047432a_pes
apres75426402apres
apses76823912apses
arames84622572arames
ares45871022a_res
arles56735742arles
armed86324442armed
armer76924452armer
armers85520272armers
armet76739462armet
armets84918352armets
armies85123692armies
arms66137502arm_s
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atmas75721022atmas
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
axmen145112272axmen
ayes76543512a_yes
bales76250082bal_es
balms95723922balm_s
blames105121862blames
blues75127042blues
blumes105917792blumes
calces104420052calces
calmed114816382calmed
calmer105216932calmer
calmest11312342calmest
calms95222352calm_s
calves115119282calves
calxes154113032calxes
cames97047312cames
climes104720002climes
clues74623032clues
comes97246992comes
cymes1210118922cymes
dales66439742dal_es
dalles74222062dalles
dames85435852dames
demes86032692demes
dimes85833042dimes
domes85735562domes
elms67322702elm_s
elves85118742elves
emes65434662_emes
falces115216002falces
fames105735922fames
femes105626222femes
flames114723692flames
flees85828752flees
flies85630712flies
floes85528142floes
flues84626922flues
flumes115119732flumes
fumes105224702fumes
gales65442482gal_es
games86238552games
glees65027592glees
glimes94717522glimes
glues65125682glues
glumes94516812glumes
hales85449842hal_es
halmas117017902halmas
halms105225212halm_s
haloes94623862haloes
halves124717092halves
hames106138702hames
hemes105031082hemes
homes106938822homes
kales95730982kal_es
kames115024702kames
laces76141762laces
lades65141272lades
lakes95737652lakes
lamas75532802lamas
lambs95921412lambs
lame66849292lame_
lamed85235292lamed
lameds94812032lameds
lamer75233702lamer
lamest84722762lamest
lamps95624832lamps
lams66552262lam_s
lanes54946792lanes
lares54852632lares
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
lees45455882_lees
les35663072_l_es
lies46454202_lies
limes75636502limes
lues45943552_lues
lyes75530832_lyes
males75049792mal_es
malms95021552malm_s
memes94927702memes
mimes95732022mimes
momes95134472momes
names74833362names
nomes74933122nomes
oles46453472ol_es
pales75753802pal_es
palmed114314642palmed
palmer105816542palmer
palmers113513622palmers
palms94921752palm_s
plies74526512plies
plumes104318132plumes
pomes94833932pomes
rales54947492ral_es
rimes75634542rimes
sales56055592sal_es
salmis8514272salmis
salves94221762salves
semes75731582semes
slimes84722042slimes
sloes54728872sloes
slues54527172slues
tales55451372tal_es
tames75242012tames
times75630822times
tomes76037382tomes
vales85434262val_es
valses94514612valses
values94314942values
valves124113782valves
wales86142842wal_es
walies95324522walies
wames106432802wames
ylems1039262ylems
zymes1924712942zymes

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 Limit538002291.86028924.7
3Display Results2292290.0763013.2
 (SQL Overall)1786912292.27978407.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.