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

224 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
casava115787(None) 
casaba1079261casaba
casavas1237821casavas
cassava1255001cassava
asana5315482_asana
cabala103516912cabala
cabana103913562cabana
caravan1239232caravan
casa65630862cas__a
casabas1139982casabas
casas75327842casa_s
cascara1138312cascara
casita82913702casita
cassaba1145662cassaba
cassata938142cassata
cassavas1344802cassavas
cassia83714762cassia
masala8311812masala
piasava1243882piasava
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
agama85815583_agama
agave95314033_agave
ajiva1586803_ajiva
asanas6514113_asanas
asea46327183_as_ea
asrama839193_asrama
asyla839333_asyla
ava610139323___ava
baklava1643103baklava
balata8614673balata
banana83213413banana
basal75722283basa_l
basalt83519583basalt
brava106414793_brava
cabal95222153caba_l
cabalas113516003cabalas
cabals104020153cabals
cabanas112413033cabanas
cabbala1367183cabbala
caca85528083c__aca
cacao95420003caca_o
cacaos104616183cacaos
cacas95627983caca_s
cadaver1335793cadaver
caeca93915133ca_eca
caeoma1039033caeoma
caesar8410933caesa_r
caesars9410733caesars
caesura956233caesura
calamar1149293calamar
calami10313423calami
calash11312433calash
calesa8412473calesa
calisaya1342623calisaya
calla74827073ca_lla
calve105919923ca_lve
camail10314833camail
camas96333523cama_s
camass104114183camass
cambia124913153cambia
camera10313693camera
camisa103114323camisa
canal75428043cana_l
canals84421663canals
canape10913513canape
canard9314763canard
canary11314693canary
canasta938363canasta
cancha134411613cancha
canna75919333ca_nna
canola8313623canola
cantala94114673cantala
cantata93811813cantata
canula8312963canula
canvas113813333canvas
capita102913773capita
carabao1139673carabao
caracal11312513caracal
carack142113173carack
carafe115416163carafe
caramba1336893caramba
carapax1835793carapax
carat75048793cara_t
carate84734003carate
carats85929023carats
caravans1338623caravans
caravel1238213caravel
caraway1538133caraway
cardia9916373cardia
carina84325323carina
carve106227753ca_rve
casbah1337903casbah
casbahs1436463casbahs
cascade12118603cascade
cascaras1237703cascaras
case65848083cas__e
casease939323casease
caseate9314783caseate
cased86032413cas_ed
casefy1436273casefy
caseic103212373caseic
casein83216453casein
casern84713313casern
cases75048383cas_es
cash96636283cas__h
cashaw14439793cashaw
cashaws15398573cashaws
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
cashoo11312253cashoo
casing94829103casing
casini84615863casini
casino84317553casino
casitas93312043casitas
cask105626433cas__k
casked134815513casked
casket124820993casket
casks115720063cas_ks
casky144512683cas_ky
casque17299273casque
cassabas1245733cassabas
cassatas1036683cassatas
cassena9287843cassena
cassias93514343cassias
cassina94113163cassina
cassis84818853cassis
cast67159903cas__t
castaway1664573castaway
caste75932363cas_te
caster85232573caster
castes85631863castes
castle84918963castle
castor84418533castor
casts77237793cas_ts
casual81112863casual
casuals91410523casuals
casus76419253cas_us
catalo8314853catalo
catalpa1136503catalpa
catawba1443703catawba
catena8312483catena
causal81413203causa_l
causals91411183causals
cavalla1257883cavalla
cave95941263c__ave
cavy125920003c__avy
cesta75419483ces_ta
cesura838763cesura
chalaza2145733chalaza
choana1138443choana
cicada1136413cicada
cicala10310053cicala
clave105420153c_lave
clavi104912923c_lavi
cleave114212513cleave
cloaca1037263cloaca
coala77521123c_oala
costa75523733cos_ta
cravat11314443c_ravat
crave105626313c_rave
curara83712203curara
fascia1148703fascia
fava106820263__fava
guava938583_guava
halala94715093halala
halavah16447023halavah
halva115414433ha_lva
hamada1239923hamada
hawala12368913hawala
jacana1537933jacana
java147316643__java
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kamala12339963kamala
kanaka9357523kanaka
kasha124710723kas_ha
kava115819703__kava
labara83712893labara
larva8312483la_rva
lasagna843543lasagna
lava76725423__lava
manana84816073manana
maraca10314153maraca
marsala939583marsala
masa65034723mas__a
masalas9312053masalas
masas75630413masa_s
mascara1138023mascara
massa75518923mas_sa
mastaba1146223mastaba
nagana748943nagana
nasal56217593nasa_l
nasals63312463nasals
ottava963683ottava
paisana94010223paisana
pajama17317653pajama
palapa10310673palapa
panada94113053panada
panama104213353panama
papaya1337503papaya
pasha105417183pas_ha
pasta76624533pas_ta
pataca10311193pataca
piasaba1144193piasaba
piasavas1343333piasavas
piassava1342253piassava
posada937163posada
qabala17399193qabala
ramada9310183ramada
saga55331173__saga
saliva93110743saliva
samara8313853samara
samsara936913samsara
satara6315533satara
save75741363__save
tarama8412733tarama
vasa76522973vas__a
vasal85516293vasa_l
wasabi1154643wasabi
zanana153810363zanana

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162245.04622337.7
3Display Results2242240.0762947.4
 (SQL Overall)1786912245.49832501.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.