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 “bolshie” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
bolshie124712(None) 
bolshies1338691bolshies
banshie12129542banshie
bolshy1444882bolsh_y
banshee121212453banshee
banshies131110663banshies
beastie92412433beastie
belie75630383bel__ie
bhistie1236773bhistie
billie85019173bil_lie
blastie92411393blastie
blooie83913193b_looie
bobwhite1842423bobwhite
boccie123311453bo_ccie
boche124216953bo_ch_e
bogie89524103bo__gie
boiserie1047993boiserie
bole66448693bol___e
bolete8519613bol_ete
boleti8413403boleti_
bolide9515563bol_ide
bolivia1246063bolivia
bollix1538053bol_lix
bolshevik2151423bolshevik
bolshevize2751443bolshevize
bolson8410683bols_on
bolsons969483bolsons
bolster93713423bolster
bolthole1345463bolthole
boltlike1436313boltlike
bonnie85314853bo_nnie
bonsai838463bonsai_
bonspiel1243543bonspiel
boobie104015293bo_obie
boogie93515993bo_ogie
bookie123516003bo_okie
bootie85421163bo_otie
borsht11813503borsh_t
borshts1266543borshts
bosh96328973bo_sh__
boshes114721883bo_shes
boskier13309173bo_skier
bosque17257733bo_sque
bossier93712423bo_ssier
bossies94116833bo_ssies
botchier15287143botchier
bothies12414783bo_thies
bouchee143313543bouchee
bougie93613273bo_ugie
bouse75931853bous__e
bowse105420633bows__e
bowshot1578253bowshot
boychik2143943boychik
brashier13389933brashier
brassie93411523brassie
brushier13306973brushier
bullshit1344663bullshit
bushier123712813b_ushier
collie83621993col_lie
conchie143312683conchie
cosie74728263co_s_ie
couthie121810553couthie
dolphin1345533dolphin
donsie7613643dons_ie
falsie93513853fals_ie
flossie10337443flossie
folkie13369613fol_kie
gobshite1443273gobshite
godship1445083godship
goloshe1134723golosh_e
grushie1135813grushie
hoochie1537803hoochie
mashie11315933_mashie
mollie83517103mol_lie
oldie6415473_ol_die
palship1446833palship
popsie103013053pops_ie
postie84123963po_stie
potsie83916033pots_ie
poussie936623poussie
roshi8310753ro_shi_
roshis9311793ro_shis
sloshier1135283sloshier
solstice1047223solstice
sonship12108653sonship
sonsie6614863sons_ie
toeshoe1047843toeshoe
toughie1187593toughie
tushie939723_tushie
worship1547833worship

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.406440125.6
2DLD Change Limit134027906.12621878.4
3Display Results90900.0461956.5
 (SQL Overall)178691906.57827164.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.