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

387 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
midgets11391025(None) 
fidgets12388761fidgets
midges103516481midge_s
midget103718451midget_
midguts11296011midguts
nidgets9358141nidgets
widgets12318451widgets
bidets95215532bid_ets
budgets11489862budgets
fidges114114392fidge_s
fidget114216482fidget_
fidgety15384892fidgety
gadgets10348682gadgets
middens11379382middens
midge95016552midge__
midgut103510052midgut_
midlegs1156322midlegs
midsts95510052mid_sts
mights123516252mi_ghts
millets94216842millets
mindsets1135682mindsets
minuets9259852minuets
missets94516572missets
nidget83715642nidget_
ridgels9348022ridgels
ridges85817012ridge_s
smidgens12325642smidgens
smidges11448192smidge_s
widget113815262widget_
aiders74524633aid_ers
aides65336603aid_e_s
aidless83612073aidless
aiglets84012913aiglets
aigrets82810533aigrets
amides95722663amid_e_s
amidogens1343653amidogens
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
imagers10107763imagers
images91411463image_s
imarets9138643imarets
imides94515343imid_e_s
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
maddens11359753maddens
madders113513213madders
maddest112311213maddest
madness10310073madness
madres93718183madre_s
mages85036023m_age_s
maggots1136563maggots
magnets10311143magnets
magots9312363m_agots
maidens10349663maid_ens
mallets93318493mallets
mammets103911113mammets
mangels103614493mangels
mangers103521263mangers
manges94628943mange_s
margents11410133margents
marges94525713marge_s
markets133314033markets
maumets11369693maumets
medleys13115333medleys
meets74224613m__eets
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
miches134320733miche_s
mickeys18447943mickeys
midairs1037203midairs
midcults1343223midcults
middays14335663middays
midden104112853midde_n
middies113116153middies
middlers123410193middlers
middles113415303middles
midis85923413mid__is
midleg1038553midle_g
midlist10312513midlist
midlists1137523midlists
midmost1246153midmost
midmosts1343773midmosts
midnights1642683midnights
midribs1235513midribs
mids76541793mid___s
midst85922553mid_st_
midterm12316013midterm
midterms13284863midterms
midways16386183midways
midweek1743273midweek
midweeks1842383midweeks
midyear1343343midyear
midyears1443403midyears
miens76118303mi__ens
miggles113512033miggles
miggs96311373mi_g_gs
might113827083mi_ght_
mighty154310203mi_ghty
migs76935323mi_g__s
mikes115129893mi_ke_s
mikvehs19111683mikvehs
milages103114403milage_s
mildens10339933mildens
mildest102812063mildest
mildews13365883mildews
mildness1136523mildness
milers84625163mi_lers
miles74645073mi_le_s
milieus939803milieus
milkers134411613milkers
millers93621343millers
milles84526563mille_s
millet84030743millet_
milnebs11113793milnebs
milreis937323milreis
milters93619093milters
milts75430713mi__lts
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
minarets1048843minarets
mincers113714853mincers
minces104420803mince_s
minders103720123minders
mindless11319443mindless
mindset10313343mindset_
miners84126633mi_ners
mines75651953mi_ne_s
mingiest113315823mingiest
minglers113011293minglers
mingles103719003mingles
minkes124618783minke_s
minters93822473minters
mints76834043mi__nts
minuet82621033minuet_
minutes93513443minutes
minxes154612983minxe_s
mioses84318853miose_s
mirages102213533mirage_s
mires75640883mi_re_s
miriest93619823miriest
mirkest13309723mirkest
misacts1139353misacts
misagents1246793misagents
miscuts1139183miscuts
misdates111113633misdates
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoe_s
miseats92815783miseats
misers85025703mi_sers
mises74740563mi_se_s
misfits12279663misfits
misguess1134643misguess
mishits122513083mishits
mismeets12297733mismeets
mismet103722373mismet_
mispens11311073mispens
misseats104011683misseats
missels94614813missels
misses85130873misse_s
misset85028153misset_
misters93927513misters
mists76633903mi__sts
miters84328783mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitiest93520053mitiest
mitogens1146973mitogens
mitres83922073mitre_s
mittens9349883mittens
mitts75523753mi__tts
mixers154513563mi_xers
mixes147224403mi_xe_s
mizens174610253mi_zens
mizzens17366123mizzens
models94216353mod_els
modems114610763mod_ems
modes85537413mod_e_s
modest93818453mod_est
mongers104217273mongers
moppets13307163moppets
morgens10310463morgens
motets84216193m_otets
mudcats1236223mudcats
mudders113211113mudders
mudhens1335103mudhens
muggees11338883muggees
muggers113611933muggers
mullets93614783mullets
muskets13258643muskets
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
smidge10378483smidge__
smidgen11426513smidge_n
smidgeon12303273smidgeon
smidgeons13272733smidgeons
smidgins12314843smidgins
smudges11348283smudge_s
targets84314223targets
tickets134113683tickets
tidbits1035183tidbits
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiest83514873tidiest
tigers75616513ti_gers
tights104015853ti_ghts
tinges74722333tinge_s
tippets11339373tippets
videos104911373vid_eos
violets102210003violets
wadsets1136443wadsets
wedges114614583wedge_s
wickets164010943wickets
widders123512273widders
widens106212723wid_ens
wides94832823wid_e_s
widest104517003wid_est
widgeon1244143widgeon
widgeons1343853widgeons
wights133315783wi_ghts
wiglets113411423wiglets
willets104414323willets
wingers113921483wingers
winglets12299593winglets
wodges117413683wodge_s
zibets1737743zi_bets
zingers173514853zingers

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 Filter1786911340270.403443402.0
2DLD Change Limit1340273876.08022043.9
3Display Results3873870.1402764.3
 (SQL Overall)1786913876.62326980.4
 
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.