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

490 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
tights10401585(None) 
bights124417961bights
dights114016961dights
eights103618981eights
fights133816551fights
hights133716891hights
lights104519911lights
mights123516251mights
nights104117721nights
rights104019331rights
sights103818011sights
tight93626501tight_
wights133315781wights
alights113211432alights
aughts104710242aughts
bight118728842bight_
bigots95015132bigots
blights133110212blights
brights133710232brights
dight104027002dight_
digits84114532digits
eight94928052eight_
eighth133310602eighth
eighths14388292eighths
eighty133711602eighty
fight124027092fight_
flights143310982flights
frights14339622frights
gigots83911952gigots
heights14399442heights
highs125412522high_s
hight125327232hight_
highth12389152highth
highths13358002highths
knights1545652knights
lichts113712382lichts
light94429602light_
might113827082might_
mighty154310202mighty
nighs95013612nigh_s
night94327852night_
nighty135611272nighty
oughts104710182oughts
plights13299312plights
right94430502right_
righto104111092righto
righty135011832righty
sighs95416742sigh_s
sight94629292sight_
slights112810722slights
thighs1346632thigh_s
tigers75616512tigers
tighten11288972tighten
tightens12297952tightens
tighter112910692tighter
tightest12148362tightest
tightly14327612tightly
tigons74112262tigons
tilths9459372tilths
tilts55325612ti_lts
tincts84510802tincts
tints56030922ti_nts
tithes94720212tithes
tits46145042ti__ts
tonights1244592tonights
weights14409552weights
wight123725572wight_
wrights14318992wrights
aghas97014873_aghas
agists75713173agists
aiglets84012913aiglets
aigrets82810533aigrets
airths95414253airths
airts55626343ai_rts
aits46355533ai__ts
alight103816863alight_
angsts738863angsts
argots74116033argots
aright103817663aright_
aught95120703aught_
bahts105617803_bahts
bedights1544743bedights
begets96215523begets
bidets95215533bidets
bighted142810923bighted
bigos85020013big_os
bigot84828323bigot_
bigs76235023big__s
binits85716673binits
bints76130183bi_nts
bionts8612393bionts
births115713603births
bits66148163bi__ts
bitts75022593bi_tts
blight124114623blight_
blighty16356843blighty
bright124215923bright_
catfights1842793catfights
cigars9910723cigars
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
ergots74512373ergots
fagots1039963fagots
fiats85324483fi_ats
fiches145219533fiches
fichus14388113fichus
fidgets12388763fidgets
fifths15406543fifths
fighter143010773fighter
fighters15269403fighters
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
gigues8129003gigues
gilts64924263gi_lts
girths105612273girths
girts65423623gi_rts
gists66026193gi_sts
gits55744593__gits
guts56637253__guts
height134713433height_
heighth13366343heighth
heighths14324823heighths
high116619923high__
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
itches114916213itches
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
ligate72519253ligate
ligates82318383ligates
ligers75022043ligers
lighted122913503lighted
lighten112811523lighten
lightens122510003lightens
lighter113113443lighter
lighters123111393lighters
lightest121410353lightest
lightish1556623lightish
lightly14369023lightly
lilts55822803li_lts
limits82514143limits
lints57137193li_nts
lists56628693li_sts
lithos94212553lithos
lits46252493li__ts
magots9312363magots
miches134320733miches
midgets113910253midgets
midguts11296013midguts
midsts95510053midsts
miggs96311373mig_gs
migs76935323mig__s
milts75430713mi_lts
mints76834043mi_nts
mirths114912993mirths
mishits122513083mishits
mists76633903mi_sts
mitts75523753mi_tts
naughts11447513naughts
neighs10387733neigh_s
niches114419143niches
nidgets9358143nidgets
nigh85220663nigh__
nighed113811293nighed
nigher103612753nigher
nighest11310693nighest
nightie1179653nightie
nighties121011383nighties
nightly14449033nightly
ninths936933ninths
nits45741643ni__ts
noughts11478083noughts
ought95221533ought_
outfights1643783outfights
outsights1344183outsights
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
righter113212383righter
righters122610713righters
rightest12149583rightest
righties12711573righties
rightism14156963rightism
rightist12159143rightist
rightly14389043rightly
rigors72813713rigors
rigs55137593rig__s
riots54922013ri_ots
rishis9312453rishis
rivets94417113rivets
sifts84918923si_fts
sigh85625893sigh__
sighed113712053sighed
sigher103813703sigher
sighers113712183sighers
sighted123111523sighted
sighter113412113sighter
sighters122510603sighters
sightly14408273sightly
sightsaw1542693sightsaw
sightsee1245473sightsee
sigils73912363sigils
siglos7311473siglos
sigmas94111363sigmas
signets83311503signets
signs65516323sig_ns
silts55330823si_lts
sinhs86719603sinh_s
sits45050203si__ts
sixths16416373sixths
sleights12275913sleights
slight103416003slight_
spigots1037793spigots
sprights14167143sprights
stichs114511653stich_s
stigmas10206643stigmas
stilts67915313sti_lts
stints65119763sti_nts
straights1345813straights
sughs95313323sugh_s
taches114224173taches
tachs105820933tach_s
tacts76524123t_acts
tags55545233tag__s
tahrs85412333t_ahrs
taigas73712563taig_as
taints64520533taints
targets84314223targets
tarots66422993tarots
tarts57242023t_arts
tats46858133t__ats
taught104312223taught_
taunts65715663taunts
tauts56125513t_auts
teats55636813t_eats
techs106915833tech_s
teggs74710743teg_gs
tegs56031493teg__s
teguas768013teguas
tempts10439453tempts
tenets65518953tenets
tenths94412663tenths
tents56434213t_ents
tests56530193t_ests
teths85418513teth_s
tets45847463t__ets
texts125515043t_exts
thefts12387923thefts
thigh12410123thigh__
thighed1535273thighed
thirsts1036243thirsts
this76027383t__his
thoughts15515603thoughts
thus76721473t__hus
tiaras6314553tiaras
tibias839953tibias
ticals83214713ticals
tickets134113683tickets
ticks115823293ti_cks
tics65729633ti__cs
tidbits1035183tidbits
tides64830153ti_des
tidies74721833tidies
tiers55526523ti_ers
ties45248313ti__es
tiffs114414883ti_ffs
tiger65718633tig_er
tightness1386603tightness
tightwad1642903tightwad
tightwads1742823tightwads
tiglon737923tiglon
tiglons837343tiglons
tigon63914443tig_on
tigress836093tigress
tigrish1137573tigrish
tikes95628903ti_kes
tikis95615973ti_kis
tikkas934523tikkas
tilaks1097353tilaks
tildes74513963tildes
tilers63523503tilers
tiles55542103ti_les
tills54631713ti_lls
tils45739613ti__ls
tilt46252423ti_lt_
tilth85515363ti_lth
timers84420993timers
times75630823ti_mes
tinct76126233tinct_
tineas64616483tineas
tines54848423ti_nes
tinges74722333tinges
tingles83818323tingles
tings65329203ti_ngs
tins45251303ti__ns
tint46758863ti_nt_
tipcats1137103tipcats
tipis76019923ti_pis
tippets11339373tippets
tips66436763ti__ps
tires55437493ti_res
tirls54519803ti_rls
tiros54524893ti_ros
tis37056643ti___s
tit36771053ti__t_
titans63414913titans
titbits935803titbits
titers64526413titers
tithe85319703tith_e
tithed104115593tithed
tither94920283tither
tithers104216733tithers
titi47130623ti__ti
titis56023813ti_tis
titles63719923titles
titres64718933titres
titty85316653ti_tty
toasts65914993toasts
tofts84919243t_ofts
togas67823003tog_as
togate74515683togate
togs57242433tog__s
togues76014243togues
toilets74112913toilets
toits55327473t_oits
tonight1138743tonight_
tooths96013803tooths
toots55331873t_oots
tophes115218423tophes
tophs105220053toph_s
tophus115210363tophus
torts56138123t_orts
toshes94520103toshes
tots46654123t__ots
toughs105414983tough_s
touts54830393t_outs
tracts85019073tracts
traits65121983traits
treats64821693treats
trets55928023t_rets
tricots9311563tricots
trigons84312093trigons
trigos74214173trig_os
trigs65423063trig__s
trijets14308263trijets
trivets103911583trivets
troths95414153troths
trots56629943t_rots
trouts66116633trouts
trusts64714433trusts
truths9449503truths
trysts9448793trysts
tufts85713273t_ufts
tugs56231673tug__s
tushes94319473tushes
tuts45838453t__uts
twats86616603t_wats
tweets94210103tweets
twigs96911173twig__s
twilights1642533twilights
twists9549753twists
twits86015793t_wits
typhus14395713typhus
tythes12419703tythes
ughs85410973_ugh_s
unsights1244623unsights
uplights14165053uplights
uprights14145313uprights
uptight13176033uptight_
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 6 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.1231452772.4
2DLD Change Limit1127164904.98622606.5
3Display Results4904900.1403500.0
 (SQL Overall)1786914905.24934042.9
 
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.