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

246 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
beams9532817(None) 
bams87044451b_ams
beads85429501beads
beaks115326621beaks
beam86939231beam_
beamy126218571beamy
beans75734691beans
bears75739041bears
beats76042241beats
beaus75127111beaus
bemas96424281bemas
berms95323661berms
blams95023851blams
breams104815041breams
reams75729621reams
seams75731661seams
teams75726511teams
abeam9316532abeam_
baals76122702baals
baas66844672b_aas
bads77048862b_ads
bags76645502b_ags
balms95723922balms
bals66354042b_als
bam78560142b_am_
bans66555132b_ans
baps86040842b_aps
barms96128462barms
bars66564092b_ars
bas58681752b_a_s
bass66146782b_ass
bats66962332b_ats
bays97143912b_ays
beach124623892beach
bead75937922bea_d
beady114719922beady
beak106534382bea_k
beaky146118022beaky
beamed115720732beamed
beamish14259292beamish
bean66443862bea_n
beano75421552beano
beanos85516512beanos
bear66844642bea_r
beard86024962beard
beards94116672beards
beast76338642beast
beasts84519722beasts
beat66168302bea_t
beau66137272bea_u
beaut75135212beaut
beauts86015282beauts
beaux146513212beaux
becalms1335742becalms
became123213162became
becaps123811402becaps
becks135522012becks
bedamn1137812bedamn
bedamns1235732bedamns
bedims1149592bedims
bedlams1237052bedlams
beds75937782be_ds
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beets76131442beets
begs75733832be_gs
begums11429492begums
belays114313852belays
beldams1237052beldams
bells76432162bells
bels66142492be_ls
belts75931162belts
bema85825252be_ma
bename103316072bename
benames112814602benames
bends85628972bends
benes75536232benes
bens65945702be_ns
bents76033692bents
bergs84718042bergs
berks115423122berks
berm86732752berm_
berme96022942berme
bermes106023002bermes
bes56557432be__s
beses75830722beses
besoms105712732besoms
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442be_ts
beys913829552be_ys
bias64738152bia_s
bimas95521742bimas
blabs95619632blabs
blahs105616512blahs
blam86131702blam_
blame95625492blame
blames105121862blames
blats75132502blats
blaws105620462blaws
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
boars75229602boars
boas66150832boa_s
boats75635152boats
booms95427122booms
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breads95419202breads
breaks124816422breaks
bream95121812bream_
brims94721622brims
bums85934592b_ums
cams87047282_cams
chams126028502chams
clams95127672clams
crams96229152crams
creams104715252creams
dams77444372_dams
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deems85421772deems
derms85022892derms
drams86025832drams
dreams94513982dreams
ears46356592_ears
eats47054872_eats
elms67322702_elms
ems56435492_e_ms
exams14199082exams
fears84829392fears
feats86432752feats
fems96428702fe_ms
flams105125012flams
fleams115011942fleams
foams105017952foams
gams76648882_gams
gears64628692gears
gems75329112ge_ms
germs85118872germs
geums85414112geums
glams85822932glams
gleams94812252gleams
grams85327312grams
haems105517012haems
hams96446132_hams
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
helms105619462helms
hems95534942he_ms
herms105626432herms
imams91511102imams
jams135231072_jams
jeans126022112jeans
keas86337092kea_s
lams66552262_lams
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
loams75619862loams
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
mems85931502me_ms
neaps75618322neaps
nears55529422nears
neats55931902neats
neems77316292neems
nemas75321572nemas
neums75414252neums
obeahs1135862obeahs
ogams84112682ogams
pams85641762_pams
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
perms95524512perms
prams96125512prams
rams65950772_rams
reads64835272reads
realms84913492realms
reals55038652reals
ream65841612ream_
reaps75626192reaps
rearms85114652rearms
rears54739652rears
rems66237722re_ms
roams74919612roams
scams94423972scams
seals54839692seals
seam66645972seam_
seamy105921272seamy
sears54744912sears
seas45755272sea_s
seats54844342seats
seems75525022seems
shams105829412shams
slams74927902slams
spams94922192spams
steams84916902steams
tams67247932_tams
teaks94222902teaks
teals56234132teals
team66238652team_
tears55436462tears
teas45851492tea_s
teats55636812teats
teems76019782teems
terms75523472terms
trams75327672trams
veals84926192veals
weals85428742weals
weans85326742weans
wears86030302wears
whams135515642whams
yams95330732_yams
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
zeals145320852zeals

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.0931921408.6
2DLD Change Limit538002462.00026900.0
3Display Results2462460.0633904.8
 (SQL Overall)1786912462.15682880.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.