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

247 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
dower9502770(None) 
bower107328181bower
cower104531771cower
doer57734701do_er
doper86128391doper
doser66228561doser
doter65428621doter
dowed104632611dowed
dowel95618191dowel
dowers104523291dowers
dowery134311661dowery
downer104414921downer
dowser104716081dowser
dozer158419271dozer
lower85830411lower
mower104523451mower
power105325951power
rower85430491rower
sower85229311sower
tower85729201tower
vower115220791vower
adorer74713442adorer
avower1236822avower
blower115316572blower
boner75133082boner
borer75131272borer
bowed114533422bowed
bowel105621202bowel
bowers115523702bowers
bowery146012112bowery
bowler114217312bowler
bowyer14368922bowyer
boxer145016522boxer
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cover105430772cover
cowed115637842cowed
cowers114625532cowers
cowier113616162cowier
coyer105222842coyer
crower114117552crower
darer65230792darer
dater65332312dater
dawed106222812dawed
dawen95413722dawen
deer56739022d_eer
defer94619752defer
deter65028042deter
dewar95817732dewar
dewed105020302dewed
dewier104013462dewier
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
dobber114015412dobber
docker134417652docker
dodder94712912dodder
dodger95817042dodger
doe47361952do_e_
doers65225712do_ers
does56554472do_es
doffer133911352doffer
doge66233802doge_
dogear838192dogear
doges75630162doges
dogey105719512dogey
dogger95216782dogger
dole56550002dole_
doled75430912doled
doles67843752doles
dolor67617962dolor
dome77240732dome_
domed95423262domed
domes85735562domes
done55747912done_
donee66931012donee
donor64418192donor
door56928512do_or
doozer163910462doozer
dope76038892dope_
doped95326712doped
dopers95522482dopers
dopes84935042dopes
dopey116020352dopey
dopier93515922dopier
dor47253922do__r
dore56353302dore_
dormer94415892dormer
dorper94314562dorper
dorr56627722do_rr
dorser74819172dorser
dose56442432dose_
dosed76626912dosed
dosers75723632dosers
doses65938502doses
dosser74417972dosser
dote55442882dote_
doted75227072doted
doters74423912doters
dotes65836692dotes
dotier73917032dotier
dotter74419342dotter
dour56330432do_ur
dourer74215272dourer
douser75621632douser
dove85131562dove_
doven94718552doven
doves94728152doves
dow76749972dow__
dowager1245802dowager
dowdier12328572dowdier
dowdy136112542dowdy
dowels104813342dowels
dowered122811552dowered
dowie94721142dowie
down86427492dow_n
downed115314782downed
downers113912772downers
downier11299702downier
downs94918572downs
downy125714552downy
dowry126312482dowry
dows85941052dow_s
dowse96020812dowse
dowsed115015012dowsed
dowsers115013522dowsers
dowses105718302dowses
doyen95014412doyen
doze145829082doze_
dozed165619352dozed
dozen155017472dozen
dozers164815422dozers
dozes155226302dozes
dozier163611632dozier
drawer104711362drawer
drier64423962drier
droner74717672droner
drover104614592drover
drowner11369802drowner
dryer95111462dryer
duper85519002duper
dyer85522112d_yer
endower1138482endower
ewer77523982_ewer
fewer115216122fewer
flower124815502flower
fowler123712582fowler
foyer116416552foyer
glower105114932glower
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
grower104614932grower
hewer115719932hewer
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
howe106734102howe_
howes114730262howes
howler123514312howler
joker165715892joker
jowar155211432jowar
jowed164724422jowed
knower1337072knower
loner55431032loner
loper75129232loper
loser54728672loser
lover85526452lover
lowe75435312lowe_
lowed95233902lowed
lowers94624922lowers
lowery124112702lowery
lowes85732462lowes
moper94925922moper
mover104220862mover
mowed113629012mowed
mowers113219402mowers
newer85717462newer
noter55025642noter
odder74515392odder
omer67028392_omer
over77227342_over
owe67041032_owe_
owed86833872_owed
owes75137102_owes
owner84613312_owner
oyer75927652_oyer
pawer104422972pawer
plower114315062plower
poker115122882poker
poler74431792poler
poser75128772poser
powder123611902powder
powers113822322powers
powter114116032powter
prower114218122prower
rawer84623732rawer
roger64521412roger
roper75431912roper
rover85527372rover
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rowers94924572rowers
sawer85026212sawer
sewer84426212sewer
shower124315102shower
slower94016152slower
sober74822402sober
sorer56236572sorer
sowar85821342sowar
sowed94933862sowed
sowers94923432sowers
tawer85223442tawer
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
towed95134582towed
towel84920522towel
towers94423672towers
towery124012092towery
toyer84521552toyer
vomer105517382vomer
voter85121052voter
vowed124424572vowed
vowel115515012vowel
vowers124317182vowers
widower1435342widower
wooer84316692wooer
wowed124023772wowed
wowser125110202wowser
yowe106728742yowe_
yowed1253025182yowed
yowes114926372yowes
yowler123310042yowler
zoner144520342zoner

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.0961861364.6
2DLD Change Limit538002471.67032215.6
3Display Results2472470.0633920.6
 (SQL Overall)1786912471.82997698.7
 
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.