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

243 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
tawdry1339525(None) 
bawdry15516461bawdry
awry107619682_aw_ry
bawdy147513282bawd_y
tardy94720462tard_y
tarry85422512ta_rry
tawdrily1542732tawdrily
tawer85223442tawer_
tawers94118602tawers
tawney12338232tawney
tawny114713652taw_ny
towery124012092towery
aery77231683_a_ery
airy75734153_a_iry
alary86123443_alary
ambry123512103_ambry
andro6314163_andro
angry9310873_angry
apery106517903_apery
award97118043_award
aware86420023_aware
away108024223_aw_ay
aweary1237303_aweary
awny105919303_aw_ny
baddy125016023ba_ddy
badly114918763ba_dly
bakery155911003bakery
baldly12479833baldly
baldy115518933bald_y
bandy114824183band_y
bawd105520843bawd__
bawdily1635803bawdily
bawdric15164583bawdric
bawds116115493bawd_s
bawty135614103baw_ty
bowery146012113bowery
caddy125414023ca_ddy
cadgy125210783ca_dgy
cadre85419023ca_dre
calory11312843calory
canary11314693canary
candy115119823cand_y
carry105823783ca_rry
cowry135512483cow_ry
daddy116212563da_ddy
dairy97016303da_iry
dandy104416703dand_y
datary10310243datary
daubry12445483daubry
dawdle11399503dawdle
dowdy136112543dowd_y
dowery134311663dowery
dowry126312483dow_ry
dry76526033___dry
eatery95316353eatery
faddy135511623fa_ddy
faery116015483fa_ery
fairy115318283fa_iry
fakery16509263fakery
fawny144711713faw_ny
gantry103810113gantry
gaudery1234743gaudery
gaudy106611463gaud_y
gawky16569993gaw_ky
gawsy12459093gaw_sy
hairy115316833ha_iry
handy125520873hand_y
hardly135112833hardly
hardy125622063hard_y
harry115322953ha_rry
hawkey19507633hawkey
howdy155711413howd_y
japery18439143japery
kaury12429763ka_ury
lady86527153la_d_y
lardy96119273lard_y
laundry1133513laundry
lawny115912013law_ny
lewdly1334403lewdly
lowery124112713lowery
madly115218133ma_dly
madre85720173ma_dre
marry104821693ma_rry
mayday1535883mayday
napery11489813napery
nary76931223na__ry
paddy125913593pa_ddy
padre86018163pa_dre
padri85815173pa_dri
paltry114910403paltry
pandy115021173pand_y
panfry14456413panfry
pantry115014103pantry
papery134812743papery
pardy115523953pard_y
parry105323753pa_rry
pastry114913033pastry
pawer104422973pawer_
pawers114818783pawers
pawky173810153paw_ky
payday1536613payday
powdery16396123powdery
predry1237873predry
randy95022083rand_y
rawer84623733rawer_
rawly115115833raw_ly
redry94314363_redry
rowdy125711533rowd_y
sadly94519123sa_dly
salary9515213salary
sandy94221133sand_y
saury84317223sa_ury
savory124310563savory
sawer85026213sawer_
sawers94620163sawers
sawfly1535133sawfly
sawney12387603sawney
staidly1136683staidly
standby1334423standby
starry94911673sta_rry
sundry1057943sundry
tabard9313333tabard
tabby125213893ta_bby
taber73825823taber_
tabers84621573tabers
tabor75518393tabor_
tabors84517113tabors
tackey154613083tackey
tacky145617443ta_cky
tad47959823ta_d__
tads57143943ta_d_s
taffy145110823ta_ffy
tahr75217153ta_hr_
tahrs85412333ta_hrs
taker95229003taker_
takers103923743takers
talar56225383talar_
talars66021683talars
talcky15294723talcky
taler56034863taler_
talers64628143talers
talky126215683ta_lky
tally84526863ta_lly
tamari8313413tamari
tamely113711953tamely
tamer75230103tamer_
tamers84224033tamers
tammy124013223ta_mmy
tandem9311413tandem
tangly104413933tangly
tangy94519953ta_ngy
tannery10388663tannery
tannoy958363tannoy
tansy84514943ta_nsy
tantra63713363tantra
taper74829773taper_
tapers84025813tapers
tapir75917063tapir_
tapirs84113173tapirs
tar37570693ta__r_
tardily11269583tardily
tardo65321103tard_o
tare45957623ta__re
tarn46842723ta__rn
taro46846913ta__ro
tarp66936423ta__rp
tarre55825633ta_rre
tars46763953ta__rs
tart47566183ta__rt
tartly96014023tartly
tarty86328183ta_rty
tasty84820313ta_sty
tatar56122063tatar_
tatars64619793tatars
tater54138613tater_
taters64932203taters
tatty84720183ta_tty
tautly9499503tautly
tavern9428933tavern
taw610155453taw___
tawdrier12133433tawdrier
tawdries12136083tawdries
tawed95926193taw_ed
tawie84819813taw_ie
tawing104521553tawing
tawneys13324773tawneys
tawnily1335443tawnily
tawpie11339143tawpie
taws75641593taw__s
tawse85616503taw_se
tawsed10499743tawsed
tawses94913193tawses
taxer125019363taxer_
taxers134015283taxers
teary85124053t_eary
teaware1048143teaware
teddy10489493t_eddy
terry84721873t_erry
thawer12489343thawer_
thawers13428483thawers
theory121098363theory
thwart12311683thwart
tiddly11308783tiddly
tidy86822423t_id_y
tindery11389363tindery
toady96814343toad_y
today96416953t_oday
toddy106812423t_oddy
tody86327213t_od_y
tory75840543t__ory
toward10311063toward
tower85729203tower_
towers94423673towers
towny116114493tow_ny
towy105325473tow__y
tracery12399793tracery
trawley13317303trawley
try66529673t___ry
tundra736423tundra
twangy13386993twangy
twanky16445773twanky
twerp10398413t_werp
twiny116012813t_winy
twirl85011943t_wirl
twirly12427083t_wirly
twirp10468943t_wirp
unwary1239823unwary
updry1135483_updry
vagary1337333vagary
vapory14398763vapory
vary105226063va__ry
vaward13498723vaward
waddly14478723waddly
waddy135312993wa_ddy
wady115324993wa_d_y
wafery15398693wafery
wary106740013__wary
wastry12388773wastry
watery123914493watery
wavery154610053wavery
wiry106422833__wiry
wry96524703__w_ry
yawey14458273yaw_ey

Search took 9 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.420425454.8
2DLD Change Limit1127162438.15613820.0
3Display Results2432430.0803037.5
 (SQL Overall)1786912438.65620643.6
 
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.