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

339 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
prearms1136917(None) 
prearm104512351prearm_
prewarms15406731prewarms
rearms85114651_rearms
breams104815042brea_ms
creams104715252crea_ms
dreams94513982drea_ms
drears74614252drear_s
firearms1335402firearms
forearms1336602forearms
pearls84715392p_earls
pears75138612p_ear_s
perms95524512p_e_rms
praams10459642pr_aams
prams96125512pr_a_ms
preacts113211362preacts
preamp1238992prea_mp
preamps1336612preamps
prearmed1397992prearmed
preforms1537402preforms
prelims1139822prelims
prepares122014162prepares
preterms1237222preterms
pretrims1238982pretrims
prewarm14479612prewarm_
prewarns13456942prewarns
realms84913492_realms
reams75729622_rea_ms
rearm75923572_rearm_
rears54739652_rear_s
rewarms12439602_rewarms
uprears9107492uprear_s
alarms85913053_alarms
anears63717183anear_s
appears11308953appear_s
areas55935773area__s
arms66137493___arms
arrears738843arrear_s
barms96128463__barms
beams95328173_bea_ms
beards94116673_beards
bears75739043_bear_s
berms95323663_be_rms
blears85116453blear_s
breads95419203brea_ds
breaks124816423brea_ks
bream95121813brea_m_
breasts939703breasts
breaths124411183breaths
briards10398553briards
briars84814823briar_s
charms135218843_charms
clears84116563clear_s
crams96229153cr_a_ms
creaks124315963crea_ks
cream95721353crea_m_
creamy134811363crea_my
creases94020963creases
creates95225203creates
dears65736883_dear_s
derms85022893_de_rms
disarms1039043disarms
drams86025833dr_a_ms
dreads84115023drea_ds
dream85120393drea_m_
dreamt94615713drea_mt
dreamy12509993drea_my
drear65016903drear__
drearies92313413drearies
dreary104611673drear_y
earls56127513__earls
earns55927563__earns
ears46356593__ear_s
farms106324953__farms
fears84829393_fear_s
firearm1237203firearm_
fleams115011943flea_ms
forearm1238703forearm_
freaks134713063frea_ks
freers94717303freer_s
frenums1236203frenums
freres94716173fre_res
friars93812093friar_s
gears64628693_gear_s
germs85118873_ge_rms
gleams94812253glea_ms
grams85327313gr_a_ms
greases84816713greases
greats76318393grea_ts
greaves113311443greaves
harms106829013__harms
hears86737373_hear_s
hearts96218943_hearts
herms105626433_he_rms
inarms8410093_inarms
learns65513743_learns
lears55938733_lear_s
nears55529423_near_s
oreads73915773orea_ds
orgasms1054293orgasms
overarms13258383overarms
paeans85118263paea_ns
palms94921753p__alms
pams85641763p__a_ms
paras76143043p__aras
pards85634333p__ards
pareiras1038183pareiras
parers85530743pare_r_s
pares77164483p__ares
paris75145943p__aris
parks116134463p__arks
parrs75928673p__arrs
pars67560793p__ar_s
parts77743373p__arts
peaces106324083p_eaces
peages94321853p_eages
peags86122843p_ea_gs
peaks114825623p_ea_ks
peals75235493p_ea_ls
peans75437643p_ea_ns
pear69745233p_ear__
pearl75324463p_ear_l
pearly116414843p_early
peart76440753p_ear_t
peas65755063p_ea__s
peases85229473p_eases
peats76140193p_ea_ts
pedros9312183p_edros
peers75130273p_eer_s
peres76246643p_e_res
performs1547483performs
peris75537073p_e_ris
perks115325803p_e_rks
perm85834633p_e_rm_
perps95521483p_e_rps
pervs105117373p_e_rvs
petards104311153petards
pharos11312063p_haros
phenoms1437813phenoms
phreaks1634543phrea_ks
picaras11311283picaras
picaros11310893picaros
piers75926333pie_r_s
plasms103711333p_lasms
pleads94613953plea_ds
pleas75627033plea__s
pleases94515483pleases
pleats85218593plea_ts
plenums1136533plenums
pleuras937413pleuras
poems95715553poe__ms
polars84419353polar_s
praam94815613pr_aam_
prahus11458243pr_ahus
pram85733493pr_a_m_
prangs94816233pr_angs
pranks124814723pr_anks
praos74923563pr_a_os
prases84429023pr_ases
prates84633163pr_ates
prats76333393pr_a_ts
praus74621753pr_a_us
prawns11509023pr_awns
praxes156215183pr_axes
praxis154012253pr_axis
prays105022433pr_a_ys
preach133613923prea_ch
preaches153214893preaches
preachy17307313preachy
preact103220393prea_ct
preadmit1346813preadmit
preadmits1444923preadmits
preaged11612333preaged
preanal9310713preanal
prearming14139223prearming
preaver121011613preaver
preavers13910263preavers
prebakes1639013prebakes
prebids12399883prebids
preboards1446423preboards
prebuys1444393prebuys
precasts1239453precasts
precess11310863precess
precis103416703pre_cis
precrash1544823precrash
precures12312903precures
precuts111710473precuts
predates11615813predates
predawns1444363predawns
predries112714383predries
predry1237873predr_y
preens85020113pre_ens
prees75937173pre__es
prefabs1435163prefabs
prefaces15311063prefaces
prefades1439533prefades
prefers123713333prefers
prefires134313283prefires
preform1439613preform_
pregame1239553pregame
pregames1339003pregames
prelates10418573prelates
prelim10311423prelim_
premeds12389593premeds
premies113823063premies
premiss113513813premiss
premiums1437533premiums
prename11412643prename
prenames12311643prenames
preops104911943pre_ops
preoral9312673preoral
prepacks1836583prepacks
prepare111913623prepar_e
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
prepaves15189193prepaves
prepays1437483prepays
prepreg12165963prepreg
prepregs13144763prepregs
prepress12137983prepress
preps96220693pre__ps
prerace11414123prerace
presages11312203presages
presales10315263presales
presets94216423presets
presorts105311683presorts
press75425953pre__ss
presses93523153presses
prestos93716083prestos
prests84021263pre_sts
presume11310303presume
presumes1239843presumes
pretapes122811533pretapes
preterm11310163preterm_
pretors9316813pretors
pretrim11310783pretrim
prevails1337663prevails
preverbs15295303preverbs
prevues1239263prevues
prewar114712583prewar__
prewarmed17104563prewarmed
prewarn124410153prewar_n
prewires133811013prewires
preworks17599013preworks
prewrap14104973prewrap
prewraps15114053prewraps
prexes154915953pre_xes
prexies163415003prexies
preyers124412363preyers
preys105717783pre__ys
prezes173614693pre_zes
priapus1134353priapus
priers84521193prier_s
prims95425933pr__ims
priors83914483prior_s
prisms104915503pr_isms
proas75028803proa__s
procarps1445973procarps
proems104711163pr_oems
programs1339783programs
proms95426413pr__oms
pryers115012243pryer_s
psalms1045673p_salms
rams65950773_r_a_ms
rares55247443_r_ares
reacts83616603_reacts
readds84111643_readds
reads64835273_rea_ds
reales64934123_reales
realm75621623_realm_
reals55038653_rea_ls
ream65841613_rea_m_
reaps75626193_rea_ps
rear45644553_rear__
reared75930013_reared
rearer64928913_rearer
rearers74323563_rearers
rearmed103912823_rearmed
rearmost1047263_rearmost
reatas64021013_reatas
reaves94127573_reaves
rebars84019833_rebar_s
reearns749103reearns
reforms1239823_reforms
regards94112563_regards
rehems113410983_rehems
remarks13329983_remarks
rems66237723_re__ms
reparks13249513_reparks
repros84216003_repros
retards85015003_retards
retems83914573_retems
retrims93612373_retrims
retros63820193_retros
rewards114813993_rewards
rewarm115913493_rewarm_
roams74919613_roa_ms
roars55622243_roar_s
screams114810623screa_ms
seams75731663_sea_ms
sears54744913_sear_s
shears93820903shear_s
sidearms1144093sidearms
smarms105712533_smarms
smears84714433smear_s
spears84019473spear_s
sperms102512603spe_rms
spreads1039763sprea_ds
steams84916903stea_ms
streams94713373strea_ms
swarms116112173_swarms
swears94114073swear_s
teams75726513_tea_ms
tears55436463_tear_s
terms75523473_te_rms
tharms115712243_tharms
therms115914873the_rms
tonearms1044713tonearms
trams75327673tr_a_ms
treads74817923trea_ds
treats64821693trea_ts
unarms839243_unarms
upbears1195423upbear_s
uprear8168793uprear__
upreared1137073upreared
uproars986453uproar_s
uptears9106453uptear_s
urares64519093ur_ares
uraris63817273ur_aris
ureas55826013urea__s
ureases74416723ureases
warms107726853__warms
wears86030303_wear_s
wreaks134711113wrea_ks
wreaths13338373wreaths
yardarms14123333yardarms
yearns9509543_yearns
years84527673_year_s

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 Limit1340273396.86019537.5
3Display Results3393390.1262690.5
 (SQL Overall)1786913397.39224173.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.