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

242 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
prearmed139799(None) 
prewarmed17104561prewarmed
rearmed103912821_rearmed
breamed124011592brea_med
creamed123913712crea_med
dreamed114310632drea_med
firearmed1544042firearmed
forearmed1544862forearmed
pearled10411552p_earled
permed115217352p_e_rmed
preached163412062preached
preacted132710942preacted
preaged11612332prea_ged
prearm104512352prearm__
prearms11369172prearm_s
predried12309572predried
preformed17176202preformed
premed114617762pre__med
prepared132210872prepar_ed
presumed1337972presumed
prewarned1594772prewarned
reamed94326122_rea_med
reared75930012_rear_ed
rewarmed14257432_rewarmed
upreared1137082uprear_ed
afeared1176833afear_ed
alarmed1037743_alarmed
aneared8512743anear_ed
appeared1336143appear_ed
armed86324433___armed
beamed115720733_bea_med
bearded114212133_bearded
bermed115217723_be_rmed
bleared104211253blear_ed
breached163411643breached
breaded115014063brea_ded
breasted1138823breasted
breathed14469643breathed
charmed154714253_charmed
cleared103612463clear_ed
crammed143710123cr_ammed
creaked143413233crea_ked
creamer113714093crea_mer
creased104315593crea_sed
created104323453crea_ted
disarmed1238643disarmed
drammed13378073dr_ammed
dreaded103612023drea_ded
dreamer104110843drea_mer
drearier9297923drearier
drearies92313413drearies
eared65139503__ear_ed
earned74818333__earned
farmed125117653__farmed
feared106320433_fear_ed
framed125116523fr_a_med
freaked15399703frea_ked
geared85317743_gear_ed
gleamed11327933glea_med
greased93812393grea_sed
greaved12408913grea_ved
harmed125218833__harmed
hearsed113811423_hearsed
hearted113314033_hearted
inarmed10268673_inarmed
learned8329303_learned
neared75119813_near_ed
orgasmed1242933orgasmed
overarmed1538103overarmed
palmed114314643p__almed
pared86946763p__ar_ed
parged104922043p__arged
parked134425143p__arked
parled94626293p__arled
parred95024073p__arred
parsed96323893p__arsed
parted94228683p__arted
peaced115818913p_ea_ced
peached154315883p_eached
peaked136117403p_ea_ked
pealed95322813p_ea_led
pearler9310373p_earler
pearter9412743p_earter
peered93819493p_eer_ed
performed17155303performed
perfumed1654543perfumed
perked134617693p_e_rked
phreaked1834493phrea_ked
pierced12347593pie_rced
pleached16338063pleached
pleaded113511263plea_ded
pleased103712073plea_sed
pleated103816633plea_ted
praised104214813pr_aised
pranced123714043pr_anced
pranged114512553pr_anged
pranked143712093pr_anked
prated94924923pr_a_ted
prawned1346743pr_awned
prayed124815433pr_a_yed
preacher153211373preacher
preaches153214893preaches
preadmit1346813preadmit
prealter1048863prealter
preambled1643893preambled
preamp1238993prea_m_p
preamps1336613prea_mps
prearming14139223prearming
preaver121011613prea_ver
preaverred1642763preaverred
prebaked1737173prebaked
preboarded1663893preboarded
preceded1438293preceded
precharged1944553precharged
precised133213413precised
precited133013813precited
precoded1438863precoded
precured1339993precured
predated12513273predated
predries112714383predries
preed85128123pre___ed
preened103214993pre_ened
prefabbed1942323prefabbed
prefaced1638423prefaced
prefaded1537823prefaded
preferred1555003preferred
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
pregame1239553pregame_
pregames1339003pregames
preharden15104823preharden
preluded1236473preluded
premarket17127853premarket
premeds12389593pre__meds
premen105017803pre__men
premised133013193premised
premixed20338013premixed
prename11412643prename_
prenames12311643prenames
prenomen1249633prenomen
preorder1136463preorder
preowned1435213preowned
prepacked20155653prepacked
prepare111913623prepar_e_
preparer12169643prepar_er
prepares122014163prepar_es
prepasted14137673prepasted
prepaved16177233prepaved
prepped11329903pre_pped
prepreg12165963prepr_eg
prepriced1676643prepriced
prerace11414123prerace_
presaged1238813presaged
preserved15107563preserved
presided12410553presided
presorted1239453presorted
pressed103317313pre_ssed
pressmen1238833pressmen
presume11310303presume_
presumer1247583presumer
presumes1239843presumes
pretaped13339133pretaped
pretasted12147963pretasted
pretrimmed1742633pretrimmed
prettied1159253prettied
pretyped16306123pretyped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarm14479613prewarm__
prewarms15406733prewarm_s
prewashed1843923prewashed
prewired14358473prewired
preworked1954653preworked
preyed125313203pre__yed
primed115118913pr__imed
primmed14388853pr_immed
programed1585893programed
prorated11513713prorated
psalmed1234503p_salmed
purebred1344253purebr_ed
rammed113117303_r_ammed
rared65738323_r_ar_ed
reached134619083_reached
reacted103015713_reacted
readded103310733_readded
readied93316623_readied
reamer84325213_rea_mer
reaped94122453_rea_ped
rearer64928913_rear_er
reargued1035573_reargued
rearm75923573_rearm__
rearms85114653_rearm_s
reaved104523923_rea_ved
rebred95816353_rebr_ed
rebreed104611073_rebreed
redried93714903_redried
reearned948893reearned
reformed14249603_reformed
reframed1437853_reframed
refried113513883_refried
regarded11279803_regarded
relumed1069813_relumed
remarked15209243_remarked
renamed103114523_renamed
reparked15208923_reparked
resumed10310623_resumed
retarded102410753_retarded
retimed104714653_retimed
retried84419163_retried
rewarded13229523_rewarded
roamed95215093_roa_med
roared75015393_roar_ed
screamed13277603screa_med
seamed94823883_sea_med
seared75232843_sear_ed
sheared114516013shear_ed
smeared104510623smear_ed
speared104314423spear_ed
spearmen1234853spearmen
steamed103712143stea_med
streamed11258903strea_med
swarmed1367483_swarmed
teamed95418593_tea_med
teared75722153_tear_ed
termed94816703_te_rmed
trammed123810713tr_ammed
treaded95014283trea_ded
treadled1067123treadled
treated83618703trea_ted
unarmed101811923_unarmed
unearned9310063unearned
unharmed1438093unharmed
unwarmed1437303unwarmed
upreached1764083upreached
warmed124516893__warmed
wearied112911823_wearied
wreaked15369023wrea_ked
wreathed15257463wreathed
yearned11327373_yearned

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622427.39019778.3
3Display Results2422420.0962520.8
 (SQL Overall)1786912427.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.