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

220 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
canvass1237687(None) 
canvas113813331canva_s
canvases13349521canvases
camass104114182ca_mass
canals84421672can_als
cancans11311872cancans
cannas84518402canna_s
cantals93919572cantals
canvased14246222canvased
canvaser13276562canvaser
canvasers14265362canvasers
canvassed15274042canvassed
canvasser14274262canvasser
canvasses14286042canvasses
carcass11310512carcass
kavass13517302ka_vass
admass957143_admass
amass77119683_a_mass
anas46649863_an_a_s
anears63717183_anears
angas65827983_anga_s
anlas55626933_anla_s
anlases72514903_anlases
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
antas55432033_anta_s
anvils9219713_anvils
avast85519363_a_vast
badass949293ba_dass
bagass938933ba_gass
bandas95120543banda_s
banians9312033banians
bantams1149063bantams
banyans1237913banyans
banzais1837163banzais
cabals104020153ca_bals
cacaos104616183ca_caos
cacas95627983ca_ca_s
caesars9410733caesars
caftans12179443caftans
caimans113811783caimans
calash11312433ca_lash
calcars11312653calcars
calesas9411833calesas
callans94518473callans
callas84526753calla_s
calpacs133110343calpacs
calvados1444813calvados
calvary1537183calvary
calves115119283calv_es
camas96333523ca_ma_s
camases114216343ca_mases
camisas113411923camisas
canal75428043can_a_l
canape10913513can_ape
canapes111213083canapes
canard9314763can_ard
canards10311203canards
canary11314693can_ary
canasta938363can_asta
canastas1037693can_astas
cancan10314103canca_n
cancels114113313cancels
cancers114018583cancers
canchas143212403canchas
candids113812693candids
candies104125613candies
candles104422343candles
candors104216763candors
caners84629203can_ers
canes75350373can__es
canfuls1248423canfuls
cangues10611823cangues
canids95118133can_ids
canines93724033canines
cankers134418753cankers
canna75919333canna__
cannabis1266033cannabis
cannels93413363cannels
canners93822663canners
cannons94412883cannons
canoers94318373canoers
canoes84725883can_oes
canolas9313993canolas
canoness1039393canoness
canons85522063can_ons
cans65050853can___s
canso75019403can__so
cansos84915383can_sos
canst74932213can__st
cantal84122033canta_l
cantala94114673cantala
cantalas104013523cantalas
cantata93811813cantata
cantatas103410093cantatas
canters94827733canters
canthus1248713canthus
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973can_tos
cantraps12319113cantraps
cants77036943can__ts
cantus85117763can_tus
canulas9312853canulas
canvasing1546433canvasing
canvassers15273583canvassers
canvassing1643803canvassing
canyons124511593canyons
capias10318353capia_s
capiases1239253capiases
capless114312763capless
captans111612053captans
carats85929023ca_rats
caravans1338623caravans
carcase11312743carcase
carcases12313093carcases
caress85720263ca_ress
carless95118493carless
carnivals1444503carnivals
carpals113414633carpals
carvels124914593carvels
carvers124817543carvers
carves115128453carv_es
carwash1536003carwash
casas75327843ca_sa_s
casavas1237823casavas
casbahs1436463casbahs
casease939323casease
caseases10410473caseases
cashaws15398573cashaws
casuals91410523casuals
catnaps1197033catnaps
causals91411183causals
caveats1239803caveats
cavers115026843ca_vers
caves105639703ca_v_es
caviars1238623caviars
cavies114525003ca_vies
cavils114014393ca_vils
caymans14349513caymans
centals94317053centals
centas85020703centa_s
cineast9310523cineast
cineasts1045543cineasts
class75525483c__lass
coaevals1344553coaevals
coevals1237873coevals
compass13379563compass
concuss1138063concuss
confabs1435393confabs
confess12399903confess
congas94417033conga_s
conveys15308223conveys
convoys15267023convoys
crass76328043c__rass
cravats1237403cravats
crevasse1343093crevasse
cuirass934973cuirass
cutlass938013cutlass
fangas105017193fanga_s
fantasm1236593fantasm
fantasms1345633fantasms
fantast10311703fantast
fantasts1147113fantasts
fantasy1336153fantasy
favas115618593fa_va_s
ganjahs18104003ganjahs
ganjas14149113ganja_s
halvahs16417533halvahs
halvas124714173halva_s
hangars114313493hangars
hansas94616043hansa_s
harass9313943ha_rass
hardass1139753hardass
invars9310003_invars
jackass2034963jackass
javas155915423ja_va_s
kanas95326913kan_a_s
kanbans1337723kanbans
kantars11310033kantars
kavas125919953ka_va_s
kvass12507273__kvass
lanais6316793lan_ais
landaus8310343landaus
landmass1144423landmass
larvas9310233larva_s
lavas85422223la_va_s
lavash12597373la_vash
manas76240433man_a_s
manats84623463man_ats
mangas94122923manga_s
maniacs114313063maniacs
manias84029033mania_s
manless93012933manless
mannans93611523mannans
mannas85019803manna_s
mantas85725363manta_s
manuals9311213manuals
matrass939403matrass
nanas55928633nan_a_s
navars92810573na_vars
pandas95521963panda_s
pangas99921103panga_s
pavans115715593pa_vans
qanats154112813qan_ats
randans8313213randans
sandals82715203sandals
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
scandals1136993scandals
tankas104613763tanka_s
vandals113211663vandals
vandas103915993vanda_s
wangans1149503wangans
wanness102610683wanness
zanzas1487053zanza_s

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272205.95322514.2
3Display Results2202200.0802750.0
 (SQL Overall)1786912206.45327691.2
 
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.