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

249 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
brittle916860(None) 
brattle9249251brattle
bristle91910101bristle
brittled11186091brittled
brittler10165981brittler
brittles10178651brittles
brittly12165971brittly
battle85217862b_attle
belittle1044052belittle
bottle84916072b_ottle
brattled11196722brattled
brattles10199332brattles
brickle15279932brickle
bricole112810492bricole
bridle94115462bri_dle
brindle104210102brindle
bristled11187342bristled
bristles101510432bristles
bristly12178062bristly
britt75732232britt__
brittlely1442472brittlely
brittlest11146192brittlest
britts84813442britt_s
cuittle946402cuittle
embrittle1342382embrittle
gristle8169222gristle
kittle104012172_kittle
little63312162_little
prattle9208832prattle
rattle64717612_rattle
skittle1135532skittle
spittle937922spittle
tittle63613322_tittle
vittle94711752_vittle
whittle13106102whittle
ariette7312373ariette
aristae7312533aristae
article9310923article
barite84224813bari_t_e
baritone1058643baritone
bastile9313913bastile
battled104213123b_attled
battler94113383b_attler
battles94517683b_attles
battue84311003b_attue
beetle8311673b_eetle
belittled1243033belittled
belittler1142493belittler
belittles1143873belittles
bhistie1236773bhistie
bible95119423b_i_ble
bile66147183b_i__le
bindle94516263b_indle
birle75023633b_i_rle
bistre83815023b_istre
bitable11312203b_itable
bite66547003b_i_t_e
bitt65545813b_itt__
bitted94418483b_itted
bitten84715123b_itten
bitter84622673b_itter
bittier94211663b_ittier
bitts75022593b_itt_s
bitty106119173b_itt_y
blintze1833903blintze
blite76225353bli_t_e
blithe115810863bli_the
boite74426323boi_t_e
bottled104611233b_ottled
bottler94211883b_ottler
bottles94216273b_ottles
brabble10349973brabble
bractlet1239283bractlet
braille939713braille
bramble133710033bramble
brattice1245693brattice
brattier1047663brattier
bratty1159683bratt_y
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
brindled12407853brindled
brindles113710223brindles
brine75132273bri__ne
brioche14275923brioche
briskly16165403briskly
bristlier1144313bristlier
bristol937043bristol
bristols1046773bristols
brit66350153bri_t__
britches15278683britches
brith104924373bri_t_h
briths115113863bri_ths
brits76433083bri_t_s
britska13132883britska
brittling1235543brittling
britzka22132133britzka
brothel12318193brothel
brutal859383brutal_
brute75321783br_ut_e
brutely1235933brutely
burette939853burett_e
bustle84015483b_ustle
butle75023103b__utle
butte74924293b_utt_e
cattle85118903_cattle
citole8311503_citole
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
cripple13378583cripple
cristae9310613cristae
critter94113033critter
crittur9315133crittur
cuittled1133993cuittled
cuittles1045903cuittles
cuttle84113893_cuttle
dottle74212503_dottle
dribble12368603dribble
drizzle16285913drizzle
embrittled1551633embrittled
embrittles1452003embrittles
entitle7610293entitle
epistle957893epistle
fettle93713123_fettle
friable122612563friable
fribble14287783fribble
frijole1734583frijole
fritt86129413fritt__
fritted113611333fritted
fritter103912773fritter
fritts94613193fritt_s
frizzle18367043frizzle
gribble12297273gribble
griddle1035503griddle
grille74315743gri_lle
gripple12416613gripple
gristles9189203gristles
gristly11187333gristly
gritted94110903gritted
gritter83913353gritter
grittier9316263grittier
grittily1244183grittily
gritty10338403gritt_y
grizzle16306113grizzle
gruntle8257053gruntle
guttle74111973_guttle
intitle7610583intitle
istle52214713__istle
ixtle12168013__ixtle
kettle104311613_kettle
kirtle10309473_kirtle
kittel10368873_kittel
kittled12388193_kittled
kittler11338163_kittler
kittles113012493_kittles
littler7348553_littler
littles73212783_littles
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
oriole6814293ori_ole
pettle84116053_pettle
pintle83818263_pintle
pottle84416103_pottle
prattled11246533prattled
prattler10166343prattler
prattles10189403prattles
prickle153611013prickle
prithee1239933prithee
protyle12229453protyle
rattled84012953_rattled
rattler74012743_rattler
rattles73217303_rattles
rattly94111543_rattly
retile65929673_retile
retitle73913093_retitle
riddle83915713_riddle
riffle124210233_riffle
rifle85518333_ri_fle
rile45650533_ri__le
rille55728733_ri_lle
rimple103814583_rimple
ripple103413913_ripple
rite45849453_ri_t_e
ritter63822423_ritter
rootle63214453_rootle
rotte54625933_rott_e
rustle63615413_rustle
rutile65217683_rutile
scuttle936463scuttle
settle63915663_settle
shuttle1046103shuttle
skittles1245763skittles
spittles1038333spittles
sprattle1054763sprattle
surtitle845283surtitle
tattle64115653_tattle
thistle10107803thistle
throttle1164083throttle
title54721073_ti_tle
tittie63213153_tittie
tittles73413253_tittles
trestle72611363trestle
triable92515393triable
trickle133613443trickle
trifle94012883tri_fle
trindle83311363trindle
triple84215923tri_ple
triste63818643trist_e
trite54730033tri_t_e
tritely1039003tritely
tritone73613883tritone
twattle1064273twattle
vittae93911003_vittae
vittled11347343_vittled
vittles103211113_vittles
wattle94314213_wattle
whistle13107533whistle
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
wintle94014603_wintle
wrastle10368993wrastle
wrestle10298843wrestle
wriggle12316213wriggle
wrinkle14296923wrinkle
wristlet1138643wristlet
writable1338753writable
write85522833wri_t_e
writhe125310703wri_the
written10336343written

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.403443402.0
2DLD Change Limit1340272496.34621119.9
3Display Results2492490.0932677.4
 (SQL Overall)1786912496.84226116.8
 
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.