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 “aurora” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

310 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
aurora641176(None) 
aurorae739661aurorae
auroral7310471auroral
auroras7311701auroras
agora6914332a_gora
angora71111572angora
aroma71220142a_roma
arroba898662arroba
aura45836252au__ra
aurar54420252aurar_
aureola747032aureola
aurorean844882aurorean
aurous64119262aurous
curara83712202curara
durra65315792dur_ra
furor8312392furor_
furore9410012furore
furors9310952furors
juror1239562juror_
jurors1338282jurors
murra74519082mur_ra
surra55521342sur_ra
abhor10411063abhor_
abhors11410623abhors
aboma91114603a_boma
aboral8314373a_boral
abort76133583a_bort
abroad9310943abroad
abrosia939273abrosia
absorb1038003absorb
accord1178843accord
acerola947823acerola
acorn75616623a_corn
acrobat11411813acrobat
acromia1139963acromia
across8312643across
actor71116073actor_
actors81016753actors
adjuror1542883adjuror_
adjurors1642853adjurors
adore65723663a_dore
adorn64917093a_dorn
adroit7518783adroit
adsorb946943adsorb
aero45435343aero__
aerobat9514473aerobat
aerobe8412403aerobe
aerobia939463aerobia
aerogram1149523aerogram
aerosat7417183aerosat
afford1346493afford
afore85818603a_fore
aftosa996573aftosa
agorae7511203a_gorae
agoras7613343a_goras
agria65517143agr_ia
airer54927893airer_
airers64922313airers
airport9511383airport
alforja1782303alforja
algor6513053algor_
algors7312553algors
aloha8513613a_loha
amoral8314623a_moral
amort75832203a_mort
amphora1446923amphora
amrita8411133amrita
angoras8811363angoras
annona648873annona
anoa45634473a_no_a
anorak1038923a_norak
antra56521923a_ntra
anuria6313103anur_ia
anurous7311553anurous
aorta55922573aor_ta
apnoea867093apnoea
aporia8315863aporia
aport75432173a_port
apron7318833apro_n
aprons8316993aprons
araroba945763araroba
arbor74818113arbor_
arbors84717873arbors
ardor64617863ardor_
ardors74416863ardors
area45843393a_r_ea
areca75618633a_reca
arena55323813a_rena
areola6813673areola
arepa75615563a_repa
aria46245423a_r_ia
armor75118053armor_
armors85017813armors
armory114211473armory
aroid65428333a_roid
aromas81018613a_romas
arose55832083a_rose
arras55626133a_r_ras
array86317143a_r_ray
arrear6310253arrear
arriba867683arriba
arrobas969213arrobas
arrow83414883arro_w
arrows92813483arrows
arrowy12288273arrowy
arroyo936963arroyo
arugola844353arugola
ashore9414613ashore
asrama839193asrama
assort64916373assort
assuror754203assuror_
assurors894043assurors
atria56022333atr_ia
attorn6310793attorn
auburn836213auburn
aucuba1045493aucuba
auger64922473auger_
augers73818703augers
augur64311213augur_
augural856403augural
augurs7399963augurs
augury10366663augury
aurae54128113aur_ae
aural54428963aur_al
auras55932553aur_as
aurate64426473aurate
aurei54821863aur_ei
aureolae845313aureolae
aureolas846853aureolas
aureole738693aureole
aures55137093aur_es
aureus65314883aureus
auric74521723aur_ic
auriform1345173auriform
auris55331523aur_is
aurist65027253aurist
aurochs1245983aurochs
aurorally1245263aurorally
aurum7614963aur_um
aurums849383aurums
ausform1245233ausform
austral73411513austral
author939763author_
authors10311833authors
auto47432083auto__
autocrat1049283autocrat
autoed7712823autoed
automan9310883automan
automat9414873automat
autos56523323auto_s
bandora1038813bandora
bora66141633__bora
buckra1436753buckra
bura66139533bu__ra
burka114617693bur_ka
burqa165013093bur_qa
burr65631233bur_r_
burro75018493bur_ro
burros85114993burros
burrow114610803burrow
burrs74925653bur_rs
burry105221563bur_ry
bursa74921523bur_sa
bursar85413253bursar
bursera936763bursera
camorra11115763camorra
carbora11310703carbora
chroma132912473chroma
corona83817403corona
corpora1139353corpora
crore74922863_crore
cruor7310443cruor_
cruors838623cruors
crura7312583_crura
cupola10317693cupola
curaras93911943curaras
curare84916953curare
curari84414403curari
curer75030753curer_
curers84923183curers
curia74523763cur_ia
curiosa9346643curiosa
curr65429653cur_r_
curran8312023cur_ran
currs75624393cur_rs
curry105920343cur_ry
cursor84110293cursor_
cursors93910023cursors
cursory12406393cursory
dhoora1035653dhoora
dura55232113du__ra
durbar968723durbar
duro56228023duro__
duroc84513143duro_c
durocs9569703durocs
duros65422693duro_s
durr55624353dur_r_
durras74713373dur_ras
durrs65519993dur_rs
error53712233error_
errors63311313errors
eureka1034483eureka
euro45325273euro__
euroky1334823euroky
euros54920243euro_s
fedora1038593fedora
femora1149583femora
flora85317103_flora
fora75937393__fora
frore86218803_frore
fulcra1135213fulcra
furores10310033furores
furrow12427743furrow
furry116719283fur_ry
gurry94515413gur_ry
hora76136553__hora
humor101110513humor_
humoral1237973humoral
humors11129633humors
hurrah12369183hur_rah
hurray12459913hur_ray
hurry114917183hur_ry
ixora1236913_ixora
judoka18102583judoka
jura116024893ju__ra
kora86431553__kora
krona93611793_krona
kurta95113913kur_ta
laura54116203lau__ra
lurer54625313lurer_
lurers64217493lurers
lustra6358893lustra
madrona10288703madrona
mora66641273__mora
mucor94011943mucor_
mucors104410843mucors
mucosa10166273mucosa
mudra83912433mu_dra
mura65633293mu__ra
murr65225133mur_r_
murras84916003mur_ras
murre74821073mur_re
murrha11366453murrha
murrs75521293mur_rs
murry105120233mur_ry
neuroma946523neuroma
ora37250833___ora
orra46120723_or_ra
ourari63413543ourari
outroar739513outroar
pakora1247283pakora
pandora1039543pandora
parura8310583parura
peroral9314793peroral
proa66229963_pro_a
purana8712933purana
purda82914693pur_da
purer75127903purer_
purport1159393purport
purpura1144793purpura
purr64925813pur_r_
purrs75320433pur_rs
pyrola1139003pyrola
quota145111963qu_ota
rasbora945943rasbora
remora8414583remora
roar46328573__roar
rota45834343__rota
rugola736293rugola
rugosa734563rugosa
rumor71011323rumor_
rumors81110393rumors
scrota8310183scrota
senora63216153senora
serosa6313023serosa
sirra54416323sir_ra
sora45746913__sora
sororal7310653sororal
stroma84313073stroma
suboral92011993suboral
suborn8310003suborn
sudor6312623sudor_
sudoral8148543sudoral
sudors7311093sudors
supra73614253su_pra
sura45740293su__ra
surer54833093surer_
surras65919533sur_ras
sutra54217933su_tra
terra54419653ter_ra
tora47545993__tora
trona54118953_trona
tumor71110693tumor_
tumoral938133tumoral
tumors8810603tumors
tundra736423tundra
turgor736863turgor_
turgors836823turgors
tutor5712493tutor_
tutors6912323tutors
ultra539363_ultra
umbra948513_umbra
uproar8106933uproar
urare56322553_urare
urari54619963_urari
urbia7311143_urbia
urea46528053_ur_ea
ursa44116903_ur_sa
wirra83210823wir_ra
yurta86014253yur_ta

Search took 9 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163108.34313510.2
3Display Results3103100.2031527.1
 (SQL Overall)1786913108.68620572.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.