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

182 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
nighties12101138(None) 
eighties12710801eighties
nightie1179651nightie_
righties12711571righties
blighties1546222blighties
mightier1436382mightier
mightiest1546442mightiest
naughties1344572naughties
niceties10310862niceties
nifties102612502ni_fties
nightless1386072nightless
nightlifes1793752nightlifes
nightlives1763802nightlives
nights104117722night__s
nightsides1543942nightsides
nighttides1543762nighttides
nighttimes1653182nighttimes
nineties8312912nineties
pigsties1139782pigsties
anilities9516003anilities
bigamies1337373bigamies
biggies113813523big_gies
bighted142810923bight_ed
bighting15269453bighting
bights124417963bight__s
bigotries1286443bigotries
cities84524853ci__ties
digamies1238643digamies
dighted132511493dight_ed
dighting142510843dighting
dights114016963dight__s
digitizes2046923digitizes
dignities1149593dignities
dimities11314003dimities
dinghies1347363dingh_ies
dirties83119383di_rties
ditties83116983di_tties
eighteen1245763eighteen
eighteens1344883eighteens
eighths14388293eight_hs
eightieth1643093eightieth
eightieths1751903eightieths
eights103618983eight__s
eightvos1543743eightvos
fifties132111083fi_fties
fighter143010773fight_er
fighters15269403fighters
fighting162710083fighting
fightings17276503fightings
fights133816553fight__s
fixities1838213fixities
flightier1644423flightier
flightiest1744513flightiest
highlifes1942883highlifes
highrise1554403highrise
highrises1644633highrises
hightails1645313hightails
highted152710163hight_ed
highths13358003hight_hs
highting16259723highting
hightops1745043hightops
hights133716893hight__s
hogties112813993hog_ties
ignites81310583_ignites
ingates82716913ingat_es
kilties113014143ki_lties
kitties113213623ki_tties
knighted1745123knight_ed
knighting1844443knighting
knights1545653knight__s
ligates82318383ligat_es
lighted122913503light_ed
lighten112811523light_en
lightens122510003lightens
lighter113113443light_er
lighters123111393lighters
lightest121410353light_est
lighting132811833lighting
lightings14277723lightings
lightish1556623lightish
lightless1386073lightless
lightness13107433lightness
lights104519913light__s
lignites9129613lignites
mightily1744623mightily
mightiness1645093mightiness
mights123516253might__s
naiveties1245433naiveties
nasties73520493n_asties
naughtier1343103naughtier
naughtiest1442733naughtiest
neckties1445903neckties
negates83215843negat_es
negatives1346583negatives
niches114419143nich__es
nicotines1148353nicotines
nicotins1058173nicotins
nidates8311893nidat_es
nidifies1238233nidifies
niftier10328713ni_ftier
niftiest112910073ni_ftiest
niggles93512203nig_gles
nigglier1044843nigglier
niggliest1144933niggliest
nighed113811293nigh__ed
nigher103612753nigh__er
nighest11310693nigh__est
nighing123410063nigh_ing
nighness1236103nighness
nighs95013613nigh___s
night94327853night___
nightcap1642963nightcap
nightcaps1743193nightcaps
nightdress1552983nightdress
nightjar1943163nightjar
nightjars2043343nightjars
nightlife1683733nightlife
nightly14449033night_ly
nightmares1653563nightmares
nightside1444123nightside
nighttide1443903nighttide
nighttime1553363nighttime
nightwear1642573nightwear
nighty135611273night__y
nigrifies1346363nigrifies
nihils937573ni_h_ils
nilghais1242903nilghai_s
nimieties1145223nimieties
ninnies73713613ni_nnies
niobites1037313niobites
nitchies1339073nitchies
niteries8318383niteries
nites55736343ni__t_es
nitres65519333ni__tres
nitrites82313453nitrites
nittier73512243ni_ttier
nittiest82712603ni_ttiest
nixies135313873ni__xies
nudities939683nudities
pieties9419223pi_eties
piggies113813483pig_gies
pigmies122610993pig_mies
pities83828083pi__ties
righted122912143right_ed
righter113212383right_er
righters122610713righters
rightest12149583right_est
righting132610853righting
rightism14156963rightism
rightisms15105623rightisms
rightist12159143rightist
rightists13126053rightists
rightness13117353rightness
rights104019333right__s
rightsizes2353433rightsizes
sighted123111523sight_ed
sighter113412113sight_er
sighters122510603sighters
sighting133110863sighting
sightings14256533sightings
sightless1385923sightless
sightlier1344453sightlier
sightliest1445113sightliest
sightlines1465753sightlines
sights103818013sight__s
sightsee1245473sightsee
sightsees1344543sightsees
sixties14310973si_xties
tighten11288973tight_en
tightens12297953tightens
tighter112910693tight_er
tightest12148363tight_est
tightness1386603tightness
tights104015853tight__s
tightwires17102763tightwires
titties73617363ti_tties
unities72520153uni__ties
vichies15310623vich_ies
weightier1643313weightier
weightiest1743423weightiest
wights133315783wight__s
withies133913543with_ies

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621827.34619896.8
3Display Results1821820.0762394.7
 (SQL Overall)1786911827.84222786.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.