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

337 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
aides6533660(None) 
abides94719891abides
aedes64625151aedes
aide56045001aide_
aided75828931aided
aider65431131aider
aiders74524631aiders
aids57846361aid_s
amides95722661amides
asides75118871asides
azides165113801azides
bides85536771bides
hides95129421hides
ides57734231_ides
nides65229131nides
rides66140811rides
sides65838361sides
tides64830151tides
wides94832821wides
abbes96723522abbes
abide86223712abide_
abided105313312abided
abider95314462abider
abiders104011082abiders
ables75935542ables
abodes94417512abodes
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acids87121002acid_s
acmes96020652acmes
acnes75922622acnes
acres76327762acres
added84918432added
adder75419592adder
adders84315702adders
addles84216602addles
adds67622452a_dds
adieu6417422adieu
adieus739632adieus
adios65822862adios
adits66523712adits
ados57633512a_dos
ads49755732a_d_s
adzes155913802adzes
ages55844592a_ges
agues64919052agues
aid49269082aid__
aidless83612072aidless
aidmen92610372aidmen
ailed66240282ailed
ails45654712ai_ls
aimed85626052aimed
aimer75926822aimer
aimers84621912aimers
aims67738182ai_ms
ains46158882ai_ns
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airns55521032airns
airs46447422ai_rs
airts55626342airts
ais39083572ai__s
aisles64721142aisles
aits46355532ai_ts
aiver85725162aiver
aivers94822322aivers
akees96119242akees
alder65421912alder
alders74218422alders
ales47067102a_les
alines65735222alines
almes75126542almes
aloes54933672aloes
amices105018012amices
amide86128482amide_
amids85627512amid_s
amies76837692amies
amines84727982amines
ands57833612and_s
anes45255932a_nes
animes84719592animes
anises64826692anises
anodes74418762anodes
antes56334322antes
apes66047432a_pes
aphides134711202aphides
apices104916262apices
apres75426402apres
apses76823912apses
apsides103911302apsides
ardeb8314522ardeb
ardebs937012ardebs
ares45871022a_res
arider74717742arider
aridest8316142aridest
arises65233802arises
arles56735742arles
arses55733872arses
ashes86230612ashes
aside65122082aside_
asses55629282asses
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axises134413992axises
axites134913832axites
axles125219472axles
ayes76543512a_yes
azide155617162azide_
azines155517072azines
baizes174315052baizes
bardes95026932bardes
bices95029962bices
bide76041502bide_
bided95424962bided
bider85728372bider
biders94822802biders
bidet84935622bidet
bidets95215532bidets
bidis86721142bidis
bids75838452bid_s
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
bodes84935102bodes
brides94423512brides
cades85440732cades
caids85226422caid_s
cedes84927332cedes
chides124620472chides
cider84723312cider
ciders94620092ciders
cines75239682cines
cires74932912cires
cites74435592cites
codes86247292codes
daises74318982daises
dices86434242dices
didies84621832didies
didoes85716962didoes
didos76820812didos
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
diodes83915782diodes
dites66339152dites
dives95832402dives
dudes75424372dudes
eide55832242eide_
eider64624742eider
eiders74321362eiders
eidos65817752eidos
elides74420692elides
fades94932862fades
fices106031162fices
fidges114114392fidges
fidos95819052fidos
fids87034742fid_s
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
gibes84422522gibes
gids65933742gid_s
gies55641422gi_es
gites65630182gites
gives95324872gives
glides84518862glides
grides84422362grides
gudes74520812gudes
guides84118282guides
hades96035112hades
halides113416662halides
hide85134642hide_
hided105222442hided
hider95024082hider
hiders104919652hiders
hies74842832hi_es
hikes125426982hikes
hires86134342hires
hives116925512hives
ices66129642_ices
idea59122772_idea
ideas65919012_ideas
idem76121062_idem
idles66720122_idles
ids47535472_id_s
imides94515342imides
ires45639282_ires
irides74519122irides
jades135222112jades
jibes145520322jibes
jives154820812jives
kibes115521112kibes
kids96029642kid_s
kikes85122552kikes
kines95039132kines
kites95432542kites
lades65141272lades
ladies75124882ladies
lapides103012042lapides
lidos65219882lidos
lids56336462lid_s
lies46454192li_es
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
lodes66436912lodes
ludes65728852ludes
maiden93512282maiden
maidens10349662maidens
maids86327142maid_s
mailes84329112mailes
maizes175115732maizes
midges103516482midges
midis85923412midis
mids76541792mid_s
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
modes85537412modes
naiades838212naiades
naives94914222naives
nide55535792nide_
nided75920872nided
nidus65913572nidus
nines55937342nines
nites55736342nites
nixes124519622nixes
nodes64633492nodes
nudes64723292nudes
odes57243242_odes
oxides14109692oxides
pedes85327292pedes
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
prides94324182prides
qaids156116312qaid_s
raided85017702raided
raider74318742raider
raiders84615142raiders
raids65827512raid_s
raises64826542raises
redes65139132redes
ribes75530172ribes
rices75536152rices
ride55945132ride_
rider65231302rider
riders74123902riders
ridges85817012ridges
rids56539552rid_s
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
rodes614039082rodes
sades65239892sades
saices84221802saices
saids65328852said_s
sices75637272sices
side55444492side_
sided74825952sided
sidles74721152sidles
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
slides73922182slides
tide55237382tide_
tided76322512tided
tidies74721832tidies
ties45248312ti_es
tikes95628902tikes
tildes74513962tildes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
vibes104719952vibes
vices105725532vices
vide85432762vide_
video96014952video
videos104911372videos
vids85627542vid_s
vies75238622vi_es
vines85137642vines
vires84529682vires
vises84427772vises
wades95634142wades
wadies105121202wadies
waives123714182waives
wide85235412wide_
widen94717972widen
widens106212722widens
wider94826352wider
widest104517002widest
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
yids85224962yid_s
yikes125117752yikes
yipes106017842yipes
zaires1539702zaires
zines145232652zines

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.330541487.9
2DLD Change Limit538003371.81329674.6
3Display Results3373370.0933623.7
 (SQL Overall)1786913372.23679915.5
 
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.