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

247 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
caestus94777(None) 
cestus84412911c_estus
cactus104912232ca_ctus
caesars9410732caesars
caesium1158832caesium
caesiums1245532caesiums
caestuses1144892caestuses
cantus85117762ca_ntus
caseous9312512caseous
castes85631862ca_stes
casts77237792ca_st_s
casus76419252ca_s_us
cestas85018542c_estas
cestos84718092c_estos
chests114916262chest_s
cistus84611342c_istus
crests85218702crest_s
cuestas957932cuestas
acerous9513333acerous
acetous9410363acetous
acetum1038463ace_tum
aeneus61111143_aeneus
anestrus856313anestrus
asbestus1042953asbestus
ascus75013583_a_scus
bastes85330383ba_stes
basts75936933ba_st_s
beasts84519723beast_s
bests75932613_best_s
bestud9439303_bestud
bestuds10326753_bestuds
cabestro1243683cabestro
cabestros1343873cabestros
cabrestas1344013cabrestas
cabrestos1343883cabrestos
cachous14312583cachous
cadets96316513cadet_s
caecum1238183cae_cum
caeomas1138403caeomas
caesar8410933caes_ar
caesura956233caesura
caesuras1055733caesuras
cajeputs1942803cajeputs
calamus1139243calamus
calathus1345033calathus
calesas9411833cales_as
callous93516603callous
callus85317073ca_llus
campus125213923ca_mpus
canastas1037693canastas
cansful1236833cansful
cansos84915383cans_os
canst74932213canst__
canthus1248713canthus
cantos84826973ca_ntos
cants77036943ca_nt_s
capotes11314643capotes
capsids1239333capsids
capstan1137903capstan
capstans1257243capstans
carates95630613carates
carats85929023carat_s
caress85720263cares__s
caresses10314063caresses
carets85330773caret_s
carious93320283carious
caritas93316963caritas
carolus94612603carolus
carpus105514303ca_rpus
carses85233653cars_es
cartes86239473ca_rtes
carts78946293ca_rt_s
casas75327843ca_s_as
caseates10313713caseates
caseins93115053caseins
caserns94711223caserns
cases75048383ca_s_es
casette9310393casette
casettes1039653casettes
cashes114729883ca_shes
casitas93312043casitas
casks115720063ca_s_ks
casque17299273ca_sque
casques18278983ca_sques
cassatas1036683cassatas
cassias93514343cassias
cassis84818853ca_ssis
cast67159903ca_st__
caste75932363ca_st_e
caster85232573ca_ster
casters94729903ca_sters
castle84918963ca_stle
castles94917733ca_stles
castor84418533ca_stor
castors94919443ca_stors
catechus1544823catechus
cates75951893ca__tes
catguts1045323catguts
cats66356343ca__t_s
catsup1036433cats_up
catsups1135343catsups
caucus1039613ca_ucus
causals91411183causals
causers94014793causers
causes88026473caus_es
causeys12387223causeys
caustic1139753caustic
caustics1237483caustics
caveats1239803caveat_s
cavettos1344973cavettos
ceases84427073ceas_es
celestas1057083celestas
celestes10310013celestes
celts75325783c_elt_s
census84310303c_ensus
centas85020703c_entas
centos85920463c_entos
cents74730333c_ent_s
centu76119413c_entu_
centum104012363c_entum
centums11398783c_entums
cercus105013153c_ercus
cereus85215523c_ereus
cerous85821203c_erous
certes84623083c_ertes
cesium1039583c_esium
cesiums1136303c_esiums
cess65326053c_es__s
cesses84221363c_esses
cesta75419483c_est_a
cesti75217423c_est_i
cestoi84511953c_estoi
cestuses1038083c_estuses
cetes75731103c_e_tes
cheats114519543cheat_s
cherts115617233chert_s
chess105016923ches__s
chesses124112633chesses
chest104926143chest__
chested133811673chested
chestful1644243chestful
chestfuls1742883chestfuls
chestnut1344433chestnut
chestnuts1441933chestnuts
chesty144610503chest_y
cheths14389823che_ths
cists76624533c_ist_s
clasts84817293clast_s
cleats84919313cleat_s
clefts114610163cleft_s
coasts85719143coast_s
coesites101313093coesites
coitus8511893c_oitus
conatus9310463conatus
cosets85824403coset_s
costs77231143c_ost_s
creates95225203creates
cresols939653cresols
cress75022833cres__s
cresses94219813cresses
crest74632693crest__
crestal9312133crestal
crested103416543crested
cresyls1234753cresyls
crusts84916543crust_s
cubitus11346783cubitus
cuesta838513cuest_a
cultus85110733c_ultus
cuscus1038113c_uscus
custos84014313c_ustos
cyeses11510123cyes_es
cyesis1148573cyes_is
cysts105912773c_yst_s
diestrus946523diestrus
easts57530323ea_st_s
egests74411253egest_s
estrus61912113__estrus
fasts86429683fa_st_s
feasts95116093feast_s
fests85828043_fest_s
fetus85816543_fe_tus
fiestas1038433fiestas
foetus958523foe_tus
gaseous839503gaseous
gasts66628633ga_st_s
geests75912163geest_s
gestes75721393_gestes
gests66028813_gest_s
guests74311203guest_s
habitus12338173habitus
haets86525123hae_t_s
halitus10339963halitus
hastes95727073ha_stes
hests85829933_hest_s
jests125922453_jest_s
karsts106012943karst_s
lapsus8437273laps_us
lasts57731263la_st_s
latests73910313latest_s
leasts64616413least_s
maestoso1053203maestoso
maestri945483maestri
maestro945723maestro
maestros1046163maestros
maists85817573maist_s
manitus9310923manitus
masts77035763ma_st_s
meatus85112923_meatus
naevus934593nae_vus
nests55728003_nest_s
oasts56529183oa_st_s
oestrus7169583_oestrus
paesans93312693paesans
passus83610293pa_ssus
pastas85422873pa_stas
pastes85233913pa_stes
pastis84924323pa_stis
pasts75936503pa_st_s
pestos84719083_pestos
pests75933273_pest_s
prestos93716083prestos
prests84021263prest_s
quests153310353quest_s
rectus83314633_rectus
reests64618893reest_s
rests54935873_rest_s
rhesus936203rhes_us
samshus12125353samshus
siestas738813siestas
tarsus6310513tars_us
tastes64126423ta_stes
testes65125823_testes
testis64916713_testis
tests56530193_test_s
vasts86423773va_st_s
vatus86114643va__tus
vertus94613603_vertus
vestas95916683_vestas
vests85325983_vest_s
waists97415453waist_s
wastes96224883wa_stes
wasts87433673wa_st_s
wests85727003_west_s
wrests95313083wrest_s
xystus16354423_xystus
yeasts96413053yeast_s
zests145419743_zest_s

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272477.00019146.7
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.52923733.7
 
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.