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

518 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
mights12351625(None) 
bights124417961bights
dights114016961dights
eights103618981eights
fights133816551fights
hights133716891hights
lights104519911lights
might113827081might_
mighty154310201mighty
nights104117721nights
rights104019331rights
sights103818011sights
tights104015851tights
wights133315781wights
alights113211432alights
aughts104710242aughts
bight118728842bight_
bigots95015132bigots
blights133110212blights
brights133710232brights
dight104027002dight_
digits84114532digits
eight94928052eight_
eighth133310602eighth
eighths14388292eighths
eighty133711602eighty
fight124027092fight_
flights143310982flights
frights14339622frights
gigots83911952gigots
heights14399442heights
highs125412522high_s
hight125327232hight_
highth12389142highth
highths13358002highths
knights1545652knights
lichts113712382lichts
light94429602light_
magots9312362magots
miches134320732miches
midgets113910252midgets
midguts11296012midguts
midsts95510052midsts
miggs96311372mig_gs
migs76935312mig__s
milts75430712mi_lts
mints76834042mi_nts
mirths114912992mirths
mishits122513082mishits
mists76633902mi_sts
mitts75523752mi_tts
nighs95013612nigh_s
night94327852night_
nighty135611272nighty
oughts104710182oughts
plights13299312plights
right94430502right_
righto104111092righto
righty135011832righty
sighs95416742sigh_s
sight94629292sight_
slights112810722slights
tight93626502tight_
weights14409552weights
wight123725572wight_
wrights14318992wrights
aghas97014873_aghas
agists75713173agists
aiglets84012913aiglets
aigrets82810533aigrets
airths95414253airths
airts55626343ai_rts
aits46355533ai__ts
alight103816863alight_
almighty1742683almighty
amigas95912163amig_as
amigos94511203amig_os
angsts738863angsts
argots74116023argots
aright103817663aright_
aught95120703aught_
bahts105617803_bahts
bedights1544743bedights
begets96215523begets
bidets95215533bidets
bighted142810923bighted
bigos85020013big_os
bigot84828323bigot_
bigs76235013big__s
binits85716673binits
bints76130183bi_nts
bionts8612393bionts
births115713603births
bits66148153bi__ts
bitts75022593bi_tts
blight124114623blight_
blighty16356843blighty
bright124215923bright_
cigars9910713cigars
cigs75625103cig__s
cists76624533ci_sts
civets115212543civets
delights1347333delights
dicots94915793dicots
diets66026643di_ets
digest84019623digest
digests93610613digests
dighted132511493dighted
digit73825273digit_
diglots9299503diglots
digs66036053dig__s
dints67431313di_nts
dirts66824463di_rts
dishes104622653dishes
dits56450523di__ts
divots104712203divots
dixits144210313dixits
eighties12710803eighties
eightvo1443843eightvo
eightvos1543743eightvos
emigres1037673emigres
emits75421463emi__ts
ergots74512373ergots
fagots1039963fagots
fiats85324483fi_ats
fiches145219533fiches
fichus14388113fichus
fidgets12388763fidgets
fifths15406543fifths
fighter143010763fighter
fighters15269393fighters
figs85332643fig__s
filets94718953filets
filths12389783filths
firsts95110923firsts
firths125113503firths
fishes125221343fishes
fists85527543fi_sts
fits76043463fi__ts
flight134014813flight_
flighty17347433flighty
freights1555853freights
fright133715243fright_
gats56753443__gats
gets55442483__gets
ghats95818613__ghats
ghis85020163__ghis
giants74713503giants
gifts96214963gi_fts
gigas75415583gig_as
gighe10139733gigh_e
giglets93211553giglets
giglots9367863giglots
gigot74023073gigot_
gigs66631183gig__s
gigues8128993gigues
gilts64924263gi_lts
girths105612273girths
girts65423623gi_rts
gists66026193gi_sts
gits55744593__gits
guts56637253__guts
height134713433height_
heighth13366343heighth
heighths14324823heighths
high116619913high__
higher134610893higher
highest1439563highest
highly1636823highly
highted152710163highted
hightop1645013hightop
hightops1745043hightops
hilts86924413hi_lts
hints87330623hi_nts
hists86328373hi_sts
hits75545133hi__ts
ichs96214713_ich_s
iggs66612673_ig_gs
iglus6609933_iglus
ikats95311153_ikats
infights1545573infights
ingots7912063ingots
insights1245493insights
its35538833_i__ts
jigs126524763jig__s
jilts124717413ji_lts
kilts95122183ki_lts
kists95822113ki_sts
kithes135016653kithes
kiths125814973kith_s
kits86441763ki__ts
knight1438173knight_
laighs10508803laigh_s
legits71313003legits
liches114724293liches
lichis115212593lichis
licht104723493licht_
lifts85719063li_fts
ligans76817733ligans
ligate72519243ligate
ligates82318373ligates
ligers75022023ligers
lighted122913503lighted
lighten112811523lighten
lightens12259993lightens
lighter113113423lighter
lighters123111373lighters
lightest121410353lightest
lightish1556623lightish
lightly14369023lightly
lilts55822803li_lts
limits82514133limits
lints57137193li_nts
lists56628693li_sts
lithos94212553lithos
lits46252493li__ts
maches134827233maches
machos135217493machos
machs125722563mach_s
mages85036023mag_es
maggots1136553maggots
magics115311613magics
magmas115512503magmas
magnets10311143magnets
magot8326393magot_
mags75444523mag__s
magus85318753mag_us
maists85817573maists
malts76331753m_alts
manats84623463manats
marts77442233m_arts
mashes115030003mashes
masts77035763m_asts
maths105624023math_s
mats65460283m__ats
matts76829183m_atts
mauts75927193m_auts
meats75034053m_eats
meets74224613m_eets
megahits1445683megahits
megass9219443megass
megohms1592863megohms
megs75530633meg__s
melts74930103m_elts
merits8320873merits
meshes115019443meshes
meths105320233meth_s
mhos95517773m__hos
miaous8511693miaous
miaows1145473miaows
miasms1097383miasms
miauls8178713miauls
mibs85330463mi__bs
micas96823053mi_cas
miche126219243mich_e
miched143913393miched
micks135525373mi_cks
micros104115363micros
mics87435143mi__cs
midges103516473midges
midget103718443midget_
midgut103510053midgut_
midis85923403mi_dis
midnights1642683midnights
mids76541773mi__ds
midst85922553midst_
miens76118303mi_ens
miffs134512873mi_ffs
mig65646073mig___
migg85716793mig__g
miggle104012113miggle
miggles113512033miggles
mightier1436383mightier
mightiest1546443mightiest
mightily1744623mightily
mignon937953mignon
mignons1037863mignons
migrants1138183migrants
migrate101314163migrate
migrates111112843migrates
mikes115129893mi_kes
mikvos1554023mikvos
milds86422053mi_lds
milers84625163milers
miles74645073mi_les
milks115020583mi_lks
milles84526563milles
millets94216843millets
mills75435053mi_lls
milos75428013mi_los
milpas101710273milpas
mils66045323mi__ls
milt65455803mi_lt_
milty104720073mi_lty
mimeos104511543mimeos
mimers105520183mimers
mimes95732023mi_mes
mimics1289353mimics
minas75434113mi_nas
minces104420803minces
minds85427123mi_nds
miners84126633miners
mines75651953mi_nes
mingles103719003mingles
minims104514803minims
minis75432983mi_nis
minkes124618783minkes
minks115829273mi_nks
minors85117093minors
mint66758043mi_nt_
minty106323903mi_nty
minuets9259853minuets
minus75223933mi_nus
minute83414293minute
minutes93513433minutes
minxes154612983minxes
mioses84318853mioses
miosis83615163miosis
mips85534073mi__ps
mires75640883mi_res
mirins83918893mirins
mirks115122143mi_rks
mirs66940563mi__rs
mirth106418893mi_rth
mirzas1738173mirzas
mis58162613mi___s
misacts1139353misacts
misate81222693misate
miscuts1139183miscuts
miseats92815783miseats
misers85025703misers
mises74740563mi_ses
misfits12279663misfits
mishap1338863mishap
mishaps1438713mishaps
mishit112618193mishit
mislights1544663mislights
misos76523293mi_sos
miss65339413mi__ss
misses85130873misses
missets94516573missets
missis84417503missis
missus85312293missus
mist66154523mi_st_
misty106120453mi_sty
mite66249403mi__te
miters84328773miters
mites75141803mi_tes
mither114218563mither
mithers123516733mithers
mitis75425983mi_tis
mitres83922073mitres
mitt66145483mi__tt
mity95528203mi__ty
mixers154513563mixers
mixes147224403mi_xes
mixt136831913mi_xt_
mixups1743263mixups
mizens174610253mizens
moats75827643m_oats
mochas13310653mochas
moghul1244473moghul
moghuls1343613moghuls
mogs75439333mog__s
moguls948553moguls
molts76032093m_olts
months113812933months
moots75831663m_oots
morts75533563m_orts
moshes115222873moshes
mosts76028543m_osts
motets84216193motets
moths106021553moth_s
mots66853163m__ots
motts76527003m_otts
moults84713703moults
mounts84115073mounts
mouths115214533mouths
muches134718993muches
muggs94912323mug_gs
mughal1236263mughal
mughals1355753mughals
mugs76232043mug__s
mulcts10298713mulcts
mushes114124563mushes
musths11589483musths
musts75527443m_usts
muts64839983m__uts
mutts75120253m_utts
mythos14398463mythos
myths135911603myth_s
naughts11447513naughts
neighs10387733neigh_s
niches114419143niches
nidgets9358143nidgets
nigh85220663nigh__
nighed113811293nighed
nigher103612753nigher
nighest11310693nighest
nightie1179653nightie
nighties121011383nighties
nightly14449033nightly
ninths936933ninths
nits45741643ni__ts
noughts11478083noughts
omits75018253omi__ts
ought95221533ought_
picots104616443picots
piglets103311793piglets
pignus937953pignus
pignuts1035613pignuts
pigouts1037593pigouts
pigs76634223pig__s
pigsty1235933pigsty
pilots84018873pilots
pinots85920273pinots
pints75936223pi_nts
pipets105714773pipets
pipits104713063pipits
pishes114722103pishes
piths105817543pith_s
pits66348743pi__ts
pivots115111903pivots
plight123513363plight_
refights1555883refights
relights1248053relights
resights1246733resights
riches115022083riches
rifts85718643ri_fts
righted122912143righted
righter113212373righter
righters122610703righters
rightest12149583rightest
righties12711573righties
rightism14156963rightism
rightist12159143rightist
rightly14389043rightly
rigors72813713rigors
rigs55137593rig__s
riots54922013ri_ots
rishis9312453rishis
rivets94417113rivets
sifts84918923si_fts
sigh85625893sigh__
sighed113712053sighed
sigher103813703sigher
sighers113712173sighers
sighted123111523sighted
sighter113412103sighter
sighters122510593sighters
sightly14408273sightly
sightsaw1542693sightsaw
sightsee1245473sightsee
sigils73912363sigils
siglos7311463siglos
sigmas94111353sigmas
signets83311503signets
signs65516323sig_ns
silts55330823si_lts
sinhs86719603sinh_s
sits45050203si__ts
sixths16416373sixths
sleights12275913sleights
slight103416003slight_
smiths114711023smith_s
spigots1037793spigots
sprights14167143sprights
sughs95313323sugh_s
thighs1346623thigh_s
tigers75616503tigers
tighten11288973tighten
tightens12297943tightens
tighter112910683tighter
tightest12148363tightest
tightly14327613tightly
tigons74112253tigons
tilths9459373tilths
tilts55325613ti_lts
tincts84510803tincts
tints56030923ti_nts
tithes94720213tithes
tits46145033ti__ts
tonights1244593tonights
ughs85410973_ugh_s
unsights1244623unsights
uplights14165053uplights
uprights14145313uprights
vigas94817883vig_as
vigias104110893vigias
vigils104210193vigils
vigors102911483vigors
vigs85427273vig__s
visits9311423visits
vughs12678743vugh_s
waughts14355963waughts
wechts1446253wechts
weighs13338873weigh_s
weight133914183weight_
weighty17376233weighty
whishts16425313whishts
wiches144418753wiches
widgets12318453widgets
widths1335123widths
wigans104511703wigans
wiglets113411423wiglets
wigs84931253wig__s
wilts85023503wi_lts
wishes124920953wishes
wists86728523wi_sts
withes124620843withes
wits76044873wi__ts
wright133713513wright_
yachts1437023yachts
yirths12639533yirths
yoghs125410593yogh_s
zibets1737743zibets
zigs145422793zig__s
zits136030293zi__ts

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165186.72016773.2
3Display Results5185180.1703047.1
 (SQL Overall)1786915187.03025418.3
 
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.