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

282 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
aloes5493367(None) 
ales47067101al_es
almes75126541almes
aloe45540191aloe_
floes85528141floes
haloes94623861haloes
sloes54728871sloes
abbes96723522abbes
ables75935542ables
abodes94417512abodes
abos67734412abo_s
aboves114512842aboves
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adobes94411532adobes
adores74420722adores
ados57633512ado_s
adzes155913802adzes
aedes64625142aedes
aeons57624652aeons
ages55844592a_ges
agones75719862agones
agons66423782agons
agues64919052agues
aides65336602aides
akees96119242akees
alae45643752alae_
alans55636172alans
alas46358122al_as
alates64833962alates
albas75925392albas
albs68628572al_bs
alcoves1297872alcoves
alder65421912alder
alders74218422alders
aldols7109712aldols
aldose7311092aldose
aldoses8311202aldoses
ale36572342al_e_
alec66430062al_ec
alecs76620732alecs
alee46652322al_ee
alef76340692al_ef
alefs87319662alefs
alfas87219042alfas
algas65624932algas
algors7312552algors
alias55834602alias
alien56425582alien
aliens65619212aliens
alifs86121262alifs
alines65735222alines
alkies104518092alkies
allee54932122allee
allees64521482allees
alley85721672alley
alleys95113302alleys
allies63827672allies
allods73615082allods
allots64019172allots
allows94517682allows
alloys94014562alloys
alls46740922al_ls
almas76629772almas
alme65832162alme_
almeh106214552almeh
almehs11619492almehs
alms65834922al_ms
aloft8423432aloft
aloha8513612aloha
alohas9411702alohas
aloin55227422aloin
aloins65022202aloins
alone55732962alone
along65419492along
aloof83521572aloof
aloud65018072aloud
alow75328592alo_w
alps65529242al_ps
als36663022al__s
alter54828502alter
alters64924222alters
altos55822952altos
alts46639902al_ts
alums75720602alums
amies76837692amies
amoks11413552amoks
amoles84122192amoles
anes45255932a_nes
anoas57226492anoas
anodes74418752anodes
anoles64827422anoles
antes56334322antes
apes66047432a_pes
apods86316342apods
apos65433822apo_s
apres75426402apres
apses76823912apses
ares45871022a_res
arles56735742arles
arose55832082arose
arses55733872arses
ashes86230612ashes
asses55629282asses
ates45047922a_tes
atoms76817562atoms
atones65225772atones
aures55137092aures
aves76142602a_ves
avos77227012avo_s
avows114910982avows
awes76037552a_wes
awols84713522awols
axes117337852a_xes
axles125219472axles
axones134614512axones
axons125517932axons
ayes76543512a_yes
azlons154110422azlons
azoles154614612azoles
azons146518252azons
azotes154312222azotes
bales76250082bal_es
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blokes123813882blokes
blots75626172blots
blows105423832blows
blues75127042blues
boles75448602boles
calces104420052calces
calos74431902calo_s
calves115119282calves
calxes154113032calxes
canoes84725882canoes
clods85320862clods
clogs85519552clogs
clones84526562clones
clons75228132clons
clops95924852clops
close76425222close
closes85425592closes
clots75627642clots
cloves114918822cloves
cloys104916942cloys
clozes174915562clozes
clues74623032clues
coles76055062coles
dadoes85616532dadoes
dagoes85714602dagoes
dales66439742dal_es
dalles74222062dalles
does56554472_does
doles67843752doles
elopes85918162elopes
elves85118742elves
falces115216002falces
flees85828752flees
flies85630712flies
flocs105519232flocs
floe76129772floe_
flogs95919962flogs
flops105920142flops
floss85118262floss
flows115822362flows
flues84626922flues
foes76543442_foes
froes86126692froes
gales65442482gal_es
galops94712622galops
galores82614322galores
glees65027592glees
globes94314542globes
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
gloves104115182gloves
glows95518032glows
glozes164313352glozes
glues65125682glues
goes55644092_goes
hales85449842hal_es
halloes104021522halloes
haloed104717602haloed
halons95720712halons
halos85230252halo_s
halves124717092halves
haoles94919802haoles
hoes75755732_hoes
holes84748652holes
jalops15329592jalops
joes116635892_joes
joles125230832joles
kales95730982kal_es
kayoes134710822kayoes
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
lees45455882_lees
les35663072_l_es
lies46454192_lies
lobes75331002_lobes
lobs66441082_lobs
lodes66436912_lodes
loess55714702_loess
loges66534202_loges
logs57343112_logs
loos49051122_loos
lopes76437342_lopes
lops66043352_lops
lores55045402_lores
lose45144582_lose
loses56742012_loses
loss45337962_loss
lots47652092_lots
loves85332012_loves
lowes85732462_lowes
lows75843012_lows
loxes125227472_loxes
lues45943552_lues
lyes75530832_lyes
mahoes11313102mahoes
males75049792mal_es
moles74747922moles
noes45845392_noes
oboes75717712oboes
oes35866192__oes
oleos55419682oleos
oles46453472ol_es
pales75753802pal_es
plies74526512plies
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
poles75351002poles
rales54947492ral_es
roes45954142_roes
roles56747982roles
sales56055592sal_es
salols64017872salols
salons63823692salons
salves94221762salves
salvoes102811312salvoes
shoes85429662shoes
slobs74419872slobs
sloe45534952sloe_
slogs64521842slogs
slopes84820452slopes
slops75026012slops
slots54830532slots
slows85323462slows
slues54527172slues
soles55547922soles
tales55451372tal_es
talons64019442talons
toes46956442_toes
toles55147132toles
vales85434262val_es
valors93413772valors
valses94514612valses
values94314942values
valves124113782valves
voes75432822_voes
voles86234042voles
wales86142832wal_es
walies95324522walies
woes76440662_woes

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 Limit538002821.73331044.4
3Display Results2822820.0803525.0
 (SQL Overall)1786912821.90693751.8
 
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.