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

150 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
nightie117965(None) 
nighties121011381nighties
eighties12710802eighties
mightier1436382mightier
night94327852night__
nightlife1683732nightlife
nightly14449032nightly
nights104117722night_s
nightside1444122nightside
nighttide1443902nighttide
nighttime1553362nighttime
nighty135611272night_y
righties12711572righties
biggie103810933big_gie
bight118728843bight__
bighted142810923bighted
bighting15269453bighting
bights124417963bight_s
bigtime1235753big_time
blighties1546223blighties
dight104027003dight__
dighted132511493dighted
dighting142510843dighting
dights114016963dight_s
digitize1947023digitize
eight94928053eight__
eighteen1245763eighteen
eighth133310603eight_h
eighths14388293eighths
eightieth1643093eightieth
eights103618983eight_s
eightvo1443843eightvo
eighty133711603eight_y
fight124027093fight__
fighter143010773fighter
fighting162710083fighting
fights133816553fight_s
flightier1644423flightier
gighe10139733gigh__e
highlife1843003highlife
highrise1554403highrise
hight125327233hight__
hightail1545273hightail
highted152710163highted
highth12389153hight_h
highths13358003highths
highting16259723highting
hightop1645013hightop
hights133716893hight_s
hogtie102711773hog_tie
ignite71410583_ignite
ingate73018243ingat_e
kiltie103210963ki_ltie
knight1438173knight__
knighted1745123knighted
knighting1844443knighting
knightly1953013knightly
knights1545653knight_s
ligate72519253ligat_e
ligative1258803ligative
light94429603light__
lighted122913503lighted
lighten112811523lighten
lighter113113443lighter
lighting132811833lighting
lightish1556623lightish
lightly14369023lightly
lights104519913light_s
lignite81310303lignite
might113827083might__
mightiest1546443mightiest
mightily1744623mightily
mights123516253might_s
mighty154310213might_y
naughtier1343103naughtier
naughties1344573naughties
necktie1344363necktie
negate72915573negat_e
negative1239083negative
niceties10310863niceties
niche105016793nich__e
nicotin948383nicotin
nicotine1058473nicotine
nidate7313783nidat_e
niftier10328713ni_ftier
nifties102612503ni_fties
niggle83612823nig_gle
nigglier1044843nigglier
nigh85220663nigh___
nighed113811293nigh_ed
nigher103612753nigh_er
nighest11310693nighest
nighing123410063nighing
nighs95013613nigh__s
nightcap1642963nightcap
nightjar1943163nightjar
nightless1386073nightless
nightlifes1793753nightlifes
nightlives1763803nightlives
nightmare1553623nightmare
nightsides1543943nightsides
nighttides1543763nighttides
nighttimes1653183nighttimes
nightwear1642573nightwear
nihil8410283ni_h_il
nilghai1142473nilghai_
nilghais1242903nilghais
nineties8312913nineties
niobite937953niobite
nitchie1247233nitchie
nite45943583ni__t_e
niterie7313743niterie
nitid61817833ni__tid
nitre57519683ni__tre
nitrite72314463nitrite
nittier73512243ni_ttier
nixie125114943ni__xie
piggie103210773pig_gie
pigsties1139783pigsties
right94430503right__
righted122912143righted
righter113212383righter
righting132610853righting
rightism14156963rightism
rightist12159143rightist
rightly14389043rightly
righto104111093right_o
rights104019333right_s
rightsize2243653rightsize
righty135011833right_y
sighlike1635533sighlike
sight94629293sight__
sighted123111523sighted
sighter113412113sighter
sighting133110863sighting
sightlier1344453sightlier
sightline1345683sightline
sightly14408273sightly
sights103818013sight_s
sightsee1245473sightsee
tight93626503tight__
tighten11288973tighten
tighter112910693tighter
tightly14327613tightly
tights104015853tight_s
tightwire16102853tightwire
tittie63213153ti_ttie
weightier1643313weightier
wight123725573wight__
wights133315783wight_s

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.406440125.6
2DLD Change Limit1340271505.75023309.0
3Display Results1501500.0463260.9
 (SQL Overall)1786911506.20228811.8
 
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.