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

153 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
bolshies133869(None) 
bolshie1247121bolshie_
banshies131110662banshies
boshes114721882bo_sh_es
bossies94116832bo_ssies
bothies12414782bo_thies
abolishes1446053abolish_es
baldies105317703bal_dies
ballies93725743bal_lies
banshees13127863banshees
banshie12129543banshie_
bashes115631393b_ash_es
beasties102514653beasties
beladies11310423beladies
belches143514343belch_es
belfries1336983belfries
belies84631053bel__ies
bellies94023723bel_lies
bhisties1339003bhisties
bilbies114712343bil_bies
billies93923503bil_lies
biologies12311183biologies
biopsies1237383biops_ies
blasties102113633blasties
bloodies11310163bloodies
blushes124314823blush_es
bobbies103714563bo_bbies
bobwhites1942193bobwhites
boccies133311513bo_ccies
boches134618523bo_ch_es
bodies94524143bo__dies
bogies94724313bo__gies
boiseries11411043boiseries
bolases93315003bol_ases
boles75448603bol___es
boletes9316063bol_etes
bolides10515073bol_ides
bolivias1345393bolivias
bollixes1747203bollixes
bolloxes1736833bolloxes
bolsheviks2251083bolsheviks
bolshevizes2851403bolshevizes
bolshy1444883bolsh__y
bolsons969483bols_ons
bolster93713423bols_ter
bolsters103712453bolsters
boltholes1445723boltholes
boluses94113833bol_uses
bonspiel1243543bonspiel
bonspiels1342903bonspiels
boobies113718203bo_obies
boodies103721443bo_odies
boogies103719013bo_ogies
bookies133819403bo_okies
boonies93422483bo_onies
booties94124613bo_oties
borsches1536003borsches
borshts1266543borsh_ts
boskier13309173bo_skier
boskiest14289733bo_skiest
bosques18217973bo_sques
bosses85925403bo_s_ses
bossier93712423bo_ssier
bossiest103112213bo_ssiest
botanies10312853botanies
botches143716023botch_es
botchier15287143botchier
botchiest1636153botchiest
botflies1336733botflies
bouchees15339533bouchees
bougies103715183bo_ugies
bounties10311403bounties
bouses84931783bous__es
boweries13312293boweries
bowses115718863bows__es
bowshots1645103bowshots
boychiks2242933boychiks
brashes124518463brash_es
brashier13389933brashier
brashiest14359863brashiest
brassies103613533brassies
brollies1039533brol_lies
brushes124014663brush_es
brushier13306973brushier
brushiest14297543brushiest
bullies94121893bul_lies
bullshits1443393bullshits
busbies113011693b_usbies
bushes115226113b_ush_es
bushier123712813b_ushier
bushiest133512523b_ushiest
busies85525263b_us_ies
cockshies2045173cockshies
colies84837053col__ies
collies94326583col_lies
colonies103620013colonies
conchies153214853conchies
coshes115022783co_sh_es
cosies84932153co_s_ies
dollies83620983dol_lies
dolphins1445653dolphins
falsies103515013fals_ies
flossies112810123flossies
folkies143612253fol_kies
follies103618943fol_lies
glossies93311253glossies
gobshites1542933gobshites
godships1544723godships
goloshes1236263golosh_es
holies94630033hol__ies
hollies103420813hol_lies
hoochies1639603hoochies
jollies143516273jol_lies
joshes165114853jo_sh_es
lollies73116923lol_lies
mashies12318253_mashies
molies84429513mol__ies
mollies93420233mol_lies
moshes115222873mo_sh_es
noshes96618233no_sh_es
oldies7314423_ol_dies
ologies8615023_ologies
oologies9312993oologies
palships1546213palships
palsies94420273pals_ies
poesies93217403poes_ies
policies122415663policies
polies84034583pol__ies
polishes13711783polish_es
polities102722343polities
popsies112816463pops_ies
posies84431433po_s_ies
posties93128813po_sties
potsies93019483pots_ies
poussies1038113poussies
roshis9311793ro_shi_s
roughies1298323roughies
shies86136553___shies
sloshes103811803slosh_es
sloshier1135283sloshier
sloshiest1246683sloshiest
solstices1146703solstices
sonships1357463sonships
sophies12314623so_phies
toeshoes1147713toeshoes
toshes94520103to_sh_es
toughies1278243toughies
tushies10312163_tushies
voleries11313233voleries
welshes13379093welsh_es
wooshes13169883woosh_es
worships1647103worships
worthies14310283worthies

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.423422437.4
2DLD Change Limit1461621536.95321021.4
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.43624030.5
 
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.