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

130 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
cardiacs137690(None) 
cardiac1278811cardiac_
cardias10715091cardia_s
cardia9916372cardia__
cardiae10713702cardia_e
cardigans1345142cardigans
cardinals1247982cardinals
cardings123812622cardings
carditis11310212carditis
cordials1139602cordials
acaridans1254033acaridans
acedias1039763acedia_s
arias55438023_ar_ia_s
arnicas939543_arnicas
asdics9439863_asdi_cs
bardic11312923bardi_c_
caddice13327733caddi_ce
caddices14297853caddices
caddies113718383caddi_es
caddis104613373caddi__s
caddises12329353caddises
cadis84428493ca_di__s
calpacs133110343ca_lpacs
candidacy1852363candidacy
candidas12338643candidas
candids113812693candi_ds
candies104125613candi_es
capias10318353ca_pia_s
carabaos1238073carabaos
caracals12310743caracals
carack142113173car__ack
caracks152211563car__acks
carapace1446083carapace
carapaces1546043carapaces
carats85929023car__ats
caravans1338613caravans
caraways1636943caraways
carbides133111693carbides
carbines123617533carbines
carcass11310513car_cass
cardcase1345963cardcase
cardcases1446493cardcases
carders104820353card_ers
cardigan1245613cardigan
cardinal1139553cardinal
carding113922433cardi_ng
cardio9915673cardi__o
cardioid1247433cardioid
cardioids1345223cardioids
carditic1348693carditic
cardons104519933card_ons
cardoons113411943cardoons
cards85137933card___s
caribes113715643car_ibes
carices114220953car_ices
caries85147623car_i_es
carinas93622383car_inas
carioca1139683car_ioca
cariocas1239663car_iocas
carious93320283car_ious
caritas93316943car_itas
carjack2246153car_jack
carjacks2345573car_jacks
carlines103521643carlines
carlings114015853carlings
carlins93921913carli_ns
carloads1138393carloads
carmines123617863carmines
carnies94123963carni_es
carnivals1444483carnivals
caroach1488863car_oach
carpals113414623car_pals
carpings133812383carpings
carrack1548753car_rack
carracks1637713car_racks
carriage1137853carriage
carriages1238333carriages
carriers103614203carriers
carries94328013carri_es
carrions10312443carrions
carritch1543483carritch
carsick1536343carsi_ck
carvings143810203carvings
cassias93514343cassia_s
caudices13337343caudices
caviars1238623ca_viars
celiacs11157893c_eliacs
cerias83321973cer_ia_s
clarkias1444793clarkia_s
cordial10312933cordia_l
cordings123011343cordings
cordites11314603cordites
corsacs1139013cor_sacs
czardas1934673czard_a_s
darics94314113dar_i_cs
garlics1038013garli_cs
giardias1045013giardia_s
guardians1143913guardians
hardass1139753hard_ass
hardback2045633hardback
hardbacks2145373hardbacks
hardhack2143843hardhack
hardhacks2243703hardhacks
hardhats1546833hardhats
hardies114923233hardi_es
hardpack2043923hardpack
hardpacks2143623hardpacks
hardpans1436453hardpans
hardtack1843993hardtack
hardtacks1943803hardtacks
herdics13249523herdi_cs
lariats7615053lar_iats
maniacs114313063ma_niacs
martians103111613martians
pardahs13289673pard_ahs
pariahs123812343par_iahs
parians93519733par_ians
partials101911953partials
radials83614633ra_dials
radians83013823ra_dians
sardars83112903sard_ars
sardines92815563sardines
sardius839553sardi_us
scandias1137863scandia_s
tardies84225863tardi_es
tarmacs1138323tar_macs
tarsias74013373tarsia_s
triacs83913223_tr_iacs
varias95019903var_ia_s
zodiacs1943423_zodiacs

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.1531167915.0
2DLD Change Limit1461621307.44019645.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.63923391.9
 
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.