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

177 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
uphroes123630(None) 
euphroes1345991euphroes
uphroe1136081uphroe_
euphroe1245392euphroe_
throes97518672_throes
updries10209082updries
upgrows1334322upgrows
upprops1044222upprops
uprose82311482up_rose
upthrows1643302upthrows
aperies9423203aperies
apheses12610703apheses
aphides134711203aphides
approves15126833approves
apres75426403ap_r_es
aprons8316993ap_rons
chores114828023_chores
chromes142914933_chromes
claroes93113733claroes
cuprous1149743cup_rous
duperies11312813duperies
echoes114715523ech_oes
ephebes1436153ephebes
ephods1238363eph_ods
ephors11311403eph_ors
euchres1288663euchr_es
froes86126693__froes
heroes94923823_heroes
hoes75755733__h_oes
mahoes11313103mah_oes
nephrons1346843nephrons
nephroses1446303nephroses
ochres113510833ochr_es
ochrous1237933ochrous
operons91411743operons
operose939433operose
ophites12310103ophites
ouphes113614633ouph__es
pareos87023773_pareos
pares77164483_par_es
parges94529543_parges
paries84742513_paries
parles86334393_parles
paroles95025883_paroles
parols84722613_parols
parous84024163_parous
parses85534703_parses
pekoes124410423_pekoes
peres76246643_per_es
perses85428063_perses
phages125213513_phages
pharos11312063_pharo_s
pharoses13310313_pharoses
phases114618403_phases
phizes20389133_phizes
phloem1335703_phloem
phloems1433523_phloems
phloxes1935513_phloxes
phones114121213_phones
phons105221143_ph_ons
phooey14379233_phooey
phoresy1534653_phoresy
phots105418493_ph_ots
phrase11109903_phrase
phrases12711463_phrases
physes14399783_physes
pores75849033_por_es
porose84818743_porose
porous84419483_porous
prees75937173_p_rees
pries74339533_p_ries
proas75028803_p_roas
probes104119453_p_robes
prods85523553_p_rods
proem94818273_p_roem
proems104711163_p_roems
profs105120893_p_rofs
progs86624153_p_rogs
proles84627203_p_roles
proms95426403_p_roms
props95726883_p_rops
pros65742783_p_ro_s
prose75835123_p_rose
proses84733473_p_roses
pross76529403_p_ross
proves114322253_p_roves
prows106327013_p_rows
pugrees10218523pugrees
purees84721683_purees
purges94421763_purges
purses84826373_purses
pushrods1443653pushrods
pyres105523883_pyr_es
pyrones123113303_pyrones
pyropes142210193_pyropes
pyros105718293_pyro_s
roes45954133___roes
schmoes14308543schmoes
schrods1337433schrods
shmoes114612093_shmoes
shoes85429653_sh_oes
shores94830403_shores
spares84834553spar_es
sparges104016333sparges
sphenes123013163sphenes
spheres123114353spheres
spires84628113spir_es
splores91910943splores
spores84726613spor_es
sprees85620643sp_rees
sprues84515763sp_rues
spurges104111653spurges
threes97117323_threes
throbs118311373_throbs
throe89321423_throe_
thrones105715843_thrones
throws129715233_throws
umpires1137813umpir_es
uncross938193uncross
undoes73917403u_ndoes
unfrees1048643unfrees
unhoods1137503unhoods
unhooks1436413unhooks
unhorse1038583unhorse
unhorses1138453unhorses
unrobes9269733u_nrobes
unthrones1297383unthrones
upases84112903up_ases
upbore10247883upbore_
upbows1384683up_bows
upcurves1583153upcurves
updates10329793updates
updives1334713updives
updos8389513up_do_s
updried11226473updried
upflows1543513upflows
upfront1246973upfront
upgazes1933573upgazes
upgrades12216063upgrades
upgrew1233653upgr_ew
upgrow1234273upgro_w
upgrown1343853upgrown
upheaps1494233upheaps
upheaves1643913upheaves
uphills1295233uphills
uphold12126903uph_old
upholds13135243upholds
uphove1436133uph_ove
uppiles11208263uppiles
upprop944093uppro_p
uprates93814863uprates
uprise82313693up_rise
uprises92012733uprises
uproar8106933up_roar
uproars986453up_roars
uproot8314123up_root
uproots937143uproots
uprouse937223up_rouse
uprouses1037553up_rouses
upshoots1344233upshoots
upshots1235193upshots
upsides10319633upsides
upsizes18297163upsizes
upstrokes1543153upstrokes
upsurges11144803upsurges
uptakes1336593uptakes
upthrew1542663upthr_ew
upthrow1543193upthro_w
upthrown1642593upthrown
uptimes1177543uptimes
uptore8279453uptore_
uptoss836093up_toss
urares64519093urar_es
urges64619913u__rges
usuries7510633usuries
whores125617103_whores
zeroes154314343_zeroes

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 Limit1340271776.03022226.7
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.24928595.1
 
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.