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

131 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
blowups143316(None) 
blowup1335061blowup_
bloops106611342blo_ops
blowbys17353812blowbys
blowers124313592blowers
blowguns1442162blowguns
blowouts1344322blowouts
blows105423832blow__s
loups75319622_lo_ups
backups1736173backups
belows114614183below__s
blaws105620463blaw__s
bleeps10499103bl_eeps
blimps12588153bl_imps
blips95615783bl__ips
bloats85215763blo_ats
blobs95620033blo__bs
blocks144513943blo_cks
blocs95219653blo__cs
blogs85319233blo__gs
blokes123813883blo_kes
blondes104213163blondes
blonds95213343blo_nds
bloods94614843blo_ods
blooms104613173blo_oms
bloop96116153blo_op_
blots75626173blo__ts
blouse84714723blo_use
blouses94014463blouses
blousy11459123blo_usy
blow95827193blow___
blowby16467513blow_by
blowed125016693blow_ed
blower115316573blow_er
blowfish1944703blowfish
blowfly1843243blowfly
blowgun1342653blowgun
blowier1248943blowier
blowiest1337923blowiest
blowing133813053blowing
blowjob2141753blowjob
blowjobs2241573blowjobs
blown105716673blow__n
blowoff1843913blowoff
blowoffs1942083blowoffs
blowout1248403blowout
blowpipe1742353blowpipe
blowpipes1842063blowpipes
blowsed13449023blowsed
blowsy14579453blow_sy
blowtube1541583blowtube
blowtubes1641703blowtubes
blowy134315323blow__y
blowzed22435973blowzed
blowzy23516673blow_zy
blubs95818153bl__ubs
blues75127043bl__ues
blurs74619083bl__urs
bogus85616473b_ogu_s
bolus79125543b_olu_s
bonus75324323b_onu_s
boojums1842653boojums
bops86037983b_o__ps
bosuns8439383b_osuns
bouts75131313b_o_uts
bowels114315593b_owels
bowers115523703b_owers
bowls106121433b_ow_ls
bows96242863b_ow__s
bowses115718863b_owses
brogues10719823brogues
browns116415633brow_ns
brows105425983brow__s
browses124712693browses
clomps125212233clo_mps
clonus85212413clonu_s
clops95924853clo__ps
cloques18268563cloques
closeups12102803closeups
clouds94612353clo_uds
clours85215093clo_urs
clouts87017203clo_uts
clowns114810113clow_ns
coups95522473_co_ups
croups104312553cro_ups
doowops1363943doowops
flops105920143flo__ps
flours94414053flo_urs
flouts94315273flo_uts
flowers133413173flowers
flows115822363flow__s
foldups1332733foldups
followups1742293followups
glomus9468093glomu_s
glops85619553glo__ps
glouts74414713glo_uts
glowers113412093glowers
glows95518033glow__s
groups94210513gro_ups
grownups1441503grownups
holdups1333593holdups
hookups1633263hookups
layups1133993_layups
letups8317683_letups
lockups1534243_lockups
locums10478303_locums
locus74819993_locu_s
lookups1332953lookups
loops75723963_lo_ops
lops66043353_lo__ps
lotus55718063_lotu_s
louis57322323_lo_uis
loup66028433_lo_up_
loupe75319513_lo_upe
loupes84918053_lo_upes
lours55125293_lo_urs
louts56330273_lo_uts
lowers94624923_lowers
lowes85732463_low_es
lows75843013_low__s
plops95920333plo__ps
plowers123812243plowers
plows105419903plow__s
roups75118903_ro_ups
slipups1133193slipups
sloops85513623slo_ops
slops75026013slo__ps
slows85323463slow__s
soups75322943_so_ups
stoups85313273sto_ups
stowps115710583stow_ps

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271315.94022563.5
3Display Results1311310.0602183.3
 (SQL Overall)1786911316.15629027.1
 
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.