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

241 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
nighest1131069(None) 
highest1439561highest
biggest1138142biggest
digest84019622dig_est
ingest73119002ing_est
lightest121410352lightest
lithest10513912lithest
nicest82315662ni_cest
niches114419142niches_
nighed113811292nighe_d
nigher103612752nighe_r
nighness1236102nighness
nighs95013612nigh_s_
night94327852nigh__t
nights104117722nights_
richest122813682richest
rightest12149582rightest
tightest12148362tightest
aghast105711373_aghast
aiglet74224193aigle_t
aiglets84012913aiglets
aigret73720023aigre_t
aigrets82810533aigrets
airest63825263ai_rest
airiest74221013airiest
barghest1447913barghest
behest11314613_behest
bigfeet1376153bigfeet
bighead14126653bighead
bight118728843bigh__t
bights124417963bights_
bigness1038193bigness
bilgiest11309883bilgiest
blithest1338083blithest
brightest1545663brightest
cagiest102916433cagiest
chest104926143__chest
diciest103316523diciest
digests93610613dig_ests
dight104027003digh__t
dights114016963dights_
digress938323digress
dimmest1249253dimmest
dingiest102915373dingiest
direst75024243di_rest
dishes104622653dishes_
dishiest12313683dishiest
ditheist1249493ditheist
divest106820073di_vest
edgiest92310353edgiest
egest65222343_eg_est
eight94928053eigh__t
eights103618983eights_
fiches145219533fiches_
fight124027093figh__t
fights133816553fights_
figment1379743figment
finest94321733fi_nest
firmest1239273firmest
fishes125221343fishes_
fishiest14310453fishiest
fittest102510803fittest
gashest114813413gashest
geest64829613__geest
gest56149133__g_est
ghast95621223__ghast
ghost96318763__ghost
gighe10139733gighe__
giglet83920273gigle_t
giglets93211553giglets
gigues8129003gigues_
guest65225923__guest
hest75950773___hest
higher134610893highe_r
highness1536053highness
highs125412523high_s_
hight125327233high__t
hights133716893hights_
hippest14219753hippest
hugest10311763hug_est
iciest82914743_iciest
idlest74014863_idlest
illest63615723_illest
inanest72115363inanest
incest82918743_incest
inches114419673inches_
infest93315433_infest
ingesta8357863ing_esta
ingests83210983ing_ests
ingles74420873ingles_
ingress838653ingress
inkiest113415043inkiest
inquest1638603inquest
invest93014843_invest
jiggiest17277693jiggiest
jimpest18297553jimpest
jiviest1738113jiviest
kindest12311503kindest
kithes135016653kithes_
knight1438173knigh__t
knights1545653knights_
knishes1438263knishes_
liches114724293liches_
liefest1038443liefest
lievest1048343lievest
light94429603ligh__t
lights104519913lights_
likest104914383li_kest
limiest93716103limiest
limpest113712313limpest
lingiest93715263lingiest
liniest73321153liniest
livest95315733li_vest
logiest82515543logiest
lushest103312283lushest
miches134320733miches_
might113827083migh__t
mightiest1546443mightiest
mights123516253mights_
mildest102812063mildest
mingiest113315823mingiest
miriest93619823miriest
mirkest13309723mirkest
mitiest93520053mitiest
naches114622413naches_
naggiest102610013naggiest
naivest10309473naivest
nearest73415843nearest
neatest72516003neatest
neglect1047363neglect
neighed12135893neighe_d
neighs10387733neigh_s_
nest45548733n___est
newest9314213n_ewest
niche105016793niche__
niched125514063niche_d
nides65229133ni_des_
nidget83715633nidge_t
nidgets9358143nidgets
nieces84112713nieces_
nieves94311293nieves_
niftiest112910073niftiest
nigger89713573nigge_r
niggers93111323niggers
niggles93512203niggles_
niggliest1144933niggliest
nigh85220663nigh___
nighing123410063nighing
nightie1179653nightie
nighties121011383nighties_
nightless1386073nightless
nightly14449033nightly
nightspot1552863nightspot
nighty135611273nigh_ty
nimblest1236923nimblest
nines55937343ni_nes_
nippiest12279973nippiest
nites55736343ni_tes_
nitres65519333nitres_
nittiest82712603nittiest
nixes124519623ni_xes_
nixies135313873nixies_
noblest93613563noblest
noisiest839763noisiest
nonguest938563nonguest
noshes96618233noshes_
nosiest73415673nosiest
nudest74113833n_udest
nugget8311723nugge_t
nuggets936383nuggets
numbest1138793numbest
oiliest72817683oiliest
piggiest12259663piggiest
piglet93420923pigle_t
piglets103311793piglets
pigment12510733pigment
piniest93121133piniest
pinkest132812623pinkest
pipiest113114493pipiest
pishes114722103pishes_
pithiest132711443pithiest
poshest12312423poshest
rashest103916873rashest
riches115022083riches_
ridgiest1038903ridgiest
rifest93114583ri_fest
right94430503righ__t
rightist12159143rightist
rights104019333rights_
rimiest93215853rimiest
ripest84317943ri_pest
roughest1238773roughest
sagest74920263sag_est
sagiest82617983sagiest
sickest131813793sickest
sighed113712053sighe_d
sigher103813703sighe_r
sighers113712183sighers
sighless1276553sighless
sighs95416743sigh_s_
sight94629293sigh__t
sights103818013sights_
signet73621153signe_t
signets83311503signets
siziest16311473siziest
slightest13136943slightest
snidest8310913sni_dest
sniglet83612413snigle_t
sniglets9276813sniglets
snuggest1045243snuggest
suggest9310863suggest
tidiest83514873tidiest
tight93626503tigh__t
tights104015853tights_
tigress836093tigress
tiniest73020123tiniest
tithes94720213tithes_
toughest1238303toughest
triggest1036923triggest
uniquest1775603uniquest
vaguest1137333vaguest
vilest9416843vi_lest
viniest103216613viniest
wiches144418753wiches_
widest104517003wi_dest
wiggiest13269013wiggiest
wight123725573wigh__t
wights133315783wights_
wigless11359673wigless
wiglet105519153wigle_t
wiglets113411423wiglets
wildest113311273wildest
wiliest103416593wiliest
wingiest123214283wingiest
winiest103419693winiest
wiriest103816853wiriest
wisest95016443wi_sest
wishes124920953wishes_
withes124620843withes_
withiest142411243withiest
zingiest182810893zingiest

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.1401276364.3
2DLD Change Limit1340272416.56320421.6
3Display Results2412410.0932591.4
 (SQL Overall)1786912416.79626293.6
 
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.