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 “causes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

194 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
causes8802647(None) 
carses85233651carses
cases75048381ca_ses
caules85927251caules
cause75225351cause_
caused95117041caused
causer84117781causer
causers94014791causers
causey113513271causey
causeys12387221causeys
cayuses12188401cayuses
clauses93813321clauses
cruses88127711cruses
pauses84621471pauses
abuses85119102abuses
accuses114112192accuses
acutes83917722acutes
amuses85117942amuses
anuses66218772anuses
apses76823912_apses
arses55733872_arses
asses55629282_asses
aures55137092_aures
baases85218012baases
bases75644352ba_ses
basses85428302basses
bouses84931782bouses
buses75936012_buses
cables104527552cables
caches137926912caches
cactuses1237932cactuses
cades85440732ca_des
cadges104716702cadges
cadres94017932cadres
cafes106426922ca_fes
cages85936012ca_ges
cakes116037672ca_kes
calces104420052calces
calluses1039322calluses
calves115119282calves
calxes154113032calxes
camases114216342camases
cames97047312ca_mes
camises114218462camises
campuses1437772campuses
canes75350372ca_nes
canoes84725882canoes
cansos84915382cansos
capes95441922ca_pes
cares77369182ca_res
caress85720262caress
caries85147622caries
carles85435082carles
carouses10614502carouses
carse74934332carse_
cartes86239472cartes
carves115128452carves
casas75327842ca_sas
case65848082ca_se_
cased86032412ca_sed
cashes114729882cashes
casks115720062ca_sks
cassis84818852cassis
castes85631862castes
casts77237792ca_sts
casus76419252ca_sus
cates75951892ca_tes
caucus1039612caucus
caucuses1236782caucuses
caudex1636402caudex
caudles103912812caudles
caulds95512382caulds
caulis85320082caulis
caulks125611862caulks
cauls75727772cau_ls
causal81413202causal
causals91411182causals
caves105639702ca_ves
cavies114525002cavies
cayuse11207762cayuse_
ceases84427072ceases
censes83721802censes
ceruses93716232ceruses
cesses84221362cesses
chaises124317492chaises
chaoses124715122chaoses
chases115128232chases
chasses124017502chasses
chausses1345962chausses
chiauses1336482chiauses
choses115825132choses
chouses125117812chouses
chutes114615772chutes
classes94717942classes
clause84311502clause_
closes85425592closes
clues74623032clu_es
copses104922472copses
corses84433462corses
coses76949492c_oses
coupes105022522coupes
courses94218892courses
crases85532312crases
crises84529432crises
cruces105117542cruces
crudes96218622crudes
cruises93514442cruises
cruse75726102cruse_
cruset84425092cruset
crusets93811042crusets
crushes124215132crushes
crusts84916542crusts
cruxes154911562cruxes
cubes95028162c_ubes
cues65438982c_u_es
cukes115422092c_ukes
cures75645432c_ures
curses85328272curses
cusec94614902c_usec
cusecs10509152c_usecs
cusks114916052c_usks
cusps94913672c_usps
cuss65430612c_us_s
cusses84522772cusses
cutes79438322c_utes
cyeses11510122cyeses
daises74318982daises
daubes94913702daubes
douses74928932douses
druses75517252druses
eases56041612ea_ses
fauces114916152fauces
fauves125610422fauves
favuses1336182favuses
fuses85628422_fuses
gases65633992ga_ses
gasses75724782gasses
gauges85915992gauges
gauss65613452gaus_s
gausses8308692gausses
gauzes164710632gauzes
hanses95022632hanses
hausen9610382hausen
hausens1077632hausens
hawses125113992hawses
houses96032272houses
ictuses938302ictuses
lapses85217692lapses
lases54944762la_ses
lasses64827592lasses
louses66230282louses
manses84225512manses
marses84827112marses
masses85028712masses
mauves113811552mauves
mouses85531422mouses
muses75134302_muses
nausea637312nausea
nauseas735992nauseas
nouses64627162nouses
oases55330982oa_ses
onuses65616252onuses
opuses84012242opuses
parses85534702parses
pases75346502pa_ses
passes86030472passes
pause75021832pause_
paused95114962paused
pauser84415962pauser
pausers94113222pausers
pluses83618072pluses
puses75532202_puses
raises64826542raises
rases55447212ra_ses
reuses66025522reuses
rhuses94911792rhuses
rouses65436282rouses
ruses56136582_ruses
sasses64124392sasses
sauces84919502sauces
sautes63924912sautes
scouses93313242scouses
souses64229242souses
taluses7311212taluses
tasses64826762tasses
taupes8212672taupes
tawses94913192tawses
touses64229672touses
uruses63616502uruses
uses44931112__uses
valses94514612valses
varuses10310622varuses
vases84626262va_ses
wamuses1237022wamuses

Search took 6 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 Filter178691825510.216827273.1
2DLD Change Limit825511944.75017379.2
3Display Results1941940.1261539.7
 (SQL Overall)1786911945.09235092.5
 
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.