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

165 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
pasteup113498(None) 
pasteups1243491pasteups
paste74932952paste__
pasted94426902paste_d
pastel85918712paste_l
pastels95215182pastels
paster85734372paste_r
pastern94415062pastern
pasters94531732pasters
pastes85233912paste_s
asleep847283_asleep
aster55434893_aste_r
astern64815813_astern
asters65631603_asters
auteur6107943_auteur
baste74829983baste__
basted95227233baste_d
baster85333593baste_r
basters94930303basters
bastes85330383baste_s
caste75932363caste__
caster85232573caste_r
casters94729903casters
castes85631863caste_s
catsup1036433ca_tsup
dustup935363dust_up
easter65027983easte_r
eastern74412533eastern
easters75125683easters
faceup1334893fa_ceup
fasted105320953faste_d
fasten95114893faste_n
fastens105511753fastens
faster94625773faste_r
fastest102413723fastest
gasted84821583gaste_d
gaster75027353gaste_r
gasters85624293gasters
haste85927863haste__
hasted105125283haste_d
hasteful14105253hasteful
hasten95718563haste_n
hastens106214813hastens
hastes95727073haste_s
hauteur1033893hauteur
instep838193inste_p
lasted74323603laste_d
laster64830633laste_r
lasters75627693lasters
makeup1434863ma_keup
masseur935703masseur
masted94025803maste_d
master84831343maste_r
masters94628923masters
mastery124214323mastery
misteuk1335893misteuk
palter84423263palte_r
palters94021683palters
panted95024823pante_d
pantoum1138703pantoum
pareu74928743pa_reu_
pareus85420743pa_reus
parted94228683parte_d
pase65346863pas_e__
paseo77022513pas_e_o
paseos88015813pas_eos
pases75346503pas_e_s
pashed125923143pashe_d
pashes115828393pashe_s
passe75525693passe__
passed94320943passe_d
passee84522023passe_e
passel85117003passe_l
passels93913023passels
passer84721033passe_r
passers94717753passers
passes86030473passe_s
passus83610293pas_sus
past65959013past___
pasta76624533past__a
pastas85422873past_as
pasterns104112623pasterns
pastie85525523past_ie
pastier94320383pastier
pasties94529813pasties
pastiest103319553pastiest
pastil85018323past_il
pastils94416173pastils
pastime114611973pastime
pastina93914593pastina
pasting103826553pasting
pastis84924323past_is
pastless102411203pastless
pastness102510503pastness
pastor84817483past_or
pastors94119003pastors
pastry114913033past_ry
pasts75936503past__s
pasture9311463pasture
pasty105725053past__y
pate65350463pa_te__
pated85237843pa_te_d
paten74827343pa_te_n
patens84820863pa_tens
patent84524923pa_tent
pater74740723pa_te_r
paters84935833pa_ters
pates76047893pa_te_s
patted94724683patte_d
pattee84323383patte_e
patten84418193patte_n
pattens95414923pattens
patter84628263patte_r
pattern93712053pattern
patters94825193patters
pester84827593peste_r
pesters93827093pesters
piaster93012883piaste_r
piasters102912813piasters
pileup10437923p_ileup
piste75824603piste__
pistes85325633piste_s
pistou83211843pistou_
pistous92714383pistous
plaster93318693plaste_r
plasters103518133plasters
plastery13279703plastery
plastrum1245713plastrum
pluteus9326243pluteus
poseur8419403pos_eur
postcoup1443863postcoup
posted93722493poste_d
posteen93512623posteen
poster84129173poste_r
postern93615613postern
posters93928013posters
postop10511943post_op
proteus92511593proteus
pseud867043p_s_eud
pushup1335273pus_hup
raster64731443raste_r
rasters74629023rasters
setup73915823__setup
steep76020703__steep
step67126293__ste_p
stoup75517073__stoup
takeup1234583ta_keup
taste55127233taste__
tasted74123973taste_d
tasteful11115223tasteful
taster64930573taste_r
tasters74225643tasters
tastes64126423taste_s
unstep839223unste_p
upstep1035503upste_p
vaster94521023vaste_r
vastest102911513vastest
washup1435323was_hup
waste86125053waste__
wasted104423023waste_d
wasteful14104933wasteful
waster95228943waste_r
wasters104026593wasters
wastery134610993wastery
wastes96224883waste_s

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.406440125.6
2DLD Change Limit1340271655.93622578.7
3Display Results1651650.0463587.0
 (SQL Overall)1786911656.38827972.9
 
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.