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

109 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
flowed13351376(None) 
blowed125016691blowed
flawed134712721flawed
flower124815501flower
glowed114913831glowed
lowed95233901_lowed
plowed124213201plowed
slowed104617071slowed
allowed111610082allowed
avowed1335962avowed
blawed124713892blawed
blower115316572blower
blowsed13449022blowsed
blowzed22435972blowzed
bowed114533422_bowed
browed125216392browed
chowed154914652chowed
clawed125115072clawed
clewed1225113202clewed
cloned94518802cloned
closed95317972closed
clowned13447732clowned
cloyed125111562cloyed
cowed115637852_cowed
crowed124717312crowed
dowed104632612_dowed
elbowed13235472elbowed
eloped95914152eloped
fallowed15127752fallowed
fellowed15136832fellowed
flaked144715652flaked
flamed124618972flamed
flared105317602flared
flayed134414052flayed
fled85429772fl__ed
flexed17419092flexed
fleyed13408812fleyed
flied96519432fl_ied
flited104616582flited
floated113312702floated
flocced15365482flocced
flocked174510252flocked
floe76129772flo_e_
floes85528142flo_es
flogged13528802flogged
flood95215602flo_od
flooded12307932flooded
flooey123910172flooey
floored11268682floored
flopped15338762flopped
floret9321122floret
florid10311452florid
flossed11388532flossed
floured11289872floured
flouted113210812flouted
flow105924922flow__
flowered1546012flowered
flowers133413172flowers
flowery16327782flowery
flown116213992flow_n
flows115822362flow_s
flued95021252fl_ued
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
flyted13378772flyted
folded114212792folded
followed15146272followed
fooled104317822fooled
footed104418622footed
fowled133914102f_owled
foxed165115212f_oxed
frowned14348832frowned
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
reflowed15126902reflowed
rowed94034322_rowed
scowed124413832scowed
showed135016972showed
slewed104815522slewed
sloped94216852sloped
slower94016152slower
snowed104613622snowed
sowed94933862_sowed
stowed105817202stowed
towed95134582_towed
trowed104714652trowed
upflowed1742892upflowed
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.373479064.3
2DLD Change Limit825511092.56332208.7
3Display Results1091090.0303633.3
 (SQL Overall)1786911092.96660246.5
 
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.