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

226 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
boletus94864(None) 
boletes9316061boletes
blets75324942b_let_s
boleros9310292boleros
boles75448602bole__s
bolete8519612bolet_e
boleti8413402bolet_i
boletuses1155062boletuses
bolters94017802bolters
bolts76232112bol_t_s
bolus79125542bol__us
coleus86818272cole_us
foetus958522fo_etus
soleus64615612sole_us
abortus9397913abo_rtus
aglets73915683aglet_s
balatas9311833balatas
baleens938473baleens
baleful1237993baleful
balers85626933bale_rs
bales76250083bale__s
ballets93719513ballet_s
beaus75127113b__eaus
beets76131443b_eet_s
begets96215523beget_s
bejesus1643693bejesus
beleaps1138053beleaps
belters93819413belters
belts75931163bel_t_s
berets85822523beret_s
besets85718803beset_s
betas75528763b__etas
beths105519223b__eths
bets67051443b__et_s
bidets95215533bidet_s
biles75542143bile__s
bilious9310933bilious
billets94516153billet_s
blats75132503b_lat_s
bleaks125112433b_leaks
blears85116453b_lears
bleats85518613b_leats
blebs96416153b_le_bs
bleeds95211593b_leeds
bleeps10499103b_leeps
blends96012883b_lends
bless75917813b_le_ss
blet66247673b_let__
blites84721213b_lites
bloats85215763bloat_s
blots75626173b_lot_s
bluets87215493bluet_s
boarts84716873boart_s
boasts85017923boast_s
boatels93510233boatels
boaters93419243boaters
boats75635153bo_at_s
bodegas1135483bodegas
bodes84935103bode__s
bogeys124510913boge_ys
bogles95020833bogle__s
bogus85616473bo__gus
boheas114013213bohe_as
boilers93417063boile_rs
boites84322703bo_ites
bolas74733763bol__as
bolases93315003bolases
bolds85825283bol__ds
bole66448693bole___
bolero8412093bole_ro
bolides10515073bolides
bolls75531313bol__ls
bolos75531373bol__os
bolsons969483bolsons
bolster93713423bolster
bolsters103712453bolsters
bolt66254173bol_t__
bolted94617803bol_ted
bolter83920753bol_ter
boluses94113833boluses
bomblets1436023bomblet_s
boners84825433bone_rs
bones76446533bone__s
bonitas939453bonitas
bonitos939733bonitos
bonnets94812803bonnet_s
bonus75324323bo__nus
booklets14247123booklet_s
boomlets12246673boomlet_s
boosts86115013boost_s
bootees94114473bootees
booths115313793bo_oths
boots75837973bo_ot_s
bopeeps1333103bopeeps
borates94823013borates
boreas85421733bore_as
boreens9310403boreens
borers85122683bore_rs
bores76448253bore__s
borts76735453bo_rt_s
boskets13409473bosket_s
botas75328783bo__tas
botels84815803bote_ls
bots66453953bo__t_s
botts75224863bo__tts
boubous1138693boubous
boules84925973boule__s
bouts75131313bo_ut_s
bowels114315593bowe_ls
bowers115523703bowe_rs
bowlegs13366813bowle_gs
bowlers123715783bowle_rs
bowless123310313bowle_ss
boxers155013483boxe_rs
boxes145625073boxe__s
bulbous1138293bulbous
bullets93516393bullet_s
bullous9311663bullous
bureaus979293bureaus
burets84321263buret_s
coitus8511893co_itus
coleads102911423coleads
coles76055063cole__s
colitis92617353colitis
collets93517903collet_s
colobus11389373colobus
colonus94413443colonus
colters93522443colters
colts76633293col_t_s
comets105823583comet_s
conatus9310463conatus
cosets85824403coset_s
covetous1347093covetous
covets114819643covet_s
culets85518513culet_s
cultus85110733cul_tus
daleths1135323daleths
deletes83117933deletes
doleful1146333doleful
doles67843753dole__s
dolts65626313dol_t_s
eoliths10318573eoliths
fetus85816543__fetus
filets94718953filet_s
flatus94310783_flatus
folates103218453folates
foleys123810463fole_ys
folious103710733folious
goblets103210183goblet_s
godets8410933godet_s
goglets9379783goglet_s
golems939323gole_ms
halitus10339963halitus
holes84748653hole__s
holts85627913hol_t_s
howlets13329223howlet_s
ileus54616893_ile_us
impetus1144893impetus
inlets63915573inlet_s
iolites73819483iolites
islets64513083islet_s
joles125230833jole__s
jolters143711993jolters
jolts125018883jol_t_s
lets47147943__let_s
letup73712163__letup
letups8317683__letups
lotus55718063__lotus
moles74747923mole__s
molests93311563molests
molters93816973molters
molts76032093mol_t_s
motets84216193motet_s
muletas937383muletas
nonets64118703nonet_s
obelus8348403_obelus
objets15125323objet_s
oblates91913243oblates
oboles83815833obole__s
obolus8378813obol__us
obsoletes1144213obsoletes
oleates7417833_oleates
oleins6313523_oleins
oleos55419683_ole_os
oles46453473_ole__s
oleum73613323_ole_um
oleums8358783_oleums
oolites72817843oolites
ooliths10268323ooliths
owlets93110393owlet_s
palets85122313palet_s
pileous9510523pileous
pileus84514943pile_us
piolets93513193piolet_s
plexus15377283_plexus
poets76024443po_et_s
poleis86018353pole_is
polentas1038743polentas
polers84225643pole_rs
poles75351003pole__s
poleyns1236113poleyns
polypus14346933polypus
quietus16286393quietus
relets64025673relet_s
roles56747983role__s
rosets65819953roset_s
rouleaus844983rouleaus
silenus7369693silenus
solates73523853solates
soles55547923sole__s
solidus8338113solidus
solus54726983sol__us
solutes73515263solutes
teledus835093teledus
toilets74112913toilet_s
toledos8388863toledos
toles55147133tole__s
tolus55024483tol__us
tonlets73212503tonlet_s
valets93715623valet_s
violets102210003violet_s
voles86234043vole__s
voltes94915583vol_tes
volts85421293vol_t_s
volutes102710983volutes
vomitus12215743vomitus

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 Limit1340272265.81323056.4
3Display Results2262260.0762973.7
 (SQL Overall)1786912266.04529560.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.