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

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
casavas123781(None) 
casabas1139981casabas
casava1157871casava_
cassavas1344801cassavas
asanas6514112_asanas
cabalas113516002cabalas
cabanas112413032cabanas
canvas113813332ca_nvas
caravan1239222caravan
caravans1338612caravans
casaba1079262casaba_
casas75327842cas__as
cascaras1237692cascaras
casitas93312042casitas
cassabas1245732cassabas
cassatas1036672cassatas
cassava1255002cassava_
cassias93514342cassias
masalas9312052masalas
piasavas1343332piasavas
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413443_agamas
agaves104611513_agaves
ajivas1655133_ajivas
anabas8314083_anabas
asana5315483_asana_
asramas938303_asramas
baklavas1742783baklavas
balatas9311833balatas
bananas93312223bananas
basalts9358963basalts
bravas114913323_bravas
cabala103516913cabala_
cabals104020153caba_ls
cabana103913563cabana_
cabbalas1467373cabbalas
cacaos104616183caca_os
cacas95627983c__acas
cadaver1335773cadaver
cadavers1435863cadavers
caeomas1138393caeomas
caesars9410723caesa_rs
caesuras1055723caesuras
calabash1544253calabash
calamar1149293calamar
calamars1238133calamars
calamus1139243calamus
calesas9411823calesas
calisayas1442463calisayas
callas84526753ca_llas
calves115119283ca_lves
camails11311743camails
camas96333523c__amas
camases114216343camases
camass104114183cama_ss
cameras11313343cameras
camisas113411923camisas
canals84421663cana_ls
canapes111213083canapes
canards10311203canards
canastas1037693canastas
canchas143212403canchas
cannas84518403ca_nnas
canolas9313993canolas
cantalas104013523cantalas
cantatas103410083cantatas
canulas9312853canulas
canvass12376873canvass
capias10318353ca_pias
carabao1139673carabao
carabaos1238073carabaos
caracal11312513caracal
caracals12310743caracals
caracks152211563caracks
carafes125015703carafes
carapax1835793carapax
carates95630603carates
carats85929023cara_ts
caravel1238203caravel
caravels1337433caravels
caraway1538133caraway
caraways1636943caraways
cardias10715093cardias
carinas93622383carinas
caritas93316943caritas
carves115128453ca_rves
casa65630863cas__a_
casbah1337903cas_bah
casbahs1436463casbahs
cascades13128553cascades
cascara1138313cascara_
casease939323cas_ease
caseases10410473caseases
caseates10313703caseates
caseins93115053caseins
caseous9312513caseous
caserns94711213caserns
cases75048383cas__es
cashaw14439793cas_haw
cashaws15398573cashaws
cashes114729883cas_hes
cashews15428603cashews
cashoos12310793cashoos
casings104013513casings
casinos93512833casinos
casita82913703casita_
caskets133910173caskets
casks115720063cas__ks
casques18278983casques
cassaba1145663cassaba_
cassata938143cassata_
cassenas10317483cassenas
cassia83714763cassia_
cassinas103610633cassinas
cassis84818853cas_sis
castaway1664573castaway
castaways1743673castaways
casters94729893casters
castes85631863cas_tes
castles94917733castles
castors94919433castors
casts77237793cas__ts
casual81112863cas_ual
casuals91410523casuals
casus76419253cas__us
catalase1039213catalase
catalos9414163catalos
catalpas1246733catalpas
catawbas1544093catawbas
catenas9313103catenas
causals91411183causa_ls
cavallas1366843cavallas
caves105639703c__aves
cestas85018543ces_tas
cesuras958683cesuras
chalazas2245893chalazas
charas114223593c_haras
cicadas1235983cicadas
cicalas1139293cicalas
claves115020063c_laves
clavus11347353c_lavus
cleaves124111623cleaves
cloacas1136233cloacas
coalas87418963c_oalas
cravat11314443c_ravat
cravats1237393c_ravats
craves115825393c_raves
curaras93911943curaras
fascias1258413fascias
favas115618593__favas
guavas1037153_guavas
halalas104214083halalas
halavah16447013halavah
halavahs17415793halavahs
halvas124714173ha_lvas
hamadas1339663hamadas
hawalas13348353hawalas
jacanas1638263jacanas
javas155915423__javas
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kamalas13339123kamalas
kanakas10327213kanakas
kashas133311903kas_has
kavas125919953__kavas
larvas9310233la_rvas
lasagnas943673lasagnas
lavas85422223__lavas
mananas93414733mananas
maracas11313773maracas
marsalas1038253marsalas
masala8311813masala_
masas75630413mas__as
mascaras1237693mascaras
massas85116463mas_sas
mastabas1246803mastabas
naganas847983naganas
nasals63312463nasa_ls
ottavas1093483ottavas
paisanas10288873paisanas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
papayas1437273papayas
pashas115117063pas_has
pastas85422873pas_tas
patacas11311003patacas
piasabas1243883piasabas
piasava1243883piasava_
piassavas1442173piassavas
posadas1037193posadas
qabalas18289503qabalas
ramadas1039303ramadas
sagas66025883__sagas
salivas10309603salivas
samaras9312913samaras
samsaras1045873samsaras
sataras7315053sataras
saves85838633__saves
taramas9612693taramas
wasabis1255363wasabis
zananas16319563zananas

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.1561145455.1
2DLD Change Limit1340272067.29618369.9
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.53223724.2
 
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.