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

266 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
casaba107926(None) 
casabas1139981casabas
casava1157871casava
cassaba1145661cassaba
asana5315482_asana
cabala103516912cabala
cabana103913562cabana
carabao1139672carabao
caramba1336892caramba
casa65630862cas__a
casas75327842casa_s
casavas1237812casavas
casbah1337902casbah
cascara1138312cascara
casita82913702casita
cassabas1245732cassabas
cassata938142cassata
cassava1255002cassava
cassia83714762cassia
catawba1443702catawba
masala8311812masala
mastaba1146222mastaba
piasaba1144192piasaba
wasabi1154642wasabi
aba512850953___aba
abaca95118043_abaca
abaka114313823_abaka
abaya104413173_abaya
abba810522653_a_bba
agama85815573_agama
alba68328333_a_lba
ameba9312383_ameba
anabas8314083_anabas
asanas6514113_asanas
asea46327183_as_ea
asrama839193_asrama
asyla839333_asyla
atabal839743_atabal
baba88828353__baba
balata8614673balata
banana83213413banana
basal75722283basa_l
basalt83519583basalt
cab78355403c__ab_
cabal95222153caba_l
cabalas113516003cabalas
cabals104020153cabals
cabanas112413033cabanas
cabbala1367183cabbala
cabby145314563ca_bby
cabob114616813cabob_
cabobs124311893cabobs
cabomba1544083cabomba
cabs86739423c__abs
caca85528083c__aca
cacao95420003caca_o
cacaos104616183cacaos
cacas95627983caca_s
caeca93915133ca_eca
caeoma1039033caeoma
caesar8410933caesa_r
caesars9410723caesars
caesura956223caesura
calabash1544253calabash
calabaza2143463calabaza
calamar1149293calamar
calami10313423calami
calash11312433calash
calesa8412473calesa
calisaya1342623calisaya
calla74827073ca_lla
camail10314823camail
camas96333523cama_s
camass104114183camass
cambia124913153cambia
camera10313673camera
camisa103114323camisa
canal75428043cana_l
canals84421663canals
canape10913513canape
canard9314763canard
canary11314693canary
canasta938363canasta
cancha134411613cancha
canna75919333ca_nna
canola8313623canola
cantala94114673cantala
cantata93811813cantata
canula8312963canula
capable13313363capable
capably1639253capably
capita102913773capita
carabaos1238073carabaos
carabid12311333carabid
carabin11313213carabin
caracal11312513caracal
carack142113173carack
carafe115416163carafe
carapax1835793carapax
carat75048793cara_t
carate84734003carate
carats85929023carats
caravan1239223caravan
caraway1538133caraway
carb85143163ca_rb_
carbo94923843ca_rbo
carbs96031463ca_rbs
cardia9916373cardia
caribe103416753caribe
carina84325323carina
carnauba1252733carnauba
carob95325223carob_
carobs104818103carobs
casbahs1436463casbahs
cascabel14174503cascabel
cascable141510623cascable
cascade12118603cascade
cascaras1237693cascaras
case65848083cas__e
casease939323casease
caseate9314783caseate
cased86032413cas_ed
casefy1436273casefy
caseic103212373caseic
casein83216453casein
casern84713313casern
cases75048383cas_es
cash96636283cas__h
cashable15159793cashable
cashaw14439793cashaw
cashaws15398573cashaws
cashbox2143453cashbox
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
cashoo11312253cashoo
casing94829103casing
casini84615863casini
casino84317553casino
casitas93312043casitas
cask105626433cas__k
casked134815513casked
casket124820993casket
casks115720063cas_ks
casky144512683cas_ky
casque17299273casque
cassatas1036673cassatas
cassavas1344803cassavas
cassena9287843cassena
cassias93514343cassias
cassina94113163cassina
cassis84818853cassis
cast67159903cas__t
castable121613973castable
castaway1664573castaway
caste75932363cas_te
caster85232573caster
castes85631863castes
castle84918963castle
castor84418533castor
casts77237793cas_ts
casual81112863casual
casuals91410523casuals
casus76419253cas_us
catalo8314853catalo
catalpa1136503catalpa
catawbas1544093catawbas
catena8312473catena
causable1239973causable
causal81413203causa_l
causals91411183causals
cavalla1257883cavalla
ceiba938703c_eiba
cesta75419483ces_ta
cesura838763cesura
chalaza2145733chalaza
choana1138443choana
cicada1136413cicada
cicala10310053cicala
cloaca1037263cloaca
coala77521123c_oala
copaiba1344483copaiba
costa75523733cos_ta
crab85727673c_rab_
crabs95421393c_rabs
curara83712203curara
dagoba1074943dagoba
fascia1148703fascia
galabia1038313galabia
gamba106018513ga_mba
gasbag1035413gasbag
gazabo1834833gazabo
halala94715093halala
hamada1239913hamada
hawala12368913hawala
indaba935623indaba
isba61310883_is_ba
jacana1537933jacana
kabab134814443kabab_
kababs14409773kababs
kabaka11348503kabaka
kabala124011553kabala
kabaya15387123kabaya
kamala12339963kamala
kanaka9357523kanaka
kasbah1535183kasbah
kasha124710723kas_ha
labara83712893labara
lasagna843543lasagna
lavabo1135273lavabo
mamba116317523ma_mba
manana84816073manana
maraca10314153maraca
marsala939583marsala
masa65034713mas__a
masalas9312053masalas
masas75630413masa_s
mascara1138023mascara
massa75518923mas_sa
mastabah1554023mastabah
mastabas1246803mastabas
nagana748943nagana
nasal56217593nasa_l
nasals63312463nasals
nawab10810923nawab_
nawabs1185063nawabs
paisana94010223paisana
pajama17317653pajama
palabra1137183palabra
palapa10310673palapa
panada94113053panada
panama104213343panama
papaya1337503papaya
pasha105417183pas_ha
pasta76624533pas_ta
pataca10311193pataca
piasabas1243883piasabas
piasava1243883piasava
piassaba1242433piassaba
posada937163posada
qabala17399193qabala
ramada9310183ramada
sab56563203__sab_
sabal75422483__sabal
sabe66140573__sabe
sabra75317853__sabra
sabs66643743__sabs
saga55331173__saga
samara8313853samara
samba95618773sa_mba
samsara936913samsara
sassaby1244003sassaby
satara6315533satara
scarab10310063scarab_
scarabs1137293scarabs
soba64927923__soba
suba64926603__suba
tarama8412723tarama
taskbar1393023taskbar
tsuba745563_tsuba
vasa76522973vas__a
vasal85516293vasa_l
wasabis1255363wasabis
zanana153810363zanana
zareba1736423zareba
zariba1736983zariba

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162666.17318259.5
3Display Results2662660.0932860.2
 (SQL Overall)1786912666.40627894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.