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

258 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
brittles1017865(None) 
brattles10199331brattles
bristles101510431bristles
brittle9168601brittle_
brittled11186091brittled
brittler10165981brittler
brittlest11146191brittlest
battles94517682b_attles
belittles1143872belittles
bottles94216272b_ottles
brattle9249252brattle_
brattled11196722brattled
brickles162810282brickles
bricoles122610302bricoles
bridles104114472bri_dles
brindles113710222brindles
bristle91910102bristle_
bristled11187342bristled
britches15278682britches
brittlely1442472brittlely
brittly12165972brittl_y
britts84813442britt__s
cuittles1045902cuittles
embrittles1452002embrittles
gristles9189202gristles
kittles113012492_kittles
littles73212782_littles
prattles10189402prattles
rattles73217302_rattles
skittles1245762skittles
spittles1038332spittles
tittles73413252_tittles
vittles103211112_vittles
whittles1496672whittles
ariettes8411353ariettes
articles10310243articles
barites94322333bari_t_es
baritones1158943baritones
bastiles10313353bastiles
battle85217863b_attle_
battled104213123b_attled
battler94113383b_attler
battlers104110973b_attlers
battues94610193b_attues
beetles9312083b_eetles
belittle1044053belittle_
belittled1243033belittled
belittler1142493belittler
belittlers1242023belittlers
bhisties1339003bhisties
bibles104617643b_i_bles
biles75542143b_i__les
bindles104016453b_indles
birles84920643b_i_rles
bistres94017213b_istres
bitches144117063b_itches
bites75641173b_i_t_es
bitted94418483b_itt_ed
bitten84715123b_itt_en
bitter84622673b_itt_er
bitters94920363b_itters
bittier94211663b_ittier
bittiest103012043b_ittiest
bitts75022593b_itt__s
blintzes1944263blintzes
blites84721213bli_t_es
blitzes18408703bli_tzes
boites84322703boi_t_es
bottle84916073b_ottle_
bottled104611233b_ottled
bottler94211883b_ottler
bottlers103810013b_ottlers
brabbles11349753brabbles
bractless1335543bractless
bractlet1239283bractlet
bractlets1344753bractlets
brailles1039493brailles
brambles14308973brambles
brattices1345553brattices
brattier1047663brattier
brattiest1148103brattiest
breathes134212903breathes
bribees11409283bri_bees
bribes105918533bri__bes
brickle15279933brickle_
bricole112810493bricole_
bridals1038623bridal_s
brides94423513bri__des
bridges113911333bri_dges
bridle94115463bri_dle_
bridled113611143bri_dled
bridler103811073bri_dler
bridlers11359183bri_dlers
briefless1443613briefless
bries74942153bri___es
brigades1236393brigades
brillos9369183bri_llos
brills84916293bri__lls
brimless1235273bri_mless
brindle104210103brindle_
brindled12407853brindled
brineless1136243brineless
brines85028853bri__nes
brinies93317913bri_nies
brioches15227253brioches
brionies10310543brionies
brises84927613bri__ses
brisses94314313bri_sses
bristlier1144313bristlier
bristliest1245143bristliest
bristly12178063bristl_y
bristols1046773bristols
briths115113863bri_t_hs
brits76433083bri_t__s
britskas14132713britskas
britt75732233britt___
brittleness1353733brittleness
brittling1235543brittling
britzkas23132053britzkas
brothels13277073brothels
brutes86118683br_ut_es
burettes1048953burett_es
bustles93816323b_ustles
butles84423913b__utles
buttes84822563b_utt_es
butties93217953b_utties
chitties13310773chitties
citoles9312553_citoles
crimples14308963crimples
cringles11329463cringles
crinkles14269163crinkles
cripples14298403cripples
critter94113033critt_er
critters103511323critters
critturs10374593critturs
cuittle946403cuittle_
cuittled1133993cuittled
cuttles93613923_cuttles
ditties83116983_ditties
dottles83912283_dottles
dribbles13348393dribbles
drizzles17295293drizzles
embrittle1342383embrittle_
embrittled1551633embrittled
entitles8710663entitles
epistles1047783epistles
fettles103912733_fettles
fribbles15287713fribbles
frijoles1834373frijoles
frites94922483fri_t_es
fritted113611333fritt_ed
fritter103912773fritt_er
fritters113810783fritters
fritts94613193fritt__s
fritzes19329453fri_tzes
frizzles19297283frizzles
gribbles13307363gribbles
griddles1145753griddles
grilles83715023gri_lles
gristle8169223gristle_
gritted94110903gritt_ed
gritter83913353gritt_er
gritters94210633gritters
grittier9316263grittier
grittiest10176983grittiest
grizzles17286193grizzles
grottoes9276753grottoes
gruntles9287233gruntles
guttles83011933_guttles
intitles8710003intitles
iritises839973iritises
istles62814983__istles
ixtles13217063__ixtles
kettles113411613_kettles
kirtles11309663_kirtles
kitties113213623_kitties
kittle104012173_kittle_
kittled12388193_kittled
kittler11338163_kittler
kittlest12297573_kittlest
little63312163_little_
littler7348553_littler
littlest8309243_littlest
mettles94115023_mettles
mottles93415803_mottles
nettles73214083_nettles
orioles7412993ori_oles
pettles93916483_pettles
pintles94118723_pintles
pottles93816983_pottles
prattle9208833prattle_
prattled11246533prattled
prattler10166343prattler
prattlers11195323prattlers
pretties10615133pretties
prickles162511093prickles
printless1137513printless
protyles13249833protyles
rattle64717613_rattle_
rattled84012953_rattled
rattler74012743_rattler
rattlers83510293_rattlers
retiles74426993_retiles
retitles83612593_retitles
riddles93215023_riddles
riffles133911163_riffles
rifles94217703_ri_fles
riftless1136943_riftless
riles55343643_ri__les
rilles64725503_ri_lles
rimples113114223_rimples
ripples113513293_ripples
rites54442553_ri_t_es
ritter63822423_ritt_er
ritters74020623_ritters
ritzes154812943_ri_tzes
rootles73215633_rootles
rottes64524833_rott_es
rustles73416413_rustles
rutiles74315843_rutiles
scuttles1056503scuttles
settles73916003_settles
shuttles1136553shuttles
skittle1135533skittle_
spittle937923spittle_
sprattles1174883sprattles
surtitles945633surtitles
tattles73616283_tattles
thistles1198233thistles
throttles1254353throttles
titles63719923_ti_tles
titties73617363_titties
tittle63613323_tittle_
trestles83012553trestles
trickles143013763trickles
trifles103814823tri_fles
trindles93211683trindles
triples94616873tri_ples
tritones83413443tritones
twattles1154383twattles
vittle94711753_vittle_
vittled11347343_vittled
wattles103814073_wattles
whistles14108213whistles
whittle13106103whittle_
whittled1594913whittled
whittler1495193whittler
whittlers1594333whittlers
wintles103414983_wintles
wrastles11328933wrastles
wrestles113310063wrestles
wriggles13286263wriggles
wrinkles15296693wrinkles
wristlet1138643wristlet
wristlets1244473wristlets
writes94420333wri_t_es
writhes134811703wri_thes
written10336343writt_en

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.406440125.6
2DLD Change Limit1461622587.06320694.0
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.56223630.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.