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

169 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
dweeby154299(None) 
dweeb1137741dweeb_
dweebs1233651dweebs
deedy104315892d_eedy
derby114715342d_erby
sweeny12358842sweeny
sweepy14447452sweepy
tweedy13455932tweedy
tweeny12477002tweeny
webby1537152_webby
weedy125115002_weedy
weeny115316162_weeny
weepy134212592_weepy
aweary1237303aweary
awee76336643awee__
beefy135313833_beefy
beery105220123_beery
blebby1233743blebby
breezy20295853breezy
cheeky18448613cheeky
cheery144913153cheery
cheesy14419193cheesy
creepy13418803creepy
dauby115211223d_auby
deary95826843d_eary
deb66342693d__eb_
debs76530243d__ebs
debt77139023d__ebt
debye1138903d__ebye
decay114718483d_ecay
decoy115716313d_ecoy
decry115514353d_ecry
dee47665823d_ee__
deed65340903d_ee_d
deeds75423763d_eeds
deejay1734523deejay
deem75432893d_ee_m
deems85421773d_eems
deep76031883d_ee_p
deeply1257013deeply
deeps84921773d_eeps
deer56739023d_ee_r
deers64930523d_eers
dees56356633d_ee_s
deet57356583d_ee_t
deets65330243d_eets
defy114921263d__efy
deify124112763d_eify
deity94316773d_eity
delay94820633d_elay
delly96023873d_elly
demy105422853d__emy
deny86027123d__eny
deoxy1648883d_eoxy
deray95024183d_eray
derry94721373d_erry
dewed105020303dewe_d
dewily1338343dewily
dewy115419023d__ewy
dexy156118553d__exy
dey77243373d__e_y
dicey114819333dice_y
dikey135116423dike_y
dioecy1235543dioecy
direly10311563direly
djebel1643453djebel
dobby136013633d_obby
doby106022163d__oby
dogey105719513doge_y
dopey116020353dope_y
dowery134311663dowery
dreamy12509993dreamy
dreary104611673dreary
drecky16486333drecky
dree56638323dree__
dreed75222843dree_d
drees65628523dree_s
dreggy12364633dreggy
dressy10518143dressy
dupery12378743dupery
dweebier1442223dweebier
dweebish1742183dweebish
dwell9519853dw_ell
dwells10417713dwells
dwelt94316523dw_elt
dykey16608673dyke_y
eely77725213__eely
eery76129623__eery
feeb96924543_feeb_
feebly1436653_feebly
feebs106112683_feebs
fleecy14266483fleecy
foreby1438633foreby
freely12310963freely
geeky134710733_geeky
gleety10479193gleety
greedy11518853greedy
greeny104811453greeny
herby134715313_herby
hereby14468333hereby
leery85919133_leery
needy94614693_needy
peery105719443_peery
qwerty2133583qwerty
reedy910020293_reedy
reefy114217703_reefy
reeky125416263_reeky
seedy94821533_seedy
seely84522633_seely
seepy104717973_seepy
sheeny124912193sheeny
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
sneery93610413sneery
sneezy18345273sneezy
speedy1218410793speedy
steely93612573steely
swabby1634353swabby
sweaty123710053sweaty
sweeney13387003sweeney
sweep104715723swee_p
sweeps114110513sweeps
sweer84918573swee_r
sweet85330523swee_t
sweetly1335593sweetly
sweets94214433sweets
teeny85417883_teeny
thereby1534633thereby
tweaky1634023tweaky
twee76827083twee__
tweed94915093twee_d
tweeds10498433tweeds
tween84413743twee_n
tweens9489843tweens
tweet84823983twee_t
tweets94210103tweets
tweeze18265473tweeze
twenty1236223twenty
veery115816253_veery
weary115620613_weary
web85735563_w_eb_
weber10313523_weber
webs96622123_w_ebs
wedgy13479803_wedgy
wee66760813_wee__
weed85637513_wee_d
weeds95222213_weeds
week116428153_wee_k
weekly1635313_weekly
weeks125017863_weeks
weel75834083_wee_l
ween75835463_wee_n
weens85224053_weens
weensy12416823_weensy
weep95131653_wee_p
weeps104120563_weeps
weer75535093_wee_r
wees76249123_wee_s
weest85026773_weest
weet75254153_wee_t
weets85427723_weets
welly114620013_welly
wenny114412463_wenny
wetly114511713_wetly
wheezy24244523wheezy
whereby1842913whereby
whey135018713_whe_y
womby155910093_womby

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.423422437.4
2DLD Change Limit1127161695.76619548.4
3Display Results1691690.0463673.9
 (SQL Overall)1786911696.23528659.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.