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

205 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
celestes1031001(None) 
celestas1057081celestas
celeste949651celeste_
celeries10316312celeries
celesta947642celest_a
celestines12136892celestines
celestites12125962celestites
cerastes101111092cerastes
deletes83117932dele_tes
teleses7313122teles_es
behests1235953behest_s
blesses93812393_blesses
boletes9316063bole_tes
caestus947773c_aestus
calashes13310533calashes
calcites12313003calcites
caleches15269933caleches
calesas9411833cales_as
calottes10610083calottes
caresses10314063caresses
caseates10313713caseates
casettes1039653casettes
castes85631863c__astes
ceases84427073ce_as_es
celebrates1447673celebrates
celebs1037883cele__bs
celerities1289773celerities
celestial1146153celestial
celestials1254093celestials
celestine11147943celestine
celestite11167033celestite
celibates1358633celibates
cellists1038563cellist_s
cellmates1347513cellmates
cellules1036813cellules
celosias1048903celosias
celotex1635023cel_otex
celts75325783cel__t_s
cemented1338373cemented
cementer1239193cementer
cementers1338313cementers
cements112714223cement_s
cenotes92814543ce_notes
censes83721803ce_ns_es
centeses1079443centes_es
cerates95428253ce_rates
cereuses1049243cereuses
cerises94722253ceris_es
cerites94823433ce_rites
certes84623083c__ertes
ceruses93716233cerus_es
cerusites1146523cerusites
cesses84221363c__esses
cestas85018543c__estas
cestos84718093c__estos
cestus84412913c__estus
cetes75731103c__e_tes
cheeses123613103chees_es
chelates132713843chel_ates
chesses124112633c_hesses
chested133811673c_hested
chests114916263c_hest_s
ciliates10413453ciliates
cineastes1165563cineastes
clashes124017283c_lashes
classes94717943c_lasses
clasts84817293c_last_s
cleated103417843c_leated
cleats84919313c_leat_s
cleaves124111623c_leaves
clefted13326753c_lefted
clefts114610163c_left_s
cleomes1138813c_leomes
clepes104214623c_le_pes
cleveites1443703cleveites
closes85425593c_los_es
closets94611603c_losets
cluster94013333c_luster
clusters102912403c_lusters
clyster12317453c_lyster
clysters13227843c_lysters
coalesces1346043coalesces
coesites101313093c_oesites
coleseed1147403coleseed
coleseeds1244323coleseeds
colessee1098793colessee
colessees11146053colessees
coleuses1039723coleuses
collates103019143collates
creates95225203c_reates
creeses93914623crees_es
creeshes1336953creeshes
cresses94219813c_resses
crested103416533c_rested
crests85218703c_rest_s
cuestas957933c_uestas
culets85518513cule_t_s
culexes1636993cule_xes
culottes1076293culottes
curettes1039313curettes
cuvettes1335323cuvettes
cyeses11510123c_yes_es
delates83526283del_ates
deleaves1248063deleaves
delegates1139843delegates
delete73620703dele_te_
deleted93314913dele_ted
delisted10310563delisted
delists84414173delist_s
deluster936903deluster
delusters1035983delusters
demesnes1137083demesnes
depletes112810643deple_tes
detentes92712873detentes
detested10279623detested
detester9239683detester
detesters10298303detesters
detests83711743detest_s
devested13239133devested
devests114410473devest_s
egested938123_egested
egests74411253_egest_s
elates65032363_el_ates
elected102812613_elected
electee92513243_electee
electees10238723_electees
elects83315003_elect_s
elegies81312903_elegies
elevates111110423_elevates
elites66027123_el_ites
eluates72014683_eluates
elutes64020313_el_utes
emeses86114963_emes_es
emeutes938013_emeutes
fellates11312753fellates
felsites1138073felsites
fleshes133913273_fleshes
galettes93111153galettes
geests75912163ge_est_s
gelates83219583gel_ates
gelees74116263gele__es
geneses82613523genes_es
genettes938303genettes
gestes75721393__gestes
heresies11312693heresies
iceless9219963iceles__s
idlesses936003idlesses
keester11319913ke_ester
keesters12319593ke_esters
leses54930813__les_es
maleates103316343maleates
melees83618083mele__es
molested11178243molested
molester1099373molester
molesters1198873molesters
molests93311563molest_s
nemeses948663nemes_es
oleates7417833_oleates
omelettes1144743omelettes
palettes103112833palettes
pelisses1048483pelisses
pelites93821993pel_ites
recesses10312323recesses
reested82916233re_ested
reests64618893re_est_s
relates73731433rel_ates
releases8313343releases
relegates10310943relegates
relented92614943relented
relents74018503relent_s
relets64025673rele_t_s
reletter81311023reletter
reletters9138783reletters
releves103914973rele_ves
relishes11311953relishes
relisted9312623relisted
relists73817053relist_s
renested92212953renested
renests74014213renest_s
repletes102812473reple_tes
retastes82212903retastes
retested92212533retested
retests73813853retest_s
revested122612243revested
revests104413733revest_s
selected1159783selected
selectee10910493selectee
selectees1147013selectees
selects91912143select_s
selenates91611363selenates
selenites91312093selenites
semester1038903semester
semesters1139123semesters
teleosts846423teleost_s
telesis7310793teles_is
telestic10118953telestic
telestics1196963telestics
telexes1438353tele_xes
testes65125823__testes
vedettes1265943vedettes
velites103417303vel_ites
veloutes1136153veloutes
verstes104014283ve_rstes
wellsites1244673wellsites
welshes13379093wel_shes

Search took 8 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.406440125.6
2DLD Change Limit1461622057.29620033.2
3Display Results2052050.0932204.3
 (SQL Overall)1786912057.79522923.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.