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

330 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
tierces9371045(None) 
pierces113411191pierces
terces83921411t_erces
tierce8339841tierce_
tierced10347051tierced
tiercel9316201tiercel
tiercels10344731tiercels
amerces1149852amerces
coerces11311942coerces
fierce11348912fierce_
fiercer12356952fiercer
fiercest13216142fiercest
liernes739622liernes
merces105720742_merces
nieces84112712nie_ces
pieces104217272pie_ces
pierce104010392pierce_
pierced12347592pierced
piercer11337772piercer
piercers12316722piercers
terce75721842t_erce_
tercel83612992t_ercel
tercels94110362t_ercels
tercet83624912t_ercet
tercets93512442t_ercets
ternes65422902t_ernes
theres96525472ther_es
thermes126214612thermes
tiered73613972tier_ed
tiers55526522tier__s
tires55437492ti_r_es
titres64718932titr_es
aeries64737783_aeries
amerce10310513amerce_
amerced1256523amerced
amercer1146373amercer
amercers1256133amercers
apercus1136573apercus
aperies9423203aperies
bermes106023003_bermes
bices95029963bi__ces
biers76225223bier__s
bifaces1448063bifaces
birches143412323bi_rches
biremes1138773biremes
birles84920643bi_rles
birses84717733bi_rses
cercis104614493_cercis
cercus105013153_cercus
ceres75540013_cer_es
certes84623083_certes
cilices113814023cilices
cimices13279803cimices
circles1139903ci_rcles
circus104310593ci_rcus
cires74932913ci_r_es
coerce10310403coerce_
coerced1238583coerced
coercer1138383coercer
coercers1237653coercers
deices94119373_deices
deuces94015513_deuces
diaries83321953diaries
dices86434243di__ces
dienes75719903die_nes
diereses938693diereses
dieses75218693die_ses
directs102710263directs
dirges84915103di_rges
diverges13258313diverges
divorces1445673divorces
emerges101310883emerges
emeries91620023emeries
ernes55224813__ernes
erses55826803__erses
faeces114713123fae_ces
faeries104118993faeries
faiences1337043faiences
farces115223323_farces
feces105625363_fe_ces
fences114617113_fences
feres86038183_fer_es
fiacres1237253fiacres
fiances12310673fiances
fibres114312123fibr_es
fices106031163fi__ces
fiercely1643313fiercely
fierier103511193fierier
fieriest112112243fieriest
fineries112416743fineries
fires85740753fi_r_es
fleeces12399643fleeces
forces114422133_forces
freres94716173frer_es
haeres94017033haer_es
heres86245903_her_es
heroes94923823_heroes
herpes115517323_herpes
hirees95117293hi_rees
hires86134343hi_r_es
ibices10398163_ibices
ices66129643_i__ces
ires45639283_i_r_es
iterances1148903iterances
iterates81317813iterates
kermes124616123_kermes
kernes104717523_kernes
kiers95320093kier__s
licences12129323licences
lieges74113443lie_ges
lierne638023lierne_
liers55130403lier__s
litres65220393litr_es
liveries11314373liveries
livres94311863livr_es
mercer105214203_mercer
mercers114412773_mercers
merches144013763_merches
mercies113817563_mercies
mercs96020453_merc_s
merdes94518603_merdes
meres75143573_mer_es
merges94122483_merges
merles85322763_merles
minces104420803mi_nces
mires75640883mi_r_es
mirexes1636993mirexes
miseries10320403miseries
mitres83922073mitr_es
nerves94216193_nerves
niece74814503nie_ce_
nieves94311293nie_ves
niteries8318373niteries
nitres65519333nitr_es
patiences1367433patiences
peaces106324083_peaces
peeries93623023peeries
perches143717953_perches
peres76246643_per_es
perses85428063_perses
piece96717993pie_ce_
pieced113912103pie_ced
piecer105213083pie_cer
piecers114112253pie_cers
piers75926333pier__s
pieties9419223pieties
pineries102419083pineries
queries16315873queries
recces10614913_recces
rices75536153ri__ces
sciences1238773sciences
seres55448893_ser_es
serges74225963_serges
series64540973_series
serves94423653_serves
sices75637273si__ces
sieges73816833sie_ges
sierras737863sierras
sieves93216003sie_ves
silences10310073silences
sirees64624583si_rees
sires55945373si_r_es
sirrees73410563sirrees
sources9312173sources
spences113413923spences
steres63929533ster_es
stirpes95011293sti_rpes
swerves1377533swerves
taces76237803t__aces
tailraces1144903tailraces
tanrecs934823tanrecs
tares57456563t_ar_es
targes74524593t_arges
tarres64723043t_arres
tarries73324263tarries
teaches122718353t_eaches
teases65426273t_eases
techs106915833t_e_chs
teepees939263teepees
tees45353583t_e__es
teethes103611653teethes
telcos8710683t_elcos
teles54536003t_e_les
tenaces92814513tenaces
tenches123515523t_enches
tenrecs936033tenrecs
tenses64722553t_enses
tenues63816443t_enues
tepees84215243t_epees
terais64023503t_erais
termed94816703t_ermed
termer85717253t_ermer
termers95414503t_ermers
terms75523473t_er_ms
terne56426153t_erne_
terns55226873t_er_ns
terraces102712223terraces
terras63516953t_erras
terret63425623t_erret
terrets72913573t_errets
terries73425613terries
terse55026823t_erse_
terser67317823t_erser
tersest71713993t_ersest
testes65125823t_estes
thebes115914493the_bes
theines104013233theines
themes115319253the_mes
thence112010843thence_
theories11311593theories
there87527393ther_e_
therme115814993therme_
thermel12569893thermel
thermels13607763thermels
thermos124610753thermos
therms115914873ther_ms
theses96517973the_ses
thieves1346903thie_ves
thoraces13118933thoraces
thorpes125010353thorpes
threes97117323t_hrees
throes97518673t_hroes
thyrses1335013thyrses
tiaraed837043tiaraed
tiaras6314533tiar_as
ticced11438443ti_cced
tickles133416853tickles
ticks115823293ti__cks
tics65729633ti__c_s
tiderips1145373tiderips
tides64830153ti__des
tidies74721833ti_dies
tiebacks1646333tiebacks
tieless72512563tieless
tiepins939463tiepins
tier44936143tier___
tierceron1152223tierceron
tiercerons1252443tiercerons
tiering8315243tiering
ties45248313ti___es
tigereyes1342733tigereyes
tigers75616503tiger__s
tigress836093tigress
tikes95628903ti__kes
tildes74513963ti_ldes
tilers63523493tiler__s
tiles55542103ti__les
timbres11249343timbres
timers84420993timer__s
times75630823ti__mes
tincts84510803ti_ncts
tines54848423ti__nes
tinges74722323ti_nges
tingles83818313tingles
tinkles113713923tinkles
tipples112811253tipples
tiptoes939173tiptoes
tirades8311723tirades
tire46143353ti_r_e_
tired65228903ti_r_ed
tireder837703tireder
tiredest938403tiredest
tireless82510263tireless
tirled74714363ti_rled
tirls54519803ti_r_ls
tiros54524893ti_r_os
tisanes7311853tisanes
tissues737463tissues
titers64526403titer__s
tithes94720213ti_thes
titles63719923ti_tles
titrates82314643titrates
titre54619393titr_e_
titties73617363titties
tittles73413253tittles
tizzies15287893tizzies
tmeses85712243tme_ses
torches123715433t_orches
torcs75123763t_orc_s
tores55352673t_or_es
tories65435883t_ories
torses64727953t_orses
tortes64826053t_ortes
traces85329933t_races
trances93919643trances
treacles1039703treacles
trebles9311443trebles
trees55835763t__rees
trenches133512603trenches
tres46542903t__r_es
tresses73719543tresses
trices84826333t_rices
trienes74118413trie_nes
trientes82812123trientes
triers64321523trier__s
tries55742813t__ries
triremes1035523triremes
truces84916333t_ruces
trues54925323t__rues
tsetses785453tsetses
tsores65113663tsor_es
tubercles1344153tubercles
tumesces1244843tumesces
turves94212693t_urves
tuyeres10417793tuyer_es
tweezes19345703tweezes
twelves1334303twelves
twerps11345153twer_ps
twiers95410163twier__s
tyees86019453tye__es
tyers86220053tyer__s
tyres84725233t_yr_es
tzetzes1532673tzetzes
veeries102916883veeries
verges104320173_verges
vermes115019143_vermes
verses94223763_verses
verves124617883_verves
vices105725533vi__ces
viers85621953vier__s
vineries112716043vineries
vires84529683vi_r_es
vivaces1536413vivaces
wheres125917433wher_es
wherves16548053wherves
wienies102213683wienies
winces114819113wi_nces
wineries112316533wineries
wires86034913wi_r_es
zeroes154314343_zeroes

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273306.34321129.9
3Display Results3303300.1103000.0
 (SQL Overall)1786913306.60927037.5
 
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.