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

172 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
cause7522535(None) 
carse74934331carse
case65848081ca_se
caused95117041caused
causer84117781causer
causes88026471causes
causey113513271causey
cayuse11207761cayuse
clause84311501clause
cruse75726101cruse
pause75021831pause
abuse77119562abuse
accuse103411032accuse
acute74720362acute
amuse75920832amuse
apse67725382_apse
arse46539272_arse
base64847022ba_se
because1136232because
bouse75931852bouse
cable95329912cable
cabs86739422cabs_
cache125122482cache
cade76443912ca_de
cades85440732cades
cadge94018782cadge
cadre85419012cadre
cads76144522cads_
cafe95230322ca_fe
cafes106426922cafes
cage75339062ca_ge
cages85936012cages
cake105439962ca_ke
cakes116037672cakes
calve105919922calve
came87648752ca_me
cames97047312cames
camise103319632camise
cams87047282cams_
cane66653112ca_ne
canes75350372canes
canoe75627252canoe
cans65050842cans_
canso75019402canso
canst74932212canst
cape87242782ca_pe
capes95441922capes
caps87147892caps_
care66968372ca_re
cares77369182cares
carle74535702carle
carouse9614422carouse
cars67364762cars_
carses85233652carses
carte75940422carte
carve106227752carve
casa65630862ca_sa
cased86032412ca_sed
cases75048382ca_ses
cash96636282ca_sh
cask105626432ca_sk
cast67159902ca_st
caste75932362caste
casus76419252casus
cate66254592ca_te
cates75951872cates
cats66356342cats_
caudex1636392caudex
caudle93912912caudle
caul65630002cau_l
cauld85318442cauld
caules85927252caules
caulk115315452caulk
cauls75727772cauls
causal81413202causal
causers94014782causers
causeys12387222causeys
cave95941262ca_ve
caves105639702caves
cavie104621592cavie
caws96036102caws_
cays95437672cays_
cayuses12188402cayuses
cease75227652cease
cense75121402cense
ceruse83914522ceruse
chaise114916412chaise
chase105127122chase
chasse115114602chasse
chose105925402chose
chouse116017562chouse
chute104316462chute
clauses93813322clauses
close76425222close
clue65324532clu_e
clues74623032clues
coarse84813892coarse
copse95623922copse
corse75036182corse
coude85022632coude
coupe96023482coupe
course85117772course
crouse84619362crouse
crude86018572crude
cruise84314042cruise
crus65828482crus_
cruses88127712cruses
cruset84425092cruset
crush106815992crush
crust75827662crust
cube85830212c_ube
cue57544182c_u_e
cues65438982c_ues
cuke105824982c_uke
cure66149122c_ure
curse75829142curse
cusec94614902c_usec
cusk105521632c_usk
cusp86021062c_usp
cuss65430612c_uss
cute66440452c_ute
daube85015302daube
douse66329722douse
druse64817662druse
ease45042332ea_se
false84818122false
fauve114712072fauve
fuse76429992_fuse
gauge76117902gauge
gauss65613452gauss
gauze155712972gauze
hanse85722792hanse
hausen9610382hausen
haute89521612haute
hawse116015122hawse
house89131422house
lapse74917682lapse
lase46148512la_se
louse56131012louse
manse75528222manse
marse76231152marse
masse75125292masse
mauve104013272mauve
mouse77133002mouse
muse67136032_muse
nausea637312nausea
paise75028332paise
parse75236992parse
pase65346862pa_se
passe75525692passe
paused95114962paused
pauser84415962pauser
pauses84621472pauses
raise54828052raise
rase46149982ra_se
reuse56025362reuse
rouse56634702rouse
ruse45938932_ruse
sauce75121652sauce
saute55028082saute
scouse84113632scouse
souse56530772souse
tasse54821842tasse
taupe7314162taupe
taus46342732taus_
tawse85616502tawse
touse55430672touse
use36835162__use
valse85117522valse
vase75629652va_se
vaus75928922vaus_
youse85322232youse

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001721.53335094.6
3Display Results1721720.0463739.1
 (SQL Overall)1786911721.672106872.6
 
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.