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

392 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
agorae751120(None) 
agora6914331agora_
agoras7613341agoras
aboral8314372aboral
adore65723662ador_e
afore85818602afor_e
agapae9388042agapae
aggrade1035632aggrade
aglare7312422aglare
agonal7410052agonal
agone65924552ago_ne
agorot7414992agorot
agrafe1038092ag_rafe
agree65226032ag_ree
ahorse9311512ahorse
amoral8314622amoral
angora71111572angora_
angoras8811362angoras
anorak1038922anorak
aortae65115472a_ortae
aurae54128112a_urae
aurorae739662aurorae
florae94713882florae
goral65125752_goral
gore55744962_gor_e
gorge76423892_gorge
gorse65926812_gorse
morae75831192_morae
aboard9312613aboard
abode85518813abo_de
abollae936943abollae
aboma91114603aboma_
abomas101113583abomas
abort76133583abor_t
aborted10310423aborted
aborter939923aborter
aborts84916183aborts
above105414323abo_ve
abrade9313053a_brade
abroad9310943abroad
accrue1035823accrue
acerate92818913acerate
acorn75616623acor_n
acorned10238263acorned
acorns85013013acorns
acre67330773a_cr_e
adobe84814703ado_be
adorable1138773adorable
adored84714233adored
adorer74713443adorer
adores74420713adores
adorn64917093ador_n
adorned9256883adorned
adorner8246973adorner
adorns74212613adorns
adoze155713833ado_ze
aerate64830553a_erate
aerie54634603a_erie
aerobe8412403aerobe
affray1534973affray
afire86215913afir_e
aga410447233ag__a_
agama85815573agama_
agamas97413443agamas
agapai9456843agapai
agape85614843ag_ape
agar58726413ag__ar
agaric93513623agaric
agarose838653agarose
agars66120643agar_s
agas55938843ag__as
agate66525143ag_ate
agave95314033ag_ave
agaze156113663ag_aze
age47154333ag___e
agee56241493ag__ee
agemate101210583agemate
agene65621583ag_ene
ager55935843ager__
agers65027853ager_s
aggie73415013ag_gie
aggraded1244183aggraded
aggrades1135853aggrades
aggro738003aggr_o
aggros836543aggros
agha87417303ag_ha_
aghas97014873ag_has
agile65122263ag_ile
agiotage1043563agiotage
agita6315423agita_
agitas7310593agitas
agitate8312063agitate
agleam9158623agleam
aglee65728493ag_lee
agma77623263ag_ma_
agmas85919873ag_mas
agnate73314873agnate
agnize16329563agnize
ago48845523ago___
agog68019003ago__g
agon56531883ago__n
agones75719863agones
agonic93515143agonic
agonies83016623agonies
agonise83112693agonise
agonize172911403agonize
agons66423783ago_ns
agony96415653ago_ny
agoroth1145133agoroth
agouti7388763agouti
agouty10366913agouty
agrafes1137523ag_rafes
agraffe1443333ag_raffe
agreed84712503ag_reed
agrees74915323ag_rees
agria65517143ag_ria
agrias74315393agrias
ague55725923ag__ue
ajowan1634893ajowan
alae45643753a__lae
algae65319623a_lgae
algor6513053algor__
algors7312553algor_s
aloe45540193alo__e
aloha8513613aloha_
alohas9411703alohas
alone55732963alo_ne
alulae6312743alulae
amebae1049633amebae
amerce10310513amerce
amirate91115953amirate
amoebae1145533amoebae
amole75724593amo_le
amort75832203amor_t
amphorae1546263amphorae
amtrac10109123amtrac
anoa45634473ano_a_
anoas57226493ano_as
anodal72512113anodal
anode65021033ano_de
anole55330373ano_le
anomie83215963anomie
anoraks1137603anoraks
ansae55720973a_nsae
antae56828293a_ntae
antra56521923antra_
antral65719413antral
antre55224523antr_e
anural65714743anural
anuran64313243anuran
aorta55922573a_orta
aortal65217513a_ortal
aortas65417783a_ortas
apodal9289823apodal
apogee9312553apogee
aporia8315863aporia
aporias9315133aporias
aport75432173apor_t
apyrase1236363apyrase
aquae142212713a_quae
arak86929573a__rak
arame75026623a__rame
are37874573a__r_e
area45843393a__rea
areae55229743a_reae
areolae7811733areolae
aroma71220143aroma_
aromas81018613aromas
arose55832083aro_se
arouse65019983arouse
arras55626133a_rras
array86317143a_rray
arse46539273a__rse
ashore9414613ashor_e
ashram1139053ashram
astral66919283astral
astray95615543astray
atonal6514023atonal
atone56527983ato_ne
augural856403augural
aura45836253a_ura_
aural54428963a_ural
aurar54420253a_urar
auras55932553a_uras
aurate64426473a_urate
aurora6411763aurora_
auroral7310473auroral
auroras7311703auroras
average1158853average
averse95811183averse
avowal1246323avowal
aware86420023awar_e
awoke124912003awo_ke
axonal1347653axonal
axone125918473axo_ne
azole145118033azo_le
azonal1568273azonal
azote144416343azo_te
azure14911483azur_e
begorah1355593begorah
bora66141633_bora_
borage93917013_borage
boral75831703_boral
borane84620213_borane
boras75938303_boras
borate85026153_borate
borax145918723_borax
bore66051333_bor_e
borne77926793_borne
brae65639113__brae
calorie92716883calorie
camerae11312043camerae
caporal11410943caporal
choral115118493choral
chorale124313353chorale
chore105126763chor_e
chorea115216083chorea
comae97128423_comae
coral76033453_coral
core67263113_cor_e
corse75036183_corse
coxae146115183_coxae
crore74922863cror_e
dagoba1074943dagoba_
dagobas1145143dagobas
dore56353303_dor_e
eagre64315323eag_r_e
engorge945543engorge
flora85317103flora_
floral94313813floral
floras94715693floras
fora75937393_fora_
forage104617003_forage
foram105124933_foram
foray115023973_foray
force105324273_force
fore78351473_for_e
forge95126943_forge
forme105225993_forme
forte86131463_forte
frae75330473__frae
frore86218803fror_e
gae46457703_g__ae
galeae74717453galeae
galore73514843galor_e
garage8314513_garage
garote7717943garote
gerah9315303_gerah
glare65222953_glare
goa47343803_go_a_
goad66830983_go_ad
goal55829303_go_al
goas55239943_go_as
goat56250833_go_at
goban84414073_goban
gonad75216053_gonad
gone55639043_go_ne
gooral7310463gooral
goose65925903_goose
gor47848263_gor__
gorals76917653_gorals
gored75227083_gored
gores65740373_gores
gorged95016983_gorged
gorger86116983_gorger
gorges85321893_gorges
gorget87123863_gorget
gorhen1038893_gorhen
gorier73719373_gorier
gorm75529393_gor_m
gormed105013833_gormed
gorms85619593_gorms
gorp75625903_gor_p
gorps85316993_gorps
gorses74723293_gorses
gorsy95915783_gorsy
gory86129663_gor_y
gouge78220063_gouge
gourde8107933_gourde
gowan95415743_gowan
grab75427613_g_rab
grace85124543_g_race
grad66829863_g_rad
grade75126093_g_rade
gram77034583_g_ram
gran56335013_g_ran
grape84824663_g_rape
grat55651283_g_rat
grate64932883_g_rate
grave94624873_g_rave
gray85329893_g_ray
graze155820053_g_raze
gree56641563_g_ree
groan65618423_groan
groat65531973_groat
grope84821613_grope
grove95219333_grove
grue55825713_g_rue
gurge75419783_gurge
gyral94412783_gyral
gyrase10508773_gyrase
gyrate104912523_gyrate
gyre84722763_gyr_e
hagrode1236443hagrode
hoorah124411113hoorah
hooray123011373hooray
hora76136553_hora_
horah117922043_horah
horal86328673_horal
horas86333093_horas
horde94623053_horde
horse86132653_horse
hydrae13258573hydrae
ignore7269063ignor_e
ixora1236913ixora_
ixoras1337193ixoras
jagra1338173jag_ra_
jagras1438463jag_ras
joram145816983_joram
kora86431553_kora_
korai97018513_korai
koras95927113_koras
korat94934433_korat
kore85834163_kor_e
laurae64011663laurae
librae84310173librae
loral55927823_loral
loran55925093_loran
lore45850353_lor_e
mayoral1237683mayoral
moorage1038743moorage
mora66641273_mora_
moral75533433_moral
morale85220553_morale
moras76438763_moras
moray105423793_moray
more67154523_mor_e
morse76032703_morse
novae85913123_novae
ogre56320743og_r_e
oorie53026363_oorie
ora37250833__ora_
orad56031693__orad
oral47638123__oral
orate55133303__orate
ore36661833__or_e
orle45630463__orle
pagoda10487873pagoda_
pagodas11367553pagodas
pakora1247283pakora_
pakoras1337473pakoras
parae76335703_parae
phorate12413363phorate
pore66451263_por_e
prorate9418733prorate
psoae74411623pso_ae
regorge9257833regorge
score75526733scor_e
scoriae9310893scoriae
shoran94016033shoran
shore85432643shor_e
snore55424953snor_e
sora45746913_sora_
soras55041013_soras
sore47059533_sor_e
sporal82915453sporal
spore75428593spor_e
stoae55024263sto_ae
storage8310473storage
storax1389783storax
store56333813stor_e
swore84920813swor_e
tagrag837043tag_rag
terrae62915203terrae
thorax1638253thorax
thorpe113610093thorpe
togae67020113_togae
tora47545993_tora_
torah87125273_torah
toras55540373_toras
tore47359323_tor_e
torse55833333_torse
torte55431703_torte
umbrae1038683umbrae
vaginae11377683vaginae
wagonage1343293wagonage
whore116018043whor_e
wore77144673_wor_e
worse86525263_worse
yore76335943_yor_e
zoeae144412483_zoeae
zonae145116443_zonae

Search took 7 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 Limit1127163926.53317253.3
3Display Results3923920.1103563.6
 (SQL Overall)1786913926.78326343.9
 
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.