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

322 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
fidgets1238876(None) 
fidges114114381fidge_s
fidget114216471fidget_
fidgety15384891fidgety
midgets113910251midgets
nidgets9358141nidgets
widgets12318451widgets
bidets95215532bid_ets
budgets11489862budgets
fadges114814022fadge_s
fidge104516052fidge__
fidged124610922fidge_d
fidgeted1443892fidgeted
fidgeter1343782fidgeter
fidgeters1443612fidgeters
fights133816552fi_ghts
filets94718952fi_lets
fillets103414752fillets
fingers113418422fingers
forgets113813792forgets
fridges12369482fridge_s
fudges114314492fudge_s
gadgets10348682gadgets
midges103516472midge_s
midget103718442midget_
midguts11296012midguts
nidget83715632nidget_
ridgels9348022ridgels
ridges85817002ridge_s
widget113815252widget_
aiders74524633aid_ers
aides65336603aid_e_s
aidless83612073aidless
aiglets84012913aiglets
aigrets82810533aigrets
badgers114812643badgers
badges103917363badge_s
begets96215523_begets
bidders114012303bidders
biders94822803bid_ers
bides85536773bid_e_s
bidet84935623bid_et_
biggest1138143biggest
biggety1434433biggety
bights124417963bi_ghts
bigots95015133bi_gots
bilges94915633bilge_s
billets94516153billets
bingers104519983bingers
binges93923123binge_s
biogens1038963biogens
bridges113911333bridge_s
budgers114314923budgers
budges104820123budge_s
budget104618113budget_
cadets96316503cad_ets
cadgers114711993cadgers
cadges104716703cadge_s
ciders94620083cid_ers
civets115212543ci_vets
codgers115113923codgers
cudgels1135333cudgels
deets65330243__deets
didacts1186063didacts
didies84621833didie_s
didoes85716963didoe_s
diets66026643__diets
digest84019623di_gest
digests93610613di_gests
diggers104413383diggers
dights114016963di_ghts
digits84114533di_gits
dingers94321373dingers
dinges83825423dinge_s
dingeys12458403dingeys
dipnets10109033dipnets
dirges84915103dirge_s
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119073dodge_s
duets65323883__duets
edgers84413913_edgers
edges75718723_edge_s
eiders74321363eid_ers
eights103618983ei_ghts
facets116316653f_acets
faders105117463fad_ers
fades94932863fad_e_s
fadge104816993fadge__
fadged124712353fadge_d
faggots1234853faggots
fagots1039963f_agots
fanjets1734803fanjets
faucets12578443faucets
ferrets103111393ferrets
fets75345943f___ets
fiats85324483fi__ats
fibbers144510603fibbers
fibers114717523fi_bers
fibres114312123fibre_s
fices106031163fi_ce_s
fiches145219533fiche_s
ficoes114613463ficoe_s
fiddlers13328283fiddlers
fiddles123212603fiddles
fideism1335773fid_eism
fideist1139753fid_eist
fideists1245543fideists
fidgeting1544513fidgeting
fidging133910503fidging
fidos95819053fid__os
fids87034733fid___s
fiefs116213703fi__efs
fifers125414923fi_fers
fifes114822393fi_fe_s
figged124013893figge_d
fight124027093fi_ght_
figments1446943figments
figs85332643fi_g__s
filberts1334983filberts
filers94623723fi_lers
files85441273fi_le_s
filet85540163fi_let_
fillers104320203fillers
filles94224523fille_s
fillet95027083fillet_
filmers124211293filmers
filmsets1353413filmsets
filters103816543filters
finders113717873finders
fines86644263fi_ne_s
finest94321733fi_nest
finger104920323finge_r
finites10315923finites
finless102810783finless
fiques1837973fique_s
firers94922683fi_rers
fires85740753fi_re_s
firmers124711443firmers
firmest1239273firmest
firsts95110923fi_rsts
fishers134714723fishers
fishes125221343fishe_s
fishnets1445633fishnets
fists85527543fi__sts
fitchets16307413fitchets
fitments1376793fitments
fitness10299393fitness
fits76043463fi___ts
fitters104517743fitters
fittest102510803fittest
fivers124420923fi_vers
fives116027363fi_ve_s
fixates1737383fixates
fixers165112983fi_xers
fixes154723593fi_xe_s
fizgigs2142203fizgigs
fizzers18357003fizzers
fizzes174512553fizze_s
fledges12409373fledge_s
fleets96915063f_leets
flights143310983flights
flingers123410183flingers
florets1039853florets
fodders124010753fodders
fodgel1136403fodge_l
fogeys13509263f_ogeys
foggers124112013foggers
forgers115218183forgers
forges105024263forge_s
forget106326393forget_
frets85523403f__rets
fridge11379253fridge__
friges104116483frige_s
frights14339623frights
fringes113514103fringe_s
friskets15326263friskets
froglets1235263froglets
fudge105315523fudge__
fudged125212813fudge_d
fumets114311813f_umets
gadget93616173gadget_
gadgety13356163gadgety
gargets94614573gargets
gets55442483___gets
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gigots83911953gi_gots
gimlets10338433gimlets
gingers94118633gingers
godets8410933god_ets
gorgets94711783gorgets
hedgers124310253hedgers
hedges115016243hedge_s
hiders104919653hid_ers
hides95129423hid_e_s
hights133716893hi_ghts
hindguts1343013hindguts
hingers113420193hingers
hinges105121023hinge_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
jiggers164010173jiggers
judgers16369043judgers
judges153713453judge_s
kedges124812943kedge_s
kidders13399163kidders
kidneys1533423kidneys
kinglets13318583kinglets
kismets13306883kismets
ledgers94912173ledgers
ledges84917983ledge_s
lidless8309273lidless
lieges74113443liege_s
ligers75022023li_gers
lights104519913li_ghts
limpets11329783limpets
lingers84223293lingers
linnets739823linnets
lodgers95113833lodgers
lodges86820143lodge_s
loggets9378913loggets
middens11379373middens
midge95016543midge__
midgut103510053midgut_
midlegs1156323midlegs
midsts95510053mid_sts
mights123516253mi_ghts
millets94216843millets
mindsets1135683mindsets
minuets9259853minuets
missets94516573missets
nidates8311883nidates
nides65229133nid_e_s
niggers93111313niggers
nights104117723ni_ghts
nudgers9479373nudgers
nudges84114733nudge_s
nuggets936383nuggets
pargets105215193pargets
pickets154314183pickets
pidgins11259123pidgins
piglets103311793piglets
pingers104020733pingers
piolets93513193piolets
pipets105714773pi_pets
piquets1836603piquets
pledgets12365673pledgets
riblets93412553riblets
rickets134915093rickets
ridders93612483ridders
riders74123903rid_ers
rides66140813rid_e_s
ridge75018663ridge__
ridged94014213ridge_d
ridgel8399963ridge_l
ridgetop1242233ridgetop
ridgetops1342193ridgetops
ridgiest1038903ridgiest
ridgils9326573ridgils
ridleys11145783ridleys
riggers93613833riggers
rights104019333ri_ghts
rillets74216153rillets
ringers83922943ringers
ringlets92910233ringlets
rivets94417113ri_vets
sedges83817793sedge_s
sides65838363sid_e_s
sidlers83414223sidlers
sidles74721153sidle_s
sieges73816833siege_s
sights103818013si_ghts
signets83311503signets
singers83824693singers
singes74326853singe_s
singlets93611473singlets
sippets113310173sippets
smidgens12325643smidgens
smidges11448193smidge_s
targets84314223targets
tickets134113683tickets
tidbits1035173tidbits
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiest83514873tidiest
tigers75616503ti_gers
tights104015853ti_ghts
tinges74722323tinge_s
tippets11339373tippets
videos104911373vid_eos
violets102210003violets
wadsets1136443wadsets
wedges114614553wedge_s
wickets164010943wickets
widders123512263widders
widens106212723wid_ens
wides94832823wid_e_s
widest104517003wid_est
widgeon1244143widgeon
widgeons1343853widgeons
wights133315783wi_ghts
wiglets113411423wiglets
willets104414323willets
wingers113921473wingers
winglets12299593winglets
wodges117413673wodge_s
zibets1737743zi_bets
zingers173514843zingers

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.1561145455.1
2DLD Change Limit1340273227.17318684.9
3Display Results3223220.1102927.3
 (SQL Overall)1786913227.43924020.8
 
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.