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

178 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
foams10501795(None) 
flams105125011flams
foals85721691foals
foam97127171foam_
foamy135313201foamy
forams115115911forams
forms105327051forms
loams75619861loams
roams74919611roams
bams87044452_bams
beams95328172beams
blams95023852blams
boars75229602boars
boas66150832boa_s
boats75635152boats
booms95427122booms
cams87047282_cams
chams126028502chams
clams95127672clams
coals76129602coals
coats75635002coats
comas95833002comas
corms95626222corms
crams96229152crams
dams77444372_dams
defoams1336192defoams
doats65224882doats
doms76239572do_ms
dooms85321342dooms
dorms85723842dorms
doums85417642doums
drams86025832drams
exams14199082exams
fabs98635862f_abs
fads86939872f_ads
fags86939122f_ags
fame95639392f_ame
fames105735922f_ames
fans76247372f_ans
farms106324952farms
fas68262932f_a_s
fats76252502f_ats
fays108535362f_ays
fears84829392fears
feats86432752feats
fems96428702f_ems
fiars86720832fiars
fiats85324482fiats
films105617962films
firms105217422firms
flabs105818642flabs
flags95321282flags
flam96333292flam_
flame105124442flame
flames114723692flames
flamy135217472flamy
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
fleams115011942fleams
floats96816252floats
foal76630922foa_l
foamed126014402foamed
foamer114714312foamer
foamers123812102foamers
fobs96034272fo_bs
focus105815882focus
foes76543442fo_es
fogs87035002fo_gs
fohns117310782fohns
foils85025812foils
foins85523382foins
folds95221692folds
folks126017122folks
fonds95824822fonds
fons76943892fo_ns
fonts86124752fonts
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682fo_ps
foram105124932foram_
forays124813002forays
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
foss76431642fo_ss
fouls87221432fouls
fours85521492fours
fowls115518892fowls
foxes156321092foxes
foys105628292fo_ys
frags96322172frags
frame105821802frame
frames115119862frames
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
gams76648882_gams
glams85822932glams
gloams95210662gloams
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gorms85619592gorms
grams85327312grams
hams96446132_hams
hoars85925552hoars
holms105117802holms
imams91511112imams
jams135231072_jams
jorams154810532jorams
koans95818622koans
koas85635092koa_s
lams66552262_lams
loads65323372loads
loafs85616992loafs
loam65630482loam_
loamy105913342loamy
loans56026462loans
looms75124642looms
moans74624372moans
moas65545342moa_s
moats75827642moats
moms86539482mo_ms
nomas74726412nomas
noms65636402no_ms
norms76019312norms
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oats46554212_oats
ofays11488922ofays
ogams84112682ogams
ohms95514032_ohms
oms56337512_o_ms
pams85641762_pams
poems95715552poems
poms87037742po_ms
prams96125512prams
rams65950772_rams
reams75729622reams
roads66523622roads
roam67132412roam_
roans54926442roans
roars55622242roars
roms67038962ro_ms
rooms75324682rooms
scams94423972scams
seams75731662seams
shams105829412shams
slams74927902slams
soaks95220292soaks
soaps75120712soaps
soars54732512soars
somas76030372somas
soms66239372so_ms
spams94922192spams
tams67247932_tams
teams75726512teams
toads65621072toads
toms68343492to_ms
trams75327672trams
whams135515642whams
woads94818442woads
worms105320762worms
yams95330732_yams
zooms164415522zooms

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 Limit538001781.59333772.8
3Display Results1781780.0463869.6
 (SQL Overall)1786911781.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.