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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

206 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
caste7593236(None) 
baste74829981baste
carte75940421carte
case65848081cas_e
cast67159901cast_
caster85232571caster
castes85631861castes
castle84918961castle
casts77237791casts
cate66254601ca_te
chaste114617391chaste
haste85927861haste
paste74932951paste
taste55127231taste
waste86125051waste
acute74720362acute
ante46538902_ante
aster55434892_aster
ate37059242_a_te
base64847022bas_e
bast66362412bast_
basted95227232basted
baster85333592baster
bastes85330382bastes
basts75936932basts
bate66552422ba_te
cable95329912cable
cache125122482cache
cacti9318642cacti
cade76443912ca_de
cadet85339342cadet
cadge94018792cadge
cadre85419022cadre
cafe95230322ca_fe
cage75339062ca_ge
cake105439962ca_ke
calve105919922calve
came87648752ca_me
cane66653122ca_ne
canoe75627252canoe
canst74932212canst_
cant66362032cant_
canted94825782canted
canter85230112canter
cantle84522152cantle
canto74931012canto
cants77036942cants
canty105226802canty
cape87242782ca_pe
capote10315732capote
carate84734002carate
care66968372ca_re
caret75360562caret
carle74535702carle
carse74934332carse
cart66570342cart_
carted98631442carted
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carts78946292carts
carve106227752carve
casa65630862cas_a
casas75327842casas
caseate9314782caseate
cased86032412cased
cases75048382cases
casette9310392casette
cash96636282cas_h
cashed125124352cashed
cashes114729882cashes
cashew144311452cashew
casita82913702casita
cask105626432cas_k
casked134815512casked
casket124820992casket
casks115720062casks
casky144512682casky
casque17299272casque
casters94729902casters
castled104311512castled
castles94917732castles
castor84418532castor
casus76419252casus
cat58282342ca_t_
cater74840722ca_ter
cates75951892ca_tes
cats66356342ca_ts
catted95422472catted
cattie85221022cattie
cattle85118902cattle
catty104520412catty
cause75225352cause
cave95941262ca_ve
cavie104621592cavie
cease75227652ceas_e
cesta75419482cesta
cesti75217422cesti
cete64934782c_ete
chase105127122chas_e
chasse115114602chasse
chasten124312402chasten
chaster124718502chaster
chute104316462chute
cist67244962cist_
cisted95217522cisted
cists76624532cists
cite65640342c_ite
clast76030582clast_
clasts84817292clasts
coast75236272coast_
coasted104015952coasted
coaster94219042coaster
coasts85719142coasts
comte96125472comte
conte76633202conte
coset75748842coset
cosie74728262cosie
cost68057942cost_
costa75523732costa
costae85319682costae
costed95623112costed
coster84331292coster
costs77231142costs
cote66648732c_ote
crate76537402crate
cute66440452c_ute
cyst96322812cyst_
cysts105912772cysts
date56443322da_te
ease45042332eas_e
east46659102east_
easter65027982easter
easts57530322easts
ecarte84313502ecarte
fast77052312fast_
fasted105320952fasted
fasten95114892fasten
faster94625772faster
fasts86429682fasts
fate75444282fa_te
gast56052562gast_
gasted84821582gasted
gaster75027352gaster
gasts66628632gasts
gate55746572ga_te
geste65920692geste
hast76259482hast_
hasted105125282hasted
hasten95718562hasten
hastes95727072hastes
hasty115718762hasty
hate78450172ha_te
haute89521612haute
lase46148512las_e
last46260322last_
lasted74323602lasted
laster64830632laster
lasts57731262lasts
late47560482la_te
latte55426302latte
masse75125292masse
mast65959962mast_
masted94025802masted
master84831342master
masts77035762masts
mate65154222ma_te
matte75626842matte
moste75925082moste
nasty85717282nasty
oast47156322oast_
oasts56529182oasts
pase65346862pas_e
passe75525692passe
past65959012past_
pasta76624532pasta
pasted94426902pasted
pastel85918712pastel
paster85734372paster
pastes85233912pastes
pastie85525522pastie
pasts75936502pasts
pasty105725052pasty
pate65350462pa_te
piste75824602piste
rase46149982ras_e
raster64731442raster
rate45458762ra_te
sate45556102sa_te
saute55028082saute
tasse54821842tasse
tasted74123972tasted
taster64930572taster
tastes64126422tastes
tasty84820312tasty
tate44748602ta_te
vase75629652vas_e
vast75045122vast_
vaster94521022vaster
vasts86423772vasts
vasty116215922vasty
wast75655852wast_
wasted104423022wasted
waster95228942waster
wastes96224882wastes
wasts87433672wasts

Search took 3 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 Filter178691538000.610292936.1
2DLD Change Limit538002061.81029723.8
3Display Results2062060.0464478.3
 (SQL Overall)1786912062.46672461.9
 
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.