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

299 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
oralist761963(None) 
moralist10316661moralist
oralism9513761oralism
oralists8611801oralists
alist56136782__alist
arbalist10313332arbalist
dialist8517762dialist
dualist8614052dualist
formalist141910642formalist
localist101613962localist
loyalist111511132loyalist
moralise10314912moralise
moralism12312362moralism
moralists11311102moralists
muralist10312982muralist
oculist9310882oculist
odalisk1265372odalisk
onanist7314632onanist
ooralis7312552ooralis_
oralisms10610972oralisms
orality101111682orality
orals55826482oral_s_
organist9411542organist
oxalis1339222oxalis_
racist82822792_racist
rapist82520672_rapist
realist73225382realist
relist64628412_relist
royalist111311982royalist
ruralist8311702ruralist
sodalist9311882sodalist
totalist8315582totalist
vocalist131512122vocalist
aerialist9914263aerialist
agist66325583__agist
alit46155693__ali_t
amoralism1347953amoralism
analyst10189323analyst
annalist8413753annalist
aorist64827873aor__ist
arbalest1039523arbalest
arbalists1148483arbalists
argalis84214193argalis_
artist64125543ar_tist
atavist10311093atavist
atonalist9411833atonalist
baalism11310593baalism
bialis83617163bialis_
biblist11310833biblist
borals86721913boral_s_
botanist10412033botanist
braillist1146193braillist
brails84621293brails_
braise84318753bra_ise
brakiest143912243brakiest
braless92910563braless
bravest124211753bravest
brawest123810483brawest
brawliest14177193brawliest
cabalist12314503cabalist
carlish12312763carlish
cellist9314423cellist
ceramist12310933ceramist
cladist10311973cladist
coaliest10316223coaliest
corals85325143coral_s_
crasis85020473crasis_
crawliest14187403crawliest
craziest19319923craziest
cyclist1438853cyclist
czarist18710223czarist
delist74625053_delist
dialists9411413dialists
diallist949553diallist
diarist8517113diarist
drails74716953drails_
drawliest13166243drawliest
dualism1049163dualism
dualists958243dualists
duelist8511413duelist
earliest82415243earliest
enlist6417043_enlist
etatist7415033etatist
fatalist11314973fatalist
finalist113014733finalist
focalise131210373focalise
forklift1843523forklift
formalise14239783formalise
formalism16218183formalism
formalists15217623formalists
formulist14205913formulist
frailest1139493frailest
frails93716473frails_
fraise94214913fra_ise
galiot72322593_galiot
globalist1256763globalist
gorals76917653goral_s_
grails77518783grails_
grapiest112211923grapiest
gratis74819243gratis_
gravest114011633gravest
grayest11489363grayest
grayish1437813grayish
grist65529873gr__ist
halest94823273_halest
harpist12312353harpist
heraldist1346403heraldist
herbalist1449813herbalist
holist94723213_holist
homilist13410033homilist
hornist102314823hor_nist
idealist9310653idealist
idylist1146653idylist
imagist1077333imagist
immoralist1446513immoralist
iratest7312483iratest
ironist7314843ironist
journalist1755003journalist
kabalist14410083kabalist
krait94726773kra_i_t
kraits104912203kra_its
legalist9512393legalist
list47055343___list
localise101511853localise
localism121310013localism
localists11149793localists
lordliest1036103lordliest
loyalest11146723loyalest
loyalism13167573loyalism
loyalists12137473loyalists
maist75535683_ma_ist
marliest102415183marliest
mealiest102215973mealiest
medalist11414213medalist
metalist10519353metalist
midlist10312513midlist
modelist11310503modelist
morales93619403morales_
moralised1239663moralised
moralises11314003moralises
moralisms13410293moralisms
moralistic1446803moralistic
morality131110333morality
moralize19313923moralize
morals85324633moral_s_
muralists1148163muralists
narcist9512443narcist
neorealist1076813neorealist
normalise11259423normalise
novelist1149453novelist
oafish121311723o_afish
oakiest112913923o_akiest
oarfish13158613oarfish
oarless73913373oarless
oarlike113411193oarlike
oasis56422553o_asis_
oast47156323o_a__st
obelise9310173obelise
obelisk1345193obelisk
obelism1138203obelism
oblast8613663o_blast
oboist8312683o_boist
oculists1037133oculists
odalisks1363503odalisks
odist6421913o__dist
oghamist1444753oghamist
oiliest72817683o_iliest
okapis1235393okapis_
ologist8313833ologist
onanism9310133onanism
onanists838413onanists
oorali6311263oorali__
opaline9412483opaline
opals75718353opal_s_
oracles93212423oracles_
oral47638123oral___
orally93113593oral_ly
orangiest1038463orangiest
orangish1246543orangish
orangs74116033orangs_
orates64328613orates_
orating83520323orating
oration71617713oration
orbiest9312413orbiest
orbit73622063or_bi_t
orbits84211443or_bits
orbless937493orbless
orchis11710773orchis_
organise939323organise
organism1148393organism
organists1047383organists
orgiast837463orgiast
oribis838833oribis_
orles55326213or_les_
ornis54616773or_nis_
orologist10313103orologist
orphism1446183orphism
orris54516553or_ris_
ouraris73512933ouraris_
outlast71015443outlast
ovality1377593ovality
ovals85413393oval_s_
owlish1238703o_wlish
oxalic1537093oxali_c
oxalises1538503oxalises
ozalid1696683ozali_d
ozalids1794063ozalids
palest83926223_palest
paliest93021603_paliest
palish114718273_palish
palmist112814343_palmist
papist102618743_papist
phallist1338983phallist
pianist9615103pianist
playlist1347573playlist
pluralist1148173pluralist
pollist9816603pollist
populist1248203populist
portliest11310183portliest
praise84419413pra_ise
praline93019743praline
praxis154012253praxis_
protist9320223protist
psalmist1276353psalmist
raciest92820013_raciest
racism103214193_racism
racists92613323_racists
radish103516913_radish
ragis66325603_ragis_
rails55937403_rails_
rais45252623_ra_is_
raise54828053_ra_ise
rakis95323443_rakis_
rakish134313963_rakish
rales54947493_rales_
rallyist1145363_rallyist
ranis55235833_ranis_
rapists92510753_rapists
rarest65725483_rarest
ravish123414033_ravish
rawest93615063_rawest
rawish123012913_rawish
realest73322433realest
realise73021813realise
realism93115923realism
realists83014843realists
relict83623903_relict
relish93916953_relish
relists73817053_relists
relit55340683_reli_t
resist64524533_resist
roast56230143roa__st
roiliest8312283roiliest
royalism13128473royalism
royalists12178113royalists
ruliest72816433_ruliest
ruralise839643ruralise
ruralism1048533ruralism
ruralists947643ruralists
sadist74221353_sadist
scaliest101714393scaliest
sealift10312793sealift
serialist9715113serialist
shaliest111415053shaliest
shortlist1246683shortlist
socialist11411393socialist
sodalists1038153sodalists
stalest73720173stalest
statist7317723statist
stylist102110283stylist
tanist6324593_tanist
titlist7312923titlist
totalise8312503totalise
totalism10311093totalism
totalists9310753totalists
trails64622513trails_
trait56940843tra_i_t
traits65121983tra_its
transit7317163transit
tribalist1149953tribalist
tsarist7712253tsarist
tzarist1659103tzarist
uralite71714103uralite
uranism91112513uranism
uraris63817273uraris_
urbanist10109073urbanist
valise92917643_valise
vealiest112513203vealiest
verbalist1449503verbalist
violist10312143violist
vitalist11313393vitalist
vocalise131510813vocalise
vocalism15159043vocalism
vocalists14108893vocalists
votarist111012163votarist
waist86132383_wa_ist
womanist13410433womanist
wooralis1145803wooralis_
wrist84827563wr__ist

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 Limit1340272997.68617437.8
3Display Results2992990.1102718.2
 (SQL Overall)1786912997.95222471.2
 
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.