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

112 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
pushups143365(None) 
pushup1335271pushup_
brushups1542712brushups
dustups1033912dustups
pullups1134232pullups
pushers123814502pushers
pushes114621662push_es
washups1534682washups
bishops1437033bishops
brushup1443513brushup_
bushels124110713bushels
bushers124018803bushers
bushes115226113bush_es
bushwas15105613bushwas
cuscus1038113cuscu_s
cushats12288273cushats
cushaws15356293cushaws
cusps94913673cus__ps
cutups1036813cu_tups
dustup935363dustup_
fuckups1832923fuckups
gunships1445173gunships
gushers113512513gushers
gushes104719033gush_es
hushes124718593hush_es
lushes94022743lush_es
lusus54813873lus_u_s
mishaps1438723mishaps
museums1134563museums
mushers124016443mushers
mushes114124563mush_es
palships1546213palships
pashas115117063pash_as
pashes115828393pash_es
passus83610293passu_s
pasteups1243493pasteups
perhaps1446123perhaps
phuts104613503p__huts
pickups1754253pickups
pileups11365433pileups
pinups1037413p_inups
pishers123815753pishers
pishes114722103pish_es
plushes124313673plush_es
poseurs9378293poseurs
possums1145753possums
postops11311713postops
prahus11458243prahu_s
preships1539313preships
pseuds944793p_seuds
pshaws14435703p_shaws
psyops1334343p_syops
pullup1045893pullup_
pulps95116483pu__lps
pulques1835323pulques
pumps115520603pu__mps
pups86032233p___ups
pupus94614043pu_pu_s
pursues94111373pursues
puses75532203pus__es
push95526623push___
pushed125017463push_ed
pusher114318283push_er
pushful1544493pushful
pushier123611093pushier
pushiest133211713pushiest
pushily15247983pushily
pushing133615453pushing
pushpin1443233pushpin
pushpins1543343pushpins
pushrod1343703pushrod
pushrods1443653pushrods
pushy134614353push__y
pusleys12286233pusleys
puss64830133pus___s
pusses84322843pus_ses
pussies93615693pussies
pustule937683pustule
pustules1038443pustules
putouts937083putouts
reships1239863reships
rushees103311953rushees
rushers103816103rushers
rushes94724363rush_es
scups95316653__scups
ships105123773__ships
shops104222903__shops
shuls85319713__shuls
shuns85018143__shuns
shuts85622483__shuts
smashups1543213smashups
soups75322943__soups
sunups837263su_nups
sups64834433__s_ups
sushis9311183sush_is
tossups964023tossups
touchups1543083touchups
tuchuns1233983tuchuns
tuneups933333tuneups
turnups933893turnups
tushes94319473tush_es
tushies10312163tushies
tussurs7356393tussurs
unships1237203unships
upshots1235193upshots
upsteps1133743upsteps
ushers94415533_ushers
usques15126803_usques
usurps8105073_usurps
washup1435323washup_
whups134210003__whups
wushu1136993wushu__

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.390458182.1
2DLD Change Limit1340271125.87622809.2
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.31228309.7
 
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.