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

461 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
causal8141320(None) 
casual81112861casual
caudal91611481caudal
causals91411181causals
clausal936271clausal
pausal81511961pausal
acaudal1045772acaudal
accusal11136002accusal
aural54428962_aural
basal75722282ba_sal
cabal95222152ca_bal
caecal103713732caecal
caesar8410932caesar
canal75428042ca_nal
cantal84122032cantal
carnal83919202carnal
carousal1056282carousal
carpal103716252carpal
casa65630862ca_sa_
casas75327842ca_sas
casuals91410522casuals
caudad10157672caudad
caul65630002cau__l
causable1239972causable
causally1356612causally
cause75225352caus_e
caused95117042caused
causer84117782causer
causes88026472causes
causey113513272causey
crural8610632crural
crustal939022crustal
cuspal1037882c_uspal
faucal11339962faucal
faunal94711592faunal
nasal56217592na_sal
tarsal63315272tarsal
vasal85516292va_sal
vassal979242vassal
aal39058673_a__al
accusals12145053accusals
acetal84314903acetal
actual8311023actual
algal66518213_algal
anal48037523_a_nal
annal56520763_annal
ansa45927773_ansa_
ansae55720973_ansae
anural65714743anural
appal95315223_appal
areal55928733_areal
argal65023383_argal
arousal748633arousal
artal55525473_artal
arval86017013_arval
assai5711543_assai
assail6610153_assail
assay8710283_assay
audad71511383_audad
audial7312993_audial
aura45836253_aura_
aurae54128113_aurae
aurar54420253_aurar
auras55932553_auras
austral73411513_austral
axal116520493_a_xal
axial124515193_axial
baal67033113ba__al
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banal75925993ba_nal
barbal104016663barbal
basalt83519583ba_salt
basil75122273ba_sil
bicaudal1343423bicaudal
brumal1049503brumal
brutal859383brutal
bubal94218213_bubal
bursal84414823bursal
byssal1134993byssal
cabala103516913ca_bala
cabals104020153ca_bals
cabbala1367183cabbala
cabman123812503cabman
cabs86739423cabs__
caca85528083ca_ca_
cacao95420003ca_cao
cacas95627983ca_cas
cads76144523cads__
caeca93915133caeca_
caesars9410723caesars
caesural1055383caesural
caftan111710123caftan
caiman103615663caiman
calash11312433calash
calcar10312753calcar
calesa8412473calesa_
calesas9411823calesas
call66838673ca__ll
calla74827073calla_
callan83619603callan
callas84526753callas
calpac123211063calpac
camail10314823camail
camas96333523ca_mas
camass104114183camass
cambial134010763cambial
camel96822803ca_mel
cameral11311263cameral
camisa103114323camisa_
camisas113411923camisas
cams87047283cams__
canals84421663ca_nals
cancan10314103cancan
cancel105316683cancel
canful11610263canful
canna75919333canna_
cannas84518403cannas
cannel84216403cannel
canola8313623canola
cans65050843cans__
cansful1236823cansful
canso75019403cans_o
cansos84915383cansos
canst74932213cans_t
cantala94114673cantala
cantals93919573cantals
canthal12410053canthal
canula8312963canula_
canulae9311183canulae
canular9310323canular
canulas9312853canulas
canvas113813333canvas
capful1368173capful
capias10318353capias
capital112311523capital
caporal11410943caporal
caps87147893caps__
capsid11312413capsid
capsidal1345623capsidal
capstan1137903capstan
capsule1137343capsule
captan101613343captan
caracal11312513caracal
carat75048793ca_rat
carcel105018673carcel
carful11610973carful
carinal94318223carinal
carl65144783ca__rl
carman103920743carman
carol75128613ca_rol
carousals1165333carousals
carousel1057313carousel
carpale113414353carpale
carpals113414623carpals
carpel105418473carpel
carrel84718633carrel
cars67364763cars__
carse74934333cars_e
carses85233653carses
cartel85022533cartel
carvel114817573carvel
casaba1079263ca_saba
casava1157873ca_sava
casbah1337903casbah
case65848083ca_s_e
cased86032413ca_sed
cases75048383ca_ses
cash96636283ca_s_h
cashaw14439793cashaw
cask105626433ca_s_k
casks115720063ca_sks
casky144512683ca_sky
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassia83714763cassia
cassias93514343cassias
cassis84818853cassis
cast67159903ca_s_t
caste75932363ca_ste
castle84918963ca_stle
casts77237793ca_sts
casually1356823casually
casualty1344473casualty
casus76419253ca_sus
catalo8314853ca_talo
catcall1139153catcall
catfall1237393catfall
catnap1098383catnap
cats66356343cats__
catspaw1443353catspaw
catsup1036433catsup
cattail939173cattail
cattalo938423cattalo
catwalk1645323catwalk
caucus1039603caucus
caudally1446463caudally
caudate10311353caudate
caudex1636393caudex
caudle93912913caudle
caught124911683caught
cauld85318443cau_ld
caulds95512383caulds
caules85927253caules
caulis85320073caulis
caulk115315453cau_lk
caulks125611863caulks
cauls75727773cau_ls
causalgia1252513causalgia
causalgic1452123causalgic
causality1445323causality
causers94014783causers
causeway1643253causeway
causeys12387223causeys
causing103614413causing
caustic1139743caustic
caveat11417723caveat
caviar11310163caviar
cavil103816493ca_vil
caws96036103caws__
cayman133613213cayman
cays95437673cays__
cayuse11207763cayus_e
cayuses12188403cayuses
cecal94619113c_ecal
censual937663censual
cental84420963cental
cercal10314123cercal
cereal8315833cereal
chaetal1238283chaetal
chasmal14158213chasmal
chiral114614413chiral
chisel112111943chisel
chital114313883chital
choral115118493choral
chufa13489113chufa_
chufas14397673chufas
chukar1534633chukar
churl105913883chu_rl
citral81113883citral
clause84311503claus_e
clauses93813323clauses
claustral1143453claustral
clinal8311553clinal
clonal8310913clonal
coaeval1245183coaeval
coal66939253c__oal
coastal9411033coastal
coaxal15387303coaxal
coaxial16157003coaxial
coccal9310223coccal
coeval1138893coeval
coital84117053coital
comal95125133c_omal
consol82614113consol
consul82312303consul
copal95621783c_opal
coral76033453c_oral
corral83616253corral
corsac10410173corsac
costal85419513costal
cougar958783cougar
counsel948543counsel
cousin8517153cousin
coxal146116673c_oxal
craal74117753c_raal
cranial92114683cranial
credal9311673credal
cresol8310203cresol
crestal9312133crestal
cresyl1135133cresyl
crissal937413crissal
crucial1157893crucial
cruel74815903cru_el
crura7312583crura_
crus65828483crus__
crusade1036053crusade
crusado1043913crusado
cruse75726103crus_e
cruses88127713cruses
cruset84425093cruset
crush106815993crus_h
crusily12199093crusily
crust75827663crus_t
crusts84916543crusts
crusty114911343crusty
crystal1237433crystal
cull65929643c_u_ll
cuneal8611513cuneal
cupel9514303c_upel
curial84019153curial
curl66035053c_u_rl
curtal83914543curtal
cusec94614903c_usec
cushat113513693c_ushat
cushaw14386983c_ushaw
cushy134412323c_ushy
cusk105521633c_us_k
cusks114916053c_usks
cusp86021063c_us_p
cusps94913673c_usps
cuss65430613c_us_s
cusso74912293c_usso
cymbal15236913cymbal
daedal849083daedal
damsel9148033damsel
dorsal74613943dorsal
dossal75510303dossal
dual55928173_du_al
ducal84816423_ducal
dural64923893_dural
easel54521113ea_sel
equal1449823equ_al
facial113615633facial
faecal11359813faecal
fallal93612693fallal
farfal123410183farfal
fatal84819373fa_tal
faucals12326563faucals
faucial1257323faucial
fauna84816513fauna_
faunae95210373faunae
faunas94013633faunas
feudal1037683feudal
frugal1036393frugal
fugal95613033_fugal
fusel85218493_fusel
fusil84715323_fusil
gauss65613453gaus_s
gavial10310083gavial
gayal9312713ga_yal
hadal95518123ha_dal
haemal113811643haemal
halal85623593ha_lal
hallal94415563hallal
hamal104623103ha_mal
hammal134512063hammal
hansa85416783hansa_
hansas94616043hansas
hansel95214373hansel
hartal9415473hartal
hassel95614213hassel
haul75530453hau__l
hausen9610383hausen
housel95217043housel
jacal14313703ja_cal
jackal1937613jackal
joual12311653jou_al
jugal135612403_jugal
jural125120483_jural
labial84714343labial
lacunal9136553lacunal
laical8312323laical
larval948503larval
lauan55216793lau_an
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
laurel649033laurel
mammal95112753mammal
manual8313463manual
marsala939583marsala
marshal1238973marshal
masa65034713ma_sa_
masala8311813ma_sala
masas75630413ma_sas
massa75518923massa_
massas85116463massas
matsah1138233matsah
maul64830713mau__l
medusal1035183medusal
mensal84615653mensal
missal84314903missal
mural75225103_mural
narial6317953narial
narwal938943narwal
nasals63312463na_sals
nasial6413283nasial
natal53921493na_tal
natural739513natural
nausea637313nausea
nauseas735993nauseas
naval85315833na_val
naysay1234973naysay
neural6311993neural
noncausal1144353noncausal
nounal639813nounal
occlusal1242323occlusal
ousel55222403_ousel
paesan85114093paesan
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
paleal84716673paleal
palpal104112053palpal
paludal1035683paludal
papal95820673pa_pal
parral85517533parral
pascal10812373pascal
passel85117003passel
pause75021833paus_e
paused95114963paused
pauser84415963pauser
pauses84621473pauses
perusal939193perusal
plural839823plural
pupal97616873_pupal
quasar1536833quasar
racial83419243racial
radial74020393radial
ramal74622243ra_mal
rascal8511123rascal
ratal55025113ra_tal
recusal968673recusal
refusal1056893refusal
rugal65916093_rugal
rural55821173_rural
sabal75422483sa_bal
sacral83414413sacral
sal36462883___sal
salal55425703sa_lal
salsa56718923salsa_
salsas65316133salsas
sambal105215183sambal
sandal73317283sandal
sansar63613393sansar
sarsar63011843sarsar
saul45836523sau__l
sauna54117553sauna_
saunas63915433saunas
saurel6511983saurel
sausage847193sausage
scandal1038673scandal
sisal54217733_sisal
spousal965533spousal
squeal1538013squeal
sural55931263_sural
tahsil936343tahsil
tamal73522613ta_mal
tarnal63716503tarnal
tarsals72512603tarsals
tassel66014773tassel
taus46342733taus__
tubal75517203_tubal
tussal6288323tussal
unusual743943unusual
usual5310183__usual
vagal94613633va_gal
valval12398863valval
vandal103713833vandal
vasa76522973va_sa_
vassals1057953vassals
vaus75928923vaus__
versal93013753versal
visual938803visual
wadmal1237283wadmal
warsaw1236193warsaw
wassail1056133wassail
waul76927313wau__l

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164616.87316399.8
3Display Results4614610.1562955.1
 (SQL Overall)1786914617.16924925.5
 
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.