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

186 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
prow9703038(None) 
brow97228441brow
crow96428131crow
frow106425051frow
grow86127301grow
plow95923231plow
pow87147281p_ow
pro55837261pro_
proa66229961proa
prod76129501prod
prof96134661prof
prog75729001prog
prom87631701prom
prop85932811prop
pros65742781pros
prowl105615121prowl
prows106327011prows
row67453671_row
trow78031421trow
vrow105817471vrow
alow75328592alow
apron7318832apron
arrow83414892arrow
avow107816462avow
blow95827192blow
bow87051902_bow
braw94829562braw
brew95023562brew
bro56236602bro_
broo65129822broo
bros65635662bros
brown105619532brown
brows105425982brows
chow125820992chow
cow89856712_cow
craw97725262craw
crew96122682crew
croc85723732croc
crop87628632crop
crowd115815622crowd
crown105620082crown
crows105727312crows
dhow116614002dhow
dow76749972_dow
draw85623012draw
drew86221672drew
drop75324402drop
drown95515822drown
enow77819872enow
eros45238452eros
flow105924922flow
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frown115415972frown
frows116623102frows
glow85222522glow
grew85620262grew
grog65923342grog
grok95819682grok
grot55942052grot
growl96115822growl
grown95317352grown
grows95523922grows
how97252432_how
iron46728462iron
jow137639302_jow
know116115852know
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
parol74826272parol
paw87651172p_aw
peon65635242peon
pew86442302p_ew
phew128417112phew
phon95925382phon
phot95534362phot
pion67235302pion
pirog83913672pirog
plew97222812plew
plod76723272plod
plop86625742plop
plot66141232plot
plows105419902plows
ploy96123602ploy
pod66351492p_od
poh86740532p_oh
poi57244662p_oi
pol56449382p_ol
pom78249912p_om
poo57757112p_oo
pood75934322pood
poof95541662poof
pooh96027382pooh
pool65835952pool
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
pop76252252p_op
pore66451262pore
pork106929682pork
porn65636022porn
port66059632port
pot58078432p_ot
pows95537662p_ows
pox126140692p_ox
pram85733492pram
prao66229022prao
praos74923562praos
prat65952042prat
prau66529472prau
prawn105312432prawn
pray96331532pray
pree67044732pree
preop94715872preop
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
prig75924872prig
prim85132202prim
prion75119992prion
prior74316172prior
proas75028802proas
probe94320812probe
prods85523552prods
proem94818272proem
profs105120892profs
progs86624152progs
prole74527792prole
promo95620002promo
proms95426412proms
prone75332622prone
prong85218112prong
proof105221532proof
props95726882props
prose75835122prose
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
proud84615482proud
prove104823192prove
prowar114110942prowar
prower114218122prower
prowls115511082prowls
proxy175011012proxy
pry85728052pr_y
pyro96019392pyro_
pyros105718292pyros
raw67252252_raw
rob56754302_rob
roc520243252_roc
rod47953902_rod
roe36861082_roe
rom59855632_rom
rot37282952_rot
rows75941752_rows
scow96021422scow
serow86720442serow
show106229192show
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
strow88920572strow
throw118719732throw
tow610557362_tow
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trows88826182trows
troy77429682troy
upbow1245612upbow
upgrow1234272upgrow
vow96136312_vow
vrouw11507342vrouw
vrows116115262vrows
wow96643472_wow
yow96945292_yow

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 Filter178691298720.283631417.0
2DLD Change Limit298721860.84335435.3
3Display Results1861860.0464043.5
 (SQL Overall)1786911861.172152466.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.