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

212 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
fools8682420(None) 
cools75632631cools
foals85721691foals
foils85025811foils
foods95924161foods
fool75330591fool_
foots85528281foots
fouls87221431fouls
fowls115518891fowls
mools76027171mools
pools74427701pools
tools55325241tools
wools84421461wools
awols84713522awols
befools1236432befools
boils75427192boils
bolls75531312bolls
bolos75531372bolos
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
boots75837972boots
bowls106121432bowls
coals76129602coals
coils75030082coils
cols66553082_cols
coofs105924712coofs
cooks115429142cooks
cool66940492cool_
cooly105525422cooly
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
cowls106922212cowls
diols65521012diols
dolls66126922dolls
dols56943052_dols
dooly94821802dooly
dooms85321342dooms
doors65022132doors
drools74412812drools
enols54718402enols
fails85631482fails
falls85727652falls
farls85731112farls
feels85223042feels
fells85327382fells
feods99516852feods
fills84632372fills
filos86125382filos
fils75838692f_ils
flocs105519232flocs
floes85528142floes
flogs95919962flogs
floods104511652floods
floors94112352floors
flops105920142flops
floss85118262floss
flows115822362flows
foal76630922foal_
foams105017952foams
fobs96034272f_obs
focus105815882focus
foes76543442f_oes
fogs87035002f_ogs
fohns117310782fohns
foil76433912foil_
foins85523382foins
fold86528942f_old
folds95221692folds
folk116021542f_olk
folks126017122folks
folles93820472folles
follis93113902follis
folly115022602folly
fonds95824822fonds
fons76943892f_ons
fonts86124752fonts
food86830572foo_d
fooled104317822fooled
foolish1339612foolish
foot76248012foo_t
footle93914382footle
footles103715712footles
footsy12587932footsy
footy115820532footy
foozle18369202foozle
foozles19329542foozles
fops96532682f_ops
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
formols12299412formols
forms105327052forms
forts86034452forts
foss76431642f_oss
foul77027582foul_
fours85521492fours
fowl105723632fowl_
foxes156321092foxes
foys105628292f_oys
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
fuels87117352fuels
fulls84623522fulls
furls85322052furls
gaols66717572gaols
goals65521292goals
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
hols76946292_hols
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hooly115022222hooly
hoops105621072hoops
hoots84830252hoots
howls116219222howls
idols65514132idols
jowls156214522jowls
koels94613902koels
kohls12437802kohls
kolos94921212kolos
kooks85217262kooks
lolls512121732lolls
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loo_s
loots55431422loots
moils76125752moils
molls75129782molls
mols65948572_mols
moods85224622moods
mool67533862mool_
moola75117032moola
moolas83615592moolas
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
noels56418702noels
noils55024332noils
nolos54423352nolos
nooks95420392nooks
noons54125282noons
obols73715862obols
oils46337972_oils
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
owls76022932_owls
polls74627722polls
polos76129912polos
pols66044562_pols
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pool65835952pool_
poons75430972poons
poops94422412poops
poos65949112poo_s
roils54826792roils
rolls55326232rolls
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rotls55620162rotls
shools94919012shools
snools65715882snools
soils55327982soils
sokols10399092sokols
solos54830792solos
sols45448162_sols
sooks94425452sooks
soots55536212soots
sotols63714472sotols
souls55127362souls
spools85115912spools
stools65117022stools
toils54527492toils
tolls54728432tolls
tool46735682tool_
toons55027532toons
toots55331872toots
viols86118102viols
woods95723032woods
woofs114918002woofs
wool76427372wool_
wooly114417672wooly
woops104917522woops
woos76238802woo_s
yowls115715432yowls
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

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 Filter178691538000.343520965.0
2DLD Change Limit538002121.58034050.6
3Display Results2122120.0603533.3
 (SQL Overall)1786912121.98390111.4
 
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.