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 “upflow” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
upflow143352(None) 
upflows1543511upflows
flow105924922__flow
inflow1235292inflow
mudflow1642332mudflow
outflow1355352outflow
plow95923232_p_low
reflow12379652reflow
upbow1245612up_bow
upflowed1742892upflowed
upfold12124952upfold
upgrow1234272upgrow
aglow94711963_aglow
airflow1343543airflow
allow85420663_allow
alow75328593__alow
apolog938903apolog
barlow112911423barlow
bellow114213353bellow
below104617193_below
billow114111223billow
blow95827193__blow
callow114714663callow
epilog976463epilog
fallow124713853fallow
fellow123712743fellow
flaw106326643__flaw
flew105824253__flew
floc95922123__floc
floe76129773__floe
flog85523893__flog
flop96925453__flop
flown116213993__flown
flows115822363__flows
follow124010353follow
frow106425053__frow
glow85222523__glow
hallow124818323hallow
hollow124212663hollow
inflows1335523inflows
low66051873___low
mallow114014743mallow
mellow114112223mellow
mudflows1742503mudflows
outflew1336423outflew
outflown1464063outflown
outflows1445463outflows
outglow1154863outglow
pelon74423213_pelon
phlox1737333_phlox
pilaw103913743_pilaw
pillow113110573pillow
pilot77435063_pilot
plew97222813_p_lew
plod76723273_p_lod
plop86625743_p_lop
plot66141233_p_lot
plows105419903_p_lows
ploy96123603_p_loy
polo66236633_polo_
polos76129913_polos
pow87147283_p__ow
prow97030383_p_row
putlog965553putlog
pylon103614003_pylon
reflew12389453reflew
reflown13316213reflown
reflows13258983reflows
reglow10339403reglow
replow114210343replow
sallow94315753sallow
slow77729493__slow
sunglow1143943sunglow
tallow93714203tallow
teflon937453teflon
tupelo836483tupelo_
tupelos936113tupelos
unclog956603unclog
unfold10179703unfold
upbows1384683up_bows
updo76712883up_do_
updos8389513up_dos
upfling1337093upfling
upflowing1842933upflowing
upflung1342213upflung
upfolds13133753upfolds
upfront1246973upfront
upgrew1233653upgrew
upgrown1343853upgrown
upgrows1334323upgrows
uphold12126903uphold
uphroe1136083uphroe
uplit76020803up_lit
upload9257783up_load
upo58925863up__o_
upon65817583up__on
upprop944093upprop
uproot8314123uproot
upshot1138453upshot
upsilon943583upsilon
upslope1144173upslope
upthrow1543193upthrow
uptown11274963up_town
wallow123913513wallow
willow12369693willow
yellow12429883yellow

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161065.42320784.8
3Display Results1061060.0303533.3
 (SQL Overall)1786911065.57932029.2
 
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.