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

187 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
foul7702758(None) 
afoul8510191afoul
foal76630921foal
foil76433911foil
fool75330591fool
fou66743781fou_
fouls87221431fouls
four76226861four
fowl105723631fowl
soul46435711soul
befoul1137252befoul
boil66335182boil
boll65634752boll
boule74828042boule
bout66353292bout
bowl96827702bowl
caul65630002caul
coal66939252coal
coil66439652coil
col59360352co_l
cool66940492cool
could86517712could
coup86729792coup
cowl97530812cowl
dol47150652do_l
doll56632492doll
doula65717772doula
doum76226672doum
dour56330432dour
doux125817982doux
fail74840242fail
fall75535312fall
farl76338552farl
fauld95214492fauld
fault85428312fault
faun76226622faun
faux146519072faux
feal713940422feal
feel75233842feel
fell76833072fell
feu67843662feu_
feud86523022feud
feus75830752feus
fil65447142f_il
fill75540192fill
flour84916452flour
flout86226202flout
flu66530212flu_
flub95721882flub
flue75329852flue
flus75626542flus
flux145617742flux
foals85721692foals
foam97127172foam
fob86748332fo_b
fobs96034272fobs
focal104917672focal
foci94521012foci
focus105815882focus
foe66350812fo_e
foes76543442foes
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohn106116552fohn
foils85025812foils
foin77231562foin
fold86528942fold
folk116021542folk
folly115022602folly
fon66352272fo_n
fond86330952fond
fons76943892fons
font77143752font
food86830572food
fools86824202fools
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
forum108318762forum
foss76431642foss
fouled104315972fouled
fouler93614902fouler
foully1239012foully
found94917842found
fount84727032fount
fours85521492fours
fowls115518892fowls
fox136737862fo_x
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frug86517102frug
fub86337392f_ub
fud76335152f_ud
fuel76824732fuel
fug76234512f_ug
full75229152full
fun66841142f_un
fur66637322f_ur
furl77030882furl
ghoul959052ghoul
goal55829302goal
gout56646002gout
gul45832792_gul
haul75530452haul
hour75827312hour
howl107625692howl
joual12311652joual
jouk156015992jouk
joule124918202joule
jowl146120302jowl
koel84519942koel
kohl113911712kohl
loll46128382loll
loud55228042loud
loup66028432loup
lour45430682lour
lout45952142lout
maul64830722maul
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
saul45836522saul
shul75823152shul
soil46138832soil
sol37256622so_l
sou37853692sou_
souk86127172souk
souls55127362souls
soup66232912soup
sour45935892sour
sous46947212sous
toil46536282toil
toll45535262toll
tolu45529152tolu
tool46735682tool
tour45530382tour
tout46753822tout
waul76927312waul
woful1158172woful
wool76427372wool
would95513152would
you66641822you_
your78623432your
yous76230652yous
yowl105820952yowl
zouk174413542zouk

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 Filter178691298720.283631417.0
2DLD Change Limit298721871.00029872.0
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.329134455.2
 
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.