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

248 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
highest143956(None) 
nighest11310691nighest
biggest1138142biggest
digest84019622dig_est
higher134610892highe_r
highness1536052highness
highs125412522high_s_
hight125327232high__t
hights133716892hights_
hippest14219762hippest
hugest10311762hug_est
lightest121410352lightest
lithest10513912lithest
richest122813682richest
rightest12149582rightest
tightest12148362tightest
aghast105711373_aghast
aiglet74224193aigle_t
aiglets84012913aiglets
aigret73720023aigre_t
aigrets82810543aigrets
airest63825263ai_rest
airiest74221013airiest
barghest1447913barghest
behest11314613_behest
bigfeet1376153bigfeet
bighead14126653bighead
bight118728843bigh__t
bights124417963bights_
bigness1038193bigness
bilgiest11309883bilgiest
blithest1338083blithest
brightest1545663brightest
cagiest102916433cagiest
chest104926143__chest
chicest14209943chi_cest
chichiest1936343chichiest
chiefest1645313chiefest
chigoes1338353chigoes_
chillest13259593chillest
chirkest1735383chirkest
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
geest64829623__geest
gest56149133__g_est
ghast95621223__ghast
ghost96318763__ghost
gighe10139733gighe__
giglet83920273gigle_t
giglets93211553giglets
gigues8129003gigues_
guest65225923__guest
haddest122711993haddest
hairiest11612473hairiest
halest94823273h_alest
hangnest12311413hangnest
hardest113118413hardest
harshest14310193harshest
harvest132112753harvest
hashes125024803hashes_
haziest193313013haziest
hedgiest13298133hedgiest
height134713433heigh__t
heights14399443heights_
heppest14228153heppest
hest75950773___hest
hides95129433hi_des_
hies74842843hi__es_
higgles123911803higgles_
high116619933high___
highboy1943393highboy
highbush1642123highbush
highly1636823high_ly
highrise1554403highrise
highspot1753033highspot
highted152710163highted
highth12389153high_th
highths13358003highths
hightop1645013hightop
highway2044263highway
hikes125426983hi_kes_
hilliest113914113hilliest
hinges105121033hinges_
hinkiest153311753hinkiest
hipless12399923hipless
hipness12277383hipness
hippiest152611623hippiest
hirees95117293hirees_
hires86134343hi_res_
hisses94719353hisses_
hissiest112911093hissiest
hist76551553hi___st
hitches153616273hitches_
hither124417253hithe_r
hitherto1444353hitherto
hitless103211193hitless
hives116925513hi_ves_
hogget114715763hogge_t
hoggets12498323hoggets
hokiest144114243hokiest
holiest104319623holiest
homiest124116633homiest
honest94822423h_onest
hottest10411383hottest
hushes124718593hushes_
hygeist1445793hygeist
hygieist1543493hygieist
iciest82914743_iciest
idlest74014863_idlest
illest63615723_illest
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
invest93014843_invest
jiggiest17277693jiggiest
jimpest18297553jimpest
jiviest1738113jiviest
kindest12311503kindest
kithes135016653kithes_
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
nicest82315663ni_cest
niches114419143niches_
nighed113811293nighe_d
nigher103612753nighe_r
nighness1236103nighness
nighs95013613nigh_s_
night94327853nigh__t
nights104117723nights_
oiliest72817683oiliest
piggiest12259663piggiest
piglet93420923pigle_t
piglets103311793piglets
pigment12510733pigment
piniest93121133piniest
pinkest132812623pinkest
pipiest113114503pipiest
pishes114722103pishes_
pithiest132711443pithiest
poshest12312423poshest
rashest103916873rashest
riches115022083riches_
ridgiest1038903ridgiest
rifest93114583ri_fest
right94430503righ__t
rightist12159143rightist
rights104019333rights_
rimiest93215853rimiest
ripest84317943ri_pest
roughest1238773roughest
sagest74920263sag_est
sagiest82617993sagiest
shiest95821533shi__est
shiniest113212503shiniest
sickest131813793sickest
sighed113712053sighe_d
sigher103813703sighe_r
sighers113712183sighers
sighless1276553sighless
sighs95416743sigh_s_
sight94629293sigh__t
sights103818013sights_
signet73621153signe_t
signets83311503signets
siziest16311473siziest
slightest13136953slightest
suggest9310863suggest
thickest17337303thickest
thighed1535273thighe_d
thighs1346633thigh_s_
thinnest11248903thinnest
tidiest83514873tidiest
tight93626503tigh__t
tights104015853tights_
tigress836093tigress
tiniest73020123tiniest
tithes94720213tithes_
toughest1238303toughest
triggest1036923triggest
vaguest1137333vaguest
vilest9416843vi_lest
viniest103216613viniest
whiniest14298753whiniest
whishes16309443whishes_
whitest133710113whi_test
whitiest14259883whitiest
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.390458182.1
2DLD Change Limit1340272486.17021722.4
3Display Results2482480.0803100.0
 (SQL Overall)1786912486.64026911.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.