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 “weeps” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

182 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
weeps10412056(None) 
beeps95320971beeps
deeps84921771deeps
jeeps144715371jeeps
keeps116020281keeps
neeps75617881neeps
peeps95822361peeps
seeps74828751seeps
sweeps114110511sweeps
veeps104715721veeps
weeds95222211weeds
weeks125017861weeks
weens85224051weens
weep95131651weep_
weepy134212591weepy
wees76249121wee_s
weets85427721weets
wheeps14439951wheeps
beefs105618562beefs
beep85931212beep_
beers75628392beers
bees65453382bee_s
beets76131442beets
beweeps1494562beweeps
bleeps10499102bleeps
cees65941592cee_s
cepes94424462cepes
ceps86125952_ceps
cheeps135312912cheeps
creeps104213622creeps
deeds75423762deeds
deems85421772deems
deep76031882deep_
deers64930522deers
dees56356632dee_s
deets65330242deets
dweebs1233652dweebs
eels46536742_eels
ewers86018822ewers
ewes76328702ewe_s
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602fee_s
geeks104915842geeks
gees55647882gee_s
heaps105223222heaps
heeds95420422heeds
heels85625532heels
helps105219342helps
hemps126917332hemps
jeep135624842jeep_
jeers124818132jeers
jees115938542jee_s
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keep106329822keep_
keets95123482keets
keleps12478812keleps
kelps115116422kelps
kemps135012522kemps
keps106027302_keps
kreeps12427412kreeps
leaps75522932leaps
leeks95318892leeks
leers54828982leers
lees45455882lee_s
leets54927122leets
meeds84920272meeds
meets74224612meets
neaps75618322neaps
needs65719632needs
neems77316292neems
neep65728312neep_
peeks115021112peeks
peels75226422peels
peens76428192peens
peep85833692peep_
peers75130272peers
pees65257372pee_s
peps85134512_peps
perps95521482perps
preps96220692preps
reaps75626192reaps
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192ree_s
repps95114342repps
reps65937952_reps
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seep66540342seep_
seepy104717972seepy
seers55136382seers
sees45361052see_s
skeps115614252skeps
sleeps83913322sleeps
steeps85215192steeps
steps76619882steps
sweep104715722sweep_
sweepy14447452sweepy
sweets94214432sweets
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582tee_s
temps95417132temps
tweeds10498432tweeds
tweens9489842tweens
tweets94210102tweets
twerps11345152twerps
veep95325092veep_
veers84521362veers
vees75439432vee_s
waes76048602wae_s
waps96642082w_aps
warps107126422warps
wasps106714692wasps
weals85428742weals
weans85326742weans
wears86030302wears
webers11310942webers
webs96622122w_ebs
wedels103811032wedels
weds86628932w_eds
wee66760812wee__
weed85637512wee_d
weedy125115002weedy
week116428152wee_k
weel75834082wee_l
ween75835462wee_n
weensy12416822weensy
weeny115316162weeny
weeper114313302weeper
weepers123511972weepers
weepie11258792weepie
weepies122811742weepies
weer75535092wee_r
weest85026772weest
weet75254152wee_t
wefts116715492wefts
weirs84316492weirs
wekas123911792wekas
welds94719162welds
wells85426192wells
welts85225192welts
wends95822812wends
wens76337932w_ens
wept95635052w_ept
wests85727002wests
wets75940292w_ets
whaps135115162whaps
wheels123811712wheels
wheens124610612wheens
wheep136214352wheep_
whelps14437842whelps
whens114618762whens
whets115019612whets
whews145114492whews
wheys145911552wheys
whips134917082whips
whops135013932whops
whups134210002whups
wimps125213802wimps
wipes104827082wipes
wisps105214182wisps
woes76440662woe_s
woops104917522woops
wops96634152w_ops
wraps105617152wraps
wrens85016242wrens
wyes105727502wye_s
yelps105712992yelps
yeps95924402_yeps
zees136331892zee_s
zeps156019342_zeps

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001821.40338346.4
3Display Results1821820.0463956.5
 (SQL Overall)1786911821.762101413.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.