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

155 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
celesta94764(None) 
celestas1057081celestas
celeste949651celeste
calesa8412472cales_a
celestes10310012celestes
celestial1146152celestial
celosia939462celosia
cementa112810542cementa
cesta75419482c__esta
cuesta838512c_uesta
egesta7428652_egesta
ablest84721833ablest_
behest11314613behest_
behests1235953behests
beretta938463beretta
blest76431723_blest_
cabresta1243993cabresta
calesas9411833calesas
calmest11312343calmest_
canasta938363canasta
cedes84927333cedes__
cees65941593ce_es__
celeb9314873cele__b
celebs1037883cele_bs
celeriac1246163celeriac
celerity1347643celerity
celery1139623cele_ry
celestials1254093celestials
celestine11147943celestine
celestite11167033celestite
cella75420313cel__la
cellist9314423cellist_
cellists1038563cellists
cells75428063cells__
celomata1296633celomata
celosias1048903celosias
cels65534973cel_s__
celt65646713cel__t_
celts75325783cel__ts
cement103321673cement_
cements112714223cements
cepes94424463cepes__
cerebra1155933cerebra
ceres75540013ceres__
cestas85018543c__estas
cesti75217423c__esti
cetes75731103cetes__
chaeta11310683chae_ta
chest104926143c_hest_
chests114916263c_hests
chesty144610503c_hesty
clast76030583c_last_
clasts84817293c_lasts
cleat76335063c_leat_
cleats84919313c_leats
cleft106222853c_left_
clefts114610163c_lefts
clept95725773c_lept_
coelostat1145673coelostat
coldest102514763coldest_
coles76055063coles__
coleslaw1343643coleslaw
coolest9318643coolest_
costa75523733c__osta
coyest11316053coyest_
crest74632693c_rest_
crestal9312133c_restal
crests85218703c_rests
crista8311803c_rista
cruelest1059183cruelest_
cuestas957933c_uestas
culet76040343cule_t_
culets85518513cule_ts
cutest85820143cutest_
dejecta17376363dejecta
deles65139253deles__
delete73620703dele_te
delist74625053delist_
delists84414173delists
delta66117773del__ta
detest74122843detest_
detests83711743detests
devest104418703devest_
devests114410473devests
ecclesia1244103ecclesia
eeliest73516473eeliest_
egest65222343_egest_
egests74411253_egests
ejecta15337393_ejecta
eldest72912683_eldest_
elect74327033_elect_
elects83315003_elects
fellest10313753fellest_
fenestra1143553fenestra
fewest12311663fewest_
feyest12311403feyest_
fiesta938123_fiesta
geest64829623ge_est_
geests75912163ge_ests
halest94823273halest_
iceless9219963iceles_s
idlest74014863idlest_
illest63615723illest_
ingesta8357863ingesta
lepta75714393__lepta
lest46956323__lest_
melena81110473mele_na
melisma1146473melisma
merest84725113merest_
molest85022743molest_
molests93311563molests
muleta839233mule_ta
nepeta837893nepe_ta
newest9314213newest_
olestra746173_olestra
palest83926223palest_
palestra1045893palestra
pedestal1146403pedestal
peles75738083peles__
pelota8612833pel_ota
peseta8310573pese_ta
podesta1036763podesta
polenta9310093polenta
polestar1047113polestar
realest73322433realest_
reest54938093re_est_
reests64618893re_ests
relent64431853relent_
relents74018503relents
relet54749823rele_t_
relets64025673rele_ts
relist64628413relist_
relists73817053relists
renest64529713renest_
renests74014213renests
retest64028453retest_
retests73813853retests
revest94623603revest_
revests104413733revests
select82621173select_
selects91912143selects
serest64831613serest_
siesta639503_siesta
silesia739083silesia
telega736773tele_ga
teleost7410523teleost_
teleosts846423teleosts
teles54536003teles__
teleses7313123teleses
telesis7310793telesis
telestic10118953telestic
testa54822043__testa
vesta86618303__vesta
vilest9416843vilest_
weest85026773we_est_

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.453394461.4
2DLD Change Limit1340271556.40620922.1
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.90525878.5
 
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.