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

373 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
schemes148966(None) 
schemas1468161schemas
scheme1379631scheme_
schemed1577751schemed
schemer1477951schemer
schemers1576701schemers
achenes12313492achenes
chemos13311722_chemos
chimes134922572_chimes
chymes165912152_chymes
cremes104517992_cremes
hemes105031082__hemes
rhemes115913182_rhemes
sachems14348902sachem_s
scenes84520352sc_enes
schema1388372schem_a
schmeer1475362schmeer
schmeers1574832schmeers
schmoes14308542schmoes
schmos13379152sch_mos
screes85023962scre_es
sememes11109202sememes
semes75731582s__emes
shames114726222s_hames
sphenes123013162sphenes
spheres123114352spheres
themes115319252_themes
academes1344873academes
accedes1237713accedes
achene11313813achene_
aches106132293ach__es
achieves1645523achieves
ackees124914573acke_es
acmes96020653ac__mes
adheres11310163adheres
alchemies1654833alchemies
apheses12610703apheses
asceses938623asc_eses
biremes1138773biremes
cames97047313_c_ames
cedes84927323_c_edes
cees65941593_c_e_es
cepes94424463_c_epes
ceres75540013_c_eres
cetes75731103_c_etes
chafes145017913_chafes
champs154915683_champs
chams126028503_cham_s
chapes135421873_chapes
chares115631803_chares
chases115128233_chases
cheaps134613683_cheaps
cheats114519543_cheats
chebec1536963_chebec
chebecs1635013_chebecs
checks174912703_checks
cheder125113493_cheder
cheders134512393_cheders
cheek145115713_che_ek
cheeks154712783_cheeks
cheep125416503_che_ep
cheeps135312913_cheeps
cheer105420383_che_er
cheers114518913_cheers
cheese113812763_che_ese
cheeses123613103_cheeses
cheesy14419193_che_esy
chefed155010563_chefed
chefs136214663_che_fs
chegoes1337333_chegoes
chelas113817203_chelas
chemic153012093_chemic
chemics16349573_chemics
chemise143211503_chemise
chemises153211983_chemises
chemism16339303_chemism
chemist143615003_chemist
chemo12313633_chem_o
cheques2136863_cheques
cherts115617233_cherts
chess105016923_che_ss
chesses124112633_chesses
chests114916263_chests
cheths14389823_cheths
chevies153511443_chevies
chevres15379793_chevres
chewed154415013_chewed
chewer145512613_chewer
chewers154111133_chewers
chews135418513_che_ws
chides124620473_chides
chiles115425303_chiles
chimbs153910303_chimbs
chime125322593_chime_
chimed145814833_chimed
chimer135517203_chimer
chimers144515133_chimers
chimps155713663_chimps
chines115029173_chines
chives144317593_chives
chokes154917383_chokes
chomps155112223_chomps
chores114828023_chores
choses115825123_choses
chromes142914933_chromes
chumps154313823_chumps
chums125015833_chum_s
chutes114615763_chutes
chyles144813283_chyles
chyme156512503_chyme_
cleomes1138813_cleomes
clepes104214623_clepes
climes104720003_climes
coheres122917693coheres
comes97246993_c_omes
creme94319323_creme_
crepes105419343_crepes
crimes105521583_crimes
cyeses11510123_cyeses
cymes1210118923_c_ymes
demes86032693__demes
echelles1346663echelles
eches106322163ech__es
echoes114715523ech_oes
eczemas2063143eczemas
emes65434663___emes
ephebes1436153ephebes
escheats1346253escheats
eschewed1743443eschewed
eschewer1643163eschewer
eschewers1742873eschewers
eschews1534553esche_ws
estheses1137783estheses
esthetes1147743esthetes
ethenes103313873ethenes
exhumes1934323exhumes
femes105626223__femes
ghees95215553_ghe_es
hames106138703__hames
hebes105521673__hebes
heme95034413__heme_
hemps126917333__hemps
hems95534943__hem_s
heres86245903__heres
hexes155123043__hexes
homes106938813__homes
icemen1037893ic_emen
inheres10315173inheres
inhumes1296883inhumes
ischemia1544073ischemia
ischemias1644183ischemias
ischemic1744673ischemic
isochimes16103743isochimes
lexemes1635673lexemes
lichees123512783liche_es
lychees15516783lyche_es
machetes1539633machetes
memes94927703__memes
ochered132610283ochered
ochers113915303oche_rs
ochres113510833och_res
outschemes1743023outschemes
pschents1544113pschents
racemes1139093racemes
rehems113410983rehem_s
rheme106214053_rheme_
rhymes14419823_rhymes
sachem134012223sachem__
sachemic1746083sachemic
sacheted14127833sacheted
sachets123914103sache_ts
sarees65329943sare_es
scabies11613333scabies
scales84529313sc_ales
scammed14479543scammed
scammer133611973scammer
scammers14339773scammers
scamps125014173sc_amps
scams94423973sc_am_s
scapes105122263sc_apes
scares85033003sc_ares
scarves124511623scarves
scathes124515713scathes
scenas84114703sc_enas
scends95213003sc_ends
scene77220573sc_ene_
scents85317023sc_ents
schappes1736033schappes
schavs1436493sch_avs
schedules1562953schedules
schemata1545003schemata
scheming1636633scheming
scherzi2143573scherzi
scherzo2153933scherzo
scherzos2243693scherzos
schisms1437173schisms
schists1248543schists
schizos21115423schizos
schlemiel1662803schlemiel
schlemiels1791633schlemiels
schlep1347093sch_lep
schlepps1762563schlepps
schleps1445483schleps
schlubs1443193schlubs
schlumps1742743schlumps
schmear1484043schmear
schmears1584093schmears
schmelzes2542673schmelzes
schmo124510203sch_m_o
schmoe13328333sch_moe
schmoos14347513schmoos
schnaps1443703schnaps
schnozes2244483schnozes
schools1249113schools
schorls1248353schorls
schriks16185743schriks
schrods1337433schrods
schtiks16184743schtiks
schuits1235823schuits
schuls11299853sch_uls
schuss11186733sch_uss
schusses1334213schusses
schwas14396983sch_was
sciences1238773sciences
scleras948223scleras
scoleces1237073scoleces
sconces113811453sconces
scones84521303sc_ones
scopes104719593sc_opes
scores84725923sc_ores
scouses93313243scouses
scrams105216623scram_s
scrapes116217663scrapes
screaks13469353screaks
screamed13277593screamed
screamer12267873screamer
screamers13236253screamers
screams114810613screams
scree720031703scre_e_
screed95718923scre_ed
screeds106210283screeds
screen85216013scre_en
screens95212173screens
screwed135710653screwed
screwer124410063screwer
screwers13358053screwers
screws115513883scre_ws
scribes113713203scribes
scries85226823sc_ries
scrieves13387613scrieves
scrimps13517903scrimps
scrims104615933scrim_s
scrives124414273scrives
scrums104614253scrum_s
scummed14347913scummed
scummer13398753scummer
scummers14277783scummers
scums95017423sc_um_s
scutes85219193sc_utes
scuzzes1734403scuzzes
scythes15356523scythes
secedes103711983secedes
secretes10410473secretes
seemed95117613s_eemed
seemer84418043s_eemer
seemers93814333s_eemers
seems75525023s_eem_s
sees45361053s__e_es
seme65836653s__eme_
sememe10129983sememe_
semen75724103s__emen
semens84616963s__emens
semis74623533s__emis
serenes73222903serenes
seres55448893s__eres
sesames9310743sesames
sexes126126223s__exes
shades105924533s_hades
shakes135024593s_hakes
shales94731253s_hales
shamas113717933s_hamas
shame105726703s_hame_
shamed125120213s_hamed
shammes144312833shammes
shamos114216983s_hamos
shams105829413s_ham_s
shamus114112813s_hamus
shapes115124943s_hapes
shares95236413s_hares
shaves125224933s_haves
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_he_as
sheaves134412973s_heaves
sheds96122703s_he_ds
sheen85023313s_he_en
sheens95116993s_heens
sheep105321523s_he_ep
sheer84726893s_he_er
sheers94322403s_heers
sheesh1237813s_he_esh
sheet84836953s_he_et
sheets93918493s_heets
sheeves133911953sheeves
sheiks132510013s_heiks
shekel1338383s_hekel
shekels1436043s_hekels
shells94319523s_hells
shelves134112093s_helves
shends105313773s_hends
sheols94614153s_heols
sheqel1846523s_heqel
sheqels1934753s_heqels
sherds105614723s_herds
shes75734353s_h__es
shewed134716183s_hewed
shewer124515103s_hewer
shewers134312043s_hewers
shews115924713s_he_ws
shies86136553s_h_ies
shims104422543s_him_s
shines95028913s_hines
shires95225573s_hires
shives124921413s_hives
shmoes114612093s_hmoes
shoes85429653s_h_oes
shores94830403s_hores
shotes95321893s_hotes
shoves124919413s_hoves
shutes93518213s_hutes
sickees134514213sicke_es
sidemen1037943sidemen
sieges73816833s_ieges
siemens938413s_iemens
sieves93216003s_ieves
silexes1438653silexes
sirees64624583sire_es
skees95023123s_ke_es
skenes104616633s_kenes
sleeves103311343sleeves
slieves10378963slieves
slimes84722043s_limes
sneezes16278503sneezes
sockeyes1765763sockeyes
sokemen1337053sokemen
spahees1238263spahe_es
sphene113412403sphene_
sphere113313653sphere_
sphered133512313sphered
spiremes12397623spiremes
sprees85620643spre_es
spumes1021314883s_pumes
steeves103410903steeves
steles63725663s_teles
stems75219953s_tem_s
steres63929533s_teres
stimes85920573s_times
subthemes1644113subthemes
suedes73918113s_uedes
supremes1238363supremes
swedes102711893s_wedes
sycees11409653syce_es
taxemes1635853taxemes
thebes115914493_thebes
theme105921733_theme_
themed125912583_themed
theres96525473_theres
thermes126214613_thermes
theses96517973_theses
thymes144810743_thymes
tonemes9311683tonemes
wheres125917433_wheres

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 Limit1340273736.64020184.8
3Display Results3733730.1432608.4
 (SQL Overall)1786913736.93925751.7
 
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.