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

417 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
blotty1117834(None) 
blotto8198441blotto
clotty11208261clotty
plotty11208851plotty
batty105422242b_atty
bitty106119172b_itty
blasty115611052blasty
bloat75229922bloat_
bloats85215762bloats
blocky17388352blocky
bloody124710172bloody
blooey115110792blooey
bloomy134510112bloomy
blot65842322blo_t_
blotch13197142blotch
blotchy17293972blotchy
blots75626172blo_ts
blotted103911832blotted
blotter94612852blotter
blousy11459122blousy
blowby16467512blowby
blowsy14579452blowsy
blowy134315322blo_wy
blowzy23516672blowzy
booty106125912b_ooty
borty105522832b_orty
bothy136713962b_othy
bott66548572b_ott_
botts75224862b_otts
bratty1159682bratty
brothy14519622brothy
butty104020112b_utty
dotty94516102_dotty
floaty124210942floaty
grotty10389832grotty
jotty155012602_jotty
knotty13315222knotty
lofty115813302_lofty
lotte54923852_lotte
lotto55217572_lotto
potty105621002_potty
slitty9329162slitty
slutty9248002slutty
snotty9489202snotty
spotty11448582spotty
zloty17399792zlo_ty
abbotcy1642093abbotcy
agouty10366913agouty
aloft8423433aloft_
baloney1237483baloney
banty106624003b_anty
batt65053873b_att_
batts76727563b_atts
battu75216613b_attu
bawty135614103b_awty
beauty115410163beauty
betony114211583betony
betta74916843b_etta
bhoot104322103bhoot_
bhoots11459913bhoots
bigotry1344523bigotry
biont7727163biont_
bionts8612393bionts
biopsy1334533biopsy
biota74516823bio_ta
biotas84313923biotas
biotic103816613biotic
biotin83215833biotin
biotite9311033biotite
bitsy104511303b_itsy
bitt65545813b_itt_
bitts75022593b_itts
blabby1234813blabby
blast76532573blast_
blasts85116773blasts
blat66550953bl_at_
blate75933783bl_ate
blats75132503bl_ats
blatted104812713blatted
blatter94415653blatter
bleary115112553bleary
bleat75737003bleat_
bleats85518613bleats
blebby1233743blebby
blenny1156203blenny
blent76230953blent_
blest76431723blest_
blet66247673bl_et_
blets75324943bl_ets
blighty16356843blighty
blimey13468453blimey
blimy125212823bl_imy
blintz1788843blintz
blite76225353bl_ite
blites84721213blites
blithe115810863blithe
blitz165318133bl_itz
bloated104513433bloated
bloater94013423bloater
blob86027093blo__b
blobs95620033blo_bs
bloc85023273blo__c
block134917843blo_ck
blocks144513943blocks
blocs95219653blo_cs
blog75723823blo__g
blogs85319233blo_gs
bloke114316633blo_ke
blokes123813883blokes
blond85618373blo_nd
blonde94813293blonde
blonds95213343blonds
blood85319523blo_od
bloods94614843bloods
blooie83913193blooie
bloom95918973blo_om
blooms104613173blooms
bloop96116153blo_op
bloops106611343bloops
blotters104110983blotters
blottier10336413blottier
blotting113910433blotting
blouse84714723blouse
blow95827193blo__w
blowbys17353813blowbys
blowed125016693blowed
blower115316573blower
blowfly1843243blowfly
blown105716673blo_wn
blows105423833blo_ws
blowup1335063blowup
bluely113310083bluely
bluesy11448983bluesy
bluet75631193bluet_
bluets87215493bluets
bluey104817053bl_uey
blunt75525023blunt_
bluntly1235223bluntly
blunts84512893blunts
blurry11437673blurry
blurt77625623blurt_
blurts84412643blurts
boat66360313b_oat_
boats75635153b_oats
bobby114814663b_obby
body107425673b_o_dy
bogey115220233b_ogey
boggy126116073b_oggy
bogy106426193b_o_gy
boite74426323b_oite
boldly12399423boldly
bolete8519613bolete
boleti8413403boleti
boloney1247763boloney
bolshy1444883bolshy
bolt66254173b_olt_
bolted94617803bolted
bolter83920753bolter
bolts76232113b_olts
boney105227313b_oney
bonny105816623b_onny
bony96732083b_o_ny
booby125319513b_ooby
boody115420403b_oody
boogey124711523boogey
boogy114518323b_oogy
boomy125421823b_oomy
boost75132473boost_
boosts86115013boosts
boot67759373b_oot_
booted94822733booted
bootee84323023bootee
bootery1238983bootery
booth105522013b_ooth
booths115313793booths
bootie85421163bootie
boots75837973b_oots
boozy194917063b_oozy
bort65960963b_ort_
borts76735453b_orts
bortz165722203b_ortz
bosky145612393b_osky
bossy105515973b_ossy
bot59680403b_o_t_
bota66236503b_o_ta
botany1139263b_otany
botas75328783b_otas
botch126717453b_otch
botchy16537823b_otchy
botel75121863b_otel
botfly1436093b_otfly
both96533433b_o_th
bots66453953b_o_ts
bottle84916073b_ottle
bottom1048723b_ottom
bounty113411073bounty
bousy104917843b_ousy
bout66353293b_out_
bouts75131313b_outs
boxy166420733b_o_xy
boy87753563b_o__y
britt75732233britt_
brittly12165973brittly
britts84813443britts
brolly114510853brolly
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
broth106521093bro_th
broths115013923broths
browny144510043browny
buoy95921783buo__y
busty105621013b_usty
butt65143743b_utt_
butte74924293b_utte
butts75824253b_utts
calotte9510563calotte
catty104520413_catty
chatty14419363chatty
chitty14329433chitty
chott103923933chott_
chotts113610993chotts
cloddy13405233cloddy
cloggy1344873cloggy
cloot76127053cloot_
cloots85113693cloots
clot66542423clo_t_
cloth105817543clo_th
clothe114712993clothe
cloths115512483cloths
clots75627643clo_ts
clotted104011823clotted
cloudy12517803cloudy
clout75330463clout_
clouts87017203clouts
cloy96623833clo__y
cotta75818573_cotta
culotte976893culotte
cutty105417223_cutty
ditty95019293_ditty
dorty96220813_dorty
doty86128223_do_ty
fatty115117413_fatty
flatly123110213flatly
flinty126112493flinty
flirty12499143flirty
float85928573float_
floats96816253floats
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
flota85315643flo_ta
flotas94013003flotas
floury12449573floury
flout86226203flout_
flouts94315273flouts
flutey125212523flutey
fluty114415643fl_uty
footsy12587933footsy
footy115820533_footy
forty114824273_forty
fretty1249223fretty
frosty124710633frosty
frothy15578373frothy
ghosty13467213ghosty
gleety10479193gleety
glinty106910693glinty
glitzy19404783glitzy
gloat65427683gloat_
gloats74515423gloats
globby1434683globby
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293glo_ry
glossy10549003glossy
glost65422933glost_
glosts74513813glosts
glottal835103glottal
glottic1036653glottic
glottis837173glottis
glout65925813glout_
glouts74414713glouts
gnatty10336483gnatty
gouty95217363_gouty
gritty10338403gritty
grotto7349813grotto
grouty104710983grouty
gutty94516993_gutty
helotry1345653helotry
hooty115022443_hooty
hotly115815483_hotly
jetty156212583_jetty
jolty155713033_jolty
jutty154914643_jutty
kitty124614563_kitty
klutzy2243003klutzy
laity85318903_laity
lathy115215063_lathy
latte55426303_latte
lefty115613563_lefty
linty87126563_linty
loamy105913343_loamy
loath84918603_loath
lobby125113923_lobby
loft76539143_loft_
lofts85518363_lofts
loggy105714193_loggy
logy87025783_lo_gy
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
loot46955823_loot_
loots55431423_loots
loppy125911663_loppy
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
lost47951493_lost_
lot38179263_lo_t_
lota47233503_lo_ta
lotah85315853_lotah
lotas55926303_lotas
loth76132133_lo_th
loti46431843_lo_ti
lotic76420673_lotic
lotos54724633_lotos
lots47652093_lo_ts
lotted74222403_lotted
lotter64025603_lotter
lottery10389833_lottery
lottes65322753_lottes
lottos64613103_lottos
lotus55718063_lotus
loury85716753_loury
lousy84617083_lousy
lout45952143_lout_
louts56330273_louts
lowly114113333_lowly
lusty85417573_lusty
lytta888063_lytta
motey105922953_motey
mothy136214553_mothy
mott66648443_mott_
motte75526973_motte
motto76119513_motto
motts76527003_motts
natty85719143_natty
netty85816763_netty
nitty85418313_nitty
nutty84816873_nutty
obloquy2141873obloquy
ology94113113olo_gy
otto45220643__otto
patty104723613_patty
petty105320293_petty
platy105021663pl_aty
plenty11311413plenty
ploidy1237483ploidy
plot66141233plo_t_
plots75025673plo_ts
plotted104612373plotted
plotter94113663plotter
plotz164617003plo_tz
ploy96123603plo__y
polity113015863polity
potsy105815613_potsy
potto75320943_potto
pouty107018813_pouty
pretty11510873pretty
putty104721403_putty
ratty84819593_ratty
rooty86423023_rooty
rotte54625933_rotte
rutty85617803_rutty
scatty115310653scatty
shitty124110063shitty
shorty124313203shorty
shott85332193shott_
shotts93614703shotts
slanty95114843slanty
slatey95417063slatey
slaty86523153sl_aty
sleety94112653sleety
slobby1334803slobby
sloppy1395303sloppy
sloshy12366623sloshy
slot46049833slo_t_
sloth85019453slo_th
sloths94911893sloths
slots54830533slo_ts
slotted84613883slotted
slotter73314453slotter
slowly1237153slowly
smutty11266323smutty
snooty94211513snooty
snouty9419953snouty
softy115414483_softy
sooty84924843_sooty
sporty115112493sporty
stott56929793stott_
stotts64612863stotts
tatty84720183_tatty
titty85316653_titty
toothy12529693toothy
tootsy9437983tootsy
trouty95211793trouty
tutty85217023_tutty
witty114717013_witty
zlote143912943zlo_te
zlotys18374173zlotys
zooty175415353_zooty

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127164174.71623900.8
3Display Results4174170.1263309.5
 (SQL Overall)1786914175.21834245.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.