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

529 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
terrae6291520(None) 
terra54419651terra_
terrace93311831terrace
terrane72814221terrane
terras63516951terras
feriae95618602feriae
ferrate103014032ferrate
hermae115314472hermae
serrate73017532serrate
tarre55825632tarr_e
telae54323292te_lae
teniae64517352teniae
terai53525482te_rai
terce75721842te_rce
terete6319332terete
terga63315642terga_
tergal72912832tergal
ternate7415482ternate
terne56426152te_rne
terraced11318112terraced
terraces102712222terraces
terrain7410832terrain
terranes82514392terranes
terrases82111452terrases
terreen7257572terreen
terrene72411032terrene
terret63425622terret
terrier73414962terrier
terries73425612terries
terrine72517572terrine
territ63421372territ
terror63811722terror
terry84721872terr_y
terse55026822te_rse
testae64216252testae
tetra53417952tetra_
tetrad73612052tetrad
tetras63017612tetras
thermae125310492thermae
aerate64830553aerate
aerial64625713aerial
aerie54634603ae_rie
aerobe8412403aerobe
agorae7511203agorae
aortae65115473aortae
areae55229743_areae
arras55626133_arras
array86317143_array
aurae54128113_aurae
aurorae739663aurorae
barrage10710843barrage
barre75929543barr_e
bedrape1277693bedrape
berake124216083berake
berate84729023berate
bereave1258353bereave
berime105317333berime
berme96022943be_rme
berried103714043berried
berries94423553berries
berry104521763berr_y
betray111511443betray
beware11313713beware
bewrap13157053bewrap
bewray14147733bewray
brae65639113__brae
bursae84515603bursae
cellae84915933cellae
cerate84829463cerate
cercal10314123cercal
cere66741473ce_r_e
cereal8315833cereal
ceria75125353ceria_
cerias83321973cerias
cerise84822043cerise
cerite84724873cerite
ceruse83914523ceruse
cesurae937703cesurae
cirrate92413483cirrate
corrade101111043corrade
corral83616253corral
corrie83621213corrie
curare84916953curare
curiae84518373curiae
curran8312023curran
currie84317253currie
dearie73319813dearie
decare93919153decare
decree93117783decree
defrag1136463defrag
defray1337643defray
degrade10229903degrade
degree82814853degree
dekare112811563dekare
deprave1337073deprave
derat65044083de_rat
derate74531233derate
deray95024183de_ray
dere56845903de_r_e
deride84420033deride
derive103817043derive
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
derries83124623derries
derris73615273derris
derry94721373derr_y
durra65315793durra_
durras74713373durras
durrie73713253durrie
eerie55228533_eerie
enrage72715073_enrage
era35741503_e_ra_
eras45441503_e_ras
erase54925493_erase
ere36352773_e_r_e
ergate7315143_ergate
erne46727423_e_rne
erode64520993_erode
erose55727273_erose
err35626533_err__
errable9312183_errable
errand758793_errand
errant6618733_errant
errata639013_errata
erred65915673_erred
error53712233_error
errs45622533_err_s
eternal72910893eternal
eterne6311723eterne
exedrae1544713exedrae
eyra76217553_eyra_
eyras84715923_eyras
eyre75525253_eyr_e
eyrie88117833_eyrie
feirie939553feirie
feral85424653fe_ral
ferbam1339003ferbam
fere76342233fe_r_e
feria85922713feria_
ferial94621253ferial
ferias95020393ferias
ferine96422583ferine
ferlie92814053ferlie
fermate122813003fermate
ferrates113013403ferrates
ferrel92810203ferrel
ferret93021173ferret
ferriage1245463ferriage
ferric1139993ferric
ferried113411523ferried
ferries103521083ferries
ferrite103312753ferrite
ferrule1035863ferrule
ferrum1147453ferrum
ferry116020803ferr_y
ferulae10309603ferulae
ferule93413203ferule
florae94713883florae
frae75330473__frae
frere85617723frer_e
gemmae11507793gemmae
genre66016803genr_e
gerah9315303ge_rah
german9611983german
germane1049663germane
hearse94114273hearse
herbage1337003herbage
herbal112513493herbal
here76447103he_r_e
hereat93527413hereat
herma105318883herma_
hermai118912843hermai
herniae1039043herniae
herried113514453herried
herries104025073herries
herry114922473herr_y
hurrah12369183hurrah
hurray12459913hurray
hydrae13258573hydrae
interrace11312543interrace
iterate71119103iterate
jarrah1636683jarrah
jerreed1535203jerreed
jerrid14259143jerrid
jerries143817513jerries
jerry155016183jerr_y
kerne94718213ke_rne
kerria10339913kerria
kerrias11289513kerrias
kerries113317913kerries
kerry124916093kerr_y
larvae938843larvae
laurae64011663laurae
librae84310173librae
marram10313883marram
mediae94217413mediae
mensae84114043mensae
merde84320123me_rde
mere67244443me_r_e
merge84523683me_rge
mergee94018133mergee
merle75824373me_rle
merman10513853merman
merrier92612303merrier
merry104721483merr_y
metre74821303metr_e
morae75831193_morae
murra74519083murra_
murras84916003murras
murre74821073murr_e
narrate7313493narrate
nervate1039523nervate
nerve86617373ne_rve
neural6311993neural
ocreae83310273ocreae
orra46120723_orra_
overran10311663overran
overrate11615683overrate
parae76335703_parae
parral85517533parral
peerage1089803peerage
peerie83617893peerie
pennae84314033pennae
percale11314083percale
perdie94718513perdie
perdue93912633perdue
pere66450263pe_r_e
perea75026443perea_
peroral9314793peroral
perorate10417913perorate
perries93226603perries
perron83216623perron
perry105222713perr_y
perse75429523pe_rse
peruke123210393peruke
peruse84016843peruse
pervade1337023pervade
petrale9312623petrale
pleurae945863pleurae
prerace11414123prerace
pterylae1343013pterylae
rare45348433__rare
recrate92621643recrate
rediae74221993rediae
redraw10269853redraw
reframe1239393reframe
reggae858953reggae
regrade92612033regrade
regrate82618653regrate
reran57329103re_ran
reread71715433reread
rerise64325633rerise
rerose63320843rerose
retrace91417343retrace
retral64419743retral
rewrap11127533rewrap
sera46141393se_ra_
serac75925203se_rac
serai56830163se_rai
seral56336383se_ral
serape84818413serape
serdab937833serdab
sere46153473se_r_e
serene63522353serene
serfage1138403serfage
serge64727463se_rge
serial64625853serial
seriate73722473seriate
serine65432673serine
serosae7310243serosae
serrano768453serrano
serrated92513423serrated
serrates82617003serrates
serried82513963serried
serries73925353serries
serry84824123serr_y
serval93913413serval
serve85425963se_rve
setae56026223se_tae
sierra637313sierra_
sierran737193sierran
sierras737863sierras
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sirree64017333sirree
stearate839713stearate
steerage946833steerage
stelae63716483ste_lae
stere55328543ste_r_e
sterile7316603sterile
sterna63712763sterna_
sternal73411903sternal
striae65422273striae
surra55521343surra_
surras65919533surras
tae38267053t___ae
taeniae739083taeniae
tagrag837043tagrag
tare45957623t_ar_e
targe65227093t_arge
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tarred74720283tarred
tarres64723043tarres
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarry85422513tarr_y
tarsal63315273tarsal
tartan64217513tartan
tartar63214753tartar
tartare73012683tartare
tartrate899673tartrate
tarzan152910753tarzan
tea37353323te__a_
teacake1335453teacake
teak85930843te__ak
teal45546503te__al
team66238653te__am
tear45242883te__ar
tearable101512673tearable
teared75722153teared
tearer64822903tearer
teargas837013teargas
tearier73815613tearier
tears55436463tear_s
teary85124053tear_y
teas45851493te__as
tease55428713te_ase
teat45963633te__at
teaware1048143teaware
teazle15329553teazle
techie11511723techie
tecta74215523tecta_
tectal83713253tectal
tee38366873te___e
teenage8108053teenage
teepee8314363teepee
teethe94511313teethe
tegua6109563tegua_
teguas768013teguas
tekkie934203tekkie
tela45532973te_la_
tele45040873te__le
teleran7510173teleran
telia55821143telia_
telial65815363telial
telome8311923telome
temple102811333temple
tenace82715693tenace
tenebrae1044863tenebrae
tenge65720433te_nge
tenia55324483tenia_
tenias64720073tenias
tenrec837513tenrec
tense55225843te_nse
tentage81010643tentage
tentie62521183tentie
tenure6311613tenure
teopan839353teopan
tepa66021683te_pa_
tepal76319583te_pal
tepas76521683te_pas
tepee74724213te_pee
tephra1136483tephra_
tephras1236283tephras
terais64023503terais
teraph11319093teraph
terbia8311153terbia
terbias9310743terbias
terbic10410963terbic
tercel83612993tercel
terces83921413terces
tercet83624913tercet
teredo7310783teredo
terefah1344113terefah
tergite8311003tergite
tergum937933tergum
term66233153te_r_m
termed94816703termed
termer85717253termer
termite9313893termite
termly1138433termly
termor84412513termor
terms75523473te_rms
tern46134803te_r_n
ternary1038343ternary
ternes65422903ternes
terns55226873te_rns
terpene92310853terpene
terrains8410293terrains
terrapin1046183terrapin
terraria847003terraria
terrazzo1641793terrazzo
terreens8246523terreens
terrenes82212593terrenes
terrets72913573terrets
terrible1046643terrible
terriers84210813terriers
terrify1336353terrify
terrines82117523terrines
territs72714493territs
terrors73112203terrors
terser67317823terser
tertial7313853tertial
tertian7511193tertian
tesla55612603tesla_
teslas64212173teslas
tesserae844793tesserae
testa54822043testa_
testate73916233testate
testee64323303testee
tetrads82910173tetrads
tetramer1046813tetramer
tetri52716453tetr_i
tetris62816293tetris
tetrode839333tetrode
tetryl935693tetryl
texas126514933te_xas
thae76825563t__hae
thecae11299653thecae
there87527393ther_e
thereat104315243thereat
theriac1239143theriac
therian10311293therian
thermal125010963thermal
therme115814993therme
thiram1139943thiram
thorax1638253thorax
thorpe113610093thorpe
thrave126010273thrave
thraw1110515923t_hraw
thread105011093thread
threap11569663threap
threat95020463threat
three87526913t_hree
thrice114311573thrice
thrive125313223thrive
throat94819753throat
throe89321423t_hroe
throne98517603throne
throve128012393throve
thyrse1235133thyrse
tiara5315903tiara_
tiaraed837043tiaraed
tiaras6314533tiaras
tibiae838473tibiae
tierce8339843tierce
tirade7311693tirade
tire46143353t_ir_e
titrate72215573titrate
titre54619393titr_e
togae67020113t_ogae
tora47545993t_ora_
torah87125273t_orah
toras55540373t_oras
tore47359323t_or_e
torose64317693torose
torque15237673torque
torr45630903torr__
torrid7311853torrid
torrs53923563torr_s
torsade837593torsade
torse55833333t_orse
torta55925353torta_
tortas64918253tortas
torte55431703t_orte
torulae758553torulae
trace75829613t_race
trad55630913t__rad
trade65026043t_rade
tram67034553t__ram
trap67532803t__rap
trave85223033t_rave
tray77632593t__ray
tread64821703t_read
treat56240353t_reat
treble8311663treble
tree47745813t__ree
trefah1235093trefah
trepan82511673trepan
triac74116373t_riac
triad65217723t_riad
triage72812893t_riage
trial54926353t_rial
tribe74420263t_ribe
trice75127493t_rice
trike95320163t_rike
trine54734603t_rine
tripe75425383t_ripe
trite54730033t_rite
troak95213573t_roak
trode65322853t_rode
troke94821053t_roke
trone55131863t_rone
trope75725803t_rope
trove85221923t_rove
truce75118693t_ruce
true46725853t__rue
tubae74716643t_ubae
turban8310483turban
turret63121853turret
turtle63213573turtle
twae74719573t__wae
tyre75428253t_yr_e
umbrae1038673umbrae
urare56322553_urare
ursae55214453_ursae
uterine7315193uterine
venae85920983ve_nae
vera76828843ve_ra_
verbal112513663verbal
verge93419833ve_rge
verite94323443verite
vernal93514213vernal
verrucae1343193verrucae
versal93013753versal
verse84723583ve_rse
verste94515633verste
verve115417723ve_rve
were76238333we_r_e
wirra83210823wirra_
yerba101010763yerba_
yerbas11119293yerbas
zebra1637883zebra_
zebras1737853zebras

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.1431249587.4
2DLD Change Limit1127165296.17018268.4
3Display Results5295290.1733057.8
 (SQL Overall)1786915296.48627550.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.