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

352 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
widgets1231845(None) 
fidgets12388761fidgets
midgets113910251midgets
nidgets9358141nidgets
widget113815261widget_
bidets95215532bid_ets
budgets11489862budgets
fidges114114392fidge_s
fidget114216482fidget_
fidgety15384892fidgety
gadgets10348682gadgets
midges103516482midge_s
midget103718452midget_
midguts11296012midguts
nidget83715642nidget_
ridgels9348022ridgels
ridges85817012ridge_s
wadsets1136442wadsets
wedges114614582wedge_s
wickets164010942wickets
widders123512272widders
widens106212722wid_ens
wides94832822wid_e_s
widest104517002wid_est
widgeon1244142widgeon
widgeons1343852widgeons
wights133315782wi_ghts
wiglets113411422wiglets
willets104414322willets
wingers113921482wingers
winglets12299592winglets
wodges117413682wodge_s
aiders74524633aid_ers
aides65336603aid_e_s
aidless83612073aidless
aiglets84012913aiglets
aigrets82810533aigrets
badgers114812653badgers
badges103917373badge_s
begets96215523_begets
bidders114012313bidders
biders94822803bid_ers
bides85536773bid_e_s
bidet84935623bid_et_
biggest1138143biggest
biggety1434433biggety
bights124417963bi_ghts
bigots95015133bi_gots
bilges94915633bilge_s
billets94516153billets
bingers104519993bingers
binges93923123binge_s
biogens1038963biogens
bridges113911333bridge_s
budgers114314923budgers
budges104820133budge_s
budget104618123budget_
cadets96316513cad_ets
cadgers114712003cadgers
cadges104716713cadge_s
ciders94620093cid_ers
civets115212543ci_vets
codgers115113933codgers
cudgels1135333cudgels
deets65330243__deets
didacts1186063didacts
didies84621833didie_s
didoes85716963didoe_s
diets66026643__diets
digest84019623di_gest
digests93610613di_gests
diggers104413393diggers
dights114016963di_ghts
digits84114533di_gits
dingers94321383dingers
dinges83825423dinge_s
dingeys12458403dingeys
dipnets10109033dipnets
dirges84915103dirge_s
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119083dodge_s
duets65323883__duets
edgers84413923_edgers
edges75718743_edge_s
eiders74321363eid_ers
eights103618983ei_ghts
fadges114814033fadge_s
fidge104516063fidge__
fidged124610933fidge_d
fidgeted1443893fidgeted
fidgeter1343783fidgeter
fidgeters1443623fidgeters
fights133816553fi_ghts
filets94718953fi_lets
fillets103414753fillets
fingers113418433fingers
forgets113813793forgets
fridges12369483fridge_s
fudges114314503fudge_s
gadget93616183gadget_
gadgety13356163gadgety
gargets94614573gargets
gets55442483___gets
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gigots83911953gi_gots
gimlets10338433gimlets
gingers94118643gingers
godets8410933god_ets
gorgets94711783gorgets
hedgers124310263hedgers
hedges115016263hedge_s
hiders104919653hid_ers
hides95129423hid_e_s
hights133716893hi_ghts
hindguts1343013hindguts
hingers113420213hingers
hinges105121033hinge_s
hoggets12498323hoggets
ideas65919013_id_eas
ides57734233_id_e_s
idiots768643_idiots
idlers74012813_idlers
idles66720123_idle_s
idlest74014863_idlest
ingest73119003_ingest
ingests83210983_ingests
ingots7912063_ingots
inlets63915573_inlets
insets64016133_insets
islets64513083_islets
jiggers164010183jiggers
judgers16369043judgers
judges153713463judge_s
kedges124812983kedge_s
kidders13399173kidders
kidneys1533423kidneys
kinglets13318583kinglets
kismets13306883kismets
ledgers94912183ledgers
ledges84918013ledge_s
lidless8309273lidless
lieges74113443liege_s
ligers75022043li_gers
lights104519913li_ghts
limpets11329783limpets
lingers84223303lingers
linnets739833linnets
lodgers95113833lodgers
lodges86820153lodge_s
loggets9378913loggets
middens11379383middens
midge95016553midge__
midgut103510053midgut_
midlegs1156323midlegs
midsts95510053mid_sts
mights123516253mi_ghts
millets94216843millets
mindsets1135683mindsets
minuets9259853minuets
missets94516573missets
nidates8311893nidates
nides65229133nid_e_s
niggers93111323niggers
nights104117723ni_ghts
nudgers9479373nudgers
nudges84114743nudge_s
nuggets936383nuggets
pargets105215193pargets
pickets154314183pickets
pidgins11259123pidgins
piglets103311793piglets
pingers104020743pingers
piolets93513193piolets
pipets105714773pi_pets
piquets1836603piquets
pledgets12365673pledgets
riblets93412553riblets
rickets134915093rickets
ridders93612493ridders
riders74123903rid_ers
rides66140813rid_e_s
ridge75018673ridge__
ridged94014223ridge_d
ridgel8399973ridge_l
ridgetop1242233ridgetop
ridgetops1342193ridgetops
ridgiest1038903ridgiest
ridgils9326573ridgils
ridleys11145783ridleys
riggers93613843riggers
rights104019333ri_ghts
rillets74216153rillets
ringers83922953ringers
ringlets92910233ringlets
rivets94417113ri_vets
sedges83817813sedge_s
sides65838363sid_e_s
sidlers83414233sidlers
sidles74721153sidle_s
sieges73816833siege_s
sights103818013si_ghts
signets83311503signets
singers83824703singers
singes74326853singe_s
singlets93611473singlets
sippets113310183sippets
smidgens12325643smidgens
smidges11448193smidge_s
swiddens1342713swiddens
swiggers13337123swiggers
swingers123710423swingers
swinges113413423swinge_s
swivets13436963swi_vets
targets84314223targets
tickets134113683tickets
tidbits1035183tidbits
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiest83514873tidiest
tigers75616513ti_gers
tights104015853ti_ghts
tinges74722333tinge_s
tippets11339373tippets
twinges11409453twinge_s
twinjets1842413twinjets
twinsets1133663twinsets
videos104911373vid_eos
violets102210003violets
wadders123812443wadders
waders109120643wad_ers
wades95634143wad_e_s
wadies105121203wadie_s
wadmels1334303wadmels
wadset10314303wadset_
wagers105122203w_agers
wages95330933w_age_s
waggers124613083waggers
wallets103914833wallets
waughts14355963waughts
wedders123610723wedders
wedels103811033wed_els
wedge105215663wedge__
wedged125110303wedge_d
wedgies123910213wedgies
wedgiest13307983wedgiest
weets85427723w__eets
weights14409553weights
wergelts1253413wergelts
wets75940293w___ets
whets115019613w__hets
whiffets2072523whiffets
whingers15358723whingers
whinges143610633whinge_s
whippets18255253whippets
wiches144418753wiche_s
wickers164114703wickers
wicket155318943wicket_
widder112913973widde_r
widdies123514033widdies
widdles123514343widdles
wide85235413wid_e__
widely133311033wid_ely
widen94717973wid_e_n
wideners12257993wideners
wideness12259473wideness
wideouts1275233wideouts
wider94826353wid_e_r
widowers1535113widowers
widows1376563wid_ows
width12310963wid__th
widths1335123wid_ths
wieners103212483wieners
wifes114522563wi_fe_s
wifeys15425873wi_feys
wigans104511703wi_gans
wigeon1037223wi_geon
wigeons1136983wi_geons
wigged124413583wigge_d
wiggery15295873wiggery
wiggiest13269013wiggiest
wigglers13257213wigglers
wiggles123312463wiggles
wight123725573wi_ght_
wigless11359673wigless
wiglet105519153wiglet_
wigs84931253wi_g__s
wildcats1444173wildcats
wilders113513503wilders
wildest113311273wildest
wildness1236203wildness
wiles85437873wi_le_s
wiliest103416593wiliest
willers103517913willers
willet95124833willet_
wilts85023503wi__lts
wincers123415363wincers
winces114819113wince_s
winceys15395523winceys
windages1338263windage_s
winders113721263winders
windiest122213233windiest
windles113518493windle_s
windless123310863windless
wines85546863wi_ne_s
winged114620833winge_d
winger104125443winge_r
wingiest123214283wingiest
wingless122910023wingless
winglet113115983winglet_
wings95727243wing__s
winiest103419693winiest
winkers143517113winkers
winless103212283winless
winners104316913winners
winoes94317013winoe_s
winters103720483winters
winzes184313053winze_s
wipers115416083wi_pers
wipes104827083wi_pe_s
wirers94617893wi_rers
wires86034913wi_re_s
wiriest103816853wiriest
wisents10249063wisents
wises85633193wi_se_s
wisest95016443wi_sest
wishers133215213wishers
wishes124920953wishe_s
wisses94619603wisse_s
wists86728523wi__sts
wites85536963wi_te_s
withers134417753withers
withes124620843withe_s
witless103310983witless
witness103010013witness
witneys13274723witneys
wits76044873wi___ts
wivers125320803wi_vers
wives115328923wi_ve_s
wizens186110263wi_zens
wizes174723343wi_ze_s
wizzens18385483wizzens
wizzes175110773wizze_s
wodge107212933wodge__
worsets105512843worsets
wrights14318993wrights
wringers123110073wringers
zibets1737743zi_bets
zingers173514853zingers

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273526.65620136.3
3Display Results3523520.1232861.8
 (SQL Overall)1786913527.18524870.0
 
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.