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

361 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
oboist831268(None) 
oboists937901oboists
boast75935702_boast
boost75132472_boost
egoist7612282egoist
foist85730972_foist
hoboism1446622hoboism
hoist86433212_hoist
joist125125652_joist
moist76033582_moist
obiism1036362obiism
obis66226842ob_is_
obit66837082ob_i_t
obits74617552ob_its
oblast8613662oblast
oboes75717712oboes_
obols73715862obols_
obtest81213012obtest
odist6421912o_dist
ologist8313832ologist
poloist91016322poloist
soloist7915892soloist
ableist9311773ableist
ablest84721833ablest
aboil72217543aboi_l
abolish12311503abolish
abort76133583abo_rt
aborts84916183aborts
abos67734413abo_s_
about75229083abo_ut
abris75722603abris_
ageist7315383ageist
agist66325583_agist
agonist82615403agonist
alist56136783_alist
altoist7313393altoist
amorist9317643amorist
anoint6423633anoint
aorist64827873aorist
arborist10411613arborist
aroint6328153aroint
artist64125543artist
assist6314603assist
atomist92915763atomist
aurist65027253aurist
autist64324943autist
bait66556003_bai_t
baits76630583_baits
bast66362413_b_ast
beast76338643_beast
bemist105216963bemist
best66355323_b_est
biblist11310833biblist
bint67355043_b_int
biont7727163_biont
bios66335323_bios_
bis56860663_b_is_
bise66437103_b_ise
bisk106523353_b_isk
bit57070903_b_i_t
bits66148163_b_its
bitt65545813_b_itt
blast76532573_blast
blest76431723_blest
bliss75616913_bliss
boart78835933_boart
boas66150833_boas_
boasts85017923_boasts
boat66360313_bo_at
boats75635153_boats
bobs86340653_bobs_
bods76244713_bods_
bogs75742753_bogs_
boil66335183_boi_l
boils75427193_boils
boing84725553_boing
boink115516333_boink
boite74426323_boite
bolt66254173_bo_lt
bolts76232113_bolts
bongoist1147643bongoist
boniest93318993boniest
boobish14338943boobish
boobs96221993boobs_
booing94521643booing
bookish163610023bookish
books115729713books_
boomiest122711843boomiest
booms95427123booms_
boons75031913boons_
boorish123712593boorish
boors74325013boors_
boos67955033_boos_
boosts86115013_boosts
boot67759373_bo_ot
boots75837973boots_
booziest19379263booziest
bops86037983_bops_
borsht11813503_borsht
bort65960963_bo_rt
borts76735453_borts
bos57966813_bo_s_
bosh96328973_bo_sh
bosk105825733_bo_sk
boss65938343_bo_ss
bossy105515973_bossy
bot59680403_bo__t
bots66453953_bots_
bott66548573_bo_tt
botts75224863_botts
bouse75931853_bouse
bousy104917843_bousy
bout66353293_bo_ut
bouts75131313_bouts
bows96242863_bows_
bowse105420633_bowse
boxiest163711983boxiest
boyish142911233boyish
boys96737333_boys_
bris65539613_bris_
brisk115615983_brisk
briss75824273_briss
brit66350153_bri_t
brits76433083_brits
britt75732233_britt
built74325923_built
burst75332243_burst
bust65947783_b_ust
cist67244963__cist
coast75236273_coast
cobbiest14118523cobbiest
coexist1638583coexist
cohost115217213coho_st
colonist102617933colonist
colorist102818993colorist
consist9316033consist
copyist1439053copyist
cosmist11311333cosmist
cost68057943_co_st
cubist104214443cubist
deist64633593_deist
delist74625053delist
desist74818813desist
dodoism1135893dodoism
doest65829523_doest
doit56347853_doi_t
doits66223673_doits
dost57248353_do_st
droit65127123droi_t
droits74314313droits
ebonise939613ebonise
ebons74316093ebons_
egoism977473egoism
egoists887073egoists
egotist8411273egotist
enlist6417043enlist
eobiont959943eobiont
exist124618943_exist
feist86230073_feist
fist76248423__fist
florist10314243florist
foists95413983_foists
frost84727833fro_st
frowst125512073frowst
ghost96318763gho_st
gist56046763__gist
glost65422933glo_st
gnomist1049133gnomist
goboes95914443goboes_
gobos86219383gobo_s_
gooiest82813883gooiest
grist65529873_grist
heist87030913_heist
hist76551543__hist
hobbit132810543hobbi_t
hobbits14317553hobbits
hobbyist1843473hobbyist
hoboes114717443hoboes_
hoboing13309453hoboing
hoboisms1545563hoboisms
hobos106321353hobo_s_
hoise85224773_hoise
hoists95516023_hoists
holist94723213holist
hornist102314823hornist
horst85833513_horst
host77852833_ho_st
ibis66519583ib_is_
insist6314513insist
ironist7314843ironist
joint125227723_joint
joists134711033_joists
joust125122293_joust
judoist1545633judoist
jurist134616393jurist
kist86540803__kist
kobos115616893kobo_s_
kois85129403_kois_
legist71315253legist
list47055343__list
lobbyist1543533lobbyist
lobos75921843lobo_s_
locoism1156793locoism
lookist1139563lookist
lost47951493_lo_st
lutist64317553lutist
lyrist9312293lyrist
maist75535683_maist
mist66154533__mist
mobbish1635923mobbish
mobbism1535053mobbism
monist84324983monist
monodist11310923monodist
most66554203_mo_st
motorist10314413motorist
neist54628443_neist
nobbiest12117773nobbiest
noblest93613563noblest
noise55723733_noise
noisy86813363_noisy
nudist73813323nudist
oafish121311723oafish
oakiest112913923oakiest
oasis56422553oasis_
oast47156323__oast
obas65730933ob_as_
obeisant1046093obeisant
obelise9310173obelise
obelisk1345193obelisk
obelism1138203obelism
obes66036833ob_es_
obese75212423ob_ese
obesity1275653obesity
obeys107010643obeys_
obi57127733ob_i__
obia67923113ob_i_a
obias76116863ob_ias
obiisms1135673obiisms
object17135803object
objet141213143ob_jet
objets15125323objets
oblasti945953oblasti
oblasts947303oblasts
oblige937653oblige
oboe66822943obo__e
obol65220613obo__l
obole75917143obo_le
oboles83815833oboles
oboli73712873obo_li
obolus8378813obolus
obovate1235463obovate
obsess845943obsess
obtect10129633obtect
obtests9136233obtests
obtuse8147483obtuse
obvert11412993obvert
obviate1235783obviate
oculist9310883oculist
oddest81710863oddest
oddish11107653oddish
odists749853o_dists
odors64514283odors_
offish15137273offish
oftest91212003oftest
ogrish1039263ogrish
ogrism937913ogrism
oiliest72817683oiliest
oldest72114093oldest
oldish10169313oldish
olios54520853olios_
ologists939443ologists
omit65337373o_mi_t
omits75018263o_mits
onanist7314633onanist
onos46229003ono_s_
oocyst1136133oocyst
oohs75220693o_ohs_
oologist9313493oologist
oops65232673o_ops_
oot311274693o_o__t
oots46446443o_ots_
ooziest163411523ooziest
oralist7619633oralist
orbiest9312413orbiest
orbit73622063orbi_t
orbits84211443orbits
orgiast837463orgiast
ornis54616773ornis_
oroide7311703oroide
orris54516553orris_
otiose639403otiose
otocyst1244833otocyst
oust46747443__oust
outboast1048543outboast
outsit63620893outsit
ovoid94811023ovoi_d
ovoids10456923ovoids
owlish1238703owlish
oxbows1833713oxbows_
ozonise1646443ozonise
papist102618753papist
poboys1397313poboys_
point75338733_point
pois66539043_pois_
poise75127893_poise
pollist9816603pollist
poloists10910523poloists
posit75833333_posit
post67953363_po_st
prosit85124593prosit
prost75434103pro_st
protist9320223protist
purist85525053purist
quoit143819863quoi_t
quoits15379683quoits
racist82822793racist
rapist82520673rapist
relist64628413relist
resist64524533resist
roast56230143_roast
robot7325973robo__t
robotism1285963robotism
robots8313153robots_
robust8310433rob_ust
roost55730933_roost
roust55532063_roust
sadist74221353sadist
schist11312653schist
sexist133013483sexist
shist84829613_shist
sobeit8315363sobei_t
sodomist1157633sodomist
soloists869153soloists
sophist12311573sophist
spoilt85016593spoilt
subsist9311573subsist
sumoist9311613sumoist
tanist6324593tanist
theist9314763theist
toast55831013_toast
toit46353063_toi_t
toits55327473_toits
tost48351923_to_st
tourist7313203tourist
trois57226093trois_
tubaist938703tubaist
tubist83013163tubist
twist86820983_twist
typist1139823typist
utopist938693utopist
verist93823893verist
vibist11610583vibist
violist10312143violist
volost9412643volo_st
waist86132383_waist
whist115322953_whist
wist78049293__wist
worst86330133_worst
wost76544363_wo_st
wrist84827563_wrist
zooiest16199923zooiest

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.393454684.5
2DLD Change Limit1127163614.68624053.8
3Display Results3613610.1103281.8
 (SQL Overall)1786913615.18934436.5
 
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.