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

283 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
bristle9191010(None) 
bristled11187341bristled
bristles101510431bristles
bristly12178061bristly
brittle9168601brittle
gristle8169221gristle
aristae7312532aristae
bhistie1236772bhistie
bistre83815022b_istre
brattle9249252brattle
brickle15279932brickle
bricole112810492bricole
bridle94115462bri_dle
brindle104210102brindle
briskly16165402briskly
bristlier1144312bristlier
bristol937042bristol
bristols1046772bristols
brittled11186092brittled
brittler10165982brittler
brittles10178652brittles
brittly12165972brittly
bustle84015482b_ustle
cristae9310612cristae
epistle957892epistle
gristles9189202gristles
gristly11187332gristly
istle52214712__istle
rustle63615412_rustle
thistle10107802thistle
trestle72611362trestle
triste63818642trist_e
whistle13107532whistle
wrastle10368992wrastle
wrestle10298842wrestle
wristlet1138642wristlet
aisle55223193_ais_le
anisole71010833anisole
apostle937853apostle
ariette7312373ariette
arise56436433aris__e
arista6415293arist_a
aristas7413523aristas
aristate8312133aristate
aristo6414033arist_o
aristos7312373aristos
artiste73813693artist_e
barista9310813barist_a
baristas1039723baristas
barite84224813bari_t_e
baste74829983b_ast_e
bastile9313913b_astile
batiste939743batist_e
battle85217863b_attle
beastie92412433beastie
beastly1277563beastly
beetle8311673b_eetle
belittle1044053belittle
bhisties1339003bhisties
bible95119423b_i_ble
bile66147183b_i__le
bindle94516263b_indle
birle75023633b_i_rle
birse74517403birs__e
bise66437103b_is__e
bisque17257843b_isque
bistate9313823b_istate
bister84922763b_ister
bistred103311853b_istred
bistres94017213b_istres
bistro8339943b_istro
bite66547003b_i_t_e
blastie92411393blastie
blintze1833903blintze
blister94415313blister
blite76225353bli_t_e
blithe115810863bli_the
boite74426323boi_t_e
bottle84916073b_ottle
brabble10349973brabble
bractlet1239283bractlet
braille939713braille
braise84318753brais__e
bramble133710033bramble
brashly15427613brashly
brasil8713863brasil_
brasils9410973brasils
brassie93411523brassie
brattled11196723brattled
brattles10199333brattles
breathe123711843breathe
bribable1137223bribable
bribe94820783bri__be
bribee104316363bri_bee
brickles162810283brickles
bricoles122610303bricoles
bridal9511453bridal_
bridals1038623bridals
bride86425533bri__de
bridge103711883bri_dge
bridled113611143bri_dled
bridler103811073bri_dler
bridles104114473bri_dles
brie65837903bri___e
briefly1534573briefly
brigade1136493brigade
brightly1764553brightly
brill74819953bri__ll
brillo84211003bri_llo
brills84916293bri_lls
brimstone1354623brimstone
brindled12407853brindled
brindles113710223brindles
brine75132273bri__ne
brioche14275923brioche
bris65539613bris___
brisance1245953brisance
brisant9312683brisant
brises84927613bris_es
brisk115615983bris__k
brisked144210003brisked
brisker134210293brisker
brisket134413403brisket
brisks124611403bris_ks
briss75824273bris__s
brisses94314313brisses
bristliest1245143bristliest
bristling1246663bristling
brit66350153bri_t__
brith104924373bri_t_h
briths115113863bri_ths
brits76433083bri_t_s
britska13132883britska
britt75732233bri_t_t
brittlely1442473brittlely
brittlest11146193brittlest
britts84813443bri_tts
brose75227033bros__e
bruise83412873bruis__e
brusque1843703brusque
brute75321783br_ut_e
bustled104011523b_ustled
bustler94012573b_ustler
bustles93816323b_ustles
butle75023103b__utle
castle84918963_castle
christie1347783christie
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
cripple13378583cripple
crisply14426523crisply
crista8311803crist_a
cristate10310603cristate
cuittle946403cuittle
dribble12368603dribble
drizzle16285913drizzle
embrittle1342383embrittle
enisle63412093enis_le
epistler1044833epistler
epistles1047783epistles
epistyle1364073epistyle
eristic9814093eristic
firstly1335643firstly
friable122612563friable
fribble14287783fribble
frijole1734583frijole
frisbee12298513frisbee
frise85322453fris__e
frisee94217993fris_ee
frisette1195483frisette
frizzle18367043frizzle
frustule1154483frustule
gribble12297273gribble
griddle1035503griddle
grille74315743gri_lle
gripple12416613gripple
grisette994653grisette
grisly104310583gris_ly
grist65529873grist__
grister83915413grister
gristlier1044283gristlier
grists74716483grist_s
grizzle16306113grizzle
gruntle8257053gruntle
hirsle9159573hirs_le
hustle93113993_hustle
isle45121703__is_le
istles62814983__istles
ixtle12168013__ixtle
jostle13319863_jostle
justle133211583_justle
kirtle10309473_kirtle
kittle104012173_kittle
lisle53916723_lis_le
listee64223063_listee
listel64214743_listel
little63312163_little
moistly1236613moistly
nestle63013953_nestle
oriole6814293ori_ole
peristyle1444303peristyle
pestle83215843_pestle
pintle83818263_pintle
piste75824603_pist_e
pistole92414313_pistole
prattle9208833prattle
presale9416353presale
prickle153611013prickle
priestly1345843priestly
prise74632613pris__e
prisere9310943prisere
pristane10310343pristane
pristine10313503pristine
prostie91617743prostie
prostyle13187273prostyle
rassle63813203_rassle
rattle64717613_rattle
resale64025543_resale
resile64627673_resile
resole64624183_resole
restyle1038763_restyle
riddle83915713_riddle
riffle124210233_riffle
rifle85518333_ri_fle
rile45650533_ri__le
rille55728733_ri_lle
rimple103814583_rimple
ripple103413913_ripple
rise45945233_ris__e
risible937923_risible
risque15227453_risque
rissole739783_rissole
ristra6310713_ristra
rite45849453_ri_t_e
rootle63214453_rootle
rustled83311323_rustled
rustler73512343_rustler
rustles73416413_rustles
skittle1135533skittle
spittle937923spittle
thistles1198233thistles
thistly1395963thistly
throstle1175703throstle
title54721073_ti_tle
tittle63613323_tittle
trestles83012553trestles
triable92515393triable
trickle133613443trickle
trifle94012883tri_fle
trindle83311363trindle
triple84215923tri_ple
triscele1045433triscele
triseme936543triseme
triskele1244573triskele
trisome9310223trisome
tristate8311033tristate
trite54730033tri_t_e
trustee73514443trustee
tryste9399583tryst_e
urostyle11173953urostyle
vittle94711753_vittle
warstle10328013warstle
whistled1595783whistled
whistler1496313whistler
whistles14108213whistles
whittle13106103whittle
wintle94014603_wintle
wrassle10357173wrassle
wrastled12346433wrastled
wrastles11328933wrastles
wrestled12296763wrestled
wrestler11306993wrestler
wrestles113310063wrestles
wriggle12316213wriggle
wrinkle14296923wrinkle
wrist84827563wrist__
wristier1136863wristier
wristlets1244473wristlets
wrists95415643wrist_s
wristy12509703wrist_y
write85522833wri_t_e
writhe125310703wri_the

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.420425454.8
2DLD Change Limit1340272835.84622926.3
3Display Results2832830.1062669.8
 (SQL Overall)1786912836.37228043.2
 
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.