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

174 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
blowup133506(None) 
blowups1433161blowups
bloop96116152blo_op
blow95827192blow__
blowby16467512blowby
blowed125016692blowed
blower115316572blower
blowgun1342652blowgun
blown105716672blow_n
blowout1248402blowout
blows105423832blow_s
blowsy14579452blowsy
blowy134315322blow_y
blowzy23516672blowzy
loup66028432_lo_up
aloud65018073alo_ud
alow75328593alow__
backup1646613backup
below104617193below__
belows114614183below_s
blaw97026723blaw__
blawed124713893blawed
blawn106813703blaw_n
blaws105620463blaw_s
bleep95013453bl_eep
blew94722433blew__
blimp115612943bl_imp
blip88322773bl__ip
bloat75229923blo_at
bloats85215763bloats
blob86027093blo__b
blobs95620033blo_bs
bloc85023273blo__c
block134917843blo_ck
blocks144513943blocks
blocky17388353blocky
blocs95219653blo_cs
blog75723823blo__g
blogs85319233blo_gs
bloke114316633blo_ke
blokes123813883blokes
blond85618373blo_nd
blonde94813293blonde
blonds95213343blonds
blood85319523blo_od
bloods94614843bloods
bloody124710173bloody
blooey115110793blooey
blooie83913193blooie
bloom95918973blo_om
blooms104613173blooms
bloomy134510113bloomy
bloops106611343bloops
blot65842323blo__t
blotch13197143blotch
blots75626173blo_ts
blotto8198443blotto
blotty11178343blotty
blouse84714723blouse
blousy11459123blousy
blowbys17353813blowbys
blowers124313593blowers
blowfly1843243blowfly
blowguns1442163blowguns
blowier1248943blowier
blowing133813053blowing
blowjob2141753blowjob
blowoff1843913blowoff
blowouts1344323blowouts
blowpipe1742353blowpipe
blowsed13449023blowsed
blowtube1541583blowtube
blowzed22435973blowzed
blub85324873bl__ub
blue65328463bl__ue
blur66020533bl__ur
bogus85616473b_ogus
bolus79125543b_olus
bonus75324323b_onus
boojum1733843boojum
bop77549483b_o__p
bosun75113593b_osun
bout66353293b_o_ut
bow87051903b_ow__
bowed114533423b_owed
bowel105621203b_owel
bower107328183b_ower
bowl96827703b_ow_l
bowls106121433b_owls
bows96242863b_ow_s
bowse105420633b_owse
brogue94211033brogue
brow97228443brow__
browed125216393browed
brown105619533brow_n
browns116415633browns
browny144510043browny
brows105425983brow_s
browse115713853browse
clomp115615703clo_mp
clonus85212413clonus
clop86929893clo__p
cloque17288743cloque
closeup11113433closeup
cloud86716423clo_ud
clour76617283clo_ur
clout75330463clo_ut
clown105214733clow_n
clowns114810113clowns
coup86729793_co_up
croup95616783cro_up
doowop1283853doowop
flop96925453flo__p
flour84916453flo_ur
flout86226203flo_ut
flow105924923flow__
flowed133513763flowed
flower124815503flower
flown116213993flow_n
flows115822363flow_s
foldup1233813foldup
followup1642173followup
glomus9468093glomus
glop76724633glo__p
glout65925813glo_ut
glow85222523glow__
glowed114913833glowed
glower105114933glower
glows95518033glow_s
group85413923gro_up
grownup1342213grownup
holdup1245183holdup
hookup1534423hookup
layup1037723_layup
letup73712163_letup
lockup1434763_lockup
locum94812173_locum
locus74819993_locus
lookup1233453lookup
loop67835013_lo_op
lop58255313_lo__p
lotus55718063_lotus
loud55228043_lo_ud
loupe75319513_lo_upe
loups75319623_lo_ups
lour45430683_lo_ur
lout45952143_lo_ut
low66051873_low__
lowe75435313_low_e
lowed95233903_lowed
lower85830413_lower
lowes85732463_lowes
lowly114113333_lowly
lown76929293_low_n
lows75843013_low_s
lowse87219903_lowse
obloquy2141873obloquy
plop86625743plo__p
plow95923233plow__
plowed124213203plowed
plower114315063plower
plows105419903plow_s
roup66627693_ro_up
slipup1034503slipup
sloop76118913slo_op
slop66533873slo__p
slow77729493slow__
slowed104617073slowed
slower94016153slower
slowly1237153slowly
slows85323463slow_s
soup66232913_so_up
stoup75517073sto_up
stowp105614233stow_p

Search took 7 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.266671770.7
2DLD Change Limit1127161746.00018786.0
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.32928233.7
 
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.