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

365 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
gemotes10371214(None) 
demotes104717671demotes
emotes84620281_emotes
gemote94613021gemote_
gemots93712151gemot_s
remotes94521611remotes
agemates111110022agemates
cenotes92814542cenotes
demoses103815822demoses
demote94817802demote_
demoted114313542demoted
denotes83817002denotes
devotes113713752devotes
emote75421192_emote_
emoted94614922_emoted
emoter85415192_emoter
emoters94712872_emoters
gametes10312252gametes
garotes8614562garotes
gelates83219582gelates
gemmates13307672gemmates
gemot84024232gemot__
genomes103611702genomes
gentes75324162ge_ntes
geodes8412152ge_odes
gestes75721392ge_stes
motes75944002__motes
peyotes1238482peyotes
remates93827102remates
remote84222602remote_
remoter94815972remoter
remotest103310722remotest
removes124514712removes
revotes104716392revotes
aerates74627483aerates
aerobes9311493aerobes
agametes1147293agametes
agemate101210583agemate_
amoles84122193_amoles
anemones10249473anemones
anemoses10159433anemoses
azotes154312223_azotes
becomes132911963becomes
bedmates1349183bedmates
behoves15177353behoves
bemires113212833bemires
bemixes18338653bemixes
bemoans1138253bemoans
bemocks1735373bemocks
bemuses1139293bemuses
berates94126853berates
besmokes16406363besmokes
besots86415453besot_s
capotes11314643capotes
celotex1635023celotex
cenote83715843cenote_
cerates95428233cerates
cerites94823433cerites
certes84623083ce_rtes
cetes75731103ce__tes
comates114123633comates
compotes144716513compotes
comtes106222813com_tes
cotes76347843__cotes
coyotes12410703coyotes
cremates124215983cremates
daemones11209163daemones
debates103718523debates
debones103315113debones
decodes113914983decodes
delates83526283delates
deletes83117933deletes
demes86032693dem__es
demies94825803dem_ies
demises103719563demises
demits94918073demit_s
demobs11429483demo_bs
demode104013463demode_
demoded123611123demoded
demoed103713443demo_ed
demoness1138053demoness
demons94917723demo_ns
demos86022993demo__s
demotic12412333demotic
demotics1338753demotics
demotist11311843demotist
denote74118043denote_
denoted93512763denoted
depones103717093depones
deposes103117213deposes
depots94716343depot_s
deputes104911783deputes
derates84028883derates
detoxes1538803detoxes
devote104513783devote_
devoted124111093devoted
devotee113811823devotee
devotees12286283devotees
dotes65836693__dotes
elates65032363_elates
elites66027123_elites
elopes85918163_elopes
elutes64020313_elutes
emcees1037813_emcees
emes65434663_em__es
emeses86114963_emeses
emeutes938013_emeutes
emits75421473_emit_s
emmets10349153_emmets
empties11712243_empties
emydes1236173_emydes
enates64026423_enates
epodes94315563_epodes
eposes84418783_eposes
eremites10312593eremites
erodes74819883_erodes
eroses65327053_eroses
evites94916473_evites
evokes13459683_evokes
females12310663females
femes105626223fem__es
femmes135410213fem_mes
fetes85630143fe__tes
fomites123613203fomites
galores82614323galores
gambes116318313gam_bes
gambles124016203gambles
gamboges1435653gamboges
games86238553gam__es
gamete9313593gamete_
gamines103618463gamines
gamuts958783gamut_s
garote7717943garote_
garoted9710133garoted
garottes978283garottes
garrotes969363garrotes
gates65939503g__ates
gavots1038103gavot_s
gavottes1274183gavottes
geckoes14325793geckoes
gees55647883ge___es
geests75912163geest_s
gelate73421253gelate_
gelated93615633gelated
gelatis83313513gelatis
gelatos83111513gelatos
gelees74116263ge_lees
gelts65924613ge_lt_s
geminates12310033geminates
gemmae11507793gemmae_
gemmate12418383gemmate_
gemmated14336293gemmated
gemmed12329573gem_med
gemmier12337383gemmier
gemmiest13227613gemmiest
gemmules13183213gemmules
gems75329113gem___s
gemstones1245563gemstones
genes65133093ge__nes
geneses82613523geneses
genets75716663genet_s
genettes938303genettes
genies75324943ge_nies
genoas74013623geno_as
genoise839423genoise
genoises939253genoises
genome94312193genome_
genoms94412483geno_ms
genotypes1544683genotypes
genres75515623ge_nres
gentles83714343gentles
gentoos838633gentoos
gents65729613ge_nt_s
genuses83510883genuses
geode7412593ge_ode_
geodesy1233133ge_odesy
geoids8369843ge_oids
geometer1138423geometer
geometers1238183geometers
geotaxes1644743ge_otaxes
gessoes838293gessoes
gestates93213723gestates
geste65920693ge_ste_
gests66028813ge_st_s
getas65421483ge__tas
gets55442483ge__t_s
getter74117613ge_tter
getters84216093ge_tters
ghettoes1243493ghettoes
gigots83911953gigot_s
gimlets10338433gimlets
gimmes113010903gim_mes
gimmies123010113gimmies
gites65630183g__ites
globes94314543g_lobes
gloves104115183g_loves
glozes164313353g_lozes
glutes74517673g_lutes
gnomes93812973g_nomes
gnoses76515163g_noses
goboes95914443gobo_es
goes55644093g__o_es
gomutis1035723gomutis
gooses75723053g_ooses
gores65740373g__ores
goths96513003g__oths
goxes135018263g__oxes
grates75429883g_rates
gremmies1355993gremmies
griots74713643griot_s
grooves11368803grooves
gropes95220403g_ropes
grots65025853g_rot_s
groves104318103g_roves
gummites1346163gummites
gummoses1344743gummoses
gunites8313123gunites
gustoes879873gustoes
guyots1036003guyot_s
gyrates113610263gyrates
hamates122917673hamates
helots95217703helot_s
hemes105031083hem__es
hemocytes1946693hemocytes
heroes94923823hero_es
hexones17299143hexones
hexoses17228883hexoses
humates122813193humates
inmates92715763inmates
jemmies18318333jemmies
jetes124922843je__tes
kentes105118643ke_ntes
ketones115014503ketones
ketoses114912873ketoses
keynotes1543633keynotes
legates82917673legates
lemons84415053lemo_ns
lemures938793lemures
lenites7818443lenites
leones64417723le_ones
limites92915453limites
litotes7311183litotes
mates75251363__mates
meioses9310833meioses
memes94927703mem__es
memoirs1136803memoirs
memories121214343memories
memos95719113memo__s
metates92720003metates
metes74736213__metes
metopes11311363metopes
mites75141803__mites
modes85537413__modes
mokes114631033__mokes
moles74747923__moles
momes95134473__momes
montes84226933__montes
mopes95134983__mopes
mores76249643__mores
mote67048083__mote_
motel76623243__motel
motels83616893__motels
motet75641193__motet
motets84216193__motets
motey105922953__motey
moths106021553__moths
mots66853163__mot_s
mottes85523693__mottes
motts76527003__motts
moues75732843__moues
moves106128423__moves
mutes75033783__mutes
negates83215833negates
nemeses948663nemeses
notes55034583__notes
osmoles9138363osmoles
osmoses9138123osmoses
pekoes124410423peko_es
pelites93821993pelites
pelotas9410723pelotas
penates93321593penates
peones83821043pe_ones
permutes1238713permutes
petites93820203petites
peyote1139853peyote_
peyotls1233633peyotls
promotes12314123promotes
quotes153312463_quotes
rebates95123173rebates
rebores95319163rebores
recites93524583recites
recodes102918633recodes
redates83423863redates
redoes74623753redo_es
redoxes15310883redoxes
refutes104515723refutes
relates73731423relates
remakes134116173remakes
remate84428683remate_
remated103522473remated
remeets93712413remeets
remiges103015473remiges
remises93423483remises
remits85622943remit_s
remixes164313873remixes
remodel1038093remodel
remodels1135663remodels
remolds10299703remolds
remoras9314073remoras
remorse9311713remorse
remorses10311993remorses
remotely1345623remotely
remove116115573remove_
removed134611313removed
remover124612273remover
removers13449223removers
rentes65431193re_ntes
reposes94021263reposes
repots85621003repot_s
reputes94615963reputes
reroutes8312223reroutes
resites74027793resites
resoles73823653resoles
revokes144212503revokes
revote94917453revote_
revoted114314153revoted
rezones163213943rezones
rotes56143903__rotes
samites93118713samites
sapotes9313933sapotes
sedates83418033sedates
sememes11109203sememes
semes75731583sem__es
semioses10611013semioses
semises93916553semises
senates73322583senates
senores73218113senores
shmoes114612093shmo_es
shotes95321893_shotes
smites83921923_smites
smokes124814343_smokes
smote75820273_smote_
somites94219113somites
telomes9310533telomes
temples112610893temples
tempted12317283tempted
tempter11358213tempter
tempters12257293tempters
tempts10439453tempt_s
termites10313693termites
testes65125823te_stes
totes55139683__totes
vamoses1239143vamoses
velites103417303velites
veloutes1136153veloutes
verites103822253verites
verstes104014273verstes
vetoes92914083veto_es
votes84627083__votes
xeroses143612823xeroses
xeroxes13246443xeroxes
yentes95517603ye_ntes
zeroes154314343zero_es
zygotes20355163zygotes
zymoses21608693zymoses

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273658.29616155.6
3Display Results3653650.1402607.1
 (SQL Overall)1786913658.59220797.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.