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

394 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
aldoses831120(None) 
aldose7311091aldose_
abioses9311492abioses
acidoses1136772acidoses
adobes94411522a_dobes
adores74420712a_dores
alcoves1297872alcoves
aldolases1045222aldolases
aldols7109712aldo_ls
aliases7914492aliases
aloes54933672al_o_es
apodoses1136652apodoses
apposes11511472apposes
arkoses113910832arkoses
calloses10313382calloses
closes85425592cl_oses
doses65938502__doses
looses67328242_looses
loses56742012_l_oses
maltoses1039852maltoses
abases85720773a_bases
abdomen1237023abdomen
abdomens1345243abdomens
abduces1286243abduces
abiosis939373abiosis
abodes94417513a_bodes
aboves114512843a_boves
abuses85119103a_buses
abysses1234863abysses
accosts11107993accosts
accuses114112193accuses
acidosis1146133acidosis
acnodes1037823acnodes
across8312643acros_s
adages8412953a_dages
addaxes1634573addaxes
addles84216603a_ddles
address956103address
adduces1185763adduces
adenoses947903adenoses
adiposes1137173adiposes
adobe84814703a_dobe_
adobos9438453a_dobos
adonis7314063a_donis
adonises92611433a_donises
adopts998083a_dopts
adore65723663a_dore_
adored84714233a_dored
adorer74713443a_dorer
adorers84411723a_dorers
adorns74212613a_dorns
ados57633513a_do__s
adoze155713833a_doze_
advises11138973advises
adzes155913803a_d_zes
aedes64625143aed__es
aediles83413893aediles
aegises8311373aegises
aerobes9311493aerobes
aftosas10147143aftosas
agaroses938823agaroses
agones75719863a_gones
aides65336603aid__es
aidless83612073aidless
alamodes1148013alamodes
alates64833963al_ates
albedoes1184533albedo_es
albites9313203albites
albumoses1392853albumoses
alcades101011473alcades
alcove1178083alcove_
alcoved1375613alcoved
alder65421913ald__er
alders74218423ald_ers
aldol61212333aldo__l
aldolase944773aldolase
aldrins8310203aldrins
alehouses1246583alehouses
ales47067103al___es
algors7312553algo_rs
alibies9313323alibies
alidades1037003alidades
alines65735223al_ines
alkaloses13144853alkaloses
alkanes113812933alkanes
alkenes114212753alkenes
alkies104518093al_kies
alkines114415733alkines
alkynes14336463alkynes
allees64521483al_lees
alleges84212563alleges
alleles73812033alleles
allies63827673al_lies
allods73615083allo_ds
allonges937313allonges
allots64019173allo_ts
allover1038583allover
allovers1137673allovers
allowed111610073allowed
allows94517683allo_ws
alloyed11158033alloyed
alloys94014563allo_ys
alludes83610333alludes
allures72913113allures
almes75126543al__mes
almonds10127953almonds
almoner949383almoner
almoners1068133almoners
almost81014433almos_t
almuces11316823almuces
almudes10418263almudes
aloe45540193al_o_e_
alohas9411703al_ohas
aloins65022203al_oins
alone55732963al_one_
alphosis1347273alphosis
alpines94016193alpines
alsikes1137263alsikes
altoists848753altoists
altos55822953alto__s
amasses93912853amasses
ambones11312683ambones
amidases1136643amidases
amidones11348663amidones
amitoses1039053amitoses
amoles84122193a_moles
amuses85117943a_muses
amyloses1347213amyloses
ancones93116343ancones
anemoses10159433anemoses
anises64826693a_nises
ankuses1148203ankuses
anlases72514903anlases
anodes74418753a_nodes
anoles64827423a_noles
anuses66218773a_nuses
apheses12610703apheses
apodosis1146583apodosis
appose10411993appose_
apposed1247853apposed
apposer1147483apposer
apposers1236283apposers
apses76823913a__pses
arbores94016033arbores
arcuses94814693arcuses
ardors74416863ardo_rs
ardours8368873ardours
areoles71016953areoles
argosies939523argosies
arguses84711743arguses
ariose64818723ariose_
ariosos7409853ariosos
arises65233803a_rises
arkose104911343arkose_
arose55832083a_rose_
arouses74921293arouses
arrases71214543arrases
arrises71617583arrises
arses55733873a__rses
asceses938623asceses
asepses946363asepses
askeses1136463askeses
aspises9611643aspises
asses55629283a__sses
atlases72410643atlases
atones65225773a_tones
audiles83112613audiles
auxeses1435623auxeses
avenses1049643avenses
avgases11106313avgases
avoset9315673a_voset
avosets1036663a_vosets
avulses1035433avulses
axises134413993a_xises
axones134614513a_xones
azoles154614613a_zoles
azotes154312223a_zotes
azygoses2163313azygoses
balases93815433bal_ases
baldies105317703bald_ies
baldness1137043baldness
bandores11311603bandores
bathoses13310453bathoses
bigoses1039073bigoses
blesses93812393blesses
blisses94911513blisses
blokes123813883bl_okes
blouses94014463blouses
broses86524403_broses
cabooses1237863cabooses
caddises12329353caddises
callose9313653callose_
callouses1147683callouses
calluses1039323calluses
calvadoses1642483calvadoses
calzones1948763calzones
caseoses1039293caseoses
chaoses124715113chaoses
chooses125717413chooses
choses115825123_choses
cladodes1245323cladodes
classes94717943classes
clauses93813323clauses
cleomes1138813cleomes
clones84526563cl_ones
close76425223cl_ose_
closed95317963cl_osed
closer84918203cl_oser
closers94415313cl_osers
closest94312533cl_osest
closet85226603cl_oset
closets94611603cl_osets
cloves114918823cl_oves
clozes174915563cl_ozes
coses76949493__coses
dadoes85616533dado_es
demoses103815823demoses
deposes103117213deposes
didoes85716963dido_es
dildoes9229233dildo_es
dodoes85716103dodo_es
does56554473__do_es
doges75630163__doges
doles67843753__doles
domes85735563__domes
dopes84935043__dopes
dose56442433__dose_
dosed76626913__dosed
doser66228563__doser
dosers75723633__dosers
doss56235043__dos_s
dosses76126273__dosses
dotes65836693__dotes
douses74928933__douses
doves94728153__doves
dowses105718303__dowses
dozes155226303__dozes
ecdyses1333413ecdyses
eddoes8199143eddo_es
elapses957663elapses
eldress835003eldress
elopes85918163el_opes
endorses959973endorses
eposes84418783_eposes
eroses65327053_eroses
ethoses10311753ethoses
exposes1639963exposes
flenses1039473flenses
floes85528143fl_o_es
floosies113210233floosies
floss85118263fl_os_s
flosses103411973flosses
fucoses12148303fucoses
gallowses1374943gallowses
galluses936963galluses
galores82614323gal_ores
galoshes1236893gal_oshes
glasses84414273glasses
globes94314543gl_obes
gloss64319623gl_os_s
glosses84014123glosses
glosts74513813gl_osts
gloves104115183gl_oves
glozes164313353gl_ozes
glucoses1145333glucoses
gnoses76515163_gnoses
gooses75723053_gooses
halidomes15104863halidomes
halitoses1246603halitoses
halloes104021513hallo_es
haloes94623863hal_o_es
haploses1338853haploses
hardnoses1346233hardnoses
hexoses17228883hexoses
hidroses1237903hidroses
hoses85443173__hoses
ileuses738673ileuses
imposes113213683imposes
indoles83716363indoles
indorses968063indorses
iodises83413633iodises
judases1534443judases
ketoses114912873ketoses
lactoses1039813lactoses
laddies93715053laddies
lades65141273lad__es
ladies75124883lad_ies
ladles74619543lad_les
ladrones92710973ladrones
lanose6313593lanose_
lapises93513463lapises
lapses85217693_lapses
lases54944763_l_ases
lasses64827593_lasses
lassoes74613853lassoes
leases65428113_leases
lenses64620893_lenses
leones64417723_leones
leses54930813_l_eses
lobes75331003_l_obes
lodes66436913_l_odes
lodges86820143_lodges
loess55714703_l_oess
loges66534203_l_oges
looies65025833_looies
loose56627683_loose_
loosed75520893_loosed
loosen66615963_loosen
loosens716310953_loosens
looser65219943_looser
loosest75811563_loosest
lopes76437343_l_opes
lordoses937143lordoses
lores55045403_l_ores
lose45144583_l_ose_
losel54419423_l_osel
losels64714583_l_osels
loser54728673_l_oser
losers65123583_l_osers
loss45337963_l_os_s
losses65925233_losses
lotoses73713643lotoses
louses66230283_louses
loves85332013_l_oves
lowes85732463_l_owes
loxes125227473_l_oxes
lyases95211873_lyases
lyses84518253_l_yses
malaises10312333malaises
malposed1344563malposed
maltases1039693maltases
maltose939783maltose_
mannoses1039083mannoses
meioses9310833meioses
mioses84318853_mioses
mitoses9312183mitoses
mycoses1437723mycoses
myoses114013843_myoses
narcoses103910533narcoses
niduses837013niduses
nodose738883nodose_
nooses65623643_nooses
noses55435643__noses
oldies7314423old_ies
oldness836403oldness
opposes1149243opposes
oses46641513___oses
osmoses9138123osmoses
ostoses71213543ostoses
pandores11312453pandores
papooses1248053papooses
paradoses122510253paradoses
pathoses13412763pathoses
pleases94515483pleases
plisses94411773plisses
pluses83618073pl_uses
plusses93510693plusses
poses74642763__poses
proses84733473_proses
ptoses83514673_ptoses
pyoses114314303_pyoses
radomes10311043radomes
redoes74623753redo_es
redoxes15310883redoxes
reposes94021263reposes
riboses9310443riboses
rooses65526233_rooses
roses56445773__roses
salvoes102811313salvo_es
saroses73619333saroses
sloes54728873sl_o_es
slopes84820453sl_opes
sloshes103811803sl_oshes
soroses73117483soroses
sudses74114503sud_ses
sycoses1249133sycoses
talcose938133talcose_
tallises82713263tallises
taluses7311213tal_uses
trioses75015653trioses
undoes73917403undo_es
unlooses8127293unlooses
vadose1037963vadose_
valguses1234233valguses
valises103516263val_ises
valses94514613val__ses
vamooses1345523vamooses
vamoses1239143vamoses
viroses10310533viroses
walruses11554973walruses
xeroses143612823xeroses
xyloses1746843xyloses
zygoses20436783zygoses
zymoses21608693zymoses

Search took 8 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.1561145455.1
2DLD Change Limit1340273947.23318529.9
3Display Results3943940.1402814.3
 (SQL Overall)1786913947.52923733.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.