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

295 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
nidgets935814(None) 
fidgets12388761fidgets
midgets113910251midgets
nidget83715641nidget_
widgets12318451widgets
bidets95215532bid_ets
budgets11489862budgets
fidges114114392fidge_s
fidget114216482fidget_
fidgety15384892fidgety
gadgets10348682gadgets
midges103516482midge_s
midget103718452midget_
midguts11296012midguts
nidates8311892nidates
nides65229142nid_e_s
niggers93111322niggers
nights104117722ni_ghts
nudgers9479372nudgers
nudges84114742nudge_s
nuggets936382nuggets
ridgels9348022ridgels
ridges85817012ridge_s
widget113815262widget_
aiders74524633aid_ers
aides65336613aid_e_s
aidless83612073aidless
aiglets84012913aiglets
aigrets82810533aigrets
badgers114812653badgers
badges103917373badge_s
begets96215523_begets
bidders114012313bidders
biders94822803bid_ers
bides85536783bid_e_s
bidet84935633bid_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
fidge104516073fidge__
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
hides95129433hid_e_s
hights133716893hi_ghts
hindguts1343013hindguts
hingers113420213hingers
hinges105121033hinge_s
hoggets12498323hoggets
ideas65919013_id_eas
ides57734243_id_e_s
idiots768643_idiots
idlers74012813_idlers
idles66720123_idle_s
idlest74014863_idlest
indents83114663indents
indicts103210723indicts
indies73822783indie_s
indigens10288733indigens
indigents11208273indigents
indites83618983indites
inducts10259573inducts
indues73515263indue_s
indults8289493indults
ingest73119003_ingest
ingests83210983_ingests
ingots7912063_ingots
inlets63915573_inlets
insets64016133_insets
islets64513083_islets
jiggers164010183jiggers
judgers16369043judgers
judges153713463judge_s
kedges124812983kedge_s
kidders13399173kidders
kidneys1533423kidneys
kinglets13318583kinglets
kismets13306883kismets
knights1545653kni_ghts
ledgers94912183ledgers
ledges84918013ledge_s
lidless8309273lidless
lieges74113443liege_s
ligers75022043li_gers
lights104519913li_ghts
limpets11329783limpets
lingers84223303lingers
linnets739833linnets
lodgers95113833lodgers
lodges86820153lodge_s
loggets9378913loggets
middens11379383middens
midge95016563midge__
midgut103510053midgut_
midlegs1156323midlegs
midsts95510053mid_sts
mights123516253mi_ghts
millets94216843millets
mindsets1135683mindsets
minuets9259853minuets
missets94516573missets
naggers93812653naggers
nailsets834553nailsets
naughts11447513naughts
nets45941533n___ets
nicest82315663ni_cest
nicety1138433ni_cety
niches114419143niche_s
nickels13338653nickels
nickers134415093nickers
nidate7313783nid_ate
nidated939863nidated
nide55535803nid_e__
nided75920883nid_e_d
nidus65913583nid__us
niduses837013niduses
nieces84112713niece_s
nieves94311293nieve_s
niffers13287363niffers
nigger89713573nigge_r
nigglers10307253nigglers
niggles93512203niggles
nighest11310693nighest
nighs95013613ni_g_hs
night94327853ni_ght_
nighty135611273ni_ghty
nilgais845203nilgais
nilgaus844003nilgaus
nimiety1244633nimiety
nines55937343ni_ne_s
ninety9510963ni_nety
nippers113012623nippers
niseis63512023ni_seis
niters64624213ni_ters
nites55736343ni_te_s
nitres65519333nitre_s
nits45741653ni___ts
nitwits1035053nitwits
nixes124519623ni_xe_s
nixies135313873nixie_s
nodders94410263nodders
nodes64633493nod_e_s
nonets64118703n_onets
noodges9317713noodge_s
nougats8427413nougats
noughts11478083noughts
nudes64723293nud_e_s
nudest74113833nud_est
nudge74616433nudge__
nudged95511843nudge_d
nudger85111643nudge_r
nudies75217093nudie_s
nudists8356833nudists
nugget8311723nugget_
nuggety1234313nuggety
nutlets74111253nutlets
pargets105215193pargets
pickets154314183pickets
pidgins11259123pidgins
piglets103311793piglets
pingers104020743pingers
piolets93513193piolets
pipets105714773pi_pets
piquets1836603piquets
pledgets12365673pledgets
riblets93412553riblets
rickets134915093rickets
ridders93612493ridders
riders74123903rid_ers
rides66140823rid_e_s
ridge75018683ridge__
ridged94014223ridge_d
ridgel8399973ridge_l
ridgetop1242233ridgetop
ridgetops1342193ridgetops
ridgiest1038903ridgiest
ridgils9326573ridgils
ridleys11145783ridleys
riggers93613843riggers
rights104019333ri_ghts
rillets74216153rillets
ringers83922953ringers
ringlets92910243ringlets
rivets94417113ri_vets
sedges83817813sedge_s
sides65838373sid_e_s
sidlers83414233sidlers
sidles74721153sidle_s
sieges73816833siege_s
sights103818013si_ghts
signets83311503signets
singers83824703singers
singes74326853singe_s
singlets93611473singlets
sippets113310183sippets
smidgens12325643smidgens
smidges11448193smidge_s
snidest8310913snid_est
sniggers10317093sniggers
sniglets9276813sniglets
snippets12225623snippets
targets84314223targets
tickets134113683tickets
tidbits1035183tidbits
tides64830163tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiest83514873tidiest
tigers75616513ti_gers
tights104015853ti_ghts
tinges74722343tinge_s
tippets11339373tippets
videos104911373vid_eos
violets102210003violets
wadsets1136443wadsets
wedges114614583wedge_s
wickets164010943wickets
widders123512273widders
widens106212723wid_ens
wides94832833wid_e_s
widest104517003wid_est
widgeon1244143widgeon
widgeons1343853widgeons
wights133315783wi_ghts
wiglets113411423wiglets
willets104414323willets
wingers113921483wingers
winglets12299593winglets
wodges117413683wodge_s
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.420425454.8
2DLD Change Limit1340272957.12618808.2
3Display Results2952950.1102681.8
 (SQL Overall)1786912957.65623340.0
 
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.