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

345 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
cerastes10111109(None) 
cerates95428231cera_tes
aerates74627482aera_tes
berates94126852bera_tes
carates95630602cara_tes
castes85631862c__astes
ceases84427072ce_as_es
celestes10310012celestes
cerate84829462cera_te_
cerated103922472cera_ted
cerises94722252ceris_es
cerites94823432cer_ites
certes84623082cer__tes
ceruses93716232cerus_es
cerusites1146522cerusites
crases85532312c_ras_es
crashes124618402c_rashes
crates85736052c_ra_tes
creases94020962creas_es
creates95225172crea_tes
curates95323822cura_tes
derates84028882dera_tes
erases64425402_eras_es
retastes82212902retastes
verstes104014272ver_stes
acerate92818913acera_te_
acerated113113983acera_ted
acerbates1347253acerbates
acetates102013063aceta_tes
acierates11310793aciera_tes
aerate64830553aera_te_
aerated85322373aera_ted
arrases71214543arras_es
bastes85330383__bastes
beasties102514653be_asties
beasts84519723be_ast_s
berakes134815773bera_kes
berate84729023bera_te_
berated104422133bera_ted
borates94823013bora_tes
brashes124518463_brashes
brasses93818353_brasses
breasted1138823breasted
breasts939703breast_s
cadaster1136893cadaster
cadasters1236813cadasters
cadastres1244533cadastres
calashes13310533calashes
camases114216343camas_es
camasses12388973camasses
canastas1037693canastas
carafes125015703cara_fes
carate84734003cara_te_
carats85929023cara_t_s
carcases12313083carcas_es
carcasses1337473carcasses
caresses10314063caresses
carses85233653car_s_es
cartes86239473c__artes
carwashes1745773carwashes
cases75048383c__as_es
cashes114729883c__ashes
caste75932363c__aste_
caster85232573c__aster
casters94729893c__asters
castles94917733c__astles
casts77237793c__ast_s
cates75951873c__a_tes
cease75227653ce_as_e_
ceased94920783ce_as_ed
celestas1057083celestas
celeste949653celeste_
cenacles1238023cenacles
cenotes92814543ce_notes
censes83721803ce_ns_es
ceramals1246513ceramals
ceramics1446793ceramics
ceramides1447433ceramides
ceramists1346713ceramist_s
ceratin93020163cera_tin
ceratins102818723ceratins
cercises12410933cercises
ceres75540013cer___es
cereuses1049243cereuses
cerise84822043ceris_e_
cerite84724873cer_ite_
cermets1139713cermet_s
ceruse83914523cerus_e_
cerusite1047763cerusite_
cerussites1243183cerussites
cervices1537133cervices
cervixes2054603cervixes
cesses84221363ce__sses
cestas85018543ce__stas
cestos84718093ce__stos
cestus84412913ce__stus
cetanes9315133ceta_nes
cetes75731103ce___tes
charases131312753charas_es
chases115128233c_has_es
chasses124017503c_hasses
chaste114617393c_haste_
chasten124312403c_hasten
chastens13429183c_hastens
chaster124718503c_haster
chastest1349703c_hastest
chelates132713833chela_tes
cherishes1767563cherishes
christen13106703christen
christens14125413christens
christies1449263christies
cineastes1165553cineastes
citrates102315073citra_tes
clashes124017283c_lashes
classes94717943c_lasses
clasts84817293c_last_s
clerisies1147253clerisies
coasted104015943c_oasted
coaster94219033c_oaster
coasters104317303c_oasters
coasts85719133c_oast_s
comates114123633coma_tes
coracles121811163coracles
corantoes1147653corantoes
corantos10310103corantos
cordites11314603cordites
corpses113913803corps_es
corsages11310363corsages
corses84433463cor_s_es
corsets94819803cor_sets
courantes1148883courantes
cradles103114133c_radles
crafted13419773c_rafted
crafter124111333c_rafter
crafters13419943c_rafters
crafts115312743c_raft_s
crakes124921813c_ra_kes
crambes1339953c_rambes
cranes84330753c_ra_nes
crapes104727693c_ra_pes
crashed134214203c_rashed
crasher124616153c_rasher
crashers134013223c_rashers
crasis85020473c_ras_is
crass76328043c_ras__s
crasser94114333c_rasser
crassest103411523c_rassest
crate76537403c_ra_te_
crated94827773c_ra_ted
crater85026633c_ra_ter
craters95021883c_ra_ters
craves115825393c_ra_ves
crazes174720133c_ra_zes
crazies183413853c_razies
crease85519573creas_e_
creased104315583creas_ed
creaser94415723creas_er
creasers103612813creasers
creasier103210193creasier
creasiest11229943creasiest
create85126373crea_te_
created104323443crea_ted
creeses93914623crees_es
creeshes1336953creeshes
cremates124215983cremates
creosotes1145653creosotes
cresses94219813c_resses
cressets10309103cressets
crested103416533c_rested
crests85218703c_rest_s
crevasses1444133crevasses
crises84529433c_ris_es
crosses94220793c_rosses
croutes94815643c_routes
cruses88127713c_rus_es
crusets93811043c_rusets
crushes124215133c_rushes
crusted103712753c_rusted
crusts84916543c_rust_s
cuirasses1144373cuirasses
curacies12311763curacies
curares94916853cura_res
curate85226243cura_te_
curated104717583cura_ted
curettes1039313curettes
curites93919863cur_ites
curses85328273cur_s_es
curtsies1038733curtsies
cycases1437533cycas_es
cytaster1383863cytaster
cytasters1483643cytasters
deashes113313903de_ashes
debases103814133debas_es
debates103718523deba_tes
degases93413103degas_es
degasses10278363degasses
delates83526283dela_tes
demasted1238763demasted
demasts1089223demast_s
deranges1039973deranges
derate74531233dera_te_
derated93623503dera_ted
derats74625063dera_t_s
deratted1048403deratted
eases56041613_e_as_es
easies64126633_e_asies
easter65027983_e_aster
easters75125683_e_asters
easts57530323_e_ast_s
ecartes94212563_ecartes
ectases92911673ectas_es
elates65032363_ela_tes
enates64026423_ena_tes
erase54925493_eras_e_
erased74816753_eras_ed
eraser64216333_eras_er
erasers74413943_erasers
erasures837203_erasures
ergates8314473_ergates
eroses65327053_eros_es
ersatzes1743063_ersatzes
erses55826803_er_s_es
eyases94513683_eyas_es
eyasses10388023_eyasses
feases95422923fe_as_es
feasted11310843fe_asted
feaster10812983fe_aster
feasters11511563fe_asters
feasts95116093fe_ast_s
ferrates113013403ferrates
ferrites112312823ferrites
frasses104314513_frasses
gelates83219583gela_tes
gestes75721393ge__stes
grasses84117343_grasses
grates75429883_gra_tes
greases84816713greas_es
gyrases11368313gyras_es
gyrates113610263gyra_tes
harasses11311033harasses
hastes95727073__hastes
hearses104414533hears_es
heresies11312693heresies
horstes104516113hor_stes
impastes12238193impastes
iterates81317813itera_tes
karates115617473kara_tes
kernites1269113kernites
lacerates112413763lacera_tes
leases65428113le_as_es
leashes103514403le_ashes
leasts64616413le_ast_s
legates82917673lega_tes
macerates132113563macera_tes
measles92412753me_asles
megasses11307743megasses
merises93421423meris_es
meristem1245743meristem
meristems1343553meristems
metates92720003meta_tes
morasses1038903morasses
negates83215833nega_tes
oersted839553oer_sted
oersteds934373oer_steds
operates10515403opera_tes
orates64328613_ora_tes
parasites11313153parasites
pastes85233913__pastes
peases85229473pe_as_es
penates93321593pena_tes
perishes13313753perishes
perlites10316353perlites
permutes1238713permutes
perses85428063per_s_es
peruses94018163perus_es
phrases12711463phras_es
pirates93020323pira_tes
prases84429023_pras_es
prates84633163_pra_tes
prepastes13128823prepastes
pretastes11119423pretastes
rases55447213__ras_es
rashes95330153__rashes
raster64731443__raster
rasters74629023__rasters
rates55352013__ra_tes
rebates95123173reba_tes
recasts93413533recast_s
recrates102420353recra_tes
redates83423863reda_tes
refasten1136103refasten
refastens1244753refastens
regrates92618373regra_tes
rehashes1436953rehashes
relates73731423rela_tes
remaster10311473remaster
remasters11310583remasters
remates93827103rema_tes
repasses101810373repasses
repasted112611533repasted
repasts93611933repast_s
reraises8415633reraises
rerises73525883reris_es
reroutes8312223reroutes
retaste72313133retaste_
retasted92412113retasted
rewashes1447033rewashes
sedates83418033seda_tes
senates73322583sena_tes
sensates8511133sensates
serapes95218103sera_pes
seriates82620663seriates
serrates82617003serrates
strasses81311433strasses
tastes64126423__tastes
teases65426273te_as_es
terabytes1443323terabytes
tergites9310543tergites
termites10313693termites
terrases82111453terras_es
testes65125823te__stes
texases1437573texas_es
thrashes1487653thrashes
trashes104119253_trashes
trasses74819323_trasses
trystes10419993_trystes
ulcerates1148843ulcera_tes
uprates93814863upra_tes
urases63723563_uras_es
urates65027763_ura_tes
ureases74416723ureas_es
verists103613673verist_s
verites103822253ver_ites
verses94223763ver_s_es
versets103913093ver_sets
verste94515633ver_ste_
versts93914733ver_st_s
wastes96224883__wastes
wrasses103812593_wrasses
wrastles11328933_wrastles
xeroses143612823xeros_es
xeruses143010753xerus_es
yeasted1138503ye_asted
yeasts96413053ye_ast_s
zebrasses2043513zebrasses

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623458.12617987.0
3Display Results3453450.1402464.3
 (SQL Overall)1786913458.43921174.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.