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

395 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
aerobes931149(None) 
aerobe8412401aerobe_
adobes94411532a_dobes
aerates74627492aerates
aeries64737782aer_ies
aerobat9514472aerobat
aerobats1049842aerobats
aerobia939462aerobia
aerobic11310212aerobic
aerobics1246832aerobics
aerogel836522aerogel
aerogels945592aerogels
anaerobes1144992anaerobes
areoles71016952areoles
arrobas969212arrobas
berobed1238232berobed
earlobes1056142earlobes
enrobes92211112enrobes
erodes74819882_erodes
eroses65327052_eroses
heroes94923822hero_es
probes104119452_probes
reprobes121910292reprobes
robes75133302__robes
saprobes1237032saprobes
strobes93813262strobes
unrobes9269732unrobes
xeroses143612822xeroses
xeroxes13246442xeroxes
zeroes154314342zero_es
abbes96723523a__bbes
abioses9311493abioses
abodes94417513a_bodes
aboves114512843a_boves
abrades10312073abrades
acerber1135243acer_ber
acerbest1245463acer_best
acerolas1048053acerolas
acerose9310893acerose_
acerous9513333acero_us
acetones10310033acetones
acnodes1037833acnodes
acres76327763acr__es
acrobat11411813acrobat
acrobats1258343acrobats
acrogen1038203acrogen
acrogens1147243acrogens
across8312643acro_ss
adenoses947903adenoses
adobe84814713a_dobe_
adobos9438453a_dobos
adores74420723a_dores
aedes64625153ae__des
aediles83413903aediles
aegises8311373aegises
aeons57624653ae_o_ns
aerate64830553aerate_
aerated85322373aerated
aerials74017553aerials
aerie54634603aer_ie_
aeried74221863aer_ied
aerier64823153aer_ier
aeriest73924053aer_iest
aerifies111313393aerifies
aero45435343aero___
aerobioses1244493aerobioses
aerobium1246303aerobium
aerobrakes1643363aerobrakes
aerodynes1344603aerodynes
aerolites9312583aerolites
aerophobes1746523aerophobes
aerosat7417183aerosat
aerosats8411013aerosats
aerosol747683aerosol
aerosols847213aerosols
aerugos834923aerugos
agaroses938823agaroses
agones75719863a_gones
agrafes1137523agrafes
agrees74915323agr_ees
airbus848343air_bus
airholes1138033airholes
alcoves1297873alcoves
aldoses8311203aldoses
aleurones965593aleurones
aloes54933673a_lo_es
amarones10311353amarones
ambones11312683ambones
amerces1149853amer_ces
amoles84122193a_moles
anaerobe1044823anaerobe_
ancones93116343ancones
anemones10249473anemones
anemoses10159433anemoses
anergies9310453anergies
aneroids9310203aneroids
anodes74418763a_nodes
anoles64827433a_noles
aperies9423203aper_ies
apposes11511473apposes
approves15126833approves
apres75426403apr__es
aproned10311503aproned
aprons8316993apro_ns
apropos1138843apropos
arabesk1332863a_rabesk
arables91814973a_rables
arames84622573a_rames
ararobas1046183ararobas
arbores94016033arbores
arbors84717883a_rbors
arbs66834733a_r_b_s
arches114822043a_rches
ardebs937013a_rdebs
arenes64928393a_renes
areolas71013863areolas
areole61017283areole_
ares45871023a_r__es
aretes64425353a_retes
argles75218483a_rgles
argues74516413a_rgues
arises65233803a_rises
arkoses113910833arkoses
arles56735743a_r_les
armies85123693a_rmies
aroids75118223a_roids
aromas81018613a_romas
arose55832083a_rose_
arouse65019983a_rouse
arouses74921293a_rouses
arrases71214543arrases
arrises71617583arrises
arrives101311513arrives
arroba898663arrob_a
arrowed1148113arrowed
arrows92813483arro_ws
arroyos1036533arroyos
arses55733873a_r_ses
ascribes1246193ascribes
atones65225773a_tones
aureoles838283aureoles
aures55137093aur__es
aurochs1245983aurochs
auroras7311703auroras
aurous64119263auro_us
autobus996513autobus
averages1249183averages
axones134614513a_xones
azoles154614613a_zoles
azotes154312223a_zotes
barbes104526233bar_bes
bathrobes1644393bathrobes
becomes132911963becomes
behoves15177353behoves
berakes134815773berakes
berates94126873berates
berimes115216643berimes
bermes106023003ber_mes
berries94423553berries
bribes105918533_bribes
bromes104719763_bromes
broses86524403_broses
caribes113715643caribes
carobs104818103carob_s
cenotes92814543cenotes
cerates95428253cerates
ceres75540013cer__es
cerises94722253cerises
cerites94823433cerites
ceros74726073cero__s
cerous85821203cero_us
certes84623083cer_tes
ceruses93716233ceruses
chromes142914933chromes
creoles9913323creoles
crones84729243_crones
crores86121163_crores
crozes174417663_crozes
daemones11209163daemones
debones103315113debones
decodes113914983decodes
demobs11429483demob_s
demoses103815823demoses
demotes104717673demotes
denotes83817003denotes
depones103717093depones
deposes103117213deposes
derates84028893derates
derbies103016053derbies
derides93420853derides
derives114017813derives
derries83124623derries
detoxes1538803detoxes
devotes113713753devotes
disrobes1139743disrobes
drones75023433_drones
droves105116673_droves
earlobe946543earlobe_
elopes85918163_elopes
emotes84620283_emotes
enrobe86610793enrobe_
enrobed10279253enrobed
enrober9218623enrober
enrobers10236953enrobers
epodes94315563_epodes
eposes84418783_eposes
erases64425403_erases
ernes55224813_er_nes
erode64520993_erode_
eroded84313583_eroded
eros45238453_ero__s
erose55727273_erose_
erses55826803_er_ses
evokes13459683_evokes
faeries104118993faer_ies
feres86038183fer__es
ferlies103216693ferlies
ferries103521083ferries
ferules103112723ferules
froes86126693_fro_es
furores10310033furores
garderobes1452293garderobes
garotes8614563garotes
garrotes969363garrotes
gemotes103712143gemotes
genomes103611703genomes
geodes8412153ge_odes
geoprobes1443743geoprobes
globes94314543_globes
grebes93813613_grebes
gropes95220403_gropes
groves104318103_groves
haeredes1246333haeredes
haeres94017033haer__es
hebes105521673he__bes
herbed123513453her_bed
herbs105520503her_b_s
heredes11313133heredes
heres86245903her__es
heroics122912003heroics
heroines112916573heroines
heroins103518013heroins
heroizes202610983heroizes
herons94820543hero_ns
heros84930863hero__s
herpes115517323her_pes
herries104025073herries
hertzes1938303hertzes
hexones17299143hexones
hexoses17228883hexoses
irones64724013_irones
jerboas1636163jerboas
jerkies183411583jerkies
jerries143817513jerries
kebobs14427293kebob_s
kerbed13339703ker_bed
kerbs115013673ker_b_s
kermes124616133ker_mes
kernes104717533ker_nes
kerogen1236093kerogen
kerogens1345763kerogens
kerries113317913kerries
ketones115014503ketones
ketoses114912873ketoses
ladrones92710973ladrones
leones64417723le_ones
lobes75331003__lobes
madrones112912283madrones
manropes1237913manropes
meioses9310833meioses
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
merges94122493mer_ges
merises93421423merises
merles85322763mer_les
metopes11311363metopes
microbes1439403microbes
necroses10310563necroses
nerolis71012773nerolis
nerols6914883nero_ls
nerves94216193ner_ves
neurones839673neurones
neuroses8310153neuroses
obes66036833___obes
padrones112711043padrones
paroles95025883paroles
pekoes124410423peko_es
peones83821043pe_ones
perches143717953perches
perdues103511333perdues
peres76246643per__es
perries93226603perries
perses85428063per_ses
perukes133210113perukes
peruses94018163peruses
peyotes1238483peyotes
probe94320813_probe_
probed114114823_probed
prober104516073_prober
probers113514583_probers
proles84627203_proles
proses84733473_proses
proves114322253_proves
pyrones123113303pyrones
pyropes142210193pyropes
rebbes10313533re_bbes
rebores95319163rebores
recodes102918633recodes
redoes74623773redo_es
redoxes15310883redoxes
remotes94521613remotes
removes124514713removes
reposes94021263reposes
reprobe112310133reprobe_
reprobed13228743reprobed
reproves132011473reproves
rerises73525883rerises
rerolls739943rerolls
reroofs1037943reroofs
rerose63320843rerose_
reroutes8312223reroutes
resoles73823653resoles
revokes144212503revokes
revotes104716393revotes
rezones163213943rezones
ribes75530173__ribes
robe65335643__robe_
robed85323733__robed
robles85321693__robles
robs65837873__rob_s
rodes614039083__rodes
roes45954143__ro_es
roles56747983__roles
ropes75940063__ropes
roses56445773__roses
rotes56143903__rotes
roues56039353__roues
roves84834483__roves
rubes74928413__rubes
safroles1136933safroles
saprobe1137333saprobe_
sarodes84216143sarodes
saroses73619333saroses
scribes113713203scribes
senores73218113senores
serapes95218103serapes
serenes73222903serenes
seres55448893ser__es
serges74225973ser_ges
series64540973ser_ies
serines74229543serines
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
serries73925353serries
serves94423653ser_ves
soroses73117483soroses
strobe84513813strobe_
strokes114316323strokes
telomes9310533telomes
terces83921413ter_ces
ternes65422903ter_nes
terries73425633terries
tetrodes939093tetrodes
throbs118311373throb_s
throes97518673thro_es
thrones105715843thrones
tribes85119023_tribes
trokes104019263_trokes
trones65629283_trones
tropes84824353_tropes
troves94719113_troves
unrobe82611673unrobe_
unrobed102711213unrobed
verbose1237753verbose
verbs104614393ver_b_s
verges104320183ver_ges
verites103822263verites
vermes115019143ver_mes
verses94223763ver_ses
verstes104014283verstes
verves124617883ver_ves
vetoes92914083veto_es
viroses10310533viroses
wardrobes1583793wardrobes
xerosis14249663xerosis
xeroxed14244523xeroxed
xeruses143010753xeruses
yerbas11119293yer_bas
zeroed16409413zero_ed
zeros144918113zero__s

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.390458182.1
2DLD Change Limit1340273956.84319586.0
3Display Results3953950.1402821.4
 (SQL Overall)1786913957.37324235.9
 
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.