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

407 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
plotty1120885(None) 
blotty11178341blotty
clotty11208261clotty
potty105621001p_otty
blotto8198442blotto
dotty94516102_dotty
floaty124210942floaty
grotty10389832grotty
jotty155012602_jotty
knotty13315222knotty
lofty115813302_lofty
lotte54923852_lotte
lotto55217572_lotto
patty104723612p_atty
petty105320292p_etty
platy105021662pl_aty
plenty11311412plenty
ploidy1237482ploidy
plot66141232plo_t_
plots75025672plo_ts
plotted104612372plotted
plotter94113662plotter
plotz164616992plo_tz
ploy96123602plo__y
polity113015862polity
potsy105815612p_otsy
potto75320942p_otto
pouty107018812p_outy
pretty11510872pretty
putty104721402p_utty
slitty9329162slitty
slutty9248002slutty
snotty9489192snotty
spotty11448572spotty
zloty17399792zlo_ty
agouty10366913agouty
aloft8423433aloft_
aplenty1237173aplenty
batty105422243_batty
bitty106119173_bitty
blasty115611053blasty
bloat75229923bloat_
bloats85215763bloats
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blot65842323blo_t_
blotch13197143blotch
blotchy17293973blotchy
blots75626173blo_ts
blotted103911833blotted
blotter94612853blotter
blousy11459123blousy
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
booty106125913_booty
borty105522833_borty
bothy136713963_bothy
bott66548573_bott_
botts75224863_botts
bratty1159683bratty
brothy14519623brothy
butty104020113_butty
calotte9510563calotte
catty104520413_catty
chatty14419363chatty
chitty14329433chitty
chott103923923chott_
chotts113610983chotts
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
glottic1036643glottic
glottis837163glottis
glout65925813glout_
glouts74414713glouts
gnatty10336483gnatty
gouty95217363_gouty
gritty10338403gritty
grotto7349813grotto
grouty104710983grouty
gutty94516993_gutty
helotry1345653helotry
hooty115022433_hooty
hotly115815473_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
loti46431833_lo_ti
lotic76420663_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
ology94113113olo_gy
otto45220643__otto
painty114714753painty
palette93613983palette
paltry114910403paltry
pantry115014103pantry
panty105929303p_anty
parity114719873parity
partly116315473partly
party106630613p_arty
pastry114913033pastry
pasty105725053p_asty
patly105020583p_atly
patsy105717203p_atsy
paty95234563p__aty
peaty105725693p_eaty
pelota8612833pelo_ta
pelotas9410723pelotas
peloton938743peloton
peltry11288653peltry
peony105717563peo_ny
pertly115312543pertly
pesty106421713p_esty
petti75119453p_etti
petto76021043p_etto
phoney143612983phoney
phony136715443pho_ny
phooey14379233phooey
phot95534353pho_t_
photic133316423photic
photo104417223pho_to
photog12379803photog
photon1111514823photon
photos113316633photos
phots105418493pho_ts
piety105817303p_iety
pigsty1235933pigsty
pilosity1366323pilosity
pilot77435063pilo_t_
piloted10310323piloted
pilots84018873pilo_ts
piosity1268643piosity
pithy135614463p_ithy
pitta75018693p_itta
pity96031933p__ity
plaguy12386413plaguy
plait75631573plait_
plaits83816473plaits
plant75437113plant_
plants84921803plants
plashy14448873plashy
plat66048873pl_at_
platan83913693platan
plate74635113pl_ate
plated95225773plated
platen84518203platen
plater84427693plater
plates85432243plates
plats75531373pl_ats
platted103614263platted
platter93917413platter
platys11459853platys
play95928983pl__ay
pleat74734473pleat_
pleats85218593pleats
plinth11310453plinth
plisky1533713plisky
plod76723273plo__d
plods85719293plo_ds
plonk114613983plo_nk
plonks124210423plonks
plop86625743plo__p
plops95920333plo_ps
plottage1144433plottage
plotters104011553plotters
plottier10327263plottier
plotties103111413plotties
plotting113011013plotting
plotzed19376213plotzed
plotzes18317693plotzes
plough12577563plough
plover115312613plover
plow95923233plo__w
plowboy1743183plowboy
plowed124213203plowed
plower114315063plower
plows105419903plo_ws
ployed124310563ployed
ploys105816593plo_ys
plucky17406583plucky
plummy15375663plummy
plumy124213233pl_umy
plunky15377953plunky
plushy14406973plushy
plutei8408903plutei
pluton838853pluton
ply86323553pl___y
poboy121612223p_oboy
pocky165314603p_ocky
podgy125610773p_odgy
poesy105014063p_oesy
poet65552903p_oet_
poetry1139383poetry
poets76024443p_oets
pogey116017893p_ogey
pogy105623553p_o_gy
pointy114913283pointy
pokey145318973p_okey
poky135922153p_o_ky
policy133211513policy
polite83625073polite
poly96235153p_o_ly
pommy14449863p_ommy
pony96434053p_o_ny
poofy136213273p_oofy
poorly1137893poorly
poppy114813193p_oppy
popsy125713403p_opsy
porgy116916123p_orgy
porky145019333p_orky
porny106020193p_orny
port66059633p_ort_
portly114713403portly
ports75934593p_orts
post67953363p_ost_
posts75228783p_osts
posy96028423p_o_sy
pot58078433p_o_t_
potato8513433p_otato
potboy1397813p_otboy
pots66452363p_o_ts
potted94624013p_otted
potter83926983p_otter
pottery123011073p_ottery
pottle84416103p_ottle
pottos84615873p_ottos
pout65752553p_out_
pouts75530323p_outs
poxy166820893p_o_xy
probity14299683probity
proette9312363proette
pronto8313993pronto
prost75434103prost_
prosy106319253pro_sy
protea82214763protea
protei82615303protei
proton84318893proton
protyl11308213protyl
proxy175011013pro_xy
ptooey11346413ptooey
ptotic102713363ptotic
punty106021613p_unty
purity114114913purity
purty105019403p_urty
putt66937843p_utt_
putti76018743p_utti
putto75617663p_utto
putts75719273p_utts
ratty84819593_ratty
rooty86423023_rooty
rotte54625933_rotte
rutty85617803_rutty
scatty115310653scatty
shitty124110053shitty
shorty124313193shorty
shott85332173shott_
shotts93614683shotts
slanty95114843slanty
slatey95417063slatey
slaty86523153sl_aty
sleety94112653sleety
slobby1334803slobby
sloppy1395303sloppy
sloshy12366623sloshy
slot46049823slo_t_
sloth85019443slo_th
sloths94911883sloths
slots54830523slo_ts
slotted84613873slotted
slotter73314443slotter
slowly1237153slowly
smutty11266323smutty
snooty94211503snooty
snouty9419953snouty
softy115414483_softy
sooty84924833_sooty
splotch1442843splotch
splotchy1841783splotchy
sporty115112493sporty
stott56929783stott_
stotts64612853stotts
tatty84720183_tatty
titty85316653_titty
toothy12529693toothy
tootsy9437983tootsy
toplofty1642293toplofty
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.190940478.9
2DLD Change Limit1127164075.56020272.7
3Display Results4074070.1902142.1
 (SQL Overall)1786914075.94030082.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.