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

133 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
blowzier223341(None) 
blowier1248941blow_ier
blowsier1335061blowsier
blockier1666132blockier
bloodier1136822bloodier
bloomier1275782bloomier
blottier10336412blottier
blousier1055662blousier
blower115316572blow__er
blowzed22435972blowz_ed
blowziest2343672blowziest
blowzily2542732blowzily
boozier18349012b_oozier
bronzier1935632bronzier
brownier13226912brownier
frowzier2343312frowzier
lowlier10338902_lowlier
bawdier13378203b_awdier
billowier1444293billow_ier
blastier10249493blastier
blazer174414023bl_az_er
blearier1037333blearier
blitzer18447663blitz_er
bloater94013423blo_ater
blocker15419923blo_cker
blogger11448313blo_gger
blonder104011943blo_nder
bloodied1245973bloodied
bloodies11310163bloodies
blooie83913193blo_oie_
bloomer11419813blo_omer
blooper11358533blo_oper
blotchier1643213blotchier
blotter94612853blo_tter
blowed125016693blow__ed
blowers124313593blow__ers
blowfish1944703blowfish
blowflies1742893blowflies
blowiest1337923blow_iest
blowing133813053blow_ing
blowpipe1742353blowpipe
blowpipes1842063blowpipes
blowsed13449023blow_sed
blowsiest1435323blowsiest
blowsily1643953blowsily
blowzy23516673blowz__y
bluesier1034943bluesier
blurrier1035163blurrier
boggier113711583b_oggier
bonier84321993b_o_nier
bonnier94711313b_onnier
bonzer175313673b_onz_er
boomier113312183b_oomier
boozer174815963b_ooz_er
boskier13309173b_oskier
bossier93712423b_ossier
bouvier1277433b_ouvier
bower107328183b_ow__er
bowlder13407483b_owlder
bowler114217313b_ow_ler
bowyer14368923b_ow_yer
boxier154311743b_o_xier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473b_razier
breezier1934533breezier
bronzer18348493bronz_er
broodier1157433broodier
broomier1236873broomier
browner124911643brow_ner
brownie12178433brownie_
brownies13189613brownies
browser124911143brow_ser
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
clowder13367943clow_der
cowier113616163_cow_ier
cozier173315143_co_zier
crozier18369933cro_zier
dowdier12328573_dowdier
downier11299703_downier
dozier163611633_do_zier
drowsier1284903drowsier
flawier13378733flaw_ier
floatier1136983floatier
flockier1745343flockier
floozie19295463floozie_
floozies20326953floozies
floppier1554633floppier
flossier11326973flossier
flower124815503flow__er
flowerer1435453flowerer
flowerier1544273flowerier
fozier183710663_fo_zier
frouzier2043703frouzier
frowsier1444893frowsier
glazier17409353gl_azier
glitzier1833593glitzier
globbier1334243globbier
gloomier1135093gloomier
gloppier1354673gloppier
glossier9358203glossier
glower105114933glow__er
growlier1234883growlier
jowlier17327563_jowlier
klutzier2142193klutzier
lazier154214613_l_azier
loamier9349163_loamier
loftier1037763_loftier
loggier93811143_loggier
logier75015733_lo_gier
loonier73312683_loonier
loopier93711193_loopier
loppier11369723_loppier
lousier72411623_lousier
lower85830413_low__er
lowlifer1443283_lowlifer
lowrider1234153_lowrider
oozier153610253__oozier
plottier10327263plottier
plower114315063plow__er
rowdier11348593_rowdier
showier1339103show_ier
sleazier1735123sleazier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slower94016153slow__er
snoozier17185193snoozier
snowier1038793snow_ier
woozier19347323_woozier

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621336.95321021.4
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.45223978.9
 
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.