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

197 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
czardas193467(None) 
cardias10715092c_ardias
cards85137932c_ard_s
charas114223592char_as
chards125119722chard_s
charkas164810952charkas
czardases2143032czardases
czardom2144182czardom
czardoms2243742czardoms
czarinas1935292czarinas
czars164812912czar__s
areas55935773__areas
arias55438023__arias
arras55626133__arras
awards107113453award_s
azaleas1636993azaleas
bandas95120543_bandas
barcas101016603_barcas
bardes95026933_bardes
bards87139643_bard_s
beards94116673beard_s
boards94616933board_s
cacas95627983c_a_cas
caddis104613373c_addis
cades85440733c_a_des
cadis84428493c_a_dis
cadres94017923c_adres
cads76144523c_a_d_s
caids85226423c_aid_s
cairds96411513caird_s
callas84526753c_allas
camas96333523c_a_mas
canards10311203canard_s
cannas84518403c_annas
canvas113813333c_anvas
capias10318353c_apias
carat75048793c_ar_at
carats85929023c_arats
carbos105122263c_arbos
carbs96031463c_ar_bs
carcase11312733c_arcase
carcass11310513c_arcass
card710245873c_ard__
cardcase1345963c_ardcase
carded105424903c_arded
carder94524183c_arder
carders104820353c_arders
cardia9916373c_ardia
cardiac1278813c_ardiac
cardiacs1376903c_ardiacs
cardiae10713703c_ardiae
cardio9915673c_ardio
cardon94120853c_ardon
cardons104519933c_ardons
carers85133953c_arers
cares77369183c_ar_es
caress85720263c_aress
carets85330773c_arets
cargos94619183c_argos
caries85147623c_aries
carinas93622383c_arinas
caritas93316943c_aritas
carks115534213c_ar_ks
carles85435083c_arles
carls77037423c_ar_ls
carman103920743c_arman
carnal83919203c_arnal
carns75937563c_ar_ns
carobs104818103c_arobs
carols85124983c_arols
caroms105619573c_aroms
carpal103716253c_arpal
carpals113414623c_arpals
carps96932253c_ar_ps
carpus105514303c_arpus
carrs75730853c_ar_rs
cars67364763c_ar__s
carses85233653c_arses
cartes86239473c_artes
carts78946293c_ar_ts
carves115128453c_arves
carwash1535993c_arwash
casas75327843c_a_sas
caudad10157673c_audad
caudal91611483c_audal
cerias83321973c_erias
chacmas1637993chacmas
chadar1239343cha_dar
chadars1338273cha_dars
chads116122233cha_d_s
chakras16428483chakras
challas124414123challas
charade13129903charade
charades141310843charades
chard116124743chard__
chares115631803char_es
charges134615983charges
charka154011703charka_
charkhas20285023charkhas
charks155219703char_ks
charms135218833char_ms
charpai1436623charpai
charpais1536923charpais
charros124312143charros
charrs115219183char_rs
chars105936633char__s
charts115823093char_ts
chordal13449883chordal
chords125214633chord_s
choreas124414203choreas
cicadas1235983cicadas
clades94920463cla_des
clads85722733cla_d_s
clarets94111103clarets
claries93422203claries
clarkias1444793clarkias
claroes93113733claroes
claros84015113clar_os
coalas87418963coa_las
cobras104014193cobr_as
codas84724243c__odas
copras103517153copr_as
cords86030623c_ord_s
corridas1177303corridas
cowards1339613coward_s
crawdad1443113crawdad
crawdads1542653crawdads
curaras93911943curaras
curds85725613c_urd_s
czar156013133czar___
czarevnas2341353czarevnas
czarina1845953czarina
czarism2056423czarism
czarisms2155753czarisms
czarist18710223czarist
czarists1966223czarists
czaritzas1991643czaritzas
dadas75819863_da_das
dharmas1356503dharmas
dharnas1155373dharnas
echards1337963echard_s
farads104713273_farads
fards96629843_fard_s
garda7316763_garda_
gardai839663_gardai
giardias1045013giardias
guards84611563guard_s
hardass1139753_hardass
hards96435653_hard_s
hazards2037463hazard_s
hoards104912623hoard_s
izars145112933izar__s
izzards16143963izzard_s
karmas123013733_karmas
lards65331863_lard_s
larvas9310233_larvas
liards75212613liard_s
lizards17427613lizard_s
madras94316423_madras
maras75443283_mar_as
markas124717003_markas
mazards1937703mazard_s
monardas1145703monardas
nadas66320813_na_das
nards65928463_nard_s
pandas95521963_pandas
paras76143043_par_as
pardah123412823_pardah
pardahs13289673_pardahs
pards85634333_pard_s
parkas125018023_parkas
purdas92612263_purdas
sardar73013173_sardar
sardars83112903_sardars
sards64736183_sard_s
shards104319173shard_s
sharias102516003sharias
swards105415133sward_s
teargas837013teargas
tiaras6314533tiar_as
tzardom1943733tzardom
tzardoms2043273tzardoms
tzarinas1733973tzarinas
tzars144914273tzar__s
vandas103915993_vandas
varas86028193_var_as
varias95019903_varias
varnas94212823_varnas
vizards20377263vizard_s
wards97734403_ward_s
wizards20326403wizard_s
yards95324613_yard_s
zamias174212923_zamias
zanzas1487053_zanzas
zarebas1836303_zarebas
zarfs174713623_zar_fs
zaribas1836043_zaribas

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271978.15616432.9
3Display Results1971970.0633127.0
 (SQL Overall)1786911978.37521336.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.