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

117 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
blowed12501669(None) 
blawed124713891blawed
blower115316571blower
blowsed13449021blowsed
blowzed22435971blowzed
bowed114533421b_owed
browed125216391browed
flowed133513761flowed
glowed114913831glowed
lowed95233901_lowed
plowed124213201plowed
slowed104617071slowed
allowed111610072allowed
avowed1335952avowed
bellowed14158602bellowed
beloved13188392beloved
billowed14137062billowed
bilobed1235912bilobed
bladed104717762bladed
blamed116017952blamed
blared95018242blared
blazed184314712blazed
bled75729312bl__ed
bleed85019802bl_eed
bloated104513432bloated
blobbed11366562blobbed
blocked16449982blocked
bloke114316632bloke_
blokes123813882blokes
blond85618372blo_nd
blonde94813292blonde
blood85319522blo_od
blooded11379802blooded
blooey115110792blooey
bloomed12439432bloomed
blooped12398542blooped
blotted103911832blotted
bloused104310642bloused
blow95827192blow__
blowby16467512blowby
blowers124313592blowers
blowier1248942blowier
blown105716672blow_n
blows105423832blow_s
blowsy14579452blowsy
blowup1335062blowup
blowy134315322blow_y
blowzy23516672blowzy
blued84520322bl_ued
blumed114313642blumed
boded95124962b_oded
bolled94722652bolled
bolted94617802bolted
boned85133242b_oned
boobed114514872boobed
booed85127272b_ooed
booked135319502booked
boomed115318132boomed
booted94822732booted
boozed184813832boozed
bored85034302b_ored
bowel105621202b_owel
bower107328182b_ower
bowled125018132b_owled
bowsed125715972b_owsed
boxed154318612b_oxed
brewed125411872brewed
browned134710972browned
browsed134511232browsed
buoyed1236692buoyed
chowed154914642chowed
clawed125115072clawed
clewed1225113202clewed
cloned94518802cloned
closed95317962closed
clowned13447722clowned
cloyed125111562cloyed
cowed115637842_cowed
crowed124717292crowed
dowed104632612_dowed
elbowed13235472elbowed
eloped95914142eloped
flawed134712722flawed
flower124815502flower
globed104811762globed
gloved114811872gloved
glower105114932glower
glozed173711222glozed
jowed164724422_jowed
lawed96028322_lawed
lobed86022132_lobed
looed64626132_looed
loped85128332_loped
loved95021362_loved
lowe75435312_lowe_
lower85830412_lower
lowes85732462_lowes
loxed135017052_loxed
meowed12148002meowed
mowed113629012_mowed
owed86833872__owed
plower114315062plower
ployed124310562ployed
rowed94034322_rowed
scowed124413822scowed
showed135016972showed
slewed104815522slewed
sloped94216852sloped
slower94016152slower
snowed104613612snowed
sowed94933862_sowed
stowed105817202stowed
towed95134582_towed
trowed104714652trowed
vowed124424572_vowed
wowed124023772_wowed
yowed1253025182_yowed

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 Filter178691825510.1101624463.6
2DLD Change Limit825511172.36034979.2
3Display Results1171170.0303900.0
 (SQL Overall)1786911172.50071476.4
 
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.