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

226 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
drams8602583(None) 
crams96229151crams
dams77444371d_ams
dirams94413701dirams
drabs85119671drabs
drags75521111drags
dram75832001dram_
drama85117411drama
dramas95814651dramas
drats66628371drats
draws95119371draws
drays95819771drays
dreams94513981dreams
drums85415871drums
grams85327311grams
prams96125511prams
rams65950771_rams
trams75327671trams
araks94820882araks
arame75026622arame
arames84622572arames
arms66137492ar_ms
arums75517832arums
bams87044452_bams
barms96128462barms
beams95328172beams
blams95023852blams
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breams104815042breams
brims94721622brims
cams87047282_cams
chams126028502chams
clams95127672clams
crabs95421392crabs
crags85622572crags
cram85635492cram_
cramp115120692cramp
cramps125615562cramps
craps95328642craps
crass76328042crass
craws105723122craws
creams104715252creams
dabs77139402d_abs
dads67442772d_ads
dags66642592d_ags
dahs88231812d_ahs
dais57040702d_ais
daks97130602d_aks
dals57145122d_als
dam67457042d_am_
dame77140312d_ame
dames85435852d_ames
damn75724322d_amn
damns84916922d_amns
damp96228842d_amp
damps105220412d_amps
dans56748142d_ans
daps77239162d_aps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
daws86638242d_aws
days87637132d_ays
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deems85421772deems
derats74625062derats
derays105514252derays
dermas94116812dermas
derms85022892derms
dhaks13479702dhaks
dhals95415442dhals
dials64925342dials
dims75435022d_ims
diram84419472diram_
dirhams13376312dirhams
doats65224882doats
doms76239572d_oms
dooms85321342dooms
dorms85723832dorms
doums85417642doums
drab76226452dra_b
drachms1534252drachms
draff125615662draff
draffs13617902draffs
draft95526682draft
drafts105012532drafts
drag64825052dra_g
drail65020972drail
drails74716952drails
drain65222892drain
drains73719402drains
drake104918302drake
drakes114715862drakes
drank104816202drank
drape85319632drape
drapes95419652drapes
drat56247832dra_t
drave95219272drave
draw85623012dra_w
drawl95516012drawl
drawls105511392drawls
drawn95614242drawn
dray85428092dra_y
dreads84115022dreads
dream85120392dream_
dreamt94615712dreamt
dreamy12509992dreamy
drears74614252drears
drees65628522drees
dregs76114862dregs
dreks105714742dreks
dress65319832dress
dribs85115052dribs
dries64733672dries
drips85417232drips
drops85719502drops
dross65418092dross
drubs85913832drubs
drugs75214652drugs
drum76521592drum_
dryads11436622dryads
drys86314802dr_ys
duads76515342duads
duals65620082duals
dumas85420432dumas
dunams937832dunams
duras65727722dura_s
durums948152durums
dyads10549972dyads
eras45441502era_s
exams14199082exams
farms106324952farms
flams105125012flams
foams105017952foams
forams115115912forams
frags96322162frags
frame105821802frame
frames115119862frames
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
gams76648882_gams
glams85822932glams
grabs85719692grabs
grads75625752grads
gram77034582gram_
grama85620272grama
gramas94317192gramas
gramp106218322gramp
gramps114114272gramps
grans64832542grans
grass66125202grass
grays95621332grays
hams96446132_hams
harms106829012harms
ihrams1137172ihrams
imams91511102imams
jams135231072_jams
jorams154810532jorams
lams66552262_lams
loams75619862loams
ogams84112682ogams
orals55826482orals
pams85641762_pams
praams10459642praams
pram85733492pram_
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prims95425932prims
proms95426402proms
rads56046602_rads
rags55448372_rags
rais45252622_rais
ram56867272_ram_
rami66034092_rami
ramp85934002_ramp
ramps96224632_ramps
ramus76418282_ramus
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
reams75729622reams
rems66237722_rems
rims65936302_rims
roams74919612roams
roms67038962_roms
rums64833472_rums
scams94423972scams
scrams105216622scrams
seams75731662seams
shams105829412shams
slams74927902slams
spams94922192spams
tams67247932_tams
teams75726512teams
tram67034552tram_
tramp96319772tramp
tramps105114452tramps
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
trims75021472trims
warms107726852warms
whams135515642whams
wraps105617152wraps
yams95330732_yams
zirams17438642zirams

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.1531167915.0
2DLD Change Limit538002261.78330173.9
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.99989390.2
 
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.