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

361 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
widdie11341073(None) 
kiddie12359391kiddie
waddie114013321waddie
widdies123514031widdies
widdle113814841widdle
baddie104114032baddie
biddies113514492biddies
birdie94013782birdie
caddie104316442caddie
cuddie104011172cuddie
diddle94915212diddle
didie74120562di_die
duddie9348862duddie
fiddle113613382fiddle
giddied11257712giddied
giddier10308722giddier
giddies103713362giddies
indie63721462_indie
kiddies133412282kiddies
laddie83713172laddie
middies113116152middies
middle103414982middle
piddle103514912piddle
riddle83915712riddle
twiddle12305482twiddle
waddied13358562waddied
waddies124214752waddies
waddle114715302waddle
wedgie11428352wedgie
weirdie11224062weirdie
widder112913972widder
widdled133511232widdled
widdles123514342widdles
widdy136112182widd_y
wide85235402wi_d_e
wienie9229972wienie
willie94116452willie
windier113412162windier
windle104617952windle
woodie103513612woodie
addle74318353_addle
aide56044993ai_d_e
baddies114017873baddies
bidden104010793bidden
bidder104114863bidder
bidding123613503bidding
biddy124612693bidd_y
bide76041473bi_d_e
bidi78226563bi_di_
bidis86721143bi_dis
biggie103810933biggie
bikie113915883bi_kie
billie85019173billie
bindi85617013bindi_
bindis94614583bindis
bindle94516263bindle
birdied11329433birdied
birdies104016213birdies
birkie124110133birkie
buddied12388003buddied
buddies113914353buddies
buddle104313083buddle
budgie104310343budgie
burdie93615023burdie
caddice13327733caddice
caddied123710563caddied
caddies113718383caddies
caddis104613373caddis
civie103716353ci_vie
coddle104713853coddle
cuddies113313263cuddies
cuddle104414533cuddle
daddies103414943daddies
daddle94214283daddle
dickie133913113dickie
diddled114212053diddled
diddler103511513diddler
diddles103915073diddles
diddley13388103diddley
diddlies1137593diddlies
diddly12389573diddly
didies84621833di_dies
die46759653___die
dikdik1152613dikdik
dildoe8198673dildoe
dindle84417223dindle
diode74716113diod_e
divide113410893divide
dwindle12415883dwindle
eddied9248323_eddied
eddies83313163_eddies
eide55832233ei_d_e
faddier1237783faddier
fiddled13329633fiddled
fiddler12309953fiddler
fiddles123212603fiddles
fiddly14328483fiddly
fidge104516053fi_dge
foodie104413843foodie
fuddies123211203fuddies
fuddle113312103fuddle
gaddi85211633gaddi_
gaddis94211373gaddis
giddap1143413giddap
giddiest11298553giddiest
giddily1335073giddily
giddy115810203gidd_y
gillie74816943gillie
gimmie11298173gimmie
girdle82110463girdle
girlie73711463girlie
goodie83613993goodie
griddle1035503griddle
heddle114211163heddle
hickie153812473hickie
hidden11429743hidden
hide85134623hi_d_e
hippie132811243hippie
hoddin11369933hoddin
hoodie105116133hoodie
howdie13349723howdie
huddle113712993huddle
idle55423763_i_dle
imide85716873_imide
indies73822773_indies
indite73520313_indite
indue63516673_indue
iodic84816743_iodic
iodid74315523_iodid
iodide84812923_iodide
iodin64419343_iodin
iodine74618643_iodine
iodise74214933_iodise
iodize164112583_iodize
jimmie17376463jimmie
kidded13299383kidded
kidder123811093kidder
kidding14389763kidding
kiddish16276583kiddish
kiddo11398943kidd_o
kiddoes13387063kiddoes
kiddos12416863kiddos
kiddy144910273kidd_y
kidlike1137063kidlike
kidvid1535023kidvid
killie104114893killie
kiltie103210963kiltie
kindle114414233kindle
laddies93715053laddies
lidded93410243lidded
lidding103611423lidding
lindies8416583lindies
lipide93511063lipide
lyddite1243333lyddite
meddle103312763meddle
midair937983midair
midday13327503midday
midden104112853midden
middled123311893middled
middler112712273middler
middles113415303middles
middy124812593midd_y
midge95016543mi_dge
midi75628463mi_di_
midis85923403mi_dis
midlife13248303midlife
midline102315103midline
midrib1138233midrib
midsize1946393midsize
midwife16225523midwife
misdid10510563misdid
mislie83219153mislie
muddied12339213muddied
muddier114110013muddier
muddies113513943muddies
muddle103414633muddle
neddies92710703neddies
nidate7313783nidate
nide55535783ni_d_e
nidi56524393ni_di_
nixie125114943ni_xie
noddies93512043noddies
noddle83211363noddle
nudie65118673_nudie
oidia6314953oi_dia
oldie6415473_oldie
paddies113715723paddies
paddle104615143paddle
pardie96021443pardie
peddle103512823peddle
perdie94718513perdie
piddled123311253piddled
piddler112911523piddler
piddles114314273piddles
piddly13319143piddly
pidgin10259813pidgin
piggie103210773piggie
pinkie124414273pinkie
pixie145415523pi_xie
puddle103914153puddle
raddle84816173raddle
reddle83815913reddle
ridded93615123ridded
ridden83511723ridden
ridder84015143ridder
ridding103314183ridding
riddled103012043riddled
riddler93411263riddler
riddles93215023riddles
ride55945123ri_d_e
ridge75018663ri_dge
ridgier937883ridgier
ridgil8316823ridgil
roadie72813803roadie
ruddier9338523ruddier
ruddle83414203ruddle
saddle83915493saddle
sickie123715743sickie
siddur834573siddur
side55444483si_d_e
sidhe95315103si_dhe
sidle65124033si_dle
silkie103313403silkie
skiddier1464193skiddier
soddies92312853soddies
studdie9195273studdie
swaddle12276743swaddle
swidden1234233swidden
swindle11389183swindle
teddies92711283teddies
tidbit938483tidbit
tiddler93110003tiddler
tiddly11308783tiddly
tide55237373ti_d_e
tidied83613273ti_died
tidier73515113ti_dier
tidies74721833ti_dies
tilde65017343tild_e
tittie63213153tittie
toddies93011993toddies
toddle85811033toddle
twaddle12245713twaddle
twiddled14284633twiddled
twiddler13244873twiddler
twiddles13265613twiddles
twiddlier1441863twiddlier
twiddly15233773twiddly
twinkie1434563twinkie
vide85432753vi_d_e
wadded124014173wadded
wadder114215483wadder
wadding133711943wadding
waddled133611643waddled
waddler124010793waddler
waddles124314843waddles
waddly14478723waddly
waddy135312993wadd_y
wade85237063w_ad_e
wadi86228173w_adi_
wadies105121203w_adies
wadis95223963w_adis
waffie15338563waffie
wallie93216803wallie
wandle105316663wandle
wedded123811833wedded
wedder113612293wedder
wedding133411873wedding
wedge105215633w_edge
wedgier12428273wedgier
wedgies123910203wedgies
weedier113810623weedier
weenie92612023weenie
weepie11258793weepie
weirdies12255783weirdies
wellie92814913wellie
whidded1634423whidded
whidding1734573whidding
widders123512263widders
widdling14228733widdling
widely133311033widely
widen94717973wi_den
widened12328053widened
widener11318693widener
widens106212723widens
wider94826353wi_der
wides94832823wi_des
widest104517003widest
widget113815253widget
widish13419363widish
widow1278933wi_dow
widowed1534843widowed
widower1435343widower
widows1376563widows
width12310963wi_dth
widths1335123widths
wieldier1234283wieldier
wienies102213683wienies
wife105228023wi__fe
wiftier13297733wiftier
wiggier12418863wiggier
wiggle113713013wiggle
wiglike15125853wiglike
wild85126513wild__
wilded113714503wilded
wilder103616473wilder
wildfire1542803wildfire
wilding123814293wilding
wildish1446853wildish
wildlife1543253wildlife
wildly13328123wildly
wilds94818203wild_s
wile75944373wi__le
wilier93217073wi_lier
willied114611563willied
willies103920153willies
wimble133211913wimble
wimmin1336143wimmin
wimpier14248043wimpier
wimple133611363wimple
wince105220883wi_nce
wind85533853wind__
windage1237933windage
winded114918213winded
winder104025263winder
windiest122213233windiest
windigo12415953windigo
windily1437943windily
winding123517913winding
windled123713483windled
windles113518493windles
window1347363window
windpipe1643183windpipe
winds95425603wind_s
windup1235383windup
windy126118103wind_y
wine74953423wi__ne
wingier113413273wingier
winier94522453wi_nier
winkle133812833winkle
wintle94014603wintle
winze175014853wi_nze
wipe94830283wi__pe
wire75839813wi__re
wirier94215553wi_rier
wisdom1235983wisdom
wise75737343wi__se
wispier12249403wispier
wite75443273wi__te
withe115220233wi_the
withier132910493withier
withies133913543withies
within123611383within
wittier103910823wittier
wive105931753wi__ve
wodge107212923w_odge
woodier113912063woodier
woodies113517153woodies
woolie93514483woolie
wordier112511203wordier
yippie13277843yippie
zaddik2134243zaddik

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.1561145455.1
2DLD Change Limit1127163616.03318683.2
3Display Results3613610.1232935.0
 (SQL Overall)1786913616.31228309.7
 
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.