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

139 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
gnomist104913(None) 
gnomish1345561gnomish
gnomists1145471gnomists
animist93815172animist
atomist92915762atomist
gnomes93812972gnomes_
gnomic11248592gnomi_c
gnosis75711212gnosis_
nomism103010952_nomism
agnomina1144263agnomina
agonist82615403agonist
agronomist1354993agronomist
amorist9317643amorist
anatomist11119263anatomist
animis84615943animis_
animism113510213animism
animists103010633animists
anoint6423633ano_int
anomic102516303anomi_c
anomie83215963anomi_e
anomies93316993anomies
aorist64827873_aorist
apomict1349053apomict
atomise93013823atomise
atomism112610963atomism
atomists102610963atomists
bemist105216963_bemist
bionomist1347113bionomist
boomiest122711843boomiest
bromism1337623bromism
canoeist10310693canoeist
canonist10513533canonist
chemist143615003chemist
chymist17268173chymist
consist9316033consist
cosmist11311333cosmist
doomiest112910453doomiest
dynamist1445343dynamist
economist1348883economist
eglomise1143933eglomise
egoist7612283ego_ist
egotist8411273egotist
encomiast1344973encomiast
endmost1056763endmost
enlist6417043en_list
enokis103010273enokis_
enosis63816423enosis_
entwist1048803entwist
ergonomist1374973ergonomist
florist10314243florist
foist85730973_fo_ist
gamest94919933g_amest
gamiest102816233g_amiest
gammiest13339333gammiest
gemmiest13227633gemmiest
genoise839423geno_ise
genomes103611703genomes_
genomic1237923genomi_c
genomics1345713genomics
genoms94412483genom_s_
germiest11249923germiest
ghost96318763gho__st
gist56046763g___ist
gloms85219783glom_s_
glomus9468093glomus_
gloomiest1235603gloomiest
glost65422933glo__st
gneiss765953gn_eiss
gnome84213953gnom__e
gnomical1346683gnomical
gnomon936183gnom_on
gnomons1035753gnomons
gnoses76515163gnoses_
goodish1237963goodish
goofiest12289393goofiest
gooiest82813883gooiest
gooniest93213003gooniest
goopiest112710553goopiest
goosiest92911823goosiest
goriest82218743g_oriest
goyish13379013g_oyish
grimiest11299823grimiest
grist65529873g__rist
grodiest10310553grodiest
grommet12268453grommet
gummiest13269033gummiest
hoist86433213_ho_ist
holist94723213_holist
homiest124116633_homiest
ignominy1443563ignominy
inmost8411363in_most
insist6314513in_sist
intimist10410213intimist
intwist1038043intwist
ironist7314843ironist
joist125125653_jo_ist
lookist1139563lookist
mist66154533___mist
moist76033583_mo_ist
momism93410353_momism
monist84324983_monist
monodist11310923monodist
neist54628443_n_eist
noise55723733_no_ise
noisy86813363_no_isy
nomas74726413_nomas_
nomes74933123_nomes_
nomina83113683_nomina
nomisms11268743_nomisms
nomistic1279593_nomistic
nomos75919743_nomos_
noms65636403_nom_s_
noris54928273_noris_
nosiest73415673_nosiest
nowise9511073_nowise
nudist73813323_nudist
oboist8312683obo_ist
odist6421913__odist
oghamist1444753oghamist
ologist8313833ologist
omit65337373__omi_t
omits75018263__omits
onanist7314633onanist
palmist112814343palmist
pogromist1445313pogromist
promise113415843promise
protist9320223protist
roomiest102611993roomiest
snowiest1138143snowiest
sodomist1157633sodomist
sumoist9311613sumoist
tenorist8413023tenorist
unionist8410353unionist
unmixt15378703un_mixt
untwist1047713untwist
utopist938693utopist
violist10312143violist
vomit102622573_vomi_t
vomits112610923_vomits

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271396.81019680.9
3Display Results1391390.0502780.0
 (SQL Overall)1786911397.28324535.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.