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

192 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
purpose113738(None) 
purposed1335251purposed
purposes1237821purposes
pappose1047412pappose
porose84818742por_ose
porpoise1248072porpoise
propose112714842propose
prose75835122p_r_ose
purple102712672purp_le
purples112712822purples
purport1159392purport
purposely1642912purposely
purposive1643222purposive
purpure1195992purpure
purse76028892pur__se
repurpose1343132repurpose
suppose1137972suppose
uprose82311482upr_ose
adipose1036653adipose
airpost939243airpost
appose10411993_appose
ariose64818723_ariose
arkose104911343_arkose
arose55832083_ar_ose
aureole738693aureole
brose75227033_br_ose
burnoose1043313burnoose
burps94220173burp_s_
burros85114993burros_
burse75527253bur__se
cirrose937473cirrose
compose135716663compose
corpse104013403corp_se
curios83218333curios_
curiosa9346643curiosa
curse75829143cur__se
depose94215763_depose
dispose10312753dispose
duros65422693dur_os_
erose55727273_er_ose
euros54920243eur_os_
expose1549523_expose
fucose11167683fu_cose
furanose1144753furanose
furioso1044323furioso
furore9410013fur_ore
grumose1035723grumose
gummose1235333gummose
gyrose105310253gyr_ose
impose103113043_impose
kurtoses12105623kurtoses
leprose938543leprose
morose85116243mor_ose
mucose10149313mu_cose
narcose95910383narcose
nurse54420123nur__se
operose939433oper_ose
oppose1039193_oppose
outpost9612443outpost
papoose1147513papoose
pappoose1143803pappoose
parclose1247243parclose
pareos87023773pareos_
pargos95719043pargos_
parole84425253par_ole
parse75236993par__se
parvise124211693parvise
parvos116614753parvos_
pentose9311593pentose
pepos96620083p_epos_
perfuse1247663perfuse
perps95521483perp_s_
perse75429523per__se
peruse84016843per_use
phrase11109903phr_ase
pilose84514233p_ilose
plumose1135963plumose
pluviose1342663pluviose
pornos85015243pornos_
porpoised1445443porpoised
porpoises1348433porpoises
pose66441733___pose
postpose1247643postpose
praise84419413p_raise
praos74923563p_raos_
prase76128753p_r_ase
prese75228383p_r_ese
prise74632613p_r_ise
probe94320813p_r_obe
prole74527793p_r_ole
prone75332623p_r_one
propone112716303propone
proposed132011073proposed
proposer121810633proposer
proposes122515973proposes
props95726883p_rops_
pros65742783p_r_os_
prosed94921093p_r_osed
proser84223463p_r_oser
proses84733473p_r_oses
proso77222413p_r_oso
pross76529403p_r_oss
prost75434103p_r_ost
prosy106319253p_r_osy
prove104823193p_r_ove
pruinose1044853pruinose
pulpous1177003pulpous
pulps95116483pulp_s_
pulse74219973pu__lse
pumps115520603pump_s_
puntos85915793puntos_
pupae96515643pu_p_ae
pupas95219283pu_pas_
pupate104213123pu_pate
puppies103212613puppies
pups86032233pu_p_s_
pupus94614043pu_pus_
purchase1545293purchase
purdas92612263purdas_
pure65543333pur___e
puree74632843pur__ee
purees84721683purees_
purest84021933pur_est
purfle112511183pur_fle
purfles122511843purfles
purge85324603pur__ge
purges94421763purges_
purine85321893pur_ine
purines94420763purines
purins83722653purins_
puris75332023pur_is_
purism104715063pur_ism
purist85525053pur_ist
purline93516533purline
purloin9107493purloin
purls74723353pur_ls_
purpled12299753purpled
purpler11289263purpler
purplest12249123purplest
purplish1554933purplish
purply13369043purp_ly
purported1443453purported
purports1265783purports
purposeful1751283purposeful
purposing1445233purposing
purpura1144793purpura
purpures1276143purpures
purrs75320433pur_rs_
purs65641043pur__s_
pursed95220883pur__sed
purser85020473pur__ser
purses84826373pur__ses
pursue84512253pur_sue
pursues94111373pursues
pursy105016413pur__sy
pyranose1344923pyranose
pyrone112714473pyr_one
pyrope132810533pyr_ope
pyropes142210193pyropes
pyros105718293pyr_os_
pyrrole1246033pyrrole
repose84121413_repose
repurposed1542673repurposed
repurposes1443173repurposes
rerose63320843rer_ose
roose56127093__roose
rose46148903__r_ose
rugose737283ru_gose
scapose1147753scapose
sorbose938983sorbose
sucrose939303sucrose
superpose1349023superpose
supposed1345783supposed
supposer1245593supposer
supposes1238203supposes
surbase939793surbase
surmise9311083surmise
surpass938283surpass
surprise1037673surprise
torose64317693tor_ose
triose64715383_triose
turbos8910783turbos_
turps74918733turp_s_
unposed10711903_unposed
upraise9158603upraise
uprise82313693upr_ise
uprouse937223uprouse
urase54624683_ur_ase
urease64516993_urease
urinose738483_urinose
urps66920473_urp_s_
verbose1237753verbose

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.1561145455.1
2DLD Change Limit1340271926.67320085.0
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.89225927.3
 
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.