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

176 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
candours1140864(None) 
candors104216761cando_rs
candour104210241candour_
pandours11317991pandours
ardours8368882_ardours
candlers114214102candlers
candor94516422cando_r_
canoers94318372can_oers
cantors94620752canto_rs
clangours12263122clangours
concours1239472concours
condors104018572condo_rs
contours1039652contours
handouts1238232handouts
pandoors11258982pandoors
pandour10408212pandour_
rancours1076712rancours
sandburs11105622sandburs
santours837182santours
tandoors9258052tandoors
adnouns835453_adnouns
amours83512663_a_mours
arbours93910043_arbours
ardors74416873_ardo_rs
ardour74110903_ardour_
armours9389853_armours
banders104324563band_ers
bandogs1138363bando_gs
bandora1038813bando_ra
bandoras1138743bandoras
bandore10611633bando_re
bandores11311603bandores
cachous14312583cachou_s
cadgers114712003ca_dgers
callous93516603callou_s
campouts1436823campouts
cancers114018583can_cers
candelas1139533candelas
candidas12338643candidas
candids113812693cand_ids
candies104125613cand_ies
candler103516593candler_
candles104422343cand_les
caners84629203can__ers
canfuls1248423can_fuls
cangues10611823can_gues
cankers134418753can_kers
canners93822663can_ners
cannolis1037863cannolis
cannonry1343293cannonry
cannons94412883canno_ns
canoer85121073can_oer_
canoes84725883can_o_es
canolas9313993can_olas
canonry1235923can_onry
canons85522063can_o_ns
canorous10310193canorou_s
cansos84915383canso__s
cantdogs1244043cantdo_gs
canters94827733can_ters
canthus1248713canthu_s
cantons95221203canto_ns
cantor85621523canto_r_
cantos84826973canto__s
cantus85117763can_tu_s
canyons124511593canyo_ns
canzonas1935383canzonas
canzones1939153canzones
captors113914983capto_rs
carders104820353card_ers
cardons104519933cardo_ns
cardoons113411943cardoons
carious93320283cariou_s
caseous9312513caseou_s
castors94919443casto_rs
censors93611833censo_rs
centaurs1035733centaurs
chadors1338753chado_rs
chandlers15387673chandlers
chantors133710263chanto_rs
cinders104617763cind_ers
clamours1255993clamours
clangors11417003clango_rs
clangour11293803clangour_
clours85215093c__lours
colours95913443c_olours
concourse1345803concourse
concurs11311473con_curs
condoes104319203condo_es
condolers122710573condolers
condoles113015803condoles
condoms124214083condo_ms
condoners122811513condoners
condones112817393condones
condor94616973condo_r_
condores113315643condores
condos94322333condo__s
congous103615083congou_s
contour939973contour_
crankous1435973crankou_s
cundums1235183cund_ums
danders93921183dand_ers
dandlers103912053dandlers
danseurs933433danseurs
enamours1044663enamours
faitours1134263faitours
fandoms13229473fando_ms
favours13437093fa_vours
ganders93521703gand_ers
grandeurs11335113grandeurs
handcars1437623handcars
handers114224333hand_ers
handfuls15115753handfuls
handguns1344363handguns
handlers124014143handlers
handoffs1844733handoffs
handout11314103handou_t
handovers16136183handovers
hangouts1236183hangouts
harbours1346923harbours
haviours1443843haviours
honours10339373hon_ours
indoors838553_indoors
inpours936423_inpours
labours9349893la_bours
landaus8310343landau_s
landers84026213land_ers
landlers94312833landlers
languors976153languors
langurs889103lan_gurs
mandolas1139133mandolas
manors84420883man_o_rs
odours7418253__odours
padouks1434873pa_douks
panders103423733pand_ers
pandoor10358583pandoor_
pandora1039543pando_ra
pandoras11310053pandoras
pandore10411853pando_re
pandores11312453pandores
pandura1037143pand_ura
panduras1136953pand_uras
pantoums1236713pantoums
parlours1036153parlours
paviours1343613paviours
rancors9811373ranco_rs
rancour987133rancour_
randoms102112433rando_ms
sandbars11108783sandbars
sandbur10105353sandbur_
sandburr11123223sandburr
sandburrs12112783sandburrs
sanders84025943sand_ers
sandspurs1242583sandspurs
sanious7514103saniou_s
santoors837633santoors
santour737373santour_
santurs7310763san_turs
sapours93610623sa_pours
saviours1154273saviours
savours10389343sa_vours
scandiums1443983scandiums
standouts1044983standouts
tabours94110093ta_bours
tambours1255873tambours
tandoor8278563tandoor_
tandoori9244773tandoori
tandooris10224633tandooris
tenours72610073ten_ours
undoers82910583_undoers
valours10248743va_lours
vanadous1246033vanadou_s
vapours12277463va_pours
vendors113510223vendo_rs
wanders114221333wand_ers
zanders173015793zand_ers

Search took 7 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.1561145455.1
2DLD Change Limit1461621766.75021653.6
3Display Results1761760.0802200.0
 (SQL Overall)1786911766.98625578.4
 
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.