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

446 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
social881333(None) 
asocial998651asocial
socials999631socials
aecial84817312aecial
asocials1075682asocials
coccal9310222coccal
eusocial1045462eusocial
facial113615632facial
fecial114714622fecial
focal104917672foc_al
jovial1636542jovial
local74820272loc_al
lochial1257082lochial
octal71214722_octal
racial83419242racial
sacral83414412sacral
serial64625852serial
sial45938832s__ial
soca66330052soc_a_
socas74026182soc_as
sociable1239502sociable
sociably1546792sociably
socially1338532socially
societal1045722societal
socman1039812socman
soil46138822so_i_l
somital939402somital
spacial1138762spacial
special11310302special
stoical9310272stoical
uncial83715222uncial
unsocial1046072unsocial
vocal104715642voc_al
aecia73819283aecia_
aerial64625713aerial
alodial899953alodial
aortal65217513aortal
apical10913903apical
atrial65418943atrial
audial7312993audial
axial124515193_axial
biocidal1344933biocidal
biosocial1344043biosocial
boccia12338793boccia_
boccias13307193boccias
boil66335183bo_i_l
boral75831703bo_ral
boreal84817213boreal
buccal1248243buccal
burial84117623burial
cecal94619113cec_al
chorial124214143chorial
ciao64924183__ciao
coal66939253__coal
coaxal15387303coaxal
coaxial16157003coaxial
cobia94117503cobia_
cobias104014973cobias
coca88030643coc_a_
cocain101315013cocain
cocas95926573coc_as
cocoa98517883cocoa_
cocoas104915743cocoas
coeval1138893coeval
coil66439653co_i_l
coital84117053coital
comal95125133co_mal
comical13312223comical
conceal113313013conceal
conchal144211583conchal
conical11316203conical
copal95621783co_pal
coral76033453co_ral
cordial10312933cordial
coria75828303coria_
corral83616253corral
costal85419513costal
cotidal1038453cotidal
coxal146116673co_xal
crucial1157893crucial
curial84019153curial
decal85523233dec_al
decimal1238083decimal
decrial10310323decrial
denial74720513denial
dial55935063__dial
dissocial1245393dissocial
docile94213123docile
domal85619203do_mal
domical1239373domical
dorsal74613943dorsal
dossal75510303dossal
dotal64919623do_tal
ducal84816423duc_al
ductal938993ductal
ecocidal1354963ecocidal
encinal949243encinal
eolian6312593eolian
eonian6311833eonian
epical10413393epical
epochal1445243epochal
especial1246293especial
espial839543espial
facia103218463facia_
faciae112913413faciae
facials123310743facials
facias113415803facias
fascial1258303fascial
faucial1257323faucial
fecal105119213fec_al
fecials123510333fecials
ferial94621253ferial
fetial95716193fetial
filial93013253filial
finial92814183finial
foal76630923fo__al
foci94521013foci__
foetal9311883foetal
foil76433913fo_i_l
folia83618933folia_
foliar93210973foliar
fontal9313143fontal
formal113215203formal
foveal1237703foveal
gavial10310083gavial
genial74917613genial
glacial1038143glacial
glial66715433_glial
goal55829303go__al
gonia64117533gonia_
gooral7310463gooral
goral65125753go_ral
horal86328673ho_ral
ilial55317833_ilial
incisal947373incisal
ischial1246423ischial
isoclinal1172663isoclinal
jacal14313703jac_al
jackal1937613jackal
joual12311653jo_ual
labial84714333labial
laical8312323laical
loca65527683loc_a_
locale83915653loc_ale
locals83714503loc_als
lochan1139093lochan
lochia1158313lochia_
loci66126283loci__
logia68116603logia_
logical1038513logical
loral55927823lo_ral
loreal63814313loreal
loyal84513483lo_yal
medial93819863medial
menial84223033menial
mesial84818083mesial
mocha1249923mocha_
mochas13310653mochas
mochila1446513mochila
modal85919233mo_dal
moil65534083mo_i_l
molal75120343mo_lal
moral75533433mo_ral
mortal84616853mortal
narial6317953narial
nasial6413283nasial
nodal64717793no_dal
nodical1049863nodical
noil46133243no_i_l
nominal92712373nominal
nonsocial1148193nonsocial
nopal75517103no_pal
noria55722183noria_
norias65518183norias
normal83213533normal
notal55221353no_tal
nounal639813nounal
nuchal11218873nuchal
obia67923103_obia_
obias76116853_obias
oca56731733_oc_a_
ocas66729633_oc_as
ocean71212963_ocean
ocicat101412813_ocicat
octad81510653_octad
octan71313483_octan
octyl10136063_octyl
offal1136243_offal
ogival1035873_ogival
ohia75719363_ohia_
ohias84415563_ohias
oil37452053_o_i_l
oomiac1037063oomiac
oomiak1235353oomiak
opal66923523_o_pal
oral47638123_o_ral
oriel54920423_oriel
oscine8311563oscine
oscula837293oscula
ossia53710403ossia_
osteal6312953osteal
ostia52315583ostia_
oval77119523_o_val
penial84120893penial
phial10313203_phial
pial65636703__pial
pical95524373pic_al
plical10411683plical
podia8415283podia_
portal84218463portal
postal84317533postal
psocid1137253psoci_d
psocids1234863psocids
rachial122012173rachial
radial74020393radial
rasorial848223rasorial
recital9412163recital
recoal84117973recoal
rectal84418133rectal
redial74923113redial
retial64724993retial
rial45938093__rial
rictal83113173rictal
roil46235293ro_i_l
royal85014703ro_yal
sabal75422483s_abal
sacra74516993sacra_
sacrals93311793sacrals
sahiwal1344443sahiwal
sail45447163s_ai_l
sal36462883s___al
salal55425703s_alal
sambal105215183sambal
samiel8313333samiel
sandal73317283sandal
scab85926713s_c_ab
scad75725763s_c_ad
scag76626893s_c_ag
scald84818123s_c_ald
scale74629143s_c_ale
scall74420373s_call
scalp95217983s_c_alp
scaly104718723s_c_aly
scam85932353s_c_am
scan65530453s_c_an
scar66434203s_c_ar
scat65848373s_c_at
schav1338313s_chav
schul102510413s_chul
scilla8310943s_cilla
scion72214993s_cion
scoria8513483scoria_
scoriae9310893scoriae
scotia8310783scotia_
scotias939733scotias
scowl1012012973s_cowl
scrag85916173s_crag
scram910621613s_cram
scrap97120403s_crap
scrawl11208083s_crawl
scribal1137963scribal
scull75315763s_cull
seal45654373s__eal
seconal9310073seconal
secpar1037923secpar
seminal91213403seminal
sendal73314993sendal
sepal77723003s_epal
sepia75318673sepia_
sepias83616103sepias
septal84513383septal
serail64222673serail
seral56336383s_eral
serials73919743serials
serval93913413serval
setal56430903s_etal
sexual1338413sexual
sheal84927703s_heal
sheila969843sheila
shiel811023773s_hiel
shill85325333s_hill
shoal83920263s_hoal
shrill94712303shrill
sials54227243s__ials
siccan1037593siccan
sigil63515503sigi_l
signal73711483signal
sill45545153s__ill
simian8811153simian
sisal54217733s_isal
skill94316723s_kill
skirl96012913s_kirl
skoal93811453s_koal
snail57020203snai_l
soak87227663so__ak
soap65831133so__ap
soar46838673so__ar
soba64927923so_ba_
sobas74424253so_bas
sobful1136333sobful
socage91012123socage
soccage1236283soccage
soccer1038543soccer
sociables1344963sociables
socialise1148733socialise
socialism1348663socialism
socialist11411393socialist
socialite1148503socialite
sociality1447953sociality
socialize2048823socialize
society1236083society
sock105233213soc__k
socked134721503socked
socket123923523socket
socking143518603socking
sockman1535663sockman
socko115215113soc_ko
socks114926083soc_ks
socle7419573soc_le
socles8418453socles
socmen1039193socmen
soda56329383so_da_
sodas64123543so_das
sodic84917483sodi_c
sodium92111443sodium
sofa75625603so_fa_
sofar86115493so_far
sofas85320713so_fas
softa86415183softa_
softas94410403softas
soils55327983so_ils
soja115619513so_ja_
sojas124716393so_jas
sokol94612283so_kol
sol37256623so___l
sola45541863so_la_
solan55328153so_lan
solar55927343so_lar
soldan73511853soldan
solgel737963solgel
soli46637003soli__
solid65025073soli_d
solidi73813153solidi
solidly1137353solidly
solids74116403solids
soling74226823soling
solion6616383solion
soma65635293so_ma_
soman75024903so_man
somas76030373so_mas
somite84519373somite
sonar56523423so_nar
sonic75225283soni_c
sonics84315633sonics
sopite84917713sopite
sora45746913so_ra_
soras55041013so_ras
sorel56231443so_rel
sori46039833sori__
soring74731883soring
sororal7310653sororal
sorrel6413543sorrel
sorta57125413sorta_
sotol54917643so_tol
soucar839323soucar
soudan73210353soudan
soul46435713so__ul
soviet9720153soviet
sovran937153sovran
sowar85821343so_war
sowcar1135863sowcar
sowing104222913sowing
soya75724433so_ya_
soyas84520913so_yas
sozin14514523sozi_n
sozine15712343sozine
sozins15510783sozins
spail74921553spai_l
spatial9310323spatial
specials1238033specials
speil75618643spei_l
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
spiel74623913s_piel
spill74821163s_pill
spinal84915313spinal
spiral83715343spiral
spital83813873spital
spoil75818643spoi_l
sponsal946333sponsal
sporal82915453sporal
spousal965533spousal
squeal1538013squeal
squill1537223squill
statal61613223statal
steal56125473s_teal
stibial946583stibial
still54922073s_till
stomal85213313stomal
stria55723203stria_
striae65422273striae
subsocial1345823subsocial
succah1336643succah
suicidal1146073suicidal
sulcal8311273sulcal
sundial859863sundial
sural55931263s_ural
swail86217163swai_l
swill83417373s_will
swirl84514143s_wirl
synovial1444743synovial
tectal83713253tectal
telial65815363telial
tibial849833tibial
tical76021493tic_al
toil46536283to_i_l
tombal102311023tombal
tonal53724303to_nal
topical1139953topical
total55321823to_tal
toxical1637643toxical
trial54926353_trial
trochal1288243trochal
uncia75015163uncia_
unciae83215313unciae
uncials92510523uncials
uncinal959963uncinal
urial54823023_urial
uxorial1446323uxorial
venial94218283venial
vial76731093__vial
vicinal12268543vicinal
vocab12409973voc_ab
vocals113811583voc_als
voila84813943vo_ila
xenial133414903xenial
zoarial1646923zoarial
zocalo1735803zoc_alo
zodiac1835303zodiac
zoeal144813783zo_eal
zoecia1735553zoecia_
zonal145116853zo_nal
zooidal1745083zooidal
zoonal1558083zoonal
zoril143916693zori_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 Limit1127164466.84316471.7
3Display Results4464460.1433118.9
 (SQL Overall)1786914467.12625075.9
 
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.