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

191 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
roams7491961(None) 
foams105017951foams
loams75619861loams
rams65950771r_ams
reams75729621reams
roads66523621roads
roam67132411roam_
roans54926441roans
roars55622241roars
roms67038961ro_ms
rooms75324681rooms
aromas81018612aromas
bams87044452_bams
beams95328172beams
blams95023852blams
boars75229602boars
boas66150832boa_s
boats75635152boats
booms95427122booms
breams104815042breams
broads94515152broads
brooms104915872brooms
cams87047282_cams
chams126028502chams
clams95127672clams
coals76129602coals
coats75635002coats
comas95833002comas
corms95626222corms
crams96229152crams
creams104715252creams
croaks125812982croaks
dams77444372_dams
doats65224882doats
doms76239572do_ms
dooms85321342dooms
dorms85723842dorms
doums85417642doums
drams86025832drams
dreams94513982dreams
exams14199082exams
flams105125012flams
foals85721692foals
foam97127172foam_
foamy135313202foamy
forams115115912forams
forms105327052forms
gams76648882_gams
glams85822932glams
gloams95210662gloams
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gorms85619592gorms
grams85327312grams
groans74815062groans
groats74816652groats
grooms94512522grooms
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
ogams84112682ogams
ohms95514032_ohms
oms56337512_o_ms
orals55826482orals
pams85641762_pams
poems95715552poems
poms87037742po_ms
praams10459642praams
prams96125512prams
proas75028802proa_s
proems104711162proems
proms95426412pro_ms
rads56046602r_ads
rags55448372r_ags
rais45252622r_ais
ram56867272r_am_
rami66034092r_ami
ramp85934002r_amp
ramps96224632r_amps
ramus76418282r_amus
raps66247732r_aps
ras37575392r_a_s
rats46260372r_ats
raws75238212r_aws
rays77642352r_ays
reads64835272reads
realms84913492realms
reals55038652reals
ream65841612ream_
reaps75626192reaps
rearms85114652rearms
rears54739652rears
rems66237722r_ems
rials55026672rials
rias45540592ria_s
rims65936302r_ims
roach105717002roach
road56332112roa_d
roamed95215092roamed
roamer84715162roamer
roamers93713462roamers
roan47234202roa_n
roar46328572roa_r
roast56230142roast
roasts64915412roasts
robes75133302robes
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rodes614039082rodes
rods56442062ro_ds
roes45954142ro_es
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
rom59855632ro_m_
roman75424822roman
romans84620242romans
romp85926572ro_mp
romps94617542romps
roods65125282roods
roofs85321152roofs
rooks95325042rooks
room66235082room_
roomy107118062roomy
roots55933672roots
ropes75940062ropes
roses56445772roses
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
roues56039352roues
roups75118902roups
routs57133412routs
roves84834482roves
rowans95715342rowans
rows75941752ro_ws
royals93711262royals
rums64833472r_ums
ryas77224612rya_s
scams94423972scams
seams75731662seams
shams105829412shams
slams74927902slams
soaks95220292soaks
soaps75120712soaps
soars54732512soars
somas76030372somas
soms66239372so_ms
spams94922192spams
tams67247932_tams
teams75726512teams
toads65621072toads
toms68343492to_ms
trams75327672trams
troaks104410602troaks
vrooms11398712vrooms
whams135515642whams
woads94818442woads
worms105320762worms
yams95330732_yams
zooms164415522zooms

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.296603685.8
2DLD Change Limit538001911.65632487.9
3Display Results1911910.0633031.7
 (SQL Overall)1786911912.01588680.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.