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

356 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
aures5513709(None) 
acres76327761acres
apres75426401apres
ares45871021a_res
auras55932561auras
aurei54821861aurei
aureus65314881aureus
auris55331531auris
azures15510181azures
cures75645431cures
dures65635921dures
lures56138531lures
mures75937221mures
abbes96723522abbes
abjures1636522abjures
ables75935542ables
abris75722602abris
abuses85119102abuses
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acre67330772acre_
acred87126352acred
acutes83917722acutes
adjures1536232adjures
adores74420722adores
adzes155913802adzes
aedes64625152aedes
aeries64737782aeries
afresh1255502afresh
agers65027852agers
ages55844592a_ges
agree65226032agree
agrees74915322agrees
agues64919052agues
aides65336602aides
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airns55521032airns
airs46447422air_s
airts55626342airts
akees96119242akees
ales47067102a_les
allures72913112allures
almes75126542almes
aloes54933672aloes
amies76837692amies
amuses85117942amuses
anes45255932a_nes
antes56334322antes
antres65021002antres
anuses66218772anuses
apers76629132apers
apes66047432a_pes
apses76823912apses
arbs66834732a_rbs
arcs67834782a_rcs
are37874572a_re_
area45843392a_rea
areas55935772a_reas
arfs76029962a_rfs
arks85936872a_rks
arles56735742arles
arms66137492a_rms
armures9510272armures
arras55626132arras
arrest63722632arrest
arris56824682arris
ars37670932a_r_s
arse46539272a_rse
arses55733872arses
arts49650262a_rts
arums75517832arums
ashes86230612ashes
asses55629282asses
assures7611402assures
ates45047922a_tes
auger64922472auger
augers73818702augers
auks85525262au_ks
aunts55227632aunts
aura45836252aur_a
aurae54128112aurae
aural54428962aural
aurar54420252aurar
auric74521742auric
aurist65027252aurist
aurous64119262aurous
aurum7614962aurum
aurums849382aurums
autos56523322autos
avers85127312avers
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
ayes76543512a_yes
azure14911482azure_
bares75457132bares
barres84427542barres
bores76448252bores
buras74736302buras
burbs95423492burbs
burds84626062burds
buret77444012buret
burets84321262burets
burgs84924092burgs
buries84633272buries
burkes124421312burkes
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
burse75527252burse
burses84425512burses
buses75936012buses
butes714535872butes
byres104421382byres
cadres94017932cadres
cares77369182cares
caules85927252caules
causes88026472causes
ceres75540012ceres
cires74932912cires
cores76361852cores
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
curbs94821652curbs
curds85725612curds
cure66149122cure_
cured85932132cured
curer75030752curer
curers84923192curers
curet75447642curet
curets84922342curets
curfs105122142curfs
curies84934022curies
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cur_s
curse75829142curse
curses85328272curses
curves114619282curves
cutes79438322cutes
dares66146702dares
daubes94913702daubes
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
duras65727732duras
dure56341812dure_
dured75025402dured
duress74712062duress
durns64819872durns
duros65422692duros
durrs65519992durrs
eagres74014572eagres
enures63919712enures
euros54920242euros
eyres84921772eyres
fares85852872fares
fauces114916152fauces
fauves125610422fauves
feres86038182feres
fires85740752fires
fores85847102fores
fumes105224702fumes
furies95126372furies
furls85322052furls
furs76735042fur_s
furzes186613692furzes
fuses85628422fuses
fuzes175120222fuzes
gauges85915992gauges
gaurs66317992gaur_s
gauzes164710632gauzes
gores65740372gores
grues65721962grues
gudes74520812gudes
gules64831042gules
gurges84716862gurges
gurus64318192gurus
gyres94820322gyres
haeres94017032haeres
hares86255542hares
heres86245902heres
hires86134342hires
hues75235232hu_es
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
inures63318952inures
ires45639282_ires
jubes145420742jubes
jukes165319102jukes
jupes145218552jupes
jurel124516332jurel
jurels133710582jurels
juries134120632juries
jutes125125132jutes
kauries113613192kauries
kauris103611532kauris
kues86426772ku_es
kurus98015632kurus
lares54852632lares
lauras63414332lauras
laurel649032laurel
laurels746662laurels
lores55045402lores
lubes74727992lubes
luces75528432luces
lucres84513302lucres
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lure45142462lure_
lured65427492lured
lurer54625312lurer
lurers64217492lurers
lurex124816732lurex
lurks95218742lurks
lutes55836662lutes
luxes124921502luxes
lyres85019962lyres
madres93718182madres
manures9313352manures
mares76457632mares
matres84522232matres
matures9314312matures
mauves113811552mauves
meres75143572meres
mires75640882mires
mores76249642mores
mules75034292mules
muras75329582muras
mure65941332mure_
mured85726702mured
murex145517172murex
murks114821732murks
murres85019042murres
murrs75521302murrs
muses75134302muses
mutes75033782mutes
nacres85614452nacres
nares55544152nares
natures7311962natures
nudes64723292nudes
nukes95418122nukes
nurds65518522nurds
nurls55519682nurls
nurse54420122nurse
nurses63919352nurses
ogres65818632ogres
ores46056682_ores
ours47237562our_s
padres95016982padres
pares77164482pares
parures9512692parures
pauses84621472pauses
peres76246642peres
pores75849032pores
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pure65543332pure_
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purges94421762purges
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
purse76028892purse
purses84826372purses
puses75532202puses
pyres105523882pyres
quires154015752quires
rares55247442rares
rasures7312012rasures
res35565042__res
rubes74928412rubes
ruers515019412ruers
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sabres85520862sabres
sauces84919502sauces
saurel6511992saurel
saurels749302saurels
sauries72821622sauries
sautes63924912sautes
seres55448892seres
sires55945372sires
sores55454282sores
sucres84218892sucres
suers55128482suers
sues46247652su_es
supes75628302supes
suras55336332suras
surds65624662surds
sure45447412sure_
surer54833102surer
surest65026762surest
surfs85022542surfs
surges73924592surges
tares57456562tares
tarres64723042tarres
taupes8212672taupes
tires55437492tires
tores55352672tores
tres46542902_tres
trues54925322trues
tubes74826452tubes
tules54532792tules
tunes55332192tunes
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
turves94212692turves
tuxes124316042tuxes
tyres84725232tyres
ukes86122812_ukes
urbs65922062_urbs
urds55922432_urds
urea46528062_urea
ureas55826012_ureas
urges64619912_urges
urns46323902_urns
urps66920482_urps
urus46426142_urus
uses44931112_uses
utes45930882_utes
vires84529682vires
wares88250582wares
wires86034912wires
yores85031322yores
yules84521582yules
yurts87216532yurts
zaires1539702zaires

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.310576422.6
2DLD Change Limit538003561.78330173.9
3Display Results3563560.1103236.4
 (SQL Overall)1786913562.20381112.6
 
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.