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

257 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
armrest931016(None) 
armrests1055381armrests
arrest63722631ar_rest
addrest958632addrest
airest63825262a_irest
aridest8316142aridest
armers85520272armers_
armet76739452arm_e_t
armets84918352arm_ets
armies85123692armies_
armless9369942armless
armlet84118192armle_t
armlets94610062armlets
armures9510272armures_
arrests73312682ar_rests
artiest73121992artiest
barmiest125212782barmiest
rarest65725482_rarest
warmest123113032warm_est
ablest84721833a_blest
abreast9311283a_breast
acerbest1245463acerbest
achiest12315193achiest
acmes96020653acm_es_
acquest1837173acquest
acres76327763a_cres_
acridest1138143acridest
actress948533actress
acutest94410603acutest
address956103address
admires1038663admires_
adores74420723adores_
aeriest73924053aeriest
afforest1446343afforest
afreet9315153a_freet
afresh1255503a_fresh
aggress935593aggress
aigret73720023aigre_t
aigrets82810533aigrets
aimers84621913aimers_
aimless93610813aimless
airiest74221013airiest
alertest8310173alertest
almagest1146233almagest
almes75126543alm_es_
almost81014433alm_ost
ament76036543a_m_ent
amidst94913233a_midst
amies76837693a_mies_
amnesty1244823a_mnesty
amorist9317643amorist
amplest11312333amplest
amreeta945163a_mreeta
anapest9311563anapest
ancress978613ancress
angriest9310253angriest
antres65021003antres_
aorist64827873a_orist
apres75426403a_pres_
aptest82917513a_ptest
arabesk1332863arabesk
arames84622573arames_
arbalest1039523arbalest
arbelest1049503arbelest
arbores94016033arbores_
arborist10411613arborist
arches114822043arches_
ardent73022613ar_dent
arenes64928393arenes_
ares45871023a__res_
aretes64425353aretes_
argent74023663ar_gent
argles75218483argles_
argues74516413argues_
arises65233803arises_
arles56735743ar_les_
armament1249633armament
armed86324433arm_e_d
armer76924443arm_e_r
armoires1057623armoires_
armored102610473armore_d
armorer9259913armore_r
armorers10288973armorers
armories10313653armories_
armorless1143483armorless
armors85017813armors_
armpit10811093arm_pit
armpits1157133armpits
arms66137493arm__s_
armure8710133armure__
arpent84822093ar_pent
arrant6623253ar_rant
arras55626133ar_ras_
arrear6310253ar_rear
arrested939163ar_rested
arrestee849443ar_restee
arrester839253ar_rester
arrestor847653ar_restor
arris56824683ar_ris_
arses55733873ar_ses_
artist64125543ar_tist
artless73712513artless
artsiest879653artsiest
ashiest10313963ashiest
attest62618613a_ttest
auldest839893auldest
aures55137093a_ures_
aurist65027253a_urist
azures15510183azures_
backrest1639393backrest
balmiest124110993balmiest
barest85327693_barest
barghest1447913barghest
barguest1137163barguest
barkiest144115153barkiest
barniest104815053barniest
barres84427553bar_res_
barret84930493bar_re_t
barrets94917103bar_rets
bravest124211753bravest
brawest123810483brawest
bummest13298623bummest
calmest11312343calm_est
crest74632693__crest
crores86121163crores_
crudest104510333crudest
dampest12411043dampest
darkest122512623dar_kest
darndest1067223darndest
dearest83618673dearest
demurest1137453demurest
dimmest1249253dimmest
direst75024243_direst
dourest8312943dourest
drest65530343__drest
driest74722753dr_iest
dryest104811123dr_yest
dumbest1238743dumbest
eagerest9510273eagerest
earliest82415243earliest
earnest7318733ear_nest
elmiest9310743elmiest
fairest10412293fairest
farmers124315263farmers_
farthest1499863farthest
firmest1239273firm_est
forest94926743_forest
freest95318283fr_eest
freres94716173freres_
fumiest12312193fumiest
gamest94919933gam_est
gamiest102816233gamiest
gammiest13339333gammiest
garment10315233garm_ent
garret74426563gar_re_t
garrets84413623gar_rets
germiest11249923germiest
gravest114011633gravest
grayest11489363grayest
greyest11348343greyest
grimiest11299823grimiest
grimmest13286293grimmest
grummest13286363grummest
hammiest152610013hammiest
hardest113118413har_dest
hardiest123416343hardiest
harmers124116593harmers_
harmless1337403harmless
harshest14310193harshest
harvest132112753har_vest
homiest124116633homiest
imprest11310203imprest
iratest7312483iratest
jammiest19307203jammiest
jimpest18297553jimpest
lamest84722763lam_est
lardiest93813893lardiest
largest83715103lar_gest
larkiest123713323larkiest
limiest93716103limiest
limpest113712313limpest
malmiest123211023malmiest
marliest102415183marliest
marmoset12411983marmoset
maturest1039703maturest
merest84725113_merest
nearest73415843nearest
numbest1138793numbest
orbiest9312413orbiest
ormers84316143ormers_
palmiest123212033palmiest
parures9512693parures_
poorest9312773poorest
prest75736353__prest
pretest9517633pretest
priest84125423pr_iest
primmest14226693primmest
protest9317533protest
prowest12311533prowest
purest84021933_purest
raciest92820013raciest
ramees84620893ramees_
ramet75743143ram_e_t
ramets83517393ram_ets
ramies84630463ramies_
ramjet15311543ramje_t
ramjets1635163ramjets
rammiest12299933rammiest
rankest112713813rankest
rares55247443_rares_
rashest103916873rashest
rawest93615063_rawest
rearrest8311603rear_rest
reest54938093_r_eest
renest64529713_renest
rerent63832453_rerent
rest46459843___rest
retest64028453_retest
revest94623603_revest
rifest93114583_rifest
rimiest93215853rimiest
ripest84317943_ripest
rudest74016313_rudest
rummest11279833rummest
sarkiest123615073sarkiest
sarment9318763sarm_ent
searest73322023searest
serest64831613_serest
smarmiest1335913smarmiest
sorest65028003_sorest
sourest7515713sourest
sparest94616433sparest
surest65026763_surest
tamest85721293tam_est
tardiest93515243tardiest
tarres64723043tar_res_
tarriest83215003tarriest
tartest72517533tar_test
tartiest82718313tartiest
tempest1139223tempest
trimmest12227023trimmest
tritest7315273tritest
truest64816193tr_uest
undrest8313013undrest
unrest62918853_unrest
urares64519093urares_
varment12313243varm_ent
wardress12256163wardress
wariest105122503war_iest
warmers124514293warmers_
warmness1337063warmness
wartiest113614643wartiest
wormiest13249543wormiest
wrest84925433__wrest
wriest94419713wr_iest
wryest12429113wr_yest
yarest95018913_yarest

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.406440125.6
2DLD Change Limit1340272576.34321129.9
3Display Results2572570.1102336.4
 (SQL Overall)1786912576.85926052.0
 
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.