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

150 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
pushup133527(None) 
pushups1433651pushups
brushup1443512brushup
dustup935362dustup
pullup1045892pullup
push95526622push__
pushed125017462pushed
pusher114318282pusher
pushes114621662pushes
pushful1544492pushful
pushy134614352push_y
washup1435322washup
wushu1136992wushu_
bishop1336943bishop
brushups1542713brushups
bush96630713bush__
bushed124822383bushed
bushel114513943bushel
busher114922203busher
bushes115226113bushes
bushwa14105143bushwa
bushy135416683bush_y
cuscus1038113cuscus
cushat113513693cushat
cushaw14386983cushaw
cushy134412323cush_y
cusp86021063cus__p
cutup9410093cu_tup
dustups1033913dustups
fuckup1733963fuckup
gunship1345383gunship
gush85424003gush__
gushed114816243gushed
gusher104115773gusher
gushes104719033gushes
gushy125213123gush_y
hup86437813___hup
hush105224113hush__
hushed134416673hushed
hushes124718593hushes
hushful1644333hushful
lush75327693lush__
lushed104218723lushed
lusher93818763lusher
lushes94022743lushes
lushly12247343lushly
lusus54813873lus_us
mishap1338863mishap
museum1037703museum
mush94929123mush__
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushy135316633mush_y
palship1446833palship
pash95638133pash__
pasha105417183pash_a
pashas115117063pashas
pashed125923143pashed
pashes115828393pashes
passus83610293passus
pasteup1134983pasteup
phut96925973p__hut
pickup1655633pickup
pileup10437923pileup
pinup9612883p_inup
pish96127913pish__
pished124817063pished
pisher114317753pisher
pishes114722103pishes
plush105614713plush__
plusher124010383plusher
plushes124313673plushes
plushly15385383plushly
plushy14406973plush_y
poseur8419403poseur
posh95427323posh__
posher115018163posher
poshly1437723poshly
possum1057953possum
postop10511943postop
prahu105013973prahu_
prahus11458243prahus
preship1439793preship
pseud867043p_seud
pshaw13447513p_shaw
pugh106619233pugh__
pullups1134233pullups
pulp84825353pu__lp
pulque1736213pulque
pump105726853pu__mp
pup76339883p___up
pupu87620713pu_pu_
pupus94614043pu_pus
pursue84512253pursue
pus55547843pus___
puses75532203pus_es
pushers123814503pushers
pushier123611093pushier
pushily15247983pushily
pushing133615453pushing
pushpin1443233pushpin
pushrod1343703pushrod
pusley11379613pusley
puss64830133pus__s
pusses84322843pusses
pussly11407373pussly
pussy105614843pus_sy
pustule937683pustule
putout8315113putout
reship11310673reship
rush76628183rush__
rushed104419863rushed
rushee93818773rushee
rusher94019653rusher
rushes94724363rushes
rushy115414813rush_y
scup84822383__scup
ship95228243__ship
shop95629843__shop
shul75823153__shul
shun75122773__shun
shut76137593__shut
smashup1443453smashup
soup66232913__soup
sunup7313053su_nup
sup57041943__s_up
sushi8310493sush_i
sushis9311183sushis
tossup875293tossup
touchup1443833touchup
tuchun1145443tuchun
tuneup835203tuneup
turnup835093turnup
tush74523903tush__
tushed104615893tushed
tushes94319473tushes
tushie939723tushie
tushy114212993tush_y
tussur6357293tussur
unhip10178823_unhip
unship1148033unship
unshut939013unshut
upshot1138453upshot
upstep1035503upstep
usher84517763_usher
usque14137733_usque
usurp7106903_usurp
washups1534683washups
whup125714163__whup

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161505.86019234.8
3Display Results1501500.0602500.0
 (SQL Overall)1786911506.06029487.0
 
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.