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

263 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
tierced1034705(None) 
pierced12347591pierced
tierce8339841tierce_
tiercel9316201tiercel
tierces93710451tierces
tiered73613971tier_ed
amerced1256522amerced
coerced1238582coerced
fierce11348912fierce_
fiercer12356952fiercer
pieced113912102pie_ced
pierce104010392pierce_
piercer11337772piercer
pierces113411192pierces
terce75721842t_erce_
tercel83612992t_ercel
terces83921412t_erces
tercet83624912t_ercet
termed94816702t_ermed
tiaraed837052tiaraed
ticced11438442ti_cced
tiercels10344732tiercels
tired65228902ti_r_ed
tirled74714362ti_rled
aeried74221863_aeried
aired66032923ai_r_ed
airted74214503ai_rted
alerted82512223alerted
amerce10310513amerce_
amercer1146373amercer
amerces1149853amerces
arced88224163__arced
averred11237593averred
averted112211613averted
bermed115217723_bermed
bielded11226713bielded
birched15349913bi_rched
birded104414303bi_rded
birled94416993bi_rled
birred94713203bi_rred
cered85227443_cer_ed
circled1237583ci_rcled
clerked14326653clerked
coerce10310403coerce_
coercer1138383coercer
coerces11311943coerces
deiced104214483_deiced
deuced104112123_deuced
diced95824683di__ced
dieted83115493die_ted
directed1238233directed
dirked124912273di_rked
dirled84514903di_rled
disced104914653di_sced
diverged14256883diverged
diverted13199583diverted
divorced1544313divorced
emerged11158213emerged
emersed10138513emersed
erred65915673__erred
everted112711853everted
exerted152210053exerted
farced125216533_farced
fenced124412713_fenced
fibered1337643fiber_ed
fielded12206813fielded
fiercely1643313fiercely
fiercest13216143fiercest
fierier103511193fierier
fired94829743fi_r_ed
firmed125411883fi_rmed
fleeced13358153fleeced
forced126316523_forced
girded93712493gi_rded
girned84010513gi_rned
girted83912873gi_rted
heired103813043heir_ed
herbed123513453_herbed
herded114215643_herded
hired95226263hi_r_ed
iced78721893_i__ced
ired55131873_i_r_ed
irked104510923_i_rked
itemed936603ite_med
iterated91213823iterated
jeered143912793jeer_ed
jereed144012073_jereed
jerked18479593_jerked
kerbed13339703_kerbed
kerfed14358233_kerfed
kerned114112933_kerned
kirned11408623ki_rned
leered73816223leer_ed
licenced13145773licenced
lierne638023lierne_
liernes739623liernes
livered113111633liver_ed
liveried1238733liveried
mercer105214203_mercer
merces105720743_merces
merged104214953_merged
minced114114913mi_nced
mired85729223mi_r_ed
mitered103213233miter_ed
mitred94414343mitr_ed
nerved104111683_nerved
niece74814503nie_ce_
nieces84112713nie_ces
osiered837123osier_ed
overbed132811853overbed
overed102216623over_ed
overfed142510253overfed
peaced115818913_peaced
peered93819493peer_ed
perched154713243_perched
perked134617693_perked
permed115217353_permed
piece96717993pie_ce_
piecer105213083pie_cer
pieces104217273pie_ces
piercers12316723piercers
queried1738683queried
riced85825543ri__ced
riverbed14245143riverbed
sered65737293_ser_ed
serged84118773_serged
served104616813_served
sicced11489653si_cced
sieged85212713sie_ged
sieved104611443sie_ved
silenced1136273silenced
sired66134283si_r_ed
smerked14327283smerked
sourced1038453sourced
specced14266703specced
spiered104412463spier_ed
steered83615253steer_ed
stirred8359703sti_rred
swerved1455703swerved
tabered103311593taber_ed
talced93811003t_alced
tapered102612933taper_ed
tared69340053t_ar_ed
tarred74720283t_arred
tarried83914133tarried
tarted74923373t_arted
teamed95418593t_eamed
teared75722153t_eared
teased74721153t_eased
teated74924023t_eated
teched124014433t_eched
tedded93810903t_edded
teed55439263t_e__ed
teemed95114873t_eemed
teethed11318623teethed
temped113912893t_emped
tended83819483t_ended
tensed74817833t_ensed
tented74221003t_ented
tercels94110363t_ercels
tercets93512443t_ercets
teredo7310783t_er_edo
termer85717253t_ermer
terne56426153t_erne_
ternes65422903t_ernes
terraced11318123terraced
terret63425623t_erret
terse55026823t_erse_
terser67317823t_erser
tested74421523t_ested
tetched133010773t_etched
tewed94718533t_e_wed
themed125912583the_med
thence112010843thence_
there87527393ther_e_
theres96525473ther_es
therme115814993therme_
thermel12569893thermel
thermes126214613thermes
theroid11313403theroid
thieved1434973thie_ved
thirled11328093thirled
thorned11479403thorned
ticked134720523ti_cked
tickled144313133tickled
tided76322513ti__ded
tidied83613273ti_died
tied55535213ti___ed
tier44936143tier___
tierceron1152233tierceron
tiering8315253tiering
tiers55526523tier__s
tiffed13368393ti_ffed
tiled64832943ti__led
tilled74722953ti_lled
tillered937443tiller_ed
tilted74616863ti_lted
timbered13137383timber_ed
timed85223613ti__med
tincted1037273tincted
tined65434533ti__ned
tinged84220803ti_nged
tingled93712803tingled
tinkered1387683tinker_ed
tinkled123910473tinkled
tinned74317533ti_nned
tinted74419533ti_nted
tipped114418263ti_pped
tippled12358393tippled
tiptoed1036143tiptoed
tirade7311693ti_rade
tire46143353ti_r_e_
tireder837703tireder
tires55437493ti_r_es
tissued835583tissued
tithed104115593ti_thed
titled73815003ti_tled
titrated92611683titrated
titre54619393titr_e_
titres64718933titr_es
tittered9239493titter_ed
torched133511363t_orched
toured74216153tour_ed
towered112911403tower_ed
traced94821583t_raced
tranced104414173tranced
treaded95014283treaded
treated83618703treated
trebled1038483trebled
treed65626733t__reed
trekked1134343trekked
trenched14289853trenched
trended94011763trended
tressed83714263tressed
triced95518673t_riced
tried65026913t__ried
truced95312053t_ruced
trued65117693t__rued
tumesced1343523tumesced
turfed103110963t_urfed
turned73914473t_urned
tweaked1534403tweaked
tweed94915093twe__ed
tweeted11336583tweeted
tweezed20274993tweezed
twirled11385983twirled
tyred95816433t_yr_ed
unpierced1443443unpierced
uttered82712433utter_ed
veered103612743veer_ed
verged114815163_verged
versed104515513_versed
viced115118183vi__ced
viewed1345993vie_wed
weirded1234513weirded
wielded12216683wielded
winced124415343wi_nced
wired95327643wi_r_ed
yerked14509373_yerked
yielded12184713yielded
yirred10426963yi_rred
zeroed16409413_zeroed
zinced18419413zi_nced

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272637.20318607.1
3Display Results2632630.0932828.0
 (SQL Overall)1786912637.70223200.6
 
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.