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

381 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
casitas9331204(None) 
caritas93316961caritas
casita82913701casita_
agitas7310592_agitas
camisas113411922camisas
capias10318352capi_as
capita102913772capita_
capital112311522capital
capitals12209452capitals
carinas93622412carinas
casabas1139982casabas
casas75327842cas__as
casavas1237822casavas
casings104013512casings
casinos93512832casinos
cassatas1036682cassatas
cassias93514342cassias
cassinas103610642cassinas
castes85631862cas_tes
casts77237792cas_t_s
cestas85018542ces_tas
fajitas1734252fajitas
pastas85422872pas_tas
raitas64417672ra_itas
abasias9711013abasi_as
acacias11510403acaci_as
acrasias1048893acrasi_as
adits66523713_adit_s
agita6315423_agita_
aits46355533_a_it_s
ajivas1655133_ajivas
alias55834603_ali_as
aliyas93911803_aliyas
amanitas1048533amanitas
amias75831473_ami_as
amigas95912173_amigas
amritas939093amritas
animas84418723_animas
antas55432033_a_ntas
aortas65417783_aortas
arias55438023_ari_as
aristas7413523_aristas
asanas6514113_asanas
ascites9312603_ascites
asides75118873_asides
axites134913833_axites
baits76630583ba_it_s
baizas173810823ba_izas
balatas9311833balatas
baristas1039723baristas
barites94322333barites
barytas12378283barytas
basics104915123basi_cs
basilar937303basilar
basils85717473basi_ls
basinal9310033basinal
basins85722763basi_ns
basions94213953basions
basis75429863basi__s
bastes85330383bas_tes
basts75936933bas_t_s
bonitas939453bonitas
cabalas113516003cabalas
cabanas112413033cabanas
cabins104418923cabi_ns
cacas95627983ca__cas
cactus104912233ca_ctus
cadets96316513cadet_s
cadis84428503cadi__s
caeomas1138403caeomas
caesiums1245533caesiums
caestus947773caestus
caesuras1055733caesuras
caftan111710123ca_ftan
caftans12179443ca_ftans
cahiers123510673cahiers
caids85226423ca_i_ds
caiman103615663ca_iman
caimans113811783ca_imans
cains75334303ca_i_ns
cairds96411513ca_irds
cairns85313303ca_irns
calcites12313003calcites
calesas9411833calesas
calices114321693calices
calicos113913493calicos
califs114915893cali_fs
calipash1543233calipash
caliphs1436753caliphs
callas84526753ca_llas
camas96333523ca__mas
cameras11313363cameras
camions113916133camions
camisa103114323camisa_
camises114218463camises
camisias12268603camisias
campsites1546473campsites
canastas1037693canastas
canchas143212403canchas
candidas12338653candidas
canids95118133cani_ds
canines93724033canines
canities101519263canities
cannas84518403ca_nnas
canolas9313993canolas
cantal84122033ca_ntal
cantals93919573ca_ntals
cantatas103410093cantatas
cantinas102713783cantinas
cantos84826973ca_ntos
cants77036943ca_nt_s
cantus85117763ca_ntus
canulas9312853canulas
canvas113813333ca_nvas
capitate121712183capitate
capitol11258283capitol
capitols12247333capitols
capizes20410373capizes
capotes11314643capotes
capsidal1345623capsidal
capsids1239333capsi_ds
capsizes2147203capsizes
capstan1137903capstan
capstans1257243capstans
captan101613343ca_ptan
captans111612053ca_ptans
carates95630613carates
carats85929023carat_s
cardias10715123cardias
carditis11310233carditis
carets85330773caret_s
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carina84325333carina_
carinae94318593carinae
carinal94318243carinal
cariocas1239663cariocas
carious93320283carious
caritases1139763caritases
cartes86239473ca_rtes
carts78946293ca_rt_s
casa65630863cas__a_
casaba1079263casaba_
casava1157873casava_
casbah1337903cas_bah
casbahs1436463casbahs
cascaras1237703cascaras
casease939323cas_ease
caseate9314783caseate
caseates10313713caseates
caseins93115053caseins
caseous9312513caseous
caserns94711223caserns
cases75048383cas__es
casette9310393casette
casettes1039653casettes
cashaw14439793cas_haw
cashaws15398573cashaws
cashes114729883cas_hes
cashews15428603cashews
cashiers13318883cashiers
cashoos12310793cashoos
casing94829103casi_ng
casini84615863casi_ni
casino84317553casi_no
caskets133910173caskets
casks115720063cas__ks
casques18278983casques
cassabas1245733cassabas
cassata938143cassata
cassavas1344803cassavas
cassenas10317483cassenas
cassia83714763cassia_
cassina94113163cassina_
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cas_sis
cassises103811743cassises
cast67159903cas_t__
caste75932363cas_t_e
caster85232573cas_ter
casters94729903casters
casting104628343casting
castings113614053castings
castle84918963cas_tle
castles94917733castles
castor84418533cas_tor
castors94919443castors
casual81112863cas_ual
casuals91410533casuals
casuists1036523casuists
casus76419253cas__us
catenas9313113catenas
cates75951893ca__tes
cations94524143cations
cats66356343ca__t_s
catsuits1045433catsuit_s
catties94023053catties
caustics1237483caustics
caveats1239803caveats
caviar11310163cavi_ar
caviars1238623caviars
cavies114525003cavi_es
cavils114014393cavi_ls
cavings134712543cavings
cavitary1664963cavitary
cavitate13159833cavitate
cavitates14168963cavitates
cavities131412613cavities
cavity14310013cavit_y
ceibas1038503c_eibas
centas85020703c_entas
cerias83321983ceri_as
cerites94823433cerites
cesiums1136303cesiums
cesta75419483ces_ta_
cestos84718093ces_tos
cestus84412913ces_tus
cesuras958693cesuras
chamisas15317813chamisas
chasings14318253chasings
chias104625523c_hi_as
chicas135916473c_hicas
chinas115119403c_hinas
chital114313883c_hital
chits105424573c_hit_s
cists76624533cis_t_s
cistus84611343cis_tus
cites74435593c__ites
clastics122811413clastics
clasts84817293clas_t_s
coastal9411043coas_tal
coasts85719143coas_t_s
cobias104014993cobi_as
coesites101313093coesites
cogitos1037613cogitos
coital84117053c_oital
coitus8511893c_oitus
colitis92617353colitis
cosets85824403coset_s
cosies84932163cosi_es
cosigns1047513cosigns
cosines94122673cosines
costa75523733cos_ta_
costae85319683cos_tae
costal85419513cos_tal
costar85518613cos_tar
costars94218013cos_tars
costs77231143cos_t_s
cottas84615573c_ottas
coxitis16238463coxitis
crasis85020473crasi__s
crista8311803crista_
cristae9310613cristae
crits75527573c_rit_s
cubital1137103cubital
cubits103714033cubit_s
cubitus11346783cubitus
cuestas957933cuestas
curites93919863curites
cushats12288273cushats
custos84014313cus_tos
cyanites132610163cyanites
cystitis1345713cystitis
cysts105912773cys_t_s
czarinas1935303czarinas
czaritzas1991643czaritzas
dacites101114593dacites
davits104012363davit_s
ditas65923673__ditas
easies64126633easi_es
easts57530323eas_t_s
facias113415803faci_as
faiths124610273fa_iths
fajita1635923fajita_
farinas103215243farinas
fascias1258413fascias
fascitis1346013fascitis
fasts86429683fas_t_s
gaits65726013ga_it_s
gasts66628633gas_t_s
granitas92610223granitas
gravitas12316013gravitas
habitan1236903habitan
habitans1346623habitans
habitat12411053habitat
habitats1346733habitats
habits113014653habit_s
habitus12338173habitus
hadiths1436023hadiths
halites103221193halites
halitus10339963halitus
hastes95727073has_tes
hostas94515833hos_tas
jarinas143712193jarinas
kashas133311903kas_has
katas95922093ka__tas
lamias85020613lami_as
laminas93615873laminas
lanital7310913lanital
lanitals837723lanitals
lariats7615053lariats
lasts57731263las_t_s
latinas74416463latinas
litas54923773__litas
mafias113913573mafi_as
maists85817573maist_s
manias84029033mani_as
manilas93915873manilas
manitos9314053manitos
manitus9310923manitus
mantas85725363ma_ntas
marinas93519393marinas
marital92314183marital
masalas9312063masalas
masas75630413mas__as
massas85116463mas_sas
mastics112614783mastics
mastitis1039113mastitis
masts77035763mas_t_s
nairas6312783na_iras
nasial6413283nasi_al
nasions73112383nasions
nasties73520493nasties
oasis56422553oasi__s
oasts56529183oas_t_s
ocarinas1036733ocarinas
paisas84317493pa_isas
partitas10310253partitas
pashas115117063pas_has
pasta76624533pas_ta_
pastes85233913pas_tes
pasties94529813pasties
pastils94416173pastils
pastinas103712153pastinas
pastis84924323pas_tis
pasts75936503pas_t_s
patinas96318523patinas
pesetas938753pesetas
pitas77427673__pitas
posits85718713posit_s
raias54631123ra_i_as
raita54623073ra_ita_
ratites74920683ratites
resites74027793resites
resits64725563resit_s
saigas74114293sa_igas
salinas73116093salinas
salivas10309603salivas
samites93118713samites
sapotas939613sapotas
sasins64923103sasi_ns
sikas94617023__sikas
simas75727553__simas
sitar54820543__sitar
sitars65417593__sitars
sites56045433__sites
sits45050203__sit_s
situs55019233__situs
tafias93111963tafi_as
taigas73712573ta_igas
tarsias74013373tarsi_as
tastes64126423tas_tes
taxites1449673taxites
vaginas11298813vaginas
valutas1036533valutas
varias95019903vari_as
vasts86423773vas_t_s
veritas103012753veritas
vestas95916683ves_tas
visits9311423visit_s
vistas94513273vis_tas
waists97415453waist_s
waits88333523wa_it_s
wapitis1236473wapitis
wastes96224883was_tes
wasts87433673was_t_s
yautias1046333yautias
zamias174212923zami_as
zaribas1836043zaribas

Search took 9 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.406440125.6
2DLD Change Limit1340273817.70317399.3
3Display Results3813810.1402721.4
 (SQL Overall)1786913818.24921662.1
 
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.