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

215 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
terraces10271225(None) 
terrace93311841terrace_
terraced11318121terraced
terranes82514431terranes
terrases82111481terrases
ferrates113013422ferrates
retraces101417272retraces
serrates82617022serrates
tenaces92814512te_naces
terces83921412te_r_ces
terrae62915212terra_e_
terrains8410322terrains
terrane72814232terrane_
terras63516972terra__s
terrenes82212602terrenes
terries73425632terr_ies
terrines82117552terrines
thoraces13118942thoraces
traces85329932t__races
aberrances1475423aberrances
aerates74627493ae_rates
arracks1387733_arracks
arrases71214543_arrases
barracks1636883barracks
barrages11711083barrages
bedrapes1386963bedrapes
berakes134815773be_rakes
berates94126873be_rates
berdaches1745053berdaches
bereaves1338273bereaves
berries94423553berr_ies
boraces113716853_boraces
braces108427773__braces
carracks1637713carracks
cerates95428253ce_rates
cervices1537133cervices
corrades111211263corrades
currachs1544543currachs
defaces133213403de_faces
degrades11269923degrades
depraves1436873depraves
derates84028893de_rates
derricks1544433derricks
derries83124623derr_ies
derrises93012783derrises
detracts11138833detracts
earaches13411303_earaches
effaces15277273_effaces
embraces14128873embraces
enfaces122110913_enfaces
enlaces92313393_enlaces
enrages83114853_enrages
erases64425403_e_rases
ergates8314493_ergates
errancies1147963_errancies
errands847603_errands
errants7410643_errants
erratas736863_erratas
ferrate103014043ferrate_
ferriages1345663ferriages
ferries103521083ferr_ies
ferrites112312833ferrites
ferrules1136163ferrules
furnaces1336053furnaces
graces94523493__graces
headraces1546613headraces
herbages1437093herbages
herries104025073herr_ies
hyraces1537913_hyraces
interfaces15410403interfaces
interlaces12412043interlaces
interrace11312543interrace_
iterances1148903iterances
iterates81317823ite_rates
jerries143817513jerr_ies
kerries113317913kerr_ies
menaces112715523me_naces
merces105720743me_r_ces
narrates8312763narrates
orrices9129363_orrices
outraces102217863outraces
overrates12414623overrates
peaces106324083pe__aces
peerages1189893peerages
percales12313803percales
perorates11417023perorates
perries93226603perr_ies
pervades1437353pervades
petrales10312983petrales
prefaces15311063prefaces
prerace11414123prerace_
races74943243___races
recrates102420373recrates
refaces123216743re_faces
refracts13137383refracts
reframes1338993reframes
regrades103212173regrades
regrates92618403regrates
relaces93420883re_laces
replaces123114123replaces
reprices122913353reprices
reracks132310533re_racks
rerebraces1445033rerebraces
respaces12311043respaces
retrace91417343retrace_
retraced111413023retraced
retracer101411883retracer
retracers11149553retracers
retracks14149103retracks
retracts101111313retracts
seracs84418573se_rac_s
serapes95218103se_rapes
serfages1238233serfages
seriates82620673seriates
serranos857873serranos
serrate73017543serrate_
serrated92513433serrated
serries73925353serr_ies
services1338573services
stearates939453stearates
steerages1046493steerages
subraces12313033subraces
superraces1449863superraces
surfaces1338673surfaces
taces76237803t___aces
tailraces1144903tailraces
tarmacs1138323tarmac_s
tarres64723043tarr__es
tarriances1244213tarriances
tarries73324263tarr_ies
tartrates979563tartrates
teacakes1435883teacakes
teaches122718353te__aches
teargases1044803teargases
teases65426273te__ases
teawares1148083teawares
tectrices1346253tectrices
tenace82715693te_nace_
tendances1247573tendances
teniases838623teniases
tenrecs936033tenrec_s
tentacles1146713tentacles
tentages91011043tentages
terais64023513te_ra_is
terce75721843te_r_ce_
tercel83612993te_r_cel
tercels94110363te_r_cels
tercet83624913te_r_cet
tercets93512443te_r_cets
tergites9310543tergites
termites10313693termites
ternaries9311643ternaries
ternate7415483ternate_
ternes65422903te_r_nes
terpenes102111563terpenes
terra54419663terra___
terracing1237703terracing
terrain7410853terra_in
terrapin1046203terrapin
terrapins1146183terrapins
terraria847013terraria
terrazzo1641813terrazzo
terrazzos1741483terrazzos
terreen7257573terr_een
terreens8246533terreens
terrene72411033terrene_
terret63425623terr__et
terrets72913583terr_ets
terrier73414963terr_ier
terriers84210823terriers
terrifies12139723terrifies
terrine72517573terrine_
territs72714503terr_its
terrors73112213terr_ors
testacies1148373testacies
testates83615453testates
tetracid1147263tetracid
tetracids1245933tetracids
tetrads82910193tetra_ds
tetramer1046813tetramer
tetramers1146463tetramers
tetrarchs14104303tetrarchs
tetras63017623tetra__s
tetrodes939093tetrodes
texases1437573te_xases
theriacas1443503theriacas
theriacs1336543theriac_s
thoraxes1896363thoraxes
thraves13469713t_hraves
tierces93710453tier_ces
tirades8311723t_irades
titrates82314663titrates
torsades937213torsades
touracos1045313touracos
trace75829613t__race_
traced94821583t__raced
tracer84820233t__racer
tracers94917843t__racers
tracks124818843t__racks
tracts85019073t__racts
trades75724503t__rades
trances93919643t_rances
trapes85024463t__rapes
traves94222743t__raves
treacles1039703t_reacles
triacs83913223t_riac_s
triages82613793t_riages
trices84826333t__rices
truces84916333t__ruces
turacos938643t_uracos
unbraces12229413unbraces
vendaces1457183vendaces
vernacles1445073vernacles
verrucas1343923verrucas
vertices13612283vertices

Search took 10 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 Filter1786911461620.346516448.0
2DLD Change Limit1461622158.75016704.2
3Display Results2152150.0762828.9
 (SQL Overall)1786912159.17219482.2
 
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.