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

258 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
soul4643571(None) 
foul77027581foul
saul45836521saul
shul75823151shul
soil46138821soil
sol37256621so_l
sou37853691sou_
souk86127171souk
souls55127361souls
soup66232911soup
sour45935891sour
sous46947211sous
afoul8510192afoul
boil66335182boil
boll65634752boll
boule74828042boule
bout66353292bout
bowl96827702bowl
caul65630002caul
coal66939252coal
coil66439652coil
col59360352co_l
cool66940492cool
could86517712could
coup86729792coup
cowl97530812cowl
dol47150652do_l
doll56632492doll
doula65717772doula
doum76226672doum
dour56330432dour
doux125817982doux
ensoul638252ensoul
foal76630922foal
foil76433912foil
fool75330592fool
fou66743782fou_
fouls87221432fouls
four76226862four
fowl105723632fowl
ghoul959052ghoul
goal55829302goal
gout56646002gout
gul45832792_gul
haul75530452haul
hour75827312hour
howl107625692howl
insoul638462insoul
joual12311652joual
jouk156015992jouk
joule124918202joule
jowl146120302jowl
koel84519942koel
kohl113911712kohl
loll46128382loll
loud55228042loud
loup66028432loup
lour45430682lour
lout45952142lout
maul64830712maul
mogul8310212mogul
moil65534092moil
mol56654592mo_l
moll66735702moll
mool67533862mool
moue65835572moue
mould86015752mould
moult74728722moult
noel45226552noel
noil46133242noil
noun45724182noun
nous46136982nous
oil37452052_oil
oud47439072_oud
our36042892_our
out38072152_out
owl66228972_owl
pol56449382po_l
poll66332132poll
pool65835952pool
pouf95732642pouf
poult76928872poult
pour611527472pour
pout65752552pout
pul56138062_pul
roil46235292roil
roll46331652roll
rotl45029682rotl
roue45941742roue
roup66627692roup
rout46153282rout
roux117419362roux
sail45447162sail
sal36462882s_al
sall44544682sall
sau36356572sau_
sauls55128122sauls
sault55834962sault
schul102510412schul
scour75315532scour
scout75031452scout
scowl1012012972scowl
scud76221282scud
sculk115112462sculk
scull75315762scull
sculp95314842sculp
scum85924522scum
scup84822382scup
scut65835542scut
seal45654372seal
seel45042982seel
sel38253322s_el
sell45840612sell
shaul85418102shaul
shoal83920262shoal
shool84523142shool
shorl84720242shorl
should1038022should
shout85433162shout
shuln84713112shuln
shuls85319712shuls
shun75122772shun
shut76137582shut
sial45938832sial
sill45545152sill
skoal93811452skoal
skua86113152skua
skulk8479622skulk
skull94812032skull
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
smug75815262smug
smut66629782smut
snool55118642snool
snout54530632snout
snub65320762snub
snug55218692snug
so28855442so__
soak87227662soak
soap65831132soap
soar46838672soar
sob57857942so_b
soba64927922soba
sobful1136332sobful
sobs64941752sobs
soca66330052soca
sock105233212sock
socle7419572socle
sod46053702so_d
soda56329382soda
sods54940212sods
sofa75625602sofa
soft76942822soft
soils55327982soils
soja115619512soja
soke85436262soke
sokol94612282sokol
sola45541862sola
sold54837412sold
sole46053672sole
soli46637002soli
solo45538942solo
sols45448162sols
solum74717602solum
solus54726982solus
som59153802so_m
soma65635292soma
some66040382some
soms66239372soms
son37761952so_n
sone46649982sone
song55133672song
sonly85718052sonly
sons46049552sons
sook84933392sook
soon46240502soon
soot45761052soot
sop57557862so_p
soph97024202soph
sops65244562sops
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sorel56231442sorel
sori46039832sori
sorn46641062sorn
sort46264812sort
sorus54527582sorus
sos37761602so_s
sot310384292so_t
soth75932512soth
sotol54917642sotol
sots45552442sots
sough95320462sough
souks94820522souks
souled75419822souled
sound64420022sound
soups75322942soups
soupy106115402soupy
sourly93612202sourly
sours55230502sours
souse56530772souse
south85223572south
sow66554762so_w
sown75127452sown
sows75342492sows
sox106444192so_x
soy67851452so_y
soya75724432soya
soys75233932soys
soyuz1748852soyuz
spoil75818642spoil
spool75219042spool
spout75029632spout
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
stool55619892stool
stoup75517072stoup
stour54916742stour
stout57434052stout
stub66221842stub
stud56220092stud
stull54916272stull
stum65526012stum
stun45623452stun
sub55445552s_ub
sue35651462s_ue
suk75632972s_uk
sulk85326652s_ulk
sulu45128422s_ulu
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
swoun84811492swoun
swum96416822swum
toil46536282toil
toll45535262toll
tolu45529152tolu
tool46735682tool
tour45530372tour
tout46753822tout
waul76927312waul
woful1158172woful
wool76427372wool
would95513152would
you66641822you_
your78623432your
yous76230652yous
yowl105820952yowl
zouk174413542zouk

Search took 3 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 Filter178691298720.0802233637.5
2DLD Change Limit298722581.96615194.3
3Display Results2582580.0803225.0
 (SQL Overall)1786912582.12684050.3
 
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.