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

206 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
camasses1238897(None) 
amasses93912851_amasses
camases114216341cama_ses
admasses1135412admasses
amassed10388632_amassed
amasser9418732_amasser
amassers10337842_amassers
badasses1136172badasses
bagasses1136312bagasses
calashes13310532calashes
camass104114182cama_s_s
camises114218462cam_ises
campuses1437772campuses
canvasses14286032canvasses
carcasses1337472carcasses
caresses10314062caresses
chasses124017502c_hasses
classes94717942c_lasses
compasses1547392compasses
gamashes1456942gamashes
harasses11311032harasses
kavasses1544302kavasses
masses85028712__masses
abases85720773_aba_ses
abashes12510373_abashes
abysses1234863_abysses
accesses1287493accesses
amass77119683_ama_s_s
amazes175613473_ama_zes
amuses85117943_am_uses
asses55629283___asses
avgasses1284193avgasses
baases85218013ba_a_ses
babassus1243063babassus
badassed1244273badassed
bagasse1035143bagasse_
balases93815433bala_ses
basses85428303__basses
biasses94911653_biasses
biomasses1343963biomasses
brasses93818353_brasses
bypasses1533833bypasses
cabooses1237863cabooses
cactuses1237933cactuses
cadaster1136903cadaster
cadasters1236833cadasters
cadastres1244543cadastres
caddises12329353caddises
calloses10313393calloses
calluses1039323calluses
calmnesses1436843calmnesses
camailed1336553camailed
camails11311753cama_ils
camas96333523cama___s
cambisms1645803cambisms
cambists1437023cambists
cames97047313cam___es
camisades1474963camisades
camisas113411923cam_isas
camise103319633cam_ise_
camisias12268603camisias
camisoles1345583camisoles
cammies134016483cam_mies
campsites1546473campsites
campused1535253campused
canalises11515493canalises
canapes111213083cana_pes
canaries10318943canaries
canastas1037693canastas
canvases13349513canvases
canvassed15274033canvassed
canvasser14274253canvasser
canvassers15273573canvassers
capiases1239253capiases
carafes125015703cara_fes
carassow1343253carassow
carassows1442933carassows
carates95630613cara_tes
carcases12313083carcases
caressed1139163caressed
caresser1038803caresser
caressers1137433caressers
carouses10614503carouses
carses85233653c__arses
carwashes1745773carwashes
caseases10410473caseases
caseoses1039293caseoses
cases75048383c__a_ses
cashes114729883c__ashes
cassis84818853c__assis
cassises103811743cassises
castes85631863c__astes
catalases1149433catalases
cataloes10311653cataloes
catalyses1447433catalyses
catharses1446413catharses
caucuses1236783caucuses
caucusses1343043caucusses
causes88026473c__auses
cayuses12188403ca_yuses
ceases84427073c_ea_ses
cerastes101111093cerastes
cesses84221363c__esses
chaises124317493c_haises
chamades16138653chama_des
chamises153513313cham_ises
chamoises16327933chamoises
chaoses124715123c_haoses
charases131312763chara_ses
chases115128233c_ha_ses
chasse115114603c_hasse_
chassed134712133c_hassed
chassis123910663c_hassis
chausses1345963chausses
chesses124112633c_hesses
chiauses1336483chiauses
clashes124017283c_lashes
classed104113653c_lassed
classer93614613c_lasser
classers104111833c_lassers
classis93712723c_lassis
clauses93813323c_lauses
cleanses10358143cleanses
comakes154413643coma_kes
comates114123643coma_tes
compassed1645543compassed
composes145017113composes
crases85532313c_ra_ses
crashes124618403c_rashes
crasser94114333c_rasser
crassest103411523c_rassest
creases94020963crea_ses
cresses94219813c_resses
crevasses1444133crevasses
crosses94220793c_rosses
cuirasses1144373cuirasses
cuisses9319883c_uisses
cusses84522773c__usses
cutlasses1145103cutlasses
cycases1437533cyca_ses
damages11511273dama_ges
damasked1643753damasked
damasks1435073dama_sks
degasses10278363degasses
eyasses10388023_eyasses
famishes1658283famishes
frasses104314513_frasses
gasses75724783__gasses
gausses8308693ga_usses
glasses84414273_glasses
grasses84117343_grasses
hamates122917683hama_tes
harassed1237113harassed
harasser1137033harasser
harassers1246193harassers
hardasses1346453hardasses
iambuses1235783iambuses
impasses12257523impasses
jackasses2243713jackasses
karosses1236493karosses
kumisses1443583kumisses
kvasses14365503_kvasses
lambastes13114693lambastes
lampases1267293lampases
landmasses1343213landmasses
lasses64827593__lasses
lavashes1445573lavashes
malaises10312333malaises
manses84225513__manses
marses84827113__marses
mashes115030003__mashes
massas85116463__massas
masse75125293__masse_
massed94421323__massed
matrasses1157293matrasses
megasses11307743megasses
messes84924343__messes
misses85130873__misses
molasses1037233molasses
morasses1038903morasses
mosses85527683__mosses
musses84624783__musses
oakmosses1551823oakmosses
passes86030473__passes
pavisses13397103pavisses
quamashes2343973quamashes
quasses16209503_quasses
repasses101810373repasses
rubasses1035493rubasses
sasses64124393__sasses
smashes123914613_smashes
strasses81311443strasses
tamales93216153tama_les
tamashas13135683tamashas
tamises92715973tam_ises
tasses64826763__tasses
trasses74819323_trasses
unamassed1244243unamassed
vamooses1345523vamooses
vamoses1239143vam_oses
vinasses1135703vinasses
wammuses1543493wammuses
wampuses1534113wampuses
wamuses1237023wam_uses
wrasses103812593_wrasses
zymases21938333zyma_ses

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.1561145455.1
2DLD Change Limit1461622067.19020328.5
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.42224075.9
 
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.