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

245 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
cymenes147741(None) 
cymene1377391cymene_
cements112714222cements
cyeses11510122cy_eses
cymes1210118922cym__es
cymogenes1745812cymogenes
gyrenes11267522gyrenes
hymens1437992hymen_s
pyrenes123511222pyrenes
xylenes1745092xylenes
achenes12313493achenes
acumens1136953acumen_s
agenes74720253_agenes
akenes104817343_akenes
alkenes114212753alkenes
amends94713283_amends
amens75624843_amen_s
aments85219803_aments
amines84727983_amines
ammines11312673ammines
amylenes13105703amylenes
arenes64928393_arenes
benes75536233__benes
butenes9313033butenes
bygones1335913bygones
bylines1239243bylines
cadences1338473cadences
cajones163311333cajones
calends1039523calends
camases114216343camases
camels105217083came_ls
cameoed1238383cameoed
cameos105818003came_os
cameras11313343cameras
cames97047313cam__es
camises114218463camises
cammies134016473cammies
camphenes1846463camphenes
canes75350373c__anes
canines93724033canines
careens94514703careens
carmines123617863carmines
casernes103810753casernes
cassenes103611293cassenes
catenas9313103catenas
cayennes1345013cayennes
caymans14349513cayman_s
cedes84927323c__edes
cees65941593c__e_es
cement103321663cemen_t
cementa112810533cementa
cemented1338373cemented
cementer1239193cementer
cementers1338303cementers
cense75121403c__ense
censes83721803c__enses
cents74730333c__ents
cepes94424463c__epes
ceres75540013c__eres
cetanes9315133cetanes
cetes75731103c__etes
chaines124518733chaines
cheeses123613103cheeses
chimeres153511303chimeres
chines115029173c_hines
chymes165912153chym__es
cimices13279803cimices
cines75239683c__ines
clepes104214623c_lepes
clients938093clients
clines84926043c_lines
clones84526563c_lones
codeines113114523codeines
codens94821013coden_s
coheres122917693coheres
cohunes1249713cohunes
coignes103912153coignes
cojones163512103cojones
colones96124433colones
comakes154413643comakes
comates114123633comates
combes125321733com_bes
combines142814623combines
comedies13311833comedies
comedones1446933comedones
comedos12329073comedos
comers105328083come_rs
comes97246993com__es
comets105823583come_ts
comings124013533comings
commences17139573commences
commends15308463commends
comments142913873comments
commies133718443commies
communes143411233communes
compends15378253compends
comperes143217973comperes
competes144117243competes
comtes106222813com_tes
cones76457423c__ones
conines93827793conines
convenes132916913convenes
cooees85621893cooe_es
copens106119963copen_s
cosines94122673cosines
covens114919263coven_s
cozened19349183cozened
cozener18328953cozener
cozeners19297783cozeners
cozens176314923cozen_s
cranes84330753c_ranes
creeses93914623creeses
cremes104517993c_remes
crenel84213063c_renel
crenels93711013c_renels
crepes105419343c_repes
crones84729243c_rones
culexes1636993culexes
cumins103314933cumin_s
cuteness1039673cuteness
cuvees1139373cuve_es
cyanines132710543cyanines
cyans105714813cy_an_s
cycases1437533cycases
cycles1339303cy_cles
cyclones1537483cyclones
cyders12398833cyde_rs
cyesis1148573cy_esis
cygnet1237893cy_gnet
cygnets1333813cygnets
cylices14359283cylices
cymae126713013cym_ae_
cymars13599143cym_ars
cymas126417883cym__as
cymbals16236143cymbals
cyme119420373cym__e_
cymlings1634203cymlings
cymlins1436693cymlins
cymogene1644723cymogene_
cymols1377193cym_ols
cymose13429653cymose_
cymous1388403cym_ous
cypres1338523cy_pres
cypreses1535143cypreses
cysteines1445133cysteines
cystines1339463cystines
cytons111710183cyton_s
dements103016623dements
demesnes1137083demesnes
denes65639723__denes
dienes75719903_dienes
domines102918973domines
dynes95917583dy__nes
emends95711433_emends
emeses86114963_emeses
ermines9416663ermines
ethenes103313873ethenes
famines123216263famines
foments122912053foments
gameness112810693gameness
gametes10312253gametes
gamines103618463gamines
genes65133093__genes
gyrene10227243gyrene_
homines123518643homines
hyaenas1334983hyaenas
hyenas1288953hy_enas
hygienes1543413hygienes
hymen13311043hymen__
hymenal1545183hymenal
hymeneal1643473hymeneal
hymeneals1742533hymeneals
hymenia1546393hymenia
hymned1535323hym_ned
hymns1337523hym_n_s
imines84918353_imines
immense1135293immense
immunes1136083immunes
indenes82916253indenes
ketenes114813503ketenes
lameness102612673lameness
laments94314853laments
lenes54738523__lenes
limens84618033limen_s
loments93413473loments
lumens85013973lumen_s
lycees11428863lyce_es
lysines10369093lysines
mameyes14376983mameyes
manes76648953__manes
memes94927703__memes
mends84927693__mends
mense75025633__mense
menses84222453__menses
menus75822843__menus
meres75143573__meres
mesnes85216213__mesnes
metes74736213__metes
mezes167719263__mezes
mimeses1139073mimeses
mines75651953__mines
moments113113123moments
myceles1435213myceles
nemeses948663nemeses
nenes55329673__nenes
omened93711003_omened
omens75618963_omen_s
oyezes1835053oy_ezes
payments1536943payments
penes75839223__penes
pinenes93416673pinenes
pyrene113210733pyrene_
pyrexes19305833pyrexes
pyrones123113303pyrones
ramees84620893rame_es
remends105013033remends
retenes76324623retenes
rumens83611813rumen_s
sameness102712683sameness
scenes84520353_scenes
sememes11109203sememes
semens84616963semen_s
serenes73222903serenes
skenes104616633_skenes
someones1039063someones
sphenes123013163sphenes
styrenes11116623styrenes
sycees11409653syce_es
syrens94911993syren_s
tameness102411253tameness
thymines1635603thymines
tmeses85712243_tmeses
trienes74118413trienes
tyees86019453ty_e_es
tynes85920303ty__nes
venenes102712133venenes
xylene1645793xylene_
yamens114010823yamen_s
yens75832263_y_en_s
yentes95517603_y_entes
yeses85119323_y_eses
zymases21938333zymases
zymes1924712943zym__es
zymogenes2444453zymogenes
zymoses21608693zymoses

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.1561145455.1
2DLD Change Limit1340272455.75023309.0
3Display Results2452450.0932634.4
 (SQL Overall)1786912455.99929786.8
 
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.