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

273 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
sublots9241091(None) 
sublets92616701sublets
sublot82315521sublot_
subplots1255771subplots
blots75626172__blots
sabots8314702sab_ots
slots54830532s__lots
sublate9315362sublate
sublates10315002sublates
sublet82827242sublet_
submits1139752submits
subnets92512082subnets
subplot1158132subplot_
subsets92813102subsets
abbots1039283_abbots
allots64019173_allots
auklets11298573auklets
ballots94116033ballots
bibelots1295133bibelots
blats75132503__blats
blets75324943__blets
bloats85215763__bloats
blobs95620033__blobs
blocs95219653__blocs
blogs85319233__blogs
blot65842323__blot_
blows105423833__blows
bolts76232113__bolts
boots75837973__boots
bots66453953__b_ots
brulots946223brulots
buboes104513993bub_oes
bugloss1035893bugloss
bulblets1255353bulblets
bulbous1138293bulbous
bullets93516393bullets
bullous9311663bullous
burbots1168673burbots
cablets114216343cablets
clots75627643__clots
coplots11511593coplots
cubists11359023cubists
cubits103714033cub_its
culets85518513cu_lets
cullets94015613cullets
cults75022553cu_l_ts
cutlets94113653cutlets
diglots9299503diglots
doblons1037043doblons
doublets11257363doublets
drylots1143743drylots
dubious1036893dubious
duologs935363duologs
giblets103210423giblets
giglots9367863giglots
goblets103210183goblets
guglets9369693guglets
guilts74111233guil_ts
gullets84013713gullets
gumboots1344253gumboots
guyots1036003gu_yots
harlots103413293harlots
helots95217703_helots
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inkblots1442663inkblots
jabots1538883jab_ots
lots47652093___lots
merlots92710123merlots
mulcts10298713mu_lcts
mullets93614783mullets
nubilous1044843nubilous
nutlets74111253nutlets
ocelots977233ocelots
outlets73616363outlets
outplots1086363outplots
pilots84018873_pilots
plots75025673__plots
publics13207143publics
pueblos1134843pueblo_s
pullets94015163pullets
pullouts1045223pullouts
putlogs1065083putlogs
qubits173710353qub_its
quilts154112543quil_ts
reboots93512093reboots
replots93412633replots
riblets93412553riblets
robots8313153rob_ots
rubatos9278653rubatos
rubious938283rubious
rubles83921703rubl_es
rubouts937983rubouts
runlets73310773runlets
sabbats1138633sabbats
sables85026693sabl_es
sabot7931783sab_ot_
sabulous1046123sabulous
sailors73213723sailors
sallets73719653sallets
sallows103915553sallows
salols64017873s_alols
salons63823693s_alons
salts55431883s_al_ts
samlets93813553samlets
sandlots938293sandlots
saults65816173saul_ts
sawlogs1135393sawlogs
scoots85315943s_coots
scots74025913s__cots
sculpts11377063sculpts
seaboots1047093seaboots
sellouts837493sellouts
sexpots1636293sexpots
shallots11319503shallots
shaloms1288983shaloms
sholoms1278033sholoms
shoots94619363s_hoots
shots84730853s__hots
siglos7311473siglo_s
silos56029433s_ilo_s
silts55330823s_il_ts
slaloms9106543slaloms
slats55436903s__lats
slits56128853s__lits
slobs74419873s__lobs
sloes54728873s__loes
slogs64521843s__logs
slops75026013s__lops
slot46049833s__lot_
sloth85019453s__loth
sloths94911893s__loths
slows85323463s__lows
sluts54523983s__luts
slyboots1343383slyboots
smaltos9408193smaltos
smalts85214893smal_ts
smelts85412773smel_ts
smolts84411883smol_ts
snoots64216683s_noots
snots55225123s__nots
solons65120023s_olons
solos54830793s_olo_s
soots55536213s__oots
sots45552453s___ots
spelts84614643spel_ts
spigots1037793spigots
splats84817303s_plats
splits85416413s_plits
spots74424113s__pots
squalors1744583squalors
stilts67915313stil_ts
stolons73410243stolons
stots54828553s__tots
stylets10369213stylets
subabbots1241873subabbots
subahs114512383sub_ahs
subas74724073sub__as
subatom1147053subatom
subatoms1245883subatoms
subbass1138033subbass
subblock1843673subblock
subblocks1943003subblocks
subclans1247413subclans
subclass1246623subclass
subcode1237163subcode
subcodes1338143subcodes
subcool1146233subcool
subcools1245753subcools
subcults1246933subcults
subcutes1238583subcutes
subcutis1246293subcutis
subdebs1236483subdebs
subdepots1443163subdepots
subducts13106093subducts
subdues1099893subdues
subedits1146713subedits
suberous10311793suberous
subers85722643sub_ers
subfloor13122903subfloor
subfloors14112613subfloors
subgoal1046323subgoal
subgoals1145553subgoals
subgums1235893subgums
subito8410453sub_ito
subjects19226533subjects
subjoin1645443subjoin
subjoins1745453subjoins
sublated11311503sublated
sublease1038383sublease
sublime11310363sublime
sublimes12310033sublimes
sublimits1345563sublimits
subline9316893subline
sublines10315783sublines
submiss1138083submiss
submit10312673submit_
subnet82520933subnet_
suborn8310013sub_orn
suborns939493suborns
subparts1246903subparts
subrents10310293subrents
subs66037123sub___s
subsects12267903subsects
subset83122583subset_
subsist9311573subsist
subsists1037993subsists
subsite9412873subsite
subsites10312783subsites
subsoil967293subsoil
subsoils1076653subsoils
subtest9513963subtest
subtests1037533subtests
subtexts1744903subtexts
subtlest10511363subtlest
subtlety1345063subtlety
subtone9310343subtone
subtones10311383subtones
subtotal1046263subtotal
subtotals1144993subtotals
subulate10312743subulate
subunits1046623subunits
suburbs1136503suburbs
subverts1336973subverts
subways1536163subways
subzone1846993subzone
subzones1947223subzones
succors1137413succors
succoth1445093succoth
sudors7311103su_dors
suets55126103su__ets
suints64617783su_ints
suitors73012493suitors
suits55028053su__its
sukkot936643sukkot_
sukkoth1342093sukkoth
sulcus8410493su_lcus
sulfas9311563su_lfas
sulks94818463su_l_ks
sullies74122233sullies
sulus54821883su_l_us
sumless92611123sumless
summits1137983summits
summons1158003summons
sumos75720093su_mo_s
sunbelts1044673sunbelts
sunblock1643763sunblock
sunblocks1743413sunblocks
sunbows1236023sunbows
sundogs947103sundogs
sunglows1244083sunglows
sunkets113511283sunkets
sunless73013693sunless
sunlit61516103sunlit_
sunsets72911573sunsets
sunspots1045083sunspots
supports1246513supports
surcoats1047943surcoats
surtouts846203surtouts
susliks1136443susliks
sutlers73116973sutlers
swots85518433s__wots
syboes1139343syb_oes
symbiots1573623symbiots
tablets94714383tablets
tubists9288323tubists
tubulous1045373tubulous
turbots988023turbots
unbolts9247803unbolts
weblogs1334223weblogs
zealots1636763zealots

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.390458182.1
2DLD Change Limit1340272736.06322105.7
3Display Results2732730.1102481.8
 (SQL Overall)1786912736.56327227.0
 
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.