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

194 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
bloomier127578(None) 
bloodier1136821bloodier
bloomer11419811bloom_er
boomier113312181b_oomier
broomier1236871broomier
gloomier1135091gloomier
blockier1666132blockier
bloodied1245972bloodied
bloodies11310162bloodies
blooie83913192bloo_ie_
bloomed12439432bloom_ed
bloomers12348822bloom_ers
bloomery15335692bloom_ery
bloomiest1335852bloomiest
blooming13299432blooming
blooper11358532bloo_per
blottier10336412blottier
blousier1055662blousier
blowier1248942bl_owier
blowsier1335062blowsier
blowzier2233412blowzier
boomer104618512b_oom_er
boozier18349012b_oozier
broodier1157432broodier
doomier103610122_doomier
loamier9349162_loamier
loonier73312682_loonier
loopier93711192_loopier
roomier93812242_roomier
balmier113811513b_almier
barmier114313043b_armier
beamier113411943b_eamier
billowier1444293billowier
bionomies1397153bionomies
blamer104417143bl_am_er
blastier10249493blastier
blearier1037333blearier
bloater94013423bl_oater
blocker15419923bl_ocker
blogger11448313bl_ogger
blonder104011943bl_onder
blooded11379803bloo_ded
bloodiest1236663bloodiest
bloodily1445183bloodily
blooding122410653blooding
bloodred1234083bloodred
blooey115110793bloo__ey
bloom95918973bloom___
bloomeries1446103bloomeries
bloomless1342963bloomless
blooms104613173bloom__s
bloomy134510113bloom__y
blooped12398543bloo_ped
bloopers12397373bloo_pers
blooping13248843blooping
blotchier1643213blotchier
blotter94612853bl_otter
blower115316573bl_o_wer
bluesier1034943bluesier
blurrier1035163blurrier
boggier113711583b_oggier
bolometer1348213bolometer
bomber125014653b__omber
bonier84321993b__onier
bonnier94711313b_onnier
boobie104015293b_oobie_
boobies113718203b_oobies
boodies103721443b_oodies
boodler103312003b_oodler
booger94816553b_oo_ger
boogie93515993b_oogie_
boogied11379283b_oogied
boogies103719013b_oogies
booker124719193b_oo_ker
bookie123516003b_ookie_
bookies133819403b_ookies
boomed115318133b_oom_ed
boomers114115913b_oom_ers
boomiest122711843b_oomiest
booming123716223b_ooming
boomlet112412273b_oomlet
boonies93422483b_oonies
booster94314553b_ooster
bootie85421163b_ootie_
booties94124613b_ooties
boozer174815963b_oo_zer
boskier13309173b_oskier
bossier93712423b_ossier
bouvier1277433b_ouvier
boxier154311743b__oxier
bronzier1935633bronzier
brooder103811623broo_der
brookie1347373brookie_
brookies1459143brookies
broomed124111053broom_ed
broomiest1356913broomiest
brooming132911143brooming
brownier13226913brownier
buxomer1833243buxom_er
choosier1337173choosier
chromier1538033chromier
clammier1435843clammier
cloddier1234063cloddier
cloggier1244253cloggier
clothier1335363clothier
cloudier1135053cloudier
droolier936073droolier
droopier1145573droopier
elmier839813el__mier
flamier123112143fl_amier
floatier1136983floatier
flockier1745343flockier
flooder11258463floo_der
flooie93712153floo_ie_
floorer10248073floo_rer
floosie10378933floosie_
floosies113210233floosies
floozie19295463floozie_
floozies20326953floozies
floppier1554633floppier
flossier11326973flossier
foamier12339003_foamier
footier104115113_footier
gleamier1144913gleamier
globbier1334243globbier
gloomed11337413gloom_ed
gloomiest1235603gloomiest
gloomily1443753gloomily
glooming12358013glooming
gloppier1354673gloppier
glossier9358203glossier
goofier11339313_goofier
gooier73516213_goo_ier
goonier83612843_goonier
goopier103910573_goopier
goosier83512563_goosier
groomer10399873groom_er
groovier1233793groovier
homier116416993__homier
hoodier113812973_hoodier
hookier143811673_hookier
hootier104915353_hootier
kookier10398283_kookier
limier83518723_l_imier
loftier1037763_loftier
loggier93811143_loggier
logier75015733_l_ogier
loobies93814103_loobies
looie55624243_loo_ie_
looies65025833_loo_ies
looker104816953_loo_ker
loomed94616763_loom_ed
looming102814853_looming
loonie64216453_loonie_
loonies73919543_loonies
looper83817113_loo_per
looser65219943_loo_ser
looter64222323_loo_ter
loppier11369723_loppier
lorimer937753_lorimer
lousier72411623_lousier
lowlier10338903_lowlier
moodier103212203_moodier
moonier93714103_moonier
moorier93113073_moorier
oozier153610253__oozier
plottier10327263plottier
plumier113510043pl_umier
plummier1434123plummier
rookier114012383_rookier
roomer84718633_room_er
roomie83013873_roomie_
roomies93017243_roomies
rootier74915393_rootier
slimier93212013sl_imier
slobbier1254633slobbier
sloppier1255713sloppier
sloshier1135283sloshier
slummier1235473slummier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
sootier73916613_sootier
spookier14175493spookier
spoonier10167653spoonier
stormier1036103stormier
swoonier11185133swoonier
swoopier13175143swoopier
woodier113912063_woodier
woolier103612353_woolier
woozier19347323_woozier
wormier12278763_wormier
zooier153411233_zoo_ier
zootier163611173_zootier

Search took 10 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.420425454.8
2DLD Change Limit1461621948.51617163.2
3Display Results1941940.0802425.0
 (SQL Overall)1786911949.01619819.3
 
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.