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

224 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
terranes8251443(None) 
terraces102712251terraces
terrane72814231terrane_
terrases82111481terrases
terrenes82212601terrenes
terrines82117551terrines
errands847602_errands
errants7410642_errants
ferrates113013422ferrates
serranos857872serranos
serrates82617022serrates
ternes65422902te_r_nes
terpenes102111572terpenes
terrace93311842terrace_
terraced11318122terraced
terrae62915212terra_e_
terrains8410322terrains
terras63516972terra__s
terreens8246532terreens
terrene72411032terrene_
terries73425632terr_ies
terrine72517572terrine_
aberrances1475433aberrances
aberrants1145853aberrants
aerates74627493ae_rates
arranges939413_arranges
arrases71214543_arrases
barrages11711083barrages
bedrapes1386963bedrapes
berakes134815773be_rakes
berates94126873be_rates
bereaves1338273bereaves
berlines102315453berlines
berries94423553berr_ies
boranes93720403_boranes
cerates95428253ce_rates
cetanes9315133ce_tanes
corrades111211263corrades
cranes84330753__cranes
currans9310613curran_s
currants1037933currants
decanes103118913de_canes
degrades11269923degrades
deplanes11311213deplanes
depraves1436873depraves
deranges1039973de_ranges
derates84028893de_rates
derries83124623derr_ies
derrises93012783derrises
enrages83114853_enrages
erases64425403_e_rases
ergates8314493_ergates
ermines9416673_ermines
ernes55224813_e_r_nes
errancies1147963_errancies
errancy1256363_errancy
errand758793_erran_d
errant6618733_erran_t
erratas736863_erratas
errhines1136413_errhines
ethanes103713513_ethanes
ferrate103014043ferrate_
ferriages1345663ferriages
ferries103521083ferr_ies
ferrites112312833ferrites
ferrules1136163ferrules
furanes103214863_furanes
germane1049663germane_
germans1079473german_s
henbanes1336573henbanes
heptanes1339003heptanes
herbages1437093herbages
heroines112916573heroines
herries104025073herr_ies
herrings12379533herrings
hexanes17319463he_xanes
iterances1148913ite_rances
iterates81317823ite_rates
jerries143817513jerr_ies
kernes104717533ke_r_nes
kerries113317913kerr_ies
lurdanes936063lurdanes
marranos1038423marranos
membranes1545563membranes
merriness1138293merriness
methanes133812163methanes
narrates8312763narrates
nervines112310463nervines
neurines8311193neurines
neurones839673neurones
overrates12414623overrates
peerages1189893peerages
pentanes10316083pentanes
percales12313803percales
perorates11417023perorates
perries93226603perr_ies
perrons93115483perron_s
pervades1437353pervades
petrales10312983petrales
rearranges1145113rearranges
recanes93222263re_canes
recrates102420373recrates
reframes1338993reframes
regrades103212173regrades
regrants9310013regrants
regrates92618403regrates
retraces101417273retraces
serapes95218103se_rapes
serenes73222903se_renes
serfages1238233serfages
seriates82620673seriates
serines74229543se_rines
serranid947573serranid
serranids1045533serranids
serrano768463serran_o
serrate73017543serrate_
serrated92513433serrated
serries73925353serr_ies
servants1138003servants
stearates939453stearates
stearines9311283stearines
steerages1046493steerages
tacrines10310563tacrines
tarpans92513533tarpan_s
tarres64723043tarr__es
tarriances1244213tarriances
tarries73324263tarr_ies
tarriness9229243tarriness
tartanas8258893tartanas
tartans72615823tartan_s
tartrates979563tartrates
tarzans16329923tarzan_s
taurines8310553taurines
teacakes1435883teacakes
teargases1044803teargases
teariness9310633teariness
teases65426273te__ases
teawares1148083teawares
telerans859473teleran_s
tenaces92814513te_naces
tenants7311013te_nants
tendances1247573tendances
teniases838623teniases
tentages91011043tentages
teopans939203teopan_s
terais64023513te_ra_is
terces83921413te_r_ces
terebenes1146063terebenes
teredines1049453teredines
tergites9310543tergites
terminus1037393terminus
termites10313693termites
ternaries9311643ternaries
ternate7415483ternate_
terne56426153te_r_ne_
terns55226873te_r_n_s
terpene92310863terpene_
terra54419663terra___
terrain7410853terra_in
terrapin1046203terrapin
terrapins1146183terrapins
terraria847013terraria
terrazzo1641813terrazzo
terrazzos1741483terrazzos
terreen7257573terr_een
terrenely1243853terrenely
terret63425623terr__et
terrets72913583terr_ets
terrier73414963terr_ier
terriers84210823terriers
terrifies12139723terrifies
territs72714503terr_its
terrors73112213terr_ors
terseness948403terseness
tertians839103tertian_s
terylenes1244933terylenes
testates83615453testates
tetanies8513553te_tanies
tetanus737933te_tanus
tetrads82910193tetra_ds
tetramer1046813tetramer
tetramers1146463tetramers
tetras63017623tetra__s
tetrodes939093tetrodes
texases1437573te_xases
thanes94918983t__hanes
therians1138313therian_s
thoraces13118943thoraces
thoraxes1896363thoraxes
thraves13469713t_hraves
thrones105715843t_hrones
tirades8311723t_irades
tisanes7311853t_isanes
titrants838483titrants
titrates82314663titrates
tolanes74216313t_olanes
torrents838143torrents
torsades937213torsades
traces85329933t__races
trades75724503t__rades
trances93919643t__rances
tranks104017763t__ranks
tranqs155210313t__ranqs
trans54933043t__ran_s
trapes85024463t__rapes
traves94222743t__raves
trepangs11205403trepangs
trepans92311593trepan_s
triages82613793t_riages
trienes74118413t_rienes
trines64132563t__rines
triunes74311383t_riunes
trones65629283t__rones
truants738163t_ruants
turbaned1145623turbaned
turbans939563turban_s
turbines1039903turbines
tyrants1037453t_yrants
tziganes1853023tziganes
versants1137783versants
versines112213823versines
warrants1168503warrants
zebranos1943713zebranos
zebrines1935883zebrines

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622247.84318636.0
3Display Results2242240.0932408.6
 (SQL Overall)1786912248.35621384.8
 
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.