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

220 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
prearming1413922(None) 
prewarming18145171prewarming
rearming111413611_rearming
breaming133612512brea_ming
creaming133413142crea_ming
dreaming124011062drea_ming
forearming1644192forearming
pearling11912012p_earling
perming123416092p_e_rming
pharming16248142p_harming
preaching172811162preaching
preacting142412532preacting
predrying1645342predrying
preforming1846232preforming
preparing14311642prepar_ing
presuming1437662presuming
prewarning16135192prewarning
reaming103924012_rea_ming
rearing83128782_rear_ing
rewarming15147382_rewarming
uprearing1238372uprear_ing
alarming1138583_alarming
anearing9413973anear_ing
appearing1436893appear_ing
arming94719803___arming
beaming123618803_bea_ming
bearding124011943_bearding
bearing103624773_bear_ing
berming123614833_be_rming
blearing113111943blear_ing
breaching17269403breaching
breading123515463brea_ding
breaking153914253brea_king
breasting1239583breasting
breathing15218373breathing
charming163012033_charming
clearing113014883clear_ing
clearwing1533673clearwing
cramming15339433cr_amming
creaking153414123crea_king
creasing113314443crea_sing
creating113921953crea_ting
disarming1338803disarming
dramming14347573dr_amming
dreading113712803drea_ding
earing75235483__ear_ing
earning83418213__earning
earring83519013__earring
farming133515083__farming
fearing113520033_fear_ing
framing133014793fr_a_ming
freaking163611453frea_king
gearing92818843_gear_ing
gleaming12277933glea_ming
greasing102811393grea_sing
harming133717933__harming
hearing113324163_hear_ing
hearsing1239383_hearsing
hearting12513123_hearting
inarming1138343_inarming
learning978553_learning
nearing83020333_near_ing
orgasming1343113orgasming
overarming1639233overarming
palming123914013p__alming
parging113318603p__arging
paring94236493p__ar_ing
parking143423043p__arking
parling103823763p__arling
parring103222063p__arring
parsing103819553p__arsing
parting103527383p__arting
peaching163613643p_eaching
peacing124117073p_ea_cing
peaking144317693p_ea_king
pealing104123203p_ea_ling
pearmain1245833p_earmain_
pearmains1345263p_earmains
peering103520353p_eer_ing
performing1844943performing
perfuming1784053perfuming
perking143716463p_e_rking
pharmings17254723p_harmings
phreaking1936473phrea_king
piercing1346663pie_rcing
pleaching17257083pleaching
pleading123011443plea_ding
pleasing112611593plea_sing
pleating112916053plea_ting
praising113214563pr_aising
prancing132612163pr_ancing
pranging123012723pr_anging
pranking153813383pr_anking
prating103424453pr_a_ting
prawning1446963pr_awning
praying133717323pr_a_ying
preadmit1346813preadmi_t
preadmits1444923preadmits
prearm104512353prearm___
prearmed1397993prearm_ed
prearms11369173prearm__s
prearrange1353213prearrange
preassign1244573preassign
preaverring1743243preaverring
prebaking1838063prebaking
preboarding1744273preboarding
prebuying1734303prebuying
precasting15169833precasting
preceding15129363preceding
precharging2043753precharging
precising14413273precising
precoding15109733precoding
precuring1439423precuring
predating13514653predating
preeing103817673pre__eing
preening113115843pre_ening
prefabbing2042583prefabbing
prefacing17118743prefacing
prefading16149033prefading
preferring1645623preferring
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
preluding1337053preluding
premising14412413premising
premixing2157803premixing
prenomina1347883prenomina
prepacking2145773prepacking
prepasting15168883prepasting
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763pre_pping
prepricing1746733prepricing
preprint12314183prepr_int
presaging1339393presaging
preserving1637363preserving
presiding13510903presiding
presorting1339983presorting
pressing112516443pre_ssing
pretaping1439133pretaping
pretasting13239283pretasting
pretrain10310923pretrain_
pretrains11410143pretrains
pretrimming1843033pretrimming
prettying1536043prettying
pretyping1764943pretyping
prevailing1656723prevailing
prevaluing1644273prevaluing
prevising15510873prevising
prevuing1457253pre_vuing
prewashing1944943prewashing
prewiring1547893prewiring
preworking2044233preworking
prewriting1647243prewriting
preying133114553pre__ying
priming123417373pr__iming
primming15268173pr_imming
programing1646313programing
prorating12314283prorating
psalming1375473p_salming
ramming123115063_r_amming
raring74332873_r_ar_ing
reaching143317203_reaching
reacting113317893_reacting
readding11411363_readding
reading93327213_rea_ding
readying13410223_readying
reaping103621213_rea_ping
rearguing1135603_rearguing
rearmice1255213_rearmice
reaving113820533_rea_ving
redrying13209023_redrying
reearning1039053reearning
reforming1538563_reforming
reframing1538623_reframing
refrying15278903_refrying
regarding12149153_regarding
reluming11310013_reluming
remarking1638893_remarking
renaming11313693_renaming
reparking1638923_reparking
resuming11310083_resuming
retarding111110653_retarding
retiming113014193_retiming
retrying122410453_retrying
rewarding14148833_rewarding
roaming103215793_roa_ming
roaring82916003_roar_ing
screaming14217833screa_ming
seaming103222113_sea_ming
searing83330923_sear_ing
shearing123915903shear_ing
shearling1336923shearling
smearing113511753smear_ing
spearing113216103spear_ing
spearmint1365983spearmint
spreading1339653sprea_ding
steaming114013213stea_ming
streaming12239653strea_ming
swarming1458223_swarming
swearing123711443swear_ing
teaming103917593_tea_ming
tearing84021493_tear_ing
terming104016003_te_rming
tramming13279343tr_amming
treading103515333trea_ding
treadling1137503treadling
treating92519613trea_ting
unarming1138623_unarming
upbearing1435033upbear_ing
upreaching1844113upreaching
uptearing1236103uptear_ing
warming133515083__warming
wearing113318863_wear_ing
wearying1546703_wearying
wreaking163010213wrea_king
wreathing16266313wreathing
yearling1297883_yearling
yearning1296983_yearning

Search took 10 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 Filter1786911486410.436409841.7
2DLD Change Limit1486412208.44017611.5
3Display Results2202200.0932365.6
 (SQL Overall)1786912208.96919923.2
 
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.