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

226 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
gnomon93618(None) 
gnomons1035751gnomons
agnomen1036762agnomen
dromon939362dromon
gammon1138902gammon
gnome84213952gnom_e
gnomes93812972gnomes
gnomic11248592gnomic
gnomonic1345902gnomonic
gonion73612832gonion
goon57236172g_o_on
jomon14610082_jomon
nomen75621622_nomen
nomoi76012532_nomoi
nomos75919742_nomos
noon47134622_no_on
aboon74918703abo_on
agnomens1144893agnomens
agnomina1144263agnomina
ancon75718233an_con
anemone9119453anemone
anion55028813an_ion
anomic102516303anomic
anomie83215963anomie
anomy105113393anom_y
anon46134853an__on
anyon85615223an_yon
bonbon10310073bonbon
boon67142173_bo_on
boron76727143_boron
boson76019733_boson
bromin102615693bromin
bromo95217203bromo_
bromos104213313bromos
codon86522853_codon
cognomen1346083cognomen
cogon89120903_cogon
colon78630193_colon
common12310803common
coon67248943_co_on
croon75522783cro_on
croton84415453croton
daemon9279593daemon
daimon9259713daimon
demon86520313_demon
donjon1436463donjon
dromond1135473dromond
dromons1038193dromons
duomo839753duomo_
duomos936823duomos
enamor838753enamor
etymon1134693etymon
gabion93211033gabion
gaboon93211773gaboon
gagman103811243gagman
gagmen103910413gagmen
gallon73715813gallon
gamin84422993g_amin
gammons1237973gammons
garcon92912483garcon
garron73113493garron
gascon9339723gascon
gasman92911743gasman
gasmen93111563gasmen
gemot84024233g_emot
genom83716843genom__
genome94312193genom_e
genomes103611703genomes
genomic1237923genomic
genoms94412483genom_s
german9611983german
germen9612313germen
gibbon1135323gibbon
gibson935123gibson
gipon84212413g_ipon
giron66118993g_iron
gismo848863gismo_
gismos957183gismos
gizmo1756013gizmo_
gizmos1844133gizmos
glamor958183glamor
globin9309723globin
glom75424383glom__
gloms85219783glom_s
glomus9468093glomus
glonoin875673glonoin
gloom87116523glo_om
glooms96211683glooms
gloomy12528763gloomy
gluon6311223g_luon
gnawn9517783gn_awn
gnomish1345563gnomish
gnomist1049133gnomist
gnoses76515163gnoses
gnosis75711213gnosis
goban84414073g_oban
gobo76126893g_obo_
gobony1236913g_obony
gobos86219373g_obos
godown1136033g_odown
godson857383godson
gogo69722833g_ogo_
gogos77516523g_ogos
gombo105814043g_ombo
gombos114311093g_ombos
gomer85220653g_omer
gonof95218653g_onof
gonzo15310243gonzo_
goo47754773g_o_o_
good66531803g_o_od
goodman1135933goodman
goodmen1135623goodmen
goof85436873g_o_of
googol835843googol
gook96429603g_o_ok
goons65326773g_o_ons
goony95519783g_o_ony
goop75829483g_o_op
goos57644913g_o_os
gorgon8310243gorgon
gowan95415743g_owan
gown85724073g_o_wn
grison7310103grison
groan65618423gro_an
groin65521083gro_in
groom85317983gro_om
grooms94512523grooms
grown95317353gro_wn
guenon736403guenon
guidon837373guidon
gunman9299453gunman
gunmen9348723gunmen
gyron95314623g_yron
homo96126473_homo_
homos105921783_homos
ignominy1443563ignominy
inion54620183in_ion
intron64215023intron
isogon7227543isogon
known12568343kno_wn
kroon94514483kro_on
lemon75618183_lemon
logon615922313_logon
loon47344793_lo_on
mammon939643mammon
mon57561573___mon
moon67140813_mo_on
moron76925423_moron
neocon836713neocon
neon47026423_n_eon
ninon55517383_ninon
niton55418283_niton
nohow1137293_nohow
nolo46229313_nolo_
nolos54423353_nolos
nom510450643_nom__
noma67529463_nom_a
nomad86016183_nomad
nomas74726413_nomas
nome66038423_nom_e
nomes74933123_nomes
nomina83113683_nomina
noms65636403_nom_s
nonman8412363_nonman
nonmen8412833_nonmen
noo37154043_no_o_
nook85728493_no_ok
noons54125283_no_ons
notion64516583_notion
noun45724183_no_un
numen74216793_numen
nylon82910513_nylon
omen66828183__omen
onion54320973on_ion
phonon114012033phonon
photon1111514823photon
pomo85828453_pomo_
pomos95321583_pomos
pompon1238943_pompon
ponton83217643ponton
poon67341263_po_on
promo95619993promo_
promos105116423promos
proton84318893proton
roman75424823_roman
ronion63315643ronion
ronyon9309133ronyon
salmon84614183salmon
sermon8413553sermon
shoon84022003sho_on
simoon858063simoon
snood64616163sno_od
snook95115573sno_ok
snool55118643sno_ol
snoop75317173sno_op
snoot55030133sno_ot
snowman12226623snowman
snowmen12246153snowmen
solon55026133_solon
soman75024903_soman
somoni8310733_somoni
soon46240503_so_on
spoon74719443spo_on
stolon64112063stolon
summon1037623summon
swoon85014783swo_on
thoron94713903thoron
toman75724053_toman
toon47740633_to_on
toyon86715673_toyon
trogon73611753trogon
uncommon1443233uncommon
union54519793un_ion
unison649033unison
unman72715423un_man
unmoor836313unmoor
unmown11296093unmown
unopen838913unopen
unwon84512343un_won
woman105818003_woman
women104619253_women
womyn13426363_womyn
wonton93410963wonton
yeoman1138823yeoman
yeomen1138183yeomen
zoon137326983_zo_on

Search took 9 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162268.06313979.4
3Display Results2262260.1401614.3
 (SQL Overall)1786912268.34621410.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.