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

338 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
dries6473367(None) 
bries74942151bries
cries75438401cries
dies55653521d_ies
dories75232361dories
drees65628521drees
dribs85115061dribs
dried75321381dried
drier64423961drier
driers74516731driers
driest74722751driest
drips85417231drips
drives105117111drives
fries85535601fries
pries74339531pries
tries55742811tries
wries85827741wries
aeries64737782aeries
amies76837692amies
ares45871022ar_es
arias55438022arias
ariel55228972ariel
ariels65119372ariels
arils58732202arils
arise56436432arise
arises65233802arises
arles56735742arles
armies85123692armies
arses55733872arses
braes75735052braes
brees75632552brees
bribes105918532bribes
brides94423512brides
brie65837902brie_
brief105422602brief
briefs115510072briefs
brier74527402brier
briers85319732briers
brigs85823222brigs
brims94721622brims
brines85028852brines
brins75533972brins
brios74725722brios
bris65539612bri_s
brises84927612brises
briss75824272briss
brits76433082brits
buries84633272buries
caries85147622caries
cires74932912cires
cribs94516752cribs
cried84624282cried
crier74724462crier
criers83918582criers
crimes105521582crimes
cripes105120872cripes
cris66233432cri_s
crises84529432crises
crits75527572crits
curies84934022curies
daces85030682daces
dairies84217732dairies
dais57040702dai_s
daises74318982daises
dales66439742dales
dames85435852dames
darbies104216982darbies
dares66146702dares
darics94314112darics
darkies124015752darkies
dates65639152dates
davies105020512davies
dazes155024142dazes
dearies83526272dearies
decries103319802decries
dees56356632d_ees
defies104624052defies
deices94119372deices
deils65722862deils
dekes105224452dekes
deles65139252deles
demes86032692demes
demies94825802demies
denes65639722denes
denies74729642denies
derbies103016052derbies
derides93420852derides
derives114017812derives
derries83124622derries
dexes135224512dexes
dexies145018342dexies
diaries83321952diaries
dibs76233682d_ibs
dices86434242dices
didies84621832didies
die46759652d_ie_
died66137852d_ied
diel59034602d_iel
diet57357532d_iet
diets66026642d_iets
difs86027322d_ifs
digs66036052d_igs
dikes105831332dikes
dimes85833042dimes
dims75435022d_ims
dines66449152dines
dins56652042d_ins
dips75536912d_ips
dire56644142dire_
direr64927072direr
direst75024242direst
dirges84915102dirges
dirks105619522dirks
dirls64720502dirls
dirties83119382dirties
dirts66824462dirts
dis46459892d_i_s
diss56434482d_iss
dites66339152dites
dits56450522d_its
dives95832402dives
djins1368452djins
dobies94422092dobies
does56554472d_oes
doges75630162doges
dogies85022252dogies
doits66223672doits
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dowries114413982dowries
doxies143917852doxies
dozes155226302dozes
drabs85119672drabs
drags75521112drags
drails74716952drails
drains73719402drains
drakes114715862drakes
drams86025832drams
drapes95419652drapes
drats66628372drats
draws95119372draws
drays95819772drays
dree56638322dr_ee
dreed75222842dreed
dreg66821652dr_eg
dregs76114862dregs
drek96321092dr_ek
dreks105714752dreks
dress65319832dress
drest65530342dr_est
drew86221672dr_ew
drib76823262dri_b
driegh11254562driegh
drift95722842drift
drifts10499892drifts
drill64718262drill
drills74414202drills
drily95816522drily
drink106816382drink
drinks116810712drinks
drip76223952dri_p
dript86923872dript
drive95318002drive
drivel105110382drivel
drivels11397922drivels
driven105210142driven
driver104714492driver
drivers114412792drivers
droids84712582droids
droits74314312droits
drones75023432drones
drops85719502drops
dross65418092dross
droves105116672droves
drubs85913832drubs
drugs75214652drugs
druids8368092druids
drums85415872drums
drupes94912652drupes
druse64817662druse
druses75517252druses
dryer95111462dryer
dryers10449272dryers
dryest104811122dryest
drys86314802dr_ys
duces86327472duces
dudes75424372dudes
dues56045502d_ues
duits65021882duits
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
dures65635922dures
durries83817352durries
duties74921902duties
dwines105013102dwines
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
eddies83313162eddies
ernes55224812ernes
erses55826802erses
eyries93816812eyries
fires85740752fires
flies85630712flies
frees86131392frees
fried95322912fried
frier85225842frier
friers94718932friers
friges104116482friges
frigs96019272frigs
frise85322452frise
frises94124272frises
frites94922482frites
frits86129102frits
frizes184015462frizes
froes86126692froes
furies95126372furies
gies55641422_gies
grees65132472grees
grides84422362grides
grids75321392grids
grief95319782grief
griefs10418722griefs
grigs75318192grigs
grimes94619032grimes
grins65427222grins
gripes94619872gripes
grips85520132grips
grits65529582grits
grues65721962grues
hies74842832_hies
hires86134342hires
ires45639282ir_es
irides74519122irides
irids66417772irids
iris45732552iri_s
irises64221172irises
ivies84215762ivies
juries134120632juries
kris86423602kri_s
krises105016082krises
kyries133411372kyries
lies46454192_lies
lories64933042lories
mires75640882mires
ores46056682or_es
orgies72316092orgies
oriel54920422oriel
oriels64914622oriels
orles55326212orles
paries84742512paries
pies66949602_pies
plies74526512plies
prees75937172prees
prices104524542prices
prides94324182prides
pried84426862pried
prier75027762prier
priers84521192priers
priest84125422priest
prigs85219702prigs
primes104225262primes
prims95425932prims
prise74632612prise
prises84133172prises
priss74623892priss
prizes173819812prizes
redries83721712redries
rees45364192_rees
reis45343232_reis
res35565042_r_es
rias45540592_rias
ribes75530172_ribes
ribs65833022_ribs
rices75536152_rices
rides66140812_rides
rids56539552_rids
riel46432382_riel
riels55121332_riels
rifs74929002_rifs
rigs55137592_rigs
riles55343642_riles
rimes75634542_rimes
rims65936302_rims
rins46153192_rins
ripes75435772_ripes
rips66237432_rips
rise45945232_rise
rises55244042_rises
rites54442552_rites
rives85336002_rives
roes45954142_roes
rues46044482_rues
ryes75529352_ryes
scries85226822scries
series64540972series
shies86136552shies
sires55945372sires
skies95026832skies
spies76037622spies
sris45434152sri_s
sties55132982sties
ties45248312_ties
tires55437492tires
tories65435882tories
trees55835762trees
tres46542902tr_es
tribes85119022tribes
trices84826332trices
tried65026912tried
triens65417542triens
trier54328532trier
triers64321522triers
trigs65423062trigs
trikes105419492trikes
trims75021472trims
trines64132562trines
trios55528092trios
tripes85324872tripes
trips74923362trips
trues54925322trues
updries10209082updries
urges64619912urges
urines64724122urines
varies94330872varies
vies75238622_vies
vires84529682vires
wires86034912wires
wried95518562wried
wrier84521752wrier
wriest94419712wriest
writes94420332writes
writs86624382writs

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 Limit538003381.50035866.7
3Display Results3383380.0933634.4
 (SQL Overall)1786913381.90693751.8
 
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.