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

242 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
oboists93790(None) 
oboist8312681oboist_
boasts85017922_boasts
boosts86115012_boosts
egoists887072egoists
foists95413982_foists
hoboisms1545562hoboisms
hoists95516022_hoists
joists134711032_joists
obiisms1135672obiisms
obits74617552ob_i_ts
oblasts947302oblasts
obtests9136232obtests
odists749852o_dists
ologists939442ologists
poloists10910522poloists
soloists869152soloists
abioses9311493abioses
abiosis939373abiosis
ableists1036543ableists
aborts84916183abo_rts
ageists848493ageists
agists75713173_agists
agonists9289833agonists
altoists848753altoists
amorists10411333amorists
anoints7311063anoints
aorists74215833aorists
arborists1147453arborists
aroints7313133aroints
artists74215593artists
assists738473assists
atomists102610963atomists
aurists74615783aurists
autists73814853autists
baits76630583_bai_ts
basts75936933_b_asts
beasts84519723_beasts
bemists113410703bemists
bests75932613_b_ests
biblists1236873biblists
bints76130183_b_ints
bionts8612393_bionts
bises75435623_b_ises
bisks115416803_b_isks
bits66148163_b_i_ts
bitts75022593_b_itts
blasts85116773_blasts
bliss75616913_blis_s
boarts84716873_boarts
boast75935703_boast_
boats75635153_bo_ats
boils75427193_boi_ls
boings96416873_boings
boinks125211273_boinks
boite74426323_boi_te
boites84322703_boites
bolts76232113_bo_lts
bongoists1244843bongoists
boost75132473_boost_
boots75837973_bo_ots
borshts1266543_borshts
borts76735453_bo_rts
bosks115218853_bo_sks
boss65938343_bo_s_s
bosses85925403_bosses
bots66453953_bo__ts
botts75224863_bo_tts
bouses84931783_bouses
bouts75131313_bo_uts
bowses115718863_bowses
brises84927613_brises
brisks124611403_brisks
briss75824273_bris_s
brits76433083_bri_ts
britts84813443_britts
bursts85116243_bursts
busts75227693_b_usts
cists76624533__cists
coasts85719143_coasts
coexists1735653coexists
cohosts12398813coho_sts
colonists112512503colonists
colorists112313593colorists
consists10310593consists
copyists1545993copyists
cosmists1237993cosmists
costs77231143_co_sts
cubists11359023cubists
deists74916433_deists
delists84414173delists
desists83611723desists
dodoisms1244523dodoisms
doits66223673_doi_ts
droits74314313droi_ts
ebonises1039223ebonises
egoisms1065953egoisms
egoist7612283egoist_
egotists937063egotists
enlists749393enlists
eobionts1043983eobionts
exists134710913_exists
feists94915313_feists
fists85527543__fists
florists1138813florists
foist85730973_foist_
frosts94214623fro_sts
frowsts13426103frowsts
ghosts10489273gho_sts
gists66026193__gists
glosts74513813glo_sts
gnomists1145473gnomists
grists74716483_grists
heists96814633_heists
hists86328373__hists
hobbits14317553hobbi_ts
hobbyists1942243hobbyists
hoboism1446623hobois_m
hoises94823673_hoises
hoist86433213_hoist_
holists104413963holists
hornists11208833hornists
horsts95817513_horsts
hosts85526703_ho_sts
ibises83610543ib_ises
insists739083insists
ironists839293ironists
joints133811453_joints
joist125125653_joist_
jousts135011273_jousts
judoists1643653judoists
jurists14409123jurists
kists95822113__kists
legists899593legists
lists56628693__lists
lobbyists1642193lobbyists
locoisms1256143locoisms
lookists1245713lookists
lutists73810273lutists
lyrists1036963lyrists
maists85817573_maists
mists76633903__mists
mobbisms1643773mobbisms
moist76033583_moist_
monists93614783monists
monodists1247703monodists
mosts76028543_mo_sts
motorists1149913motorists
noises65021853_noises
nudists8356833nudists
oasts56529183__oasts
obelises1039103obelises
obelisks1443443obelisks
obelisms1236393obelisms
obesity1275653obesity
obias76116863ob_i_as
obiism1036363obiis_m
obis66226843ob_i__s
obit66837083ob_i_t_
objects18123693objects
objets15125323ob_jets
oblast8613663oblast_
oblasti945953oblasti
obliges1037143obliges
oboes75717713obo__es
oboles83815833obo_les
obols73715863obo__ls
obolus8378813obo_lus
obovate1235463obovate
obsess845943obses_s
obtest81213013obtest_
obverts1235403obverts
obviate1235783obviate
obviates1345153obviates
obvious1244823obvious
oculists1037133oculists
odist6421913o_dist_
ogrisms1036443ogrisms
ologist8313833ologist_
omits75018263o_mi_ts
onanists838413onanists
oocysts1243923oocysts
oologists1039853oologists
oots46446443o_o__ts
oralists8611803oralists
orbits84211443orbi_ts
orgiasts943803orgiasts
oroides8311973oroides
orrises71312233orrises
otocysts1343503otocysts
ousts55225703__ousts
outboasts1144763outboasts
outsits73215253outsits
ovoids10456923ovoi_ds
ozonises1776373ozonises
papists112110453papists
points85618533_points
poises84226543_poises
pollists10910823pollists
poloist91016323poloist_
posits85718713_posits
posts75228783_po_sts
protists10313363protists
purists94014073purists
quoits15379683quoi_ts
racists92613323racists
rapists92510753rapists
relists73817053relists
resists74414923resists
roasts64915413_roasts
robotisms1375123robotisms
robots8313153robo__ts
roosts64916323_roosts
rousts617016723_rousts
sadists83310853sadists
schists1248543schists
sexists14267673sexists
shists96515113_shists
sodomists1255923sodomists
soloist7915893soloist_
sophists1347293sophists
subsists1037993subsists
sumoists1046733sumoists
tanists7313653tanists
theists1039153theists
toasts65914993_toasts
toits55327473_toi_ts
tourists838313tourists
tubaists1055103tubaists
tubists9288323tubists
twists9549753_twists
typists1236173typists
utopists1045773utopists
verists103613673verists
vibists1256483vibists
violists1137663violists
volosts1036563volo_sts
waists97415453_waists
whists124613813_whists
wists86728523__wists
worsts96014333_worsts
wrists95415643_wrists

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 Limit1340272426.39020974.5
3Display Results2422420.0932602.2
 (SQL Overall)1786912426.87325999.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.