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 “catalpas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
catalpas124673(None) 
catalpa1136501catalpa_
cabalas113516002cabal_as
cantalas104013522cantal_as
catalase1039212catal_ase
cataloes10311652cataloes
catalogs1148032catalogs
catalos9414162catal_os
cataplasm1543842cataplasm
catawbas1544092catawbas
cavallas1366842cavallas
atalayas1144783_atalayas
ataps76414833_ata_p_s
ataxias14189343_ataxias
atlas55821583_at_l_as
azaleas1636993_azaleas
battalias1144803battalias
cabala103516913cabal_a_
cabals104020153cabal__s
cabanas112413033caba_nas
cabbalas1467373cabbal_as
callas84526753c__allas
calpac123211063c__alpac
calpacs133110343c__alpacs
camelias12510303camelias
canals84421663canal__s
canapes111213083cana_pes
canastas1037693canastas
canellas10310563canellas
canolas9313993canol_as
cantala94114673cantal_a_
cantals93919573cantal__s
cantatas103410093canta_tas
canulas9312853canul_as
carapax1835793cara_pax
casabas1139983casa_bas
casavas1237813casa_vas
catalases1149433catalases
catalepsy1642393catalepsy
catalexes1845913catalexes
catalexis1844953catalexis
catalo8314853catal__o
catalog1038003catal_og
catalyses1447433catalyses
catalysis1445873catalysis
catalyst1347313catalyst
catalysts1445513catalysts
catalyze2245623catalyze
catalyzes2346053catalyzes
cataplasms1653453cataplasms
catarrhs1344333catarrhs
catawba1443703catawba_
catcalls1238323catcal_ls
catclaw1443973catcl_aw
catclaws1543633catclaws
catenas9313113cat_enas
catfalls1347063catfal_ls
catlins93818843cat_lins
catnaps1197033catnap_s
catnips1195893catnip_s
catspaw1443353cat_spaw
catspaws1543163cat_spaws
catsups1135343catsup_s
cattaloes1146183cattaloes
cattalos1037933cattal_os
cattleyas1442623cattleyas
catwalks1744793catwal_ks
cavalla1257883cavalla_
challas124414123c_hallas
chalupas1554383c_halupas
cicalas1139303cical_as
citolas939363citol_as
coalas87418963c_oal_as
cutlas8313103cut_l_as
halalas104214083halal_as
hawalas13348353hawal_as
kabalas133911063kabal_as
kalpas124112943__kalpas
kamalas13339123kamal_as
latakias1245583latakias
latillas847363latillas
masalas9312053masal_as
matildas1145023matildas
palapas11311493pala_pas
patacas11311003pata_cas
patellas1039103patellas
qabalas18289503qabal_as
ratafias1145323ratafias
ratals64219583ratal__s
rataplan1043633rataplan
rataplans1143823rataplans
salpas85116923__salpas
sataras7315063sata_ras
talas55935893__tal_as
tapas74627713__ta_pas
watapes12228383wata_pes
wataps11248683wata_p_s
yamalkas1743103yamalkas

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 Filter1786911461620.420425454.8
2DLD Change Limit146162987.78318779.6
3Display Results98980.0462130.4
 (SQL Overall)178691988.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.