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

103 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
cavallas136684(None) 
cavalla1257881cavalla_
cabalas113516002caba_las
callas84526752c__allas
canellas10310562canellas
catalpas1246732catalpas
cavallies1446382cavallies
cavally1588482cavall_y
challas124414122c_hallas
favellas1446162favellas
avails939693_avail_s
avellan1037293_avellan
axillas14278963_axillas
azaleas1636993_azaleas
barillas10310193barillas
cabala103516913caba_la_
caballed1337163caballed
cabals104020153caba_l_s
cabanas112413033caba_nas
cabbalas1467373cabbalas
cabrillas1345603cabrillas
cadelles1139953cadelles
calla74827073c__alla_
callan83619603c__allan
callans94518473c__allans
calls75634733c__all_s
callus85317073c__allus
calvarias1447663calvarias
camails11311743camail_s
camarillas1473423camarillas
camelias12510293camelias
camellias1365073camellias
canailles1148263canailles
canalled1139573canalled
canaller1038953canaller
canallers1137213canallers
canals84421663cana_l_s
canastas1037693canastas
candelas1139533candelas
canella9310793canella_
cannulas1037583cannulas
canolas9313993ca_nolas
cantalas104013523cantalas
canulas9312853ca_nulas
caracals12310743caracals
casabas1139983casa_bas
casavas1237813casa_vas
catalase1039213cata_lase
cataloes10311643cataloes
catalogs1148033catalogs
catalos9414163cata_los
catalpa1136503catalpa_
cataplasm1543843cataplasm
catawbas1544093catawbas
catcalls1238323catcall_s
catfalls1347063catfall_s
cavalcade1742053cavalcade
cavalcades1852133cavalcades
cavalero1344763cavalero
cavaleros1444093cavaleros
cavalier1348173cavalier
cavaliers1455613cavaliers
cavalries1446363cavalries
cavalry1554963cava_lry
cavatinas1444773cavatinas
cavilers1348113cavilers
cavilled1436723cavilled
caviller1337053caviller
cavillers1435603cavillers
cavils114014393cav_il_s
cedillas1145733cedillas
challa114014193c_halla_
challah15458323c_hallah
challahs16377563c_hallahs
challis124613463c_hallis
chollas123811353c_hollas
cicalas1139293cica_las
coalas87418963c_oa_las
corollas1039203corollas
crevalles1455723crevalles
favelas1337023fav_elas
favella1336173favella_
halalas104214083hala_las
hawalas13348353hawa_las
kabalas133911063kaba_las
kamalas13339123kama_las
lamellas1098153lamellas
latillas847363latillas
lavalavas1551893lavalavas
manillas102611163manillas
masalas9312053masa_las
maxillas17227703maxillas
navally1366473navall_y
novellas1176343novellas
paellas9411413pa_ellas
parallax1745643parallax
patellas1039103patellas
qabalas18289503qaba_las
savannas1143733savannas
vanillas11228123vanillas
villas96117263__villas
wallas95719393__wallas
yamalkas1743103yamalkas

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621037.34319904.9
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.55923639.5
 
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.