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

191 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
washup143532(None) 
washups1534681washups
pushup1335272pushup
smashup1443452smashup
walkup1534192walkup
warmup1335342warmup
warship1547832warship
wash106033812wash__
washed135521502washed
washer124720392washer
washes124425492washes
washout13410132washout
washtub1542462washtub
washy145911842wash_y
wasp95626852was__p
whup125714162w__hup
wushu1136992wushu_
ascus75013583_ascus
ash67944603_ash__
ashed97829773_ashed
ashen87818673_ashen
ashes86230613_ashes
ashy107717353_ash_y
asp57235343_as__p
awash116613163awash__
backup1646613backup
barhop13319643barhop
bash915240163bash__
bashaw14349303bashaw
bashed126225703bashed
basher115123813basher
bashes115631393bashes
bashful1556553bashful
basque17259083basque
bishop1336943bishop
brushup1443513brushup
carhop133610763carhop
cash96636283cash__
cashaw14439793cashaw
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
cashoo11312253cashoo
casque17299273casque
casus76419253cas_us
catchup1644783catchup
catsup1036433catsup
dash87031633dash__
dashed115920563dashed
dasher104318983dasher
dashes106124983dashes
dashi95013113dash_i
dashis104414393dashis
dashy125612383dash_y
dustup935363dustup
faceup1334893faceup
fash107232293fash__
fashed136720253fashed
fashes124524023fashes
gash86833023gash__
gashed116321973gashed
gasher104320373gasher
gashes105725153gashes
gasp76227333gas__p
hangup1277293hangup
hash106936503hash__
hashed136021943hashed
hashes125024803hashes
hasp96627293has__p
hup86437813___hup
jaup135316423ja__up
kasha124710723kash_a
kashas133311903kashas
kasher134915033kasher
kashrut1444913kashrut
larrup835713larrup
lash76539653lash__
lashed105625213lashed
lasher94824533lasher
lashes94831003lashes
layup1037723la_yup
makeup1434863makeup
markup1436903markup
mash96039393mash__
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashie11315933mashie
mashy136016503mash_y
masque17249383masque
matchup1643513matchup
mayhap1635233mayhap
mishap1338863mishap
palship1446833palship
pash95638133pash__
pasha105417183pash_a
pashas115117063pashas
pashed125923143pashed
pashes115828393pashes
passus83610293passus
pasteup1134983pasteup
pushups1433653pushups
rash76039933rash__
rasher95024113rasher
rashes95330153rashes
rashly123410213rashly
rasp66029163ras__p
reship11310673reship
sadhu9459963sadhu_
sadhus10298463sadhus
samshu11134623samshu_
samshus12125353samshus
sannup836563sannup
sash77235303sash__
sashay1238363sashay
sashed105622943sashed
sashes94728483sashes
scup84822383__scup
ship95228233__ship
shop95629833__shop
shul75823153__shul
shun75122773__shun
shut76137583__shut
smashups1543213smashups
soup66232913__soup
sup57041943__s_up
swash116316753swash__
swashed144311363swashed
swasher134011503swasher
swashes134714403swashes
takeup1234583takeup
teashop1246083teashop
tossup875293tossup
unship1148033unship
unshut939013unshut
waeful1238123waeful
wahoo112413083wa_hoo
walkups1633013walkups
wallop113310293wallop
walnut939433walnut
walrus956433walrus
wammus13426733wammus
wampum15406053wampum
wampus13499013wampus
wamus105514683wa_mus
wangun1037103wangun
wap86553373wa___p
wardship1744873wardship
warmups1433813warmups
warp95635003wa__rp
warships1647543warships
was68767563was___
wasabi1154643wasabi
washday1743383washday
washers134517523washers
washier133611153washier
washing145119283washing
washouts1445903washouts
washrag1444043washrag
washtubs1641983washtubs
wasps106714693was_ps
waspy135410993was_py
wast75655853was__t
waste86125053was_te
wasted104423023wasted
waster95228943waster
wastes96224883wastes
wastry12388773wastry
wasts87433673was_ts
watap102111673wa_tap
wauk115220593wa__uk
waul76927313wa__ul
waur76819903wa__ur
whap125119643w__hap
whaup13458883w_haup
whip125521843w__hip
whop125520923w__hop
whump154910043w__hump
whups134210003w__hups
wikiup15183533wikiup
windup1235383windup
wish107228733wish__
wisha114910853wish_a
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wishful1664503wishful
wisp97124073wis__p
workup1534323workup
worship1547833worship
yaup96618483ya__up

Search took 6 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 Limit1127161915.00322529.7
3Display Results1911910.0603183.3
 (SQL Overall)1786911915.20334343.8
 
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.