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

218 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
auras5593256(None) 
arras55626131arras
aura45836251aura_
aurae54128111aurae
aural54428961aural
aurar54420251aurar
aures55137091aures
auris55331531auris
buras74736301buras
duras65727731duras
lauras63414331lauras
muras75329581muras
suras55336331suras
aas310975392a__as
abas68642082a_bas
abbas95918642abbas
abris75722602abris
acres76327762acres
afars85716512afars
agars66120642agars
agas55938842a_gas
aghas97014872aghas
agmas85919872agmas
agoras7613342agoras
agrias74315392agrias
airns55521032airns
airs46447422air_s
airts55626342airts
ajugas1435262ajugas
alas46358122a_las
albas75925392albas
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629772almas
amas67746292a_mas
amias75831472amias
anas46649862a_nas
angas65827992angas
anlas55626932anlas
annas55824882annas
anoas57226492anoas
antas55432032antas
anural65714742anural
anuran64313242anuran
anurans73810552anurans
anurias7312252anurias
aortas65417782aortas
apres75426402apres
aquas142412612aquas
arak86929572a_rak
araks94820882a_raks
arbs66834732a_rbs
arcs67834782a_rcs
areas55935772areas
ares45871022a_res
arfs76029962a_rfs
arias55438022arias
arks85936872a_rks
arms66137492a_rms
array86317142array
arrays95311682arrays
arris56824682arris
ars37670932a_r_s
arts49650262a_rts
arums75517832arums
atlas55821582atlas
atmas75721012atmas
audad71511392audad
audads8167102audads
auks85525262au_ks
aunts55227632aunts
aurate64426472aurate
aurei54821862aurei
aureus65314882aureus
auric74521742auric
aurist65027252aurist
auroras7311702auroras
aurous64119262aurous
aurum7614962aurum
aurums849382aurums
autos56523322autos
avgas96912132avgas
azures15510182azures
boras75938302boras
bras65746452_bras
bunas75126572bunas
bura66139532bura_
buran75225302buran
burans85019302burans
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burkas124513802burkas
burls74228852burls
burns74926782burns
burps94220172burps
burqas174410902burqas
burrs74925652burrs
burs65847422bur_s
bursa74921522bursa
bursas85318272bursas
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cur_s
daturas838782daturas
douras75016722douras
dumas85420432dumas
dura55232112dura_
dural64923892dural
dures65635922dures
durns64819872durns
duros65422692duros
durras74713372durras
durrs65519992durrs
eras45441502_eras
euros54920242euros
eyras84715922eyras
faunas94013632faunas
furan84320012furan
furans94515952furans
furls85322052furls
furs76735042fur_s
gaurs66317992gaur_s
guars65021052guars
gurus64318192gurus
horas86333102horas
hulas84920882hulas
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
jagras1438462jagras
jubas144614222jubas
judas134911882judas
jura116024892jura_
jural125120482jural
jurat124829322jurat
jurats134213202jurats
kauris103611532kauris
koras95927112koras
kurtas10349882kurtas
kurus98015632kurus
laura54116202laura_
laurae64011662laurae
liras56021982liras
lumas75622912lumas
lunas55025012lunas
lures56138532lures
lurks95218742lurks
madras94316432madras
maras75443292maras
moras76438782moras
mudras94212262mudras
mura65633302mura_
mural75225112mural
murals84016762murals
mures75937222mures
murks114821732murks
murras84916012murras
murrs75521302murrs
nairas6312782nairas
nurds65518522nurds
nurls55519682nurls
okras94410972okras
ours47237562our_s
paras76143042paras
paruras9310532paruras
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
purdas92612262purdas
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
ras37575392__ras
rural55821172rural
sabras85116362sabras
saunas63915432saunas
soras55041012soras
subas74724072subas
sura45740292sura_
surah86823252surah
surahs94515542surahs
sural55931262sural
surds65624662surds
surfs85022542surfs
surras65919532surras
sutras64818592sutras
toras55540372toras
tubas75119582tubas
tufas85314382tufas
tunas54224122tunas
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
upas68322382_upas
urase54624692_urase
urbs65922062_urbs
urds55922432_urds
ureas55826012_ureas
urns46323902_urns
urps66920482_urps
ursa44116912_ursa
urus46426142_urus
utas45924952_utas
varas86028192varas
yucas106013912yucas
yugas95012062yugas
yurts87216532yurts

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.296603685.8
2DLD Change Limit538002181.50035866.7
3Display Results2182180.0633460.3
 (SQL Overall)1786912181.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.