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

300 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
blotto819844(None) 
blotty11178341blotty
lotto55217571_lotto
bloat75229922bloat_
bloats85215762bloats
blot65842322blo_t_
blotch13197142blotch
blots75626172blo_ts
blotted103911832blotted
blotter94612852blotter
bott66548572b_ott_
bottom1048712b_ottom
botts75224862b_otts
clotty11208262clotty
grotto7349812grotto
lotte54923852_lotte
lottos64613102_lottos
motto76119512_motto
otto45220642__otto
plotty11208852plotty
potto75320942_potto
aloft8423433aloft_
altho86312603al_tho
alto47831263al__to
anatto6139913anatto
arnotto7134733arnotto
batt65053873b_att_
batts76727563b_atts
battu75216613b_attu
batty105422243b_atty
bento75922953b_ento
betta74916843b_etta
bettor83612223b_ettor
bhoot104322093bhoot_
bhoots11459903bhoots
biont7727163biont_
bionts8612393bionts
biota74516823bio_ta
biotas84313923biotas
biotic103816603biotic
biotin83215823biotin
biotite9311033biotite
biotron937293biotron
biscotto1242813biscotto
bistro8339943bistro
bitt65545813b_itt_
bitts75022593b_itts
bitty106119173b_itty
blast76532573blast_
blasts85116773blasts
blasty115611053blasty
blat66550953bl_at_
blate75933783bl_ate
blats75132503bl_ats
blatted104812713blatted
blatter94415653blatter
bleat75737003bleat_
bleats85518613bleats
blent76230953blent_
blest76431723blest_
blet66247673bl_et_
blets75324943bl_ets
blintz1788843blintz
blite76225353bl_ite
blites84721213blites
blithe115810863blithe
blitz165318133bl_itz
bloated104513433bloated
bloater94013423bloater
blob86027093blo__b
blobs95620033blo_bs
bloc85023273blo__c
block134917843blo_ck
blocks144513943blocks
blocky17388353blocky
blocs95219653blo_cs
blog75723823blo__g
blogs85319233blo_gs
bloke114316633blo_ke
blokes123813883blokes
blond85618373blo_nd
blonde94813293blonde
blonds95213343blonds
blood85319523blo_od
bloods94614843bloods
bloody124710173bloody
blooey115110793blooey
blooie83913193blooie
bloom95918973blo_om
blooms104613173blooms
bloomy134510113bloomy
bloop96116153blo_op
bloops106611343bloops
blossom11114963blossom
blotchy17293973blotchy
blotters104110983blotters
blottier10336413blottier
blotting113910433blotting
blouse84714723blouse
blouson974893blouson
blousy11459123blousy
blow95827193blo__w
blowby16467513blowby
blowed125016693blowed
blower115316573blower
blowjob2141753blowjob
blown105716673blo_wn
blows105423833blo_ws
blowsy14579453blowsy
blowup1335063blowup
blowy134315323blo_wy
blowzy23516673blowzy
bluet75631193bluet_
bluets87215493bluets
blunt75525023blunt_
blunts84512893blunts
blurt77625623blurt_
blurts84412643blurts
boat66360313b_oat_
boats75635153b_oats
boffo136010373b_offo
boho96923323b_o_ho
boite74426323b_oite
bolero8412093bolero
bolete8519613bolete
boleti8413403boleti
bolo65535953b_o_lo
bolt66254173b_olt_
bolted94617803bolted
bolter83920753bolter
bolts76232113b_olts
bongo85720943b_ongo
bonito8313433bonito
boo58163663b_o__o
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
bookoo1248343bookoo
boost75132473boost_
boosts86115013boosts
boot67759373b_oot_
booted94822733booted
bootee84323023bootee
booth105522013b_ooth
booths115313793booths
bootie85421153bootie
boots75837973b_oots
booty106125913b_ooty
bort65960963b_ort_
borts76735453b_orts
borty105522833b_orty
bortz165722203b_ortz
boston8513043b_oston
bot59680403b_o_t_
bota66236503b_o_ta
botas75328783b_otas
botch126717453b_otch
botel75121863b_otel
both96533433b_o_th
bothy136713963b_othy
bots66453953b_o_ts
bottle84916073b_ottle
bottoms1136983b_ottoms
bout66353293b_out_
bouton8311533b_outon
bouts75131313b_outs
boyo96923843b_o_yo
bozo156821413b_o_zo
bratty1159683bratty
britt75732233britt_
britts84813443britts
bromo95217203bro_mo
bronco10179493bronco
broo65129823bro__o
broth106521093bro_th
broths115013923broths
brothy14519623brothy
buteo75419893b_uteo
butt65143743b_utt_
butte74924293b_utte
button8310273b_utton
butts75824253b_utts
butty104020113b_utty
calotte9510563calotte
chott103923923chott_
chotts113610983chotts
cloot76127053cloot_
cloots85113693cloots
clot66542423clo_t_
cloth105817543clo_th
clothe114712993clothe
cloths115512483cloths
clots75627643clo_ts
clotted104011823clotted
clout75330463clout_
clouts87017203clouts
conto76027173_conto
cotta75818573_cotta
cotton8312993_cotton
culotte976893culotte
datto65416423_datto
ditto65315603_ditto
dotty94516103_dotty
flattop1244403flattop
float85928573float_
floats96816253floats
floaty124210943floaty
flota85315643flo_ta
flotas94013003flotas
flout86226203flout_
flouts94315273flouts
ghetto1036073ghetto
gloat65427683gloat_
gloats74515423gloats
glost65422933glost_
glosts74513813glosts
glottal835103glottal
glottic1036643glottic
glottis837163glottis
glout65925813glout_
glouts74414713glouts
glutton844893glutton
grottos8337333grottos
grotty10389833grotty
jotty155012603_jotty
klepto1244453klepto
knotty13315223knotty
koto86323463_ko_to
latte55426303_latte
lento57223393_lento
litho86513783_litho
loath84918603_loath
lobo67229863_lo_bo
loco67030743_lo_co
loft76539143_loft_
lofts85518363_lofts
lofty115813303_lofty
logo57931763_lo_go
loo38359823_lo__o
loot46955823_loot_
loots55431423_loots
lost47951493_lost_
lot38179263_lo_t_
lota47233503_lo_ta
lotah85315853_lotah
lotas55926303_lotas
loth76132133_lo_th
loti46431833_lo_ti
lotic76420663_lotic
lotion65716523_lotion
lotos54724633_lotos
lots47652093_lo_ts
lotted74222403_lotted
lotter64025603_lotter
lottes65322753_lottes
lotus55718063_lotus
lout45952143_lout_
louts56330273_louts
lytta888063_lytta
molto75619603_molto
mott66648443_mott_
motte75526973_motte
mottos84615243_mottos
motts76527003_motts
mulatto944733mulatto
onto46127663__onto
ottos54714323__ottos
petto76021043_petto
photo104417223pho_to
plot66141233plo_t_
plots75025673plo_ts
plotted104612373plotted
plotter94113663plotter
plotz164616993plo_tz
potato8513433_potato
pottos84615873_pottos
potty105621003_potty
pronto8313993pronto
putto75617663_putto
ridotto844323ridotto
risotto744323risotto
roto45935053_ro_to
rotte54625933_rotte
shott85332173shott_
shotts93614683shotts
slitty9329163slitty
slot46049823slo_t_
sloth85019443slo_th
sloths94911883sloths
slots54830523slo_ts
slotted84613873slotted
slotter73314443slotter
slutty9248003slutty
snotty9489193snotty
spotty11448573spotty
stott56929783stott_
stotts64612853stotts
zlote143912943zlo_te
zloty17399793zlo_ty
zlotys18374173zlotys

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 Filter1786911127160.1531167915.0
2DLD Change Limit1127163006.45617459.1
3Display Results3003000.1062830.2
 (SQL Overall)1786913006.71526610.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.