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 “celestas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
celestas105708(None) 
celesta947641celesta_
celestes10310011celestes
calesas9411832cales_as
celeste949652celest_e
celestial1146152celestial
celestials1254092celestials
celosias1048902celosias
cestas85018542c__estas
cuestas957932c_uestas
behests1235953behest_s
berettas1046733berettas
cabrestas1344013cabrestas
caestus947773c_aestus
calesa8412473cales_a_
canastas1037693canastas
celebs1037883cele__bs
celeriac1246163celeriac
celeriacs1344113celeriacs
celeries10316313celeries
celestine11147943celestine
celestines12136893celestines
celestite11167033celestite
celestites12125963celestites
cellists1038563cellist_s
celosia939463celosia_
celts75325783cel__t_s
cementa112810543cementa_
cements112714223cement_s
centas85020703c__entas
cerastes101111093cerastes
cesta75419483c__esta_
cestos84718093c__estos
cestus84412913c__estus
chests114916263c_hest_s
clasts84817293c_last_s
cleats84919313c_leat_s
clefts114610163c_left_s
coelostat1145673coelostat
coelostats1253583coelostats
coleslaw1343643coleslaw
coleslaws1442793coleslaws
crestal9312133c_restal
crests85218703c_rest_s
cuesta838513c_uesta_
culets85518513cule_t_s
deletes83117933dele_tes
delists84414173delist_s
deltas74414823del__tas
detests83711743detest_s
devests114410473devest_s
egesta7428653_egesta_
egests74411253_egest_s
elastase845643_elastase
elects83315003_elect_s
fiestas1038433_fiestas
geests75912163ge_est_s
iceless9219963iceles__s
melenas999203mele_nas
melismas1245713melismas
molests93311563molest_s
muletas937383mule_tas
nepetas935943nepe_tas
olestras846583_olestras
palestras1145723palestras
pedestal1146403pedestal
pedestals1255203pedestals
pelotas9410723pel_otas
pesetas938753pese_tas
podestas1146853podestas
polentas1038753polentas
polestar1047113polestar
polestars1157283polestars
reests64618893re_est_s
relents74018503relent_s
relets64025673rele_t_s
relists73817053relist_s
renests74014213renest_s
retests73813853retest_s
revests104413733revest_s
selects91912143select_s
siestas738813_siestas
silesias848523silesias
telegas837443tele_gas
teleosts846423teleost_s
teleses7313123teles_es
telesis7310793teles_is
telestic10118953telestic
telestics1196963telestics
vestas95916683__vestas

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 Limit146162907.03020791.2
3Display Results90900.0332727.3
 (SQL Overall)178691907.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.