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

463 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
warmest12311303(None) 
wariest105122501wariest
armet76739452_arme_t
armets84918352_armets
armrest9310162_armrest
arrest63722632_arrest
barest85327692bar_est
barmiest125212782barmiest
calmest11312342calmest
darkest122512622darkest
dwarfest1543472dwarfest
earnest7318732earnest
firmest1239272firmest
gamest94919922ga_mest
garment10315232garment
hardest113118412hardest
harvest132112752harvest
lamest84722762la_mest
largest83715102largest
rarest65725482rar_est
sarment9318762sarment
tamest85721292ta_mest
tartest72517532tartest
varment12313242varment
wackest164710862wackest
wames106432802wa_mes_
waniest103819112waniest
wannest103915002wannest
wares88250582war_es_
warless104015102warless
warmed124516892warme_d
warmer113816732warme_r
warmers124514292warmers
warmish1538372warmish
warmness1337062warmness
warms107726852warm_s_
wartiest113614642wartiest
wattest102412152wattest
waviest134513072waviest
waxiest173510882waxiest
weariest112914792weariest
wiriest103816852wiriest
wormiest13249542wormiest
wrest84925432w_r_est
wriest94419712w_riest
wryest12429112w_ryest
yarest95018912yar_est
ablest84721833_ablest
acmes96020653_acmes_
aeriest73924053aeriest
airest63825263_airest
airiest74221013airiest
alarmist1049123alarmist
almes75126543_almes_
almost81014433_almost
ament76036543_a_ment
aptest82917513_aptest
arames84622573_arames_
ardent73022613_ardent
ares45871023_ar_es_
argent74023663_argent
aridest8316143_aridest
arles56735743_arles_
armed86324433_arme_d
armer76924443_arme_r
armers85520273_armers
armies85123693_armies_
armless9369943_armless
armlet84118193_armlet
armlets94610063_armlets
armpit10811093_armpit
armrests1055373_armrests
arms66137493_arm_s_
arpent84822093_arpent
arrests73312683_arrests
arses55733873_arses_
artiest73121993_artiest
artist64125543_artist
attest62618613_attest
babiest114414753babiest
baddest112611143baddest
baldest102313533baldest
balmiest124110993balmiest
barbes104526233barbes_
barbet104427883barbe_t
barbets114915843barbets
bardes95026933bardes_
bares75457133bar_es_
barges94528253barges_
barghest1447913barghest
barguest1137163barguest
barkiest144115153barkiest
barless94317003barless
barmen105418533barme_n
barms96128463barm_s_
barniest104815053barniest
barres84427543barres_
barret84930483barre_t
barrets94917103barrets
baryes116218503baryes_
basest84720493ba_sest
bermes106023003bermes_
bravest124211753bravest
brawest123810483brawest
bummest13298623bummest
cagiest102916433cagiest
cakiest133215663cakiest
cames97047313ca_mes_
cares77369183car_es_
caress85720263car_ess
caret75360563car_e_t
carets85330773car_ets
caries85147623caries_
carles85435083carles_
carless95118493carless
carmen104019343carme_n
carnet84732873carne_t
carnets93918403carnets
carpet104530093carpe_t
carpets113915333carpets
carses85233653carses_
cartes86239473cartes_
carves115128453carves_
cermet10321153cerme_t
cermets1139713cermets
chariest13315503chariest
coarsest1039163coarsest
crest74632693_cr_est
curtest9713963curtest
daftest11248943daftest
dames85435853da_mes_
dampest12411043dampest
dankest122611673dankest
dares66146703dar_es_
darndest1067223darndest
dearest83618673dear_est
dimmest1249253dimmest
direst75024243dir_est
drest65530343_dr_est
driest74722753_driest
dryest104811123_dryest
durmast1037623durmast
dwarves1434463dwarves_
earless74316063earless
earliest82415243earliest
earnests837853earnests
easiest72318773easiest
eeriest73620673eeriest
fabbest1438033fabbest
fainest10417703fainest
fairest10412293fairest
falsest10310013falsest
fames105735923fa_mes_
farces115223323farces_
fares85852873far_es_
farles96025783farles_
farmed125117653farme_d
farmer115017373farme_r
farmers124315263farmers
farms106324953farm_s_
farness102912203farness
farthest1499863farthest
fastest102413723fastest
fattest102913063fattest
ferment12315573ferment
forest94926743for_est
formes114623713formes_
frames115119863frames_
freest95318283_freest
gabfest1336453gabfest
games86238553ga_mes_
gamiest102816223gamiest
gammiest13339323gammiest
garget84327273garge_t
gargets94614573gargets
garments1139963garments
garnet73928413garne_t
garnets84115403garnets
garret74426553garre_t
garrets84413623garrets
gashest114813413gashest
gayest104314333ga_yest
germiest11249913germiest
glariest92012523glariest
goriest82218743goriest
gravest114011633gravest
grayest11489363grayest
haddest122711993haddest
hairiest11612463hairiest
halest94823273ha_lest
hames106138703ha_mes_
hammiest152610003hammiest
hardiest123416333hardiest
hardset113415833hardset
harems115513823harems_
hares86255543har_es_
harmed125218833harme_d
harmer114719553harme_r
harmers124116593harmers
harmless1337403harmless
harms106829013harm_s_
harness102413933harness
harpist12312353harpist
harshest14310193harshest
harvests14246173harvests
haziest193313003haziest
hoariest11312883hoariest
hoarsest1137133hoarsest
iratest7312483iratest
jammiest19307203jammiest
kames115024693ka_mes_
karmas123013733karmas_
karst97228993kar__st
kermes124616123kermes_
kermess13396223kermess
kirmess13234313kirmess
laciest93819033laciest
lakiest113517263lakiest
lament85024943la_ment
lames75445543la_mes_
lankest112714113lankest
lardiest93813883lardiest
larees65323113larees_
lares54852633lar_es_
larges74824233larges_
largess8408913largess
larkiest123713313larkiest
latest63822703la_test
laxest134913363la_xest
laziest163814473laziest
leariest83117843leariest
maddest112311213maddest
malmiest123211023malmiest
mammet94319253mamme_t
mammets103911113mammets
mares76457633mar_es_
margent10316693margent
marges94525713marges_
market123226043marke_t
markets133314033markets
marliest102415183marliest
marmoset12411983marmoset
marmot10318743marm_ot
marmots11311513marmots
marses84827113marses_
matiest92522453matiest
maumet103518883maume_t
maumets11369693maumets
mayest114614793ma_yest
maziest183613873maziest
merest84725113mer_est
miriest93619823miriest
mirkest13309723mirkest
murkest133110203murkest
naivest10309473naivest
names74833363na_mes_
narcist9512443narcist
nares55544153nar_es_
nearest73415843near_est
oakiest112913923oakiest
oarless73913373oarless
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
palmiest123212023palmiest
palmist112814343palmist
parament12415393parament
parent83230423par_ent
pares77164483par_es_
parges94529543parges_
parget94529393parge_t
pargets105215193pargets
paries84742513paries_
parles86334393parles_
parmesan1244743parmesan
parses85534703parses_
payment14310703payment
peartest10311293peartest
pertest9317043pertest
prest75736353_pr_est
priest84125423_priest
purest84021933pur_est
raciest92820013raciest
raiment9315413raiment
ramet75743143ra_me_t
ramets83517393ra_mets
rammiest12299933rammiest
rankest112713813rankest
rares55247443rar_es_
rashest103916873rashest
rawest93615063ra_west
rearmost1047263rearmost
rearrest8311603rearrest
reest54938093__reest
rest46459843__r_est
rummest11279833rummest
saddest92412383saddest
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saltest71916513saltest
sanest64426693sa_nest
sarees65329943sarees_
sarges75128593sarges_
sarkiest123615063sarkiest
sarmenta1047723sarmenta
sarments10311963sarments
sayest94217743sa_yest
scarcest12169173scarcest
scariest101615943scariest
searest73322023sear_est
serest64831613ser_est
sharpest1339143sharpest
smarmiest1335903smarmiest
smartest10310183smartest
sorest65027993sor_est
sparest94616423spar_est
sparsest1048813sparsest
spriest92718643spriest
spryest12247813spryest
starkest1239723starkest
surest65026763sur_est
swankest15105933swankest
swarmed1367483swarme_d
swarmer1247803swarme_r
swarmers1346323swarmers
swarms116112163swarm_s_
tallest7317093tallest
tames75242013ta_mes_
tannest72617853tannest
tardiest93515243tardiest
tares57456563tar_es_
targes74524593targes_
target75028903targe_t
targets84314223targets
tarres64723043tarres_
tarriest83215003tarriest
tartiest82718313tartiest
tautest72612443tautest
teariest82417263teariest
tersest71713993tersest
torment9316173torment
truest64816193_truest
unrest62918853unr_est
unwariest1246033unwariest
vaguest1137333vaguest
vainest10315763vainest
varies94330873varies_
varlet9423503varle_t
varlets10411573varlets
varments1339063varments
varmint12311683varmint
varves124414783varves_
vastest102911513vastest
veriest103719133veriest
vermes115019143vermes_
wackes154717713wackes_
wackiest172610273wackiest
wades95634143wa_des_
wadies105121203wadies_
wadmel1235523wadme_l
wadmels1334303wadmels
wadset10314303wadse_t
wadsets1136443wadsets
waeness102512783waeness
waes76048603wa__es_
wages95330933wa_ges_
waist86132383wa__ist
waives123714183waives_
wakames1635283wakames_
wakes126633653wa_kes_
wales86142833wa_les_
walies95324523walies_
wallet93327093walle_t
wallets103914833wallets
wame95035483wa_me__
wammus13426733wammus_
wamus105514683wa_mus_
wanes85040883wa_nes_
wanness102610683wanness
warbles123215563warbles_
warded115021043warde_d
warden104515513warde_n
wardens113711903wardens
warder104020273warde_r
warders113416813warders
wardless12249303wardless
wardress12256163wardress
wards97734403war_ds_
ware76254723war_e__
wared96339873war_e_d
warhead1436603warhead
warier93722893warie_r
wariness11313213wariness
warked144421213warke_d
warks127932403war_ks_
warm95935673warm___
warming133515083warming
warmly14228063warm_ly
warmouth1644143warmouth
warmth1477933warm_th
warmths1583783warmths
warmup1335343warm_up
warmups1433813warmups
warned104018913warne_d
warner93717223warne_r
warners103315563warners
warns87231003war_ns_
warped124816413warpe_d
warper114015583warpe_r
warpers123413583warpers
warps107126423war_ps_
warrant10614243warrant
warred104019843warre_d
warren95012853warre_n
warrens103810893warrens
wars78659803war__s_
warsles103413643warsles_
wart77866083war___t
warted104223233warte_d
wartimes1336963wartimes_
wartless11279923wartless
warts814840403war_ts_
washes124425493washes_
washiest14310403washiest
waspiest1338813waspiest
wast75655853wa___st
wastes96224883wastes_
wateriest12312233wateriest
waves115633923wa_ves_
wavies125019843wavies_
waxes155825503wa_xes_
wayless13308243wayless
weakest1439003weakest
wearies103020223wearies_
weest85026773w__eest
weirdest1244433weirdest
wergelt1138583wergelt
west75748083w___est
wettest10239363wettest
wharves16457133wharves_
whitest133710113whitest
widest104517003w_idest
wildest113311273wildest
wiliest103416593wiliest
winiest103419693winiest
wires86034913wir_es_
wisest95016443w_isest
wordiest122311543wordiest
wormed124314303worme_d
wormer114514913worme_r
wormers124012573wormers
wormish1537163wormish
worms105320753worm_s_
worses95522953worses_
worset96726583worse_t
worsets105512843worsets
worst86330133wor__st
wrests95313083w_r_ests
wries85827743w_ries_
wrist84827563w_r_ist
wurst85122993wur__st
zaniest163214773zaniest

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 Filter1786911340270.1731032896.0
2DLD Change Limit1340274637.70317399.3
3Display Results4634630.1562967.9
 (SQL Overall)1786914638.03222247.4
 
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.