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

421 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
osteal631295(None) 
steal56125471_steal
astral66919282astral
costal85419512cost_al
estral64716512estral
hostel93914152hoste_l
luteal64411482luteal
oatmeal944972oatmeal
octal71214722oct_al
ordeal779252ordeal
ostia52315582ostia_
outeat62824532outeat
postal84317532post_al
rostral7311312rostral
seal45654372_s_eal
setal56430902_setal
sheal84927702_sheal
stead65520272_stead
steak95219802_steak
steals64020062_steals
steam76322922_steam
steel55721992_steel
stela54019042_stela
teal45546502__teal
acetal84314903acetal
actual8311023actual
anneal64812293anneal
antral65719413antral
aortal65217513aort_al
apneal83411123apneal
appeal103911613appeal
apteral9311523apteral
areal55928733_areal
artal55525473art_al
artel56122743arte_l
asea46327183as_ea_
aster55434893aste_r
astern64815813astern
asternal858313asternal
asters65631603asters
astrals75515243astrals
astray95615543astray
austral73411513austral
bateau8810563bateau
bestead10389113bestead
bestial9311643bestial
betel74419903bete_l
boatel84314093boate_l
boreal84817213boreal
borstal939043borst_al
botel75121863bote_l
cereal8315833cereal
citral81113883citral
coastal9411033coast_al
coital84117053coit_al
conceal113313013conceal
congeal104011683congeal
corneal94414503corneal
costa75523733cost_a_
costae85319683cost_ae
costar85518613cost_ar
costed95623113coste_d
coster84331293coste_r
costers94128303costers
costrel9310363costrel
coteau8311083coteau
couteau938813couteau
cuneal8611513cuneal
deal56347413__deal
distal73615763dist_al
dossal75510303dos_sal
dossel74813643dosse_l
dotal64919623dot_al
dottel73610893dotte_l
endosteal1053293endosteal
enteral73516433enteral
espial839543espial
esteem838813esteem
ester54727713este_r
esters64627733esters
estival1036323estival
estray95713333estray
estreat7314813estreat
estrual7367933estrual
fatal84819373fat_al
feal713940423__feal
festal94213563fest_al
fetal85623373fet_al
fetial95716193fetial
foetal9311883foet_al
fontal9313143font_al
foster94322223foste_r
fosters104220093fosters
foveal1237703foveal
gastral8329553gastral
gateau778103gateau
gluteal854243gluteal
gospel936533gospe_l
heal75645693__heal
hosel86024813hos_e_l
hosta85917833host_a_
hostas94515823host_as
hosted105020343hoste_d
hostels103712313hostels
hostess103210233hostess
hotel85520743hote_l
hyetal1236543hyetal
ideal65716393_ideal
ileal56118083_ileal
instal6712183inst_al
instead836203instead
irreal657823irreal
lacteal966813lacteal
lateral7313563lateral
leal46043273__leal
lethal939803lethal
lineal65616023lineal
listel64214733liste_l
literal7613263literal
loreal63814313loreal
losel54419423los_e_l
lustral7339653lustral
lutea54819073lutea_
meal65643173__meal
metal75427383met_al
misdeal1037663misdeal
mistral91013633mistral
mitral81314323mitral
mortal84616853mort_al
moste75925083moste__
mostest9314793mostest
motel76623243mote_l
mutual838503mutual
natal53921493nat_al
nostril749273nostril
notal55221353not_al
oaten55222403oate_n
oater55433733oate_r
oaters65029783oaters
oatmeals1043843oatmeals
obeah1038993o_beah
obtect10129633obtect
obtest81213013obtest
ocean71212963o_cean
ocrea73311823ocrea_
ocreae83310273ocreae
octad81510653oct_ad
octan71313483oct_an
octaval1243583octaval
octet7324063octe_t
octets839403octets
octyl10136063oct_yl
odea56224573o_dea_
offal1136243o_ffal
often84611413ofte_n
ofter84116873ofte_r
oftest91212003oftest
ogival1035873ogival
olea46532723o_lea_
onstream1045103onstream
oothecal1343913oothecal
opal66923523o__pal
opted84914273opte_d
optical1149863optical
optimal1145783optimal
oral47638123o__ral
ordeals877993ordeals
oread64619603o_read
orgeat7515033orgeat
oriel54920423orie_l
osar46820953os__ar
oscula837293oscula
ose38147343os_e__
oses46641513os_e_s
osetra667423osetra
osetras737323osetras
osier53518013osie_r
osiers63412793osiers
osmol7138573os_mol
osmolal944393osmolal
ossa43714163os_sa_
ossein636593ossein
ossia53710403ossia_
osteoid848183osteoid
osteoma945423osteoma
osteomas1045323osteomas
ostiary1036463ostiary
ostiole739013ostiole
ostium8310133ostium
ostler63312193ostler
ostlers72911203ostlers
ostmark1344873ostmark
ostomy1137823ostomy
ostraca937823ostraca
ostraka1144833ostraka
ottar54313993o_ttar
otter54423973otte_r
otters64021513otters
ousel55222403ouse_l
ousted73720583ouste_d
ouster64223733ouste_r
ousters74122773ousters
outbawl1237473outbawl
outbeam1137973outbeam
outcall9310123outcall
outearn7310683outearn
outeats72215703outeats
outed65429063oute_d
outer55633303oute_r
outers64230163outers
outfall1039683outfall
outfeel1037543outfeel
outgas7313203outgas
outhaul1039063outhaul
outhear10910603outhear
outlaw9279643outlaw
outlay92711793outlay
outlead83311103outlead
outleap9298293outleap
outman83115033outman
outran63218883outran
outread82811093outread
outsail71411413outsail
outsat62920283outsat
outsaw92610283outsaw
outsay92611873outsay
outsell7109263outsell
outtalk1138233outtalk
outtell797883outtell
outwalk1437623outwalk
outwar91011513outwar
outwear1097713outwear
outyell1095843outyell
ouzel144612323ouze_l
oval77119523o__val
oxtail1337653oxtail
oxter123414093oxte_r
oxters134813273oxters
oyster94111703oyste_r
oysters103411683oysters
paleal84716673paleal
pastel85918713paste_l
peal68648103__peal
petal76526893pet_al
pineal84817683pineal
portal84218463port_al
postals93716373post_als
postanal1048053postanal
postbag1245223postbag
posted93722493poste_d
posteen93512613posteen
poster84129173poste_r
postern93615603postern
posters93927993posters
postheat13411243postheat
postman112410043postman
postoral10311703postoral
posttax1645533posttax
postural1049193postural
postwar1236903postwar
ratal55025113rat_al
ratel54224883rate_l
real45750293__real
repeal84718283repeal
reseal64819643reseal
reteam83214533reteam
retear63115483retear
retell63813643retell
retial64724993retial
retral64419743retral
reveal94115053reveal
ritual6310613ritual
rostella845493rostella
roster64329083roste_r
rosters73727533rosters
rostra6310933rostra_
sabal75422483_sabal
sal36462883_s__al
salal55425703_salal
sea36161293_s_ea_
seals54839693_s_eals
seam66645973_s_eam
sear47353843_s_ear
seas45755273_s_eas
seat47575563_s_eat
seel45042983_s_eel
sel38253323_s_e_l
sell45840613_s_ell
sepal77723003_sepal
seral56336383_seral
seta45637313_seta_
setae56026223_setae
shea76031573_shea_
sheaf115424123_sheaf
sheals94420643_sheals
shear85424833_shear
sheas86331793_sheas
shell84424123_shell
sheol84318363_sheol
shoal83920263_shoal
shtetl936433shtetl
sial45938833_s_ial
sisal54217733_sisal
skean94415623_skean
skell94915833_skell
skoal93811453_skoal
smear74416393_smear
smell74916233_smell
sneak96016173_sneak
sneap75514823_sneap
snell54517303_snell
social8813333social
sorel56231443sore_l
sotol54917643sot_ol
speak114618673_speak
spean74620513_spean
spear75821063_spear
speel74420763_speel
speil75618643_speil
spell75020303_spell
squeal1538013squeal
stab67329933_st_ab
stag57332003_st_ag
stale55637103_st_ale
stalk94518003_st_alk
stall54722353_stall
star48037763_st_ar
stat47352693_st_at
statal61613223_statal
staw78627693_st_aw
stay78333723_st_ay
steads74116223_steads
steady103510203_steady
steaks104415853_steaks
stealer72913973_stealer
stealth1096453_stealth
steams84916903_steams
steamy115112373_steamy
steed66024943_steed
steek95418003_steek
steels64117983_steels
steely93612573_steely
steep76020703_steep
steer55423863_steer
stein54620533_stein
stelae63716483_stelae
stelai63912563_stelai
stelar64013863_stelar
stele55026843_stele
stella63612973_stella
stem610628243_ste_m
stems75219953_stems
steno54716863_steno
stent55634513_stent
step67126293_ste_p
steps76619883_steps
stere55328543_stere
stern55319123_stern
sternal73411903_sternal
sterol6613323_sterol
stet45947323_ste_t
stets55423913_stets
stew77525463_ste_w
stews85519143_stews
stewy116112063_stewy
stey76224413_ste_y
still54922073_still
stoa45425913_stoa_
stoae55024263_stoae
stoai55417863_stoai
stoas55126023_stoas
stoat57135953_stoat
stomal85213313_stomal
stool55619893_stool
strap77925263_strap
straw813321293_straw
stray88525573_stray
streak104613623_streak
stream84717283_stream
streel64214023_streel
stull54916273_stull
sural55931263_sural
swear85316853_swear
sweat85628403_sweat
swell84815983_swell
tael46030713__tael
tea37353323__tea_
teak85930843__teak
teals56234133__teals
team66238653__team
tear45242883__tear
teas45851493__teas
teat45963633__teat
teel46335803__teel
tel35647903__te_l
tela45532973__tela
tell44934703__tell
tepal76319583__tepal
tineal66216153tineal
total55321823tot_al
unreal64414453unreal
unseal63315473unseal
unsteel738793unsteel
uptear896783uptear
ureal56722683_ureal
usnea539393usnea_
usneas638333usneas
usual5310183us_ual
uveal84411073_uveal
veal76936813__veal
vestal94615573vest_al
vestral104111013vestral
vineal94814743vineal
vital84819673vit_al
weal75838683__weal
wheal115716183_wheal
withal1238933withal
zeal135530333__zeal
zoeal144813783_zoeal
zoster153715853zoste_r
zosters163015403zosters

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164216.31017863.1
3Display Results4214210.1263341.3
 (SQL Overall)1786914216.57627173.2
 
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.