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

183 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
fouls8722143(None) 
foals85721691foals
foils85025811foils
fools86824201fools
foul77027581foul_
fours85521491fours
fowls115518891fowls
souls55127361souls
afoul8510192afoul_
befouls1236052befouls
boils75427192boils
bolls75531312bolls
bolus79125542bolus
boule74828042boule
boules84925972boules
bouts75131312bouts
bowls106121432bowls
cauls75727772cauls
coals76129602coals
coils75030082coils
cols66553082co_ls
cools75632632cools
could86517712could
coulis84018762coulis
coups95522472coups
cowls106922212cowls
dolls66126922dolls
dols56943052do_ls
doula65717772doula
doulas75114992doulas
doums85417642doums
fails85631482fails
falls85727652falls
farls85731112farls
fauld95214492fauld
faulds10438962faulds
fault85428312fault
faults94513552faults
fauns84516752fauns
feels85223042feels
fells85327382fells
feuds95914882feuds
feus75830752feu_s
fills84632372fills
fils75838692f_ils
flours94414052flours
flouts94315272flouts
flubs105515442flubs
flues84626922flues
flus75626542flu_s
foal76630922foal_
foams105017952foams
fobs96034272fo_bs
focus105815882focus
foes76543442fo_es
fogs87035002fo_gs
fohns117310782fohns
foil76433912foil_
foins85523382foins
fold86528942fo_ld
folds95221692folds
folk116021542fo_lk
folks126017122folks
folles93820472folles
follis93113902follis
folly115022602folly
fonds95824822fonds
fons76943892fo_ns
fonts86124752fonts
foods95924162foods
fool75330592fool_
foots85528282foots
fops96532682fo_ps
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
forums114611842forums
foss76431642fo_ss
fou66743782fou__
fouled104315972fouled
fouler93614902fouler
foulest10313312foulest
foully1239012foully
found94917842found
founds104814192founds
fount84727032fount
founts94313382founts
four76226862fou_r
fowl105723632fowl_
foxes156321092foxes
foys105628292fo_ys
frugs96114282frugs
fubs96328792f_ubs
fuds86528562f_uds
fuels87117352fuels
fugs85730692f_ugs
full75229152f_ull
fulls84623522fulls
funs75235732f_uns
furls85322052furls
furs76735042f_urs
fuss76027932f_uss
ghouls1036042ghouls
goals65521292goals
gouts64826172gouts
guls55930852_guls
hauls86123732hauls
hols76946292ho_ls
hours85422392hours
howls116219222howls
jouals1338922jouals
jouks165612342jouks
joule124918202joule
joules134116822joules
jowls156214522jowls
koels94613902koels
kohls12437802kohls
lolls512121732lolls
louis57322322louis
loups75319622loups
lours55125292lours
louts56330272louts
mauls76524952mauls
moguls948552moguls
moils76125752moils
molls75129782molls
mols65948572mo_ls
mools76027172mools
moues75732842moues
mould86015752mould
moulds94910992moulds
moult74728722moult
moults84713702moults
noels56418702noels
noils55024332noils
nouns56717312nouns
nous46136982nou_s
oils46337972_oils
ouds56430102_ouds
ours47237562_ours
outs45746962_outs
owls76022932_owls
polls74627722polls
pols66044562po_ls
pools74427702pools
poufs105616062poufs
poult76928872poult
poults84613482poults
pours74623182pours
pouts75530322pouts
puls65437562_puls
roils54826792roils
rolls55326232rolls
rotls55620162rotls
roues56039352roues
roups75118902roups
routs57133412routs
sauls55128122sauls
shuls85319712shuls
soils55327982soils
sols45448162so_ls
solus54726982solus
souks94820522souks
soul46435712soul_
soups75322942soups
sours55230502sours
sous46947212sou_s
toils54527492toils
tolls54728432tolls
tolus55024482tolus
tools55325242tools
tours55325892tours
touts54830392touts
wauls86120552wauls
wools84421462wools
would95513152would
yours85217882yours
yous76230652you_s
yowls115715432yowls
zouks184410502zouks

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.313570897.8
2DLD Change Limit538001831.59333772.8
3Display Results1831830.0463978.3
 (SQL Overall)1786911831.95291542.5
 
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.